How can we help you today?
Hive Server 2 Unable to Connect
6 CommentsSorted by Oldest First
Roger Bjärevall
said
over 10 years ago
[This reply is migrated from our old forums.]
Re: Hive Server 2 Unable to Connect
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
[This reply is migrated from our old forums. The original author name has been removed]
Re: Hive Server 2 Unable to Connect
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
Roger Bjärevall
said
about 10 years ago
[This reply is migrated from our old forums.]
Re: Hive Server 2 Unable to Connect
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
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.
Roger Bjärevall
said
about 9 years ago
[This reply is migrated from our old forums.]
Re: Hive Server 2 Unable to Connect
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
Re: Hive Server 2 Unable to Connect
thanks for the your information
anonymous