Another instance of Derby may have already booted the database /opt/spark/shark/bin/metastore_db.

[vinayak navale <vi...@gmail.com>]

Hi,

i am getting error message while running shark query when i use multiple
console

as below.

Caused by: ERROR XSDB6: Another instance of Derby may have already booted
the database /opt/spark/shark/bin/metastore_db.

is their any other way around if i can use mysql for the same what are the
cons and pros and also could you please tell what all changes need to be
done to use mysql for metastore.

your help is appreciated



Thanks,
Vinayak

Re: Another instance of Derby may have already booted the database /opt/spark/shark/bin/metastore_db.

[Reynold Xin <rx...@apache.org>]

Yes - you can configure mysql as the metastore in Hive and Shark should
pick it up:

https://cwiki.apache.org/confluence/display/Hive/AdminManual+MetastoreAdmin

Make sure you have the mysql connector jar in hive/lib.


On Tue, Oct 15, 2013 at 3:05 AM, vinayak navale <vi...@gmail.com>wrote:

> Hi,
>
> i am getting error message while running shark query when i use multiple
> console
>
> as below.
>
> Caused by: ERROR XSDB6: Another instance of Derby may have already booted
> the database /opt/spark/shark/bin/metastore_db.
>
> is their any other way around if i can use mysql for the same what are the
> cons and pros and also could you please tell what all changes need to be
> done to use mysql for metastore.
>
> your help is appreciated
>
>
>
> Thanks,
> Vinayak
>
>
>
>