Posts: 10
Registered: ‎07-04-2016

Oozie spark action fails

Hi ,


We have CDH 5.8.2 version in both DEV and SIT .Both uses mysql as backend DB.

Oozie workflow is running fine in Dev. It fails in SIT with below error though we have passed correct hive-site xml to applciation workflow directory in HDFS.


Caused by: java.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:derby:;databaseName=/var/lib/hive/metastore/metastore_db;create=true, username = APP. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------

java.sql.SQLException: Failed to create database '/var/lib/hive/metastore/metastore_db', see the next exception for details.

       at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)

       at org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(Unknown Source)


Both hive and oozie uses mysql DB.


Have properties set for metastore URI.




Please advise.



Posts: 642
Topics: 3
Kudos: 121
Solutions: 67
Registered: ‎08-16-2016

Re: Oozie spark action fails

jdbc:derby:;databaseName=/var/lib/hive/metastore/metastore_db;create=true, username = APP

The JDBC URL is for a derby database and the path is the default derby database location for Hive.

Please double check the configuration for Hive on the SIT cluster. If possible post the hive-site.xml.