On Thu, Nov 4, 2010 at 5:32 PM, bichonfrise74 <bichonfris...@gmail.com> wrote: > 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
You can run multi-user in hive or use another database: Read these: http://wiki.apache.org/hadoop/Hive/AdminManual/MetastoreAdmin http://wiki.apache.org/hadoop/HiveDerbyServerMode
