hive databases not showing via beeline/hiveserver2

ryu — Wed, 17 Mar 2021 18:47:25 GMT

Hi experts,

I am trying to upgrade my current hive version from 1.2 to 2.3.8.

I am able to connect to hive via hiveserver2 but when I do "show databases", there are no databases showing up.

0: jdbc:hive2://test02.domain.com:100> show databases;
+----------------+
| database_name |
+----------------+
+----------------+
No rows selected (0.124 seconds)
0: jdbc:hive2://test02.domain.com:100>

When accessing the mysql database I can see the databases in hive.

mysql> use hive;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

I have already updated the mysql schema with the script provided.

When I switch back to the older version of hive 1.2, I am able to see the databases via beeline/hiveserver2.

Can someone please let me know what I am missing?

Any help is much appreciated.

Thanks,

Re: hive databases not showing via beeline/hiveserver2

ryu — Wed, 17 Mar 2021 22:19:40 GMT

@ksuresh @mqureshi, @Sunile Manjee, @Shyam Sunder Rai - looping you in, any ideas on this ?

Re: hive databases not showing via beeline/hiveserver2

ryu — Wed, 17 Mar 2021 23:53:08 GMT

Ok seems like I had hive.security.authoization.enabled to true in the hiveserver2-site.xml but had not enabled the ranger hive plugin yet.

Once I set this property to false, I was able to see the hive databases with "show databases".

question Re: hive databases not showing via beeline/hiveserver2 in Support Questions

hive databases not showing via beeline/hiveserver2

Re: hive databases not showing via beeline/hiveserver2

Re: hive databases not showing via beeline/hiveserver2