Reply
Highlighted
Explorer
Posts: 7
Registered: ‎12-29-2018
Accepted Solution

Hive Metastore canary failed for an unknown reason.

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.

 

Explorer
Posts: 7
Registered: ‎12-29-2018

Re: Hive Metastore canary failed for an unknown reason.

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

 

Thanks ALL 

Posts: 1,007
Kudos: 119
Solutions: 62
Registered: ‎04-06-2015

Re: Hive Metastore canary failed for an unknown reason.

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, Community Manager


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.

Learn more about the Cloudera Community:

Terms of Service

Community Guidelines

How to use the forum

Announcements