It looks like only one user can access the Apache Derby DB. When I try to have multiple jobs running on hive, the other jobs complain something like this:
FAILED: Error in metadata: javax.jdo.JDOFatalDataStoreException: Failed to start database '/hadoop/metastore_db', see the next exception for details. NestedThrowables: java.sql.SQLException: Failed to start database '/hadoop/metastore_db', see the next exception for details. FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask Has anyone seen this before? Also, has anyone changed the embedded database to use MySQL instead? Thanks, bichonfrise74