Support Questions

jgartman · ‎01-25-2016

After installing HDP 2.3.4 on windows server 2012, the following service does not start; DerbyServer. The service terminates almost immediately when trying to start. I see the below error message when looking at the Hive logs.

Attempt to invoke the "BONECP" plugin to create a ConnectionPool gave an error : The specified datastore driver ("org.apache.derby.jdbc.ClientDriver") was not found in the CLASSPATH. Please check your CLASSPATH specification, and the name of the driver.

I see the "derby-10.10.2.0.jar" file within the hdp\hive-xxx\lib" directory

Thanks for the help...

jgartman · ‎01-28-2016

All,

I'm embarrassed to report the following... After nearly pulling the plug on this POC using windows server, i decided to start from the very beginning, basically "is it plugged in". While doing so, i discovered that I had fat fingered ip addresses in the Host File, which led to issues with the installation. After correcting the host IP addresses, i was able to successfully reinstall HDP common, Hive, Oozie, HBase.

Configuration:

2 windows servers (01 and 02)

Options: HDP Common, HBase, Hive and Oozie with MSSQL Metastore ~could never get DerbyServer to work

Modified Hive-Site.xml

Set dataNucleus.autoCreateSchema and dataNucleus.validateTables to True

Note: While monitoring the Hive and Hiveserver2 test, i noticed the test was blocked by an open connection from hive. It was an idle connection that prevented the hive test from creating the missing tables, like TBL_Privs.

View solution in original post

aervits · ‎01-28-2016

Excellent, I hope you restored faith in our product. Go @John Gartman

Cloudera Community

Support Questions

HDP 2.3.4 Windows Installation and Derby Failure