[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
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
a
anonymous
said
about 10 years ago
[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
Roger Bjärevall
said
about 10 years ago
[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
a
anonymous
said
about 10 years ago
[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.
Roger Bjärevall
said
about 10 years ago
[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
a
anonymous
said
about 10 years ago
[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
Roger Bjärevall
said
about 10 years ago
[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
a
anonymous
said
almost 10 years ago
[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
anonymous
[Attachment has been removed.]