Start a new topic

Hive Server 2 Unable to Connect

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

Does anyone have guidance/experience connecting to Hive Server 2 using DbVis? I've installed & configured the appropriate JDBC driver and successfully connected to Hive Server 2 using SQuirreL. However, I'm continuously unsuccessful when attempting to connect using DbVis. Any help would be greatly appreciated.

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

Re: Hive Server 2 Unable to Connect
thanks for the your information
[This reply is migrated from our old forums.]

Re: Hive Server 2 Unable to Connect
Hi, There har been some improvements in the number of jar files needed for JDBC access in HIVE. Now we use only these: hive-jdbc-1.2.1-standalone.jar hadoop-common-2.7.1.jar You may freely try other files as there seems to be a lot of alternatives. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: Hive Server 2 Unable to Connect
Hi, Can I use the jars hive-exec-1.1.0-cdh5.4.2.jar instead of hive-exec-0.13.0-mapr-1406.jar? The same goes for all other jars.
[This reply is migrated from our old forums.]

Re: Hive Server 2 Unable to Connect
Hi, Connecting to Hive requires a lot of jar files for JDBC to work properly. Another user have confirmed that it works with the following (you can probably ignore the version part of each file and pick the corresponding files by name): 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 Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: Hive Server 2 Unable to Connect
I have the same problems. Jars: commons-codec commons-logging hive-service httpclient httpcore libthrift hive-exec An error occurred while establishing the connection: Long Message: org/apache/hadoop/conf/Configuration Details:    Type: java.lang.NoClassDefFoundError Stack Trace: java.lang.NoClassDefFoundError: org/apache/hadoop/conf/Configuration    at org.apache.hive.jdbc.HiveConnection.createBinaryTransport(HiveConnection.java:367)    at org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:200)    at org.apache.hive.jdbc.HiveConnection.(HiveConnection.java:178)    at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:105)    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)    at java.lang.reflect.Method.invoke(Unknown Source)    at com.onseven.dbvis.g.B.D.ā(Z:1413)    at com.onseven.dbvis.g.B.F$A.call(Z:1474)    at java.util.concurrent.FutureTask.run(Unknown Source)    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)    at java.lang.Thread.run(Unknown Source) Caused by: java.lang.ClassNotFoundException: org.apache.hadoop.conf.Configuration    at java.net.URLClassLoader$1.run(Unknown Source)    at java.net.URLClassLoader$1.run(Unknown Source)    at java.security.AccessController.doPrivileged(Native Method)    at java.net.URLClassLoader.findClass(Unknown Source)    at java.lang.ClassLoader.loadClass(Unknown Source)    at java.lang.ClassLoader.loadClass(Unknown Source)    ... 14 more
[This reply is migrated from our old forums.]

Re: Hive Server 2 Unable to Connect
Mike, What jar files are you using for Hive and what error(s) do you get when connecting? Screenshots are always good. Regards Roger