Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

unable to login hive by using beeline with zookeeper service Discovery mode

Highlighted

unable to login hive by using beeline with zookeeper service Discovery mode

Super Collaborator

Hello All,

I have installed HDP3.1 recently and enabled hive llap.

i am able to connect hiveserver2 by using hive cli. when i am trying to connect hive from beeline it's throwing NULL Pointer exception.

i haven't found errors in hiveserver logs:


2019-05-20 13:28:10 INFO HiveConnection:203 - Will try to open client transport with JDBC Uri: jdbc:hive2://hive.server2.instance.uri=hadoop-master-nn1:10000;hive.server2.authentication=NONE;hive.server2.transport.mode=binary;hive.server2.thrift.sasl.qop=auth;hive.server2.thrift.bind.host=hadoop-master-nn1;hive.server2.thrift.port=10000;hive.server2.use.SSL=false/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2

java.lang.NullPointerException


Any suggestion to resolve the above issue ?

3 REPLIES 3

Re: unable to login hive by using beeline with zookeeper service Discovery mode

Community Manager

The above was originally posted in the Community Help Track. On Mon May 20 16:41 UTC 2019, a member of the HCC moderation staff moved it to the Cloud & Operations Track. The Community Help Track is intended for questions about using the HCC site itself.

Bill Brooks, Community Manager
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

Re: unable to login hive by using beeline with zookeeper service Discovery mode

The URL and the full command looks like below. You can either edit it, or go to Ambari --> Hive and copy the URL given as "Hiveserver2 Interactive JDBC URL":

beeline -u "jdbc:hive2://node01.example.com:2181,node02.example.com:2181,node03.example.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2-hive2"

Re: unable to login hive by using beeline with zookeeper service Discovery mode

Super Collaborator

Hi @Predrag Minovic,

Thank you for the sharing your input. No issues with the zookeeper name space, have double checked

i,e jdbc:hive2://hadoop-zknode01:2181,hadoop-zknode02:2181,hadoop-zknode03:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2