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 <[email protected]>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 > > > >
