hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Edward Capriolo <edlinuxg...@gmail.com>
Subject Re: Changing Apache Derby Embedded Database
Date Thu, 04 Nov 2010 22:02:26 GMT
On Thu, Nov 4, 2010 at 5:32 PM, bichonfrise74 <bichonfrise74@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

Mime
View raw message