Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Hive Metastore canary failed for an unknown reason.

avatar
Contributor

Guys, i`ve faced this error during Hive installation.

Deep log searching gave me this:

 

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.

the main question is: where to configure CLASSPATH ?

 

i`ve put mysql-jar into:

 

# ls /opt/cloudera/parcels/CDH-6.1.1-1.cdh6.1.1.p0.875250/jars/mysql*
/opt/cloudera/parcels/CDH-6.1.1-1.cdh6.1.1.p0.875250/jars/mysql-connector-java-5.1.46.jar /opt/cloudera/parcels/CDH-6.1.1-1.cdh6.1.1.p0.875250/jars/mysql-connector-java.jar
#

But no use, can anyone help me please on this ?

 

Thanks.

 

1 ACCEPTED SOLUTION

avatar
Contributor

Issue was resolved by putting mysql jar into /opt/cloudera/parcels/CDH/lib/hive/lib

 

Thanks ALL 

View solution in original post

2 REPLIES 2

avatar
Contributor

Issue was resolved by putting mysql jar into /opt/cloudera/parcels/CDH/lib/hive/lib

 

Thanks ALL 

avatar
Community Manager

I'm happy to see you resolved your issue. Please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future. 

 

 

 

 Screen Shot 2018-12-17 at 12.14.06 PM.png

 

 


Cy Jervis, Manager, Community Program
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.