question Re: JDBC string for HIVE in Support Questions

JDBC string for HIVE

vidyaranya_kupp — Sat, 16 Jan 2016 12:12:40 GMT

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.

Re: JDBC string for HIVE

deepesh1 — Sat, 16 Jan 2016 13:24:50 GMT

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.

Re: JDBC string for HIVE

vidyaranya_kupp — Mon, 19 Aug 2019 12:12:17 GMT

@de

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

Re: JDBC string for HIVE

sunile_manjee — Sun, 17 Jan 2016 02:27:38 GMT

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

Re: JDBC string for HIVE

amcbarnett — Sun, 17 Jan 2016 02:38:35 GMT

@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

Re: JDBC string for HIVE

vidyaranya_kupp — Sun, 17 Jan 2016 03:48:59 GMT

@Ancil McBarnett

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

Re: JDBC string for HIVE

bluesmix — Sun, 17 Jan 2016 07:40:41 GMT

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.