Start a new topic

UNABLE TO CONNECT TO HIVE USING VISUALIZER

[This topic is migrated from our old forums. The original author name has been removed]
[Attachment has been removed.]

I tried almost all solutions I could google. But I am not able to get a connection to HIVE. Can anyone please give a step by step procedure of setting up a driver for HIVE and connecting successfully. I database url i am using is jdbc:hive://:/databasename I have added the following jar hive-jdbc-0.10.0. I also tried adding them in the jdbc folder of visualizer, but it is not taking commons-logging-1.1.3.jar hadoop-0.20.2-dev-core.jar hive-exec-0.13.0-mapr-1406.jar hive-jdbc-0.13.0-mapr-1406.jar hive-service-0.13.0-mapr-1406.jar httpclient-4.2.5.jar httpcore-4.2.5.jar libthrift-0.9.0.jar slf4j-api-1.7.5.jar slf4j-log4j12-1.7.5.jar Please help

[This reply is migrated from our old forums.]

Re: UNABLE TO CONNECT TO HIVE USING VISUALIZER
Hi, Please first note that HIVE is not officially supported by DbVisualizer even if many users are using it. The error indicate you are using an erroneous Database URL. Here is an example that has worked for others: jdbc:hive2:/// Replace with appropriate values. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]
[Attachment has been removed.]

Re: UNABLE TO CONNECT TO HIVE USING VISUALIZER
Thanks Roger for you suggestion. I tried the URL you gave, but unfortunately I get the same error. I have attached the screenshot. Can you suggest anything else I can try. Regards Rajkumar
[This reply is migrated from our old forums.]

Re: UNABLE TO CONNECT TO HIVE USING VISUALIZER
Hi, The screenshot shows no colon (:) between jdbc and hive2. Should be: jdbc:hive2://... Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: UNABLE TO CONNECT TO HIVE USING VISUALIZER
There is a colon between jdbc and hive2. Please zoom the image to see it.
[This reply is migrated from our old forums.]

Re: UNABLE TO CONNECT TO HIVE USING VISUALIZER
Ah sorry, I didn't see it. You are then using the wrong jar files. HIVE and its jar-mania is a mess. I suggest you check with the HIVE community what jars are required. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: UNABLE TO CONNECT TO HIVE USING VISUALIZER
Thanks Roger . Can you give me the URL of the place you referred. Regards Rajkumar
[This reply is migrated from our old forums.]

Re: UNABLE TO CONNECT TO HIVE USING VISUALIZER
Hi, I suggest you Google for "hive jdbc" to locate the appropriate information for HIVE and what JAR files are required. Even though the following web page mentions SquirrelSQL it should work in DbVisualizer too. https://cwiki.apache.org/confluence/display/Hive/HiveJDBCInterface#HiveJDBCInterface-IntegrationwithSQuirrelSQLClient Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: UNABLE TO CONNECT TO HIVE USING VISUALIZER
I wrote up every step I took to get DBVis connected to Hortonworks HiveServer2. With pictures included. See if this helps. https://github.com/cyanfr/dbvis_to_hortonworks_hiveserver2/wiki/How-I-Connected-DBVisualizer-9.2.2-on-Windows-to-Hortonwork-HiveServer2