Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Oozie spark action fails

Highlighted

Oozie spark action fails

Explorer

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.

hcatMetastoreUri=thrift://xxxxxxxxxxx:9083
hcatMetastorePrincipal=hive/_HOST@xxxxxxxx.COM

 

 

Please advise.

 

 

1 REPLY 1

Re: Oozie spark action fails

Champion
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.
Don't have an account?
Coming from Hortonworks? Activate your account here