You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by bichonfrise74 <bi...@gmail.com> on 2010/11/04 22:32:53 UTC

Changing Apache Derby Embedded Database

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

Re: Changing Apache Derby Embedded Database

Posted by Edward Capriolo <ed...@gmail.com>.

On Thu, Nov 4, 2010 at 5:32 PM, bichonfrise74 <bi...@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