Support Questions

Find answers, ask questions, and share your expertise

Unable to access hive database using jdbc , It gives following error though i have added all necessary jar files

avatar
18/05/30 17:12:15 INFO jdbc.Utils: Supplied authorities: localhost:10000
18/05/30 17:12:15 INFO jdbc.Utils: Resolved authority: localhost:10000
Exception in thread "main" java.lang.NoSuchMethodError: org.apache.hadoop.hive.common.auth.HiveAuthUtils.getSocketTransport(Ljava/lang/String;II)Lorg/apache/thrift/transport/TTransport;
 at org.apache.hive.jdbc.HiveConnection.createUnderlyingTransport(HiveConnection.java:519)
 at org.apache.hive.jdbc.HiveConnection.createBinaryTransport(HiveConnection.java:539)
 at org.apache.hive.jdbc.HiveConnection.openTransport(HiveConnection.java:309)
 at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:196)
 at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:107)
 at java.sql.DriverManager.getConnection(DriverManager.java:664)
 at java.sql.DriverManager.getConnection(DriverManager.java:247)
 at Hive_java.main(Hive_java.java:15)

Driver name is org.apache.hive.jdbc.HiveDriver

connection URL is "jdbc:hive2://localhost:10000/default", "", ""

77438-jar-lib.png

2 REPLIES 2

avatar

Im getting the same issue when trying to use the Hive Warehouse Connector

avatar
Master Guru

The name of the server must be set, it can't be localhost.   NiFi and Hive are on other machines.