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.

Hiverserver interactive connection question

Hiverserver interactive connection question

Explorer

Hello,

 

I copied the llap jdbc string from ambari to connect to hive interactive server, but it shows as connected to port number 10000 which belongs to hiveserver. Isn't suppose to connect to port  10500?   Am I missing some thing ?

 

INFO jdbc.HiveConnection: Connected to  server1.hiverserever.net:10000

1 REPLY 1
Highlighted

Re: Hiverserver interactive connection question

Rising Star

@mokkan - I am sure what is your HDP version and what is the connection string you are using to connect to HiveServer2Interactive. But in HDP 2.6.X, I am getting below output while connecting to HS2I. From this I can see that it is connecting to LLAP.

beeline> !connect jdbc:hive2://abc.example.com:2181,abc1.example.com:2181,abc2.example.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2-hive2
Connecting to jdbc:hive2://abc.example.com:2181,abc1.example.com:2181,abc2.example.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2-hive2
Enter username for jdbc:hive2://abc.example.com:2181,abc1.example.com:2181,abc2.example.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2-hive2:
Enter password for jdbc:hive2://abc.example.com:2181,abc1.example.com:2181,abc2.example.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2-hive2:
Connected to: Apache Hive (version 2.1.0.2.6.4.0-91)
Driver: Hive JDBC (version 1.2.1000.2.6.4.0-91)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://abc.example.com:2181,abc1.exa>

 

From HDP 3.X, below is the response. 

 

# beeline -u "jdbc:hive2://c1108-node2.squadron-labs.com:2181,c1108-node3.squadron-labs.com:2181,c1108-node4.squadron-labs.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2-interactive"
Connecting to jdbc:hive2://c1108-node2.squadron-labs.com:2181,c1108-node3.squadron-labs.com:2181,c1108-node4.squadron-labs.com:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2-interactive
19/11/17 05:06:12 [main]: INFO jdbc.HiveConnection: Connected to c1108-node4.squadron-labs.com:10500
Connected to: Apache Hive (version 3.1.0.3.0.1.0-187)
Driver: Hive JDBC (version 3.1.0.3.0.1.0-187)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 3.1.0.3.0.1.0-187 by Apache Hive
0: jdbc:hive2://c1108-node2.squadron-labs.com>
0: jdbc:hive2://c1108-node2.squadron-labs.com>


It might be possible that you are using wrong string to connect. Please verify the same or share the complete output from your screen.

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