JDBC string for HIVE

[#1]

I have installed VNC server on Ambari(HDP Sandbox). From Eclipse on VNC Client, I want to query Hive database. What is the JDBC string I should use? I looked at other posts. Its very confusing. I am using HDP 2.3.2.

Please help.

[#2]

Since HDP Sandbox is on one node and you are running the eclipse also on the same node then you should be able to connect using jdbc:hive2://localhost:10000.

[#3]

@Former Member

I have added jar files and connection details. Connection failed. Please suggest.

,@Deepesh

Thanks Deepesh. Please find screen shots below. I have added JAR files and database connection details. connection failed. Please help

[#4]

Please take look here. Great info on connection details for jdbc https://cwiki.apache.org/confluence/display/Hive/HiveServer2+Clients

[#5 · Accepted solution]

@Vidya SK

Double check that you have all the Hive JDBC jar files

FOR HDP 2.3.x

From /usr/hdp/current/hive-client/lib/ sftp or scp to your local desktop

• hive-jdbc.jar

From /usr/hdp/current/hadoop-client

• hadoop-common.jar
• hadoop-auth.jar

User name: hive

Password: hive

I cannot remember if the Sandbox is setup with Hive run as user = false or not. Need to double check. As was indicated earlier use URL

jdbc:hive2://127.0.0.1:10000 

See also the answers for a related question

[#6]

@Ancil McBarnett

It worked !! Great !!! Thanks a lot Ancil.

[#7]

I'd recommend to test connectivity first. You can do it with beeline tool. Once you connected to jdbc url from beeline u can continue experiments with eclipse.