question Hive Metastore canary failed for an unknown reason. in Support Questions

Hive Metastore canary failed for an unknown reason.

Adilm — Fri, 16 Sep 2022 14:24:13 GMT

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.

Re: Hive Metastore canary failed for an unknown reason.

Adilm — Wed, 22 May 2019 13:28:23 GMT

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.

cjervis — Wed, 22 May 2019 13:31:34 GMT

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.