9872

HIVE JDBC ThriftHive$Client.sendBase

i Have work on Hadoop/hive. i have install hadoop and hive which is running fine on command prompt.i have also create a MySQL meta store of hive.I have define HIVE-DB database name in hive-site.xml file.The same name database is available in MySQL>HIVE-DB .but the table which is create on hive command prompt is not available in mysql command Prompt. And when i want to create a hive jdbc Connection then get following error..First it is my Program to create a jdbc connection

package aa; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.Statement; public class Main { private static String driverName = "org.apache.hadoop.hive.jdbc.HiveDriver"; public static void main(String args[]) { try { Class.forName(driverName); } catch (ClassNotFoundException e) { // TODO Auto-generated catch block e.printStackTrace(); System.exit(1); } try { Connection con = DriverManager.getConnection("jdbc:hive://localhost:10001/default", "", ""); Statement stmt = con.createStatement(); String tableName = "recordssss"; stmt.executeQuery("create table"+tableName+"(id int,name string)"); } catch(Exception e) { e.printStackTrace(); } } } and then following error is display... because i have start hive as a hive server i.e **$HIVE_HOME/bin/hive --service hiveserver -p 10001** xception in thread "main" java.lang.NoSuchMethodError: org.apache.hadoop.hive.service.ThriftHive$Client.sendBase(Ljava/lang/String;Lorg/apache/thrift/TBase;)V at org.apache.hadoop.hive.service.ThriftHive$Client.send_execute(ThriftHive.java:110) at org.apache.hadoop.hive.service.ThriftHive$Client.execute(ThriftHive.java:102) at org.apache.hadoop.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:187) at org.apache.hadoop.hive.jdbc.HiveStatement.execute(HiveStatement.java:127) at org.apache.hadoop.hive.jdbc.HiveConnection.configureConnection(HiveConnection.java:126) at org.apache.hadoop.hive.jdbc.HiveConnection.<init>(HiveConnection.java:121) at org.apache.hadoop.hive.jdbc.HiveDriver.connect(HiveDriver.java:104) at java.sql.DriverManager.getConnection(DriverManager.java:620) at java.sql.DriverManager.getConnection(DriverManager.java:200) at aa.Main.main(Main.java:25) enter code here so pls help me i have describe the problem to you so pls dear anyone help me

Answer1:

It seems like you are not using appropriate library in your client code. The jars you are using might be of wrong versions. Please check those once.

Recommend

  • Hive “ANALYZE TABLE” how to execute from java
  • Cannot find Oracle jdbc driver
  • Not able to install cloudstorage
  • error C2016: C requires that a struct or union has at least one member from struct
  • How to dynamically reshape matrix block-wise? [duplicate]
  • How to access fields declared inside anonymous object?
  • Scala prevent mixing methods
  • GLFW triangle will not change color
  • Regexp, capture between parentheses, javascript
  • Log4j cannot find properties file in a simple application
  • Express displaying mongodb documents in Jade
  • Ruby and class variables in inherit class
  • req.body is undefined - nodejs
  • Opengl-es onTouchEvents problem or a draw problem? [closed]
  • output of program is not same as passed argument
  • sending/ receiving email in Java
  • Javascript + PHP Encryption with pidCrypt
  • Akka Routing: Reply's send to router ends up as dead letters
  • Return words with double consecutive letters
  • How to format a variable of double type
  • Cannot Parse HTML Data Using Android / JSOUP
  • How to delete a row from a dynamic generate table using jquery?
  • Python: how to group similar lists together in a list of lists?
  • Windows forms listbox.selecteditem displaying “System.Data.DataRowView” instead of actual value
  • Proper way to use connect-multiparty with express.js?
  • JTable with a ScrollPane misbehaving
  • coudnt use logback because of log4j
  • Getting Messege Twice Using IMvxMessenger
  • Java static initializers and reflection
  • apache spark aggregate function using min value
  • unknown Exception android
  • JaxB to read class hierarchy
  • Checking variable from a different class in C#
  • Busy indicator not showing up in wpf window [duplicate]
  • Sorting a 2D array using the second column C++
  • Observable and ngFor in Angular 2
  • How can i traverse a binary tree from right to left in java?
  • failed to connect to specific WiFi in android programmatically
  • Unable to use reactive element in my shiny app
  • How can I use threading to 'tick' a timer to be accessed by other threads?