Beeline does not give any response

[#1]

When try to open hive through beeline it connects properly to beeline-hiveserver2, but if I use any query on that then it does not give response. for ex. if I hit query show databases then give just empty list (no database is shown). Ideally it should show the list of databases present on that cluster.

[#2]

@Anjali Shevadkar

Do you have Ranger policies defined for Hive? If yes, check if the login user has use/select on the databases.

Also, you could check the 'show databases' from Hive Cli as it by-passes the Ranger.

[#3]

@Sindhu Yes I have a ranger policy for hive and login user has all permissions on all databases. And I have also checked on hive cli show databases its working it gives us all databases.

[#4]

@Anjali Shevadkar

Can you share the screenshot of the Ranger policy and also, error snippet from Hiveserver2 log?

[#5]

I don't know how to check hiveserver2 logs.

[#6]

@Anjali Shevadkar,

This might be a lame question. Are you sure that you are connecting to the right HiveServer ?

Can you please copy the url from hive configs and try connecting to it

Go to Ambari -> Hive -> Summary -> HiveServer2 JDBC URL (Copy this url) and try to connect to it and see if this works.

.

-Aditya

[#7]

@ Aditya Sirna

Yes I am sure that I am connecting to the right hiveserver. Still there is same issue.

[#8]

@Anjali Shevadkar

I checked internally and below policy works:

beeline> !connect jdbc:hive2://:2181,:2181,:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
Connecting to jdbc:hive2://:2181,:2181,:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
Enter username for jdbc:hive2://:2181,:2181,:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2: hive
Enter password for jdbc:hive2://:2181,:2181,:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2: ****
Connected to: Apache Hive (version 1.2.1000.2.6.5.0-292)
Driver: Hive JDBC (version 1.2.1000.2.6.5.0-292)
0: jdbc:hive2://xxx:> show databases;
+----------------+--+
| database_name|
+---------------+--+
| default|
| testdb |
+----------------+--+2 rows selected (0.362 seconds)

[#9]

@Anjali Shevadkar

Were you able to verify with the permissions?

[#10]

@Anjali Shevadkar

Is your cluster kerberized. If so, are you using the relevant kerberos ticket for the user, please confirm