Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive Metastore canary failed for an unknown reason.

Solved Go to solution
Highlighted

Hive Metastore canary failed for an unknown reason.

Explorer

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

Accepted Solutions

Re: Hive Metastore canary failed for an unknown reason.

Explorer

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

 

Thanks ALL 

2 REPLIES 2

Re: Hive Metastore canary failed for an unknown reason.

Explorer

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

 

Thanks ALL 

Re: Hive Metastore canary failed for an unknown reason.

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, 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:
Community Guidelines
How to use the forum