I tried to use CM API to create a HIVE service and then started. The service can't be started due to following errors.
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.
hive = cluster.create_service(SERVICE_INSTANCE_NAME, SERVICE_NAME)
I guess if cluster.auto_configure() will connect mysql DB instead of build-in Postgre DB?
> The specified datastore driver ("com.mysql.jdbc.Driver") was not found in the CLASSPATH
For some licensing reasons, Cloudera Manager doesn't ship with the MySQL JDBC drivers. Here, Hive is configured to use MySQL, and is failing to find the driver.
If you want to use MySQL, follow the instructions at ("Installing the MySQL JDBC Connector") http://www.cloudera.com/content/cloudera/en/documentation/cloudera-manager/v5-latest/Cloudera-Manage...
I didn't plan to use MySQL; instread, I would like to use embedded DB.
Using the the CM API above, the API configured Hive to use MySQL. Do you have any example to setup embedded DB.