CODEWITHSUNDEEP
mysqlhadoophive
Raghuveer
Raghuveer

Reputation: 3057

Hive mysql connector error

I have installed Hive and mysql successfully, i did the configuration for Hive as suggested in link. But i see an error as below:

Exception in thread "main" java.lang.RuntimeException: java.lang.RuntimeException: Unable to instantiate org.apache.hadoop.hive.ql.metadata.SessionHiveMetaStoreClient
..
..
Caused by: org.datanucleus.exceptions.NucleusException: Attempt to invoke the "BONECP" plugin to create a ConnectionPool gave an error : The specified datastore driver ("com.mysql.jdbc.Driver") was not found in the CLASSPATH. Please check your CLASSPATH specification, and the name of the driver.

so i added the mysql-connector-java.jar in lib of Hive. Now hive just hangs, i dont get the shell at all.

Kindly suggest how i can resolve it

Upvotes: 0

Views: 2881

Answers (1)

alekya reddy
alekya reddy

Reputation: 934

You need to add mysql connector to the classpath in the hive. It is looking for that connector in your classpath and its not able to find it. Download mysql connector and put it to the following path

/usr/lib/hive/apache-hive-0.13.0-bin/lib

Upvotes: 1

Related Questions