Hive Metastore canary failed for an unknown reason.

[#1]

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.

[#2 · Accepted solution]

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

Thanks ALL 

[#3]

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.