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 connect to hive using beeline after upgrade

Unable to connect to hive using beeline after upgrade

Explorer

After upgrading to HDP 2.6.4, we are unable to connect to Hive using beeline. Anyone has any pointers on how to resolve this ?

2018-06-24 22:36:58 INFO ZooKeeper:100 - Client environment:user.dir=/usr/hdp/2.6.4.0-91/hive2/jdbc 2018-06-24 22:36:58 INFO ZooKeeper:438 - Initiating client connection, connectString=hdp26.xyz.com:2181 sessionTimeout=60000 watcher=org.apache.curator.ConnectionState@3e77a1ed 2018-06-24 22:36:58 INFO ClientCnxn:975 - Opening socket connection to server hdp26.xyz.com/192.168.1.146:2181. Will not attempt to authenticate using SASL (unknown error) 2018-06-24 22:36:58 INFO ClientCnxn:852 - Socket connection established to hdp26.xyz.com/192.168.1.146:2181, initiating session 2018-06-24 22:36:58 INFO ClientCnxn:1235 - Session establishment complete on server hdp26.xyz.com/192.168.1.146:2181, sessionid = 0x163dce1a1672125, negotiated timeout = 60000 2018-06-24 22:36:58 INFO ConnectionStateManager:228 - State change: CONNECTED 2018-06-24 22:36:59 INFO ZooKeeperHiveClientHelper:83 - Selected HiveServer2 instance with uri: hive.server2.authentication=KERBEROS;hive.server2.transport.mode=binary;hive.server2.thrift.sasl.qop=auth;hive.server2.thrift.bind.host=hdp26.xyz.com;hive.server2.thrift.port=10000;hive.server2.use.SSL=false;hive.server2.authentication.kerberos.principal=hive/_HOST@xyz.COM 2018-06-24 22:36:59 INFO ZooKeeper:684 - Session: 0x163dce1a1672125 closed 2018-06-24 22:36:59 INFO ClientCnxn:512 - EventThread shut down 2018-06-24 22:36:59 INFO Utils:397 - Resolved authority: hive.server2.authentication=KERBEROS;hive.server2.transport.mode=binary;hive.server2.thrift.sasl.qop=auth;hive.server2.thrift.bind.host=hdp26.xyz.com;hive.server2.thrift.port=10000;hive.server2.use.SSL=false;hive.server2.authentication.kerberos.principal=hive/_HOST@xyz.COM 2018-06-24 22:36:59 INFO HiveConnection:203 - Will try to open client transport with JDBC Uri: jdbc:hive2://hive.server2.authentication=KERBEROS;hive.server2.transport.mode=binary;hive.server2.thrift.sasl.qop=auth;hive.server2.thrift.bind.host=hdp26.xyz.com;hive.server2.thrift.port=10000;hive.server2.use.SSL=false;hive.server2.authentication.kerberos.principal=hive/_HOST@xyz.COM/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 2018-06-24 22:36:59 INFO HiveConnection:208 - Could not open client transport with JDBC Uri: jdbc:hive2://hive.server2.authentication=KERBEROS;hive.server2.transport.mode=binary;hive.server2.thrift.sasl.qop=auth;hive.server2.thrift.bind.host=hdp26.xyz.com;hive.server2.thrift.port=10000;hive.server2.use.SSL=false;hive.server2.authentication.kerberos.principal=hive/_HOST@xyz.COM/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 2018-06-24 22:36:59 INFO CuratorFrameworkImpl:224 - Starting 2018-06-24 22:36:59 INFO ZooKeeper:438 - Initiating client connection, connectString=hdp26.xyz.com:2181 sessionTimeout=60000 watcher=org.apache.curator.ConnectionState@1d082e88 2018-06-24 22:36:59 INFO ClientCnxn:975 - Opening socket connection to server hdp26.xyz.com/192.168.1.146:2181. Will not attempt to authenticate using SASL (unknown error) 2018-06-24 22:36:59 INFO ClientCnxn:852 - Socket connection established to hdp26.xyz.com/192.168.1.146:2181, initiating session 2018-06-24 22:36:59 INFO ClientCnxn:1235 - Session establishment complete on server hdp26.xyz.com/192.168.1.146:2181, sessionid = 0x163dce1a1672129, negotiated timeout = 60000 2018-06-24 22:36:59 INFO ConnectionStateManager:228 - State change: CONNECTED 2018-06-24 22:36:59 INFO ZooKeeper:684 - Session: 0x163dce1a1672129 closed 2018-06-24 22:36:59 INFO ClientCnxn:512 - EventThread shut down Error: Could not open client transport for any of the Server URI's in ZooKeeper: Unable to read HiveServer2 uri from ZooKeeper (state=08S01,code=0)

Don't have an account?
Coming from Hortonworks? Activate your account here