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

Posted to user@hive.apache.org by Rahul Channe <dr...@googlemail.com> on 2014/07/08 17:13:08 UTC

Change default meta store location

Hi All,

Whenever I am logging to hive from any directory it's creating new
metastore_db

I also update the hive-default.xml to change the metastore location to
different location but it's not working

Any help appreciated

Rahul

Re: Change default meta store location

Posted by D K <de...@gmail.com>.

Under your HIVE_HOME/conf create a fine hive-site.xml and override the
following property:
<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:derby:;databaseName=*/new_db_location*
/metastore_db;create=true</value>
  <description>JDBC connect string for a JDBC metastore</description>
</property>

substitute the new_db_location with the new location you want for the
metastore_db to exist in.



On Tue, Jul 8, 2014 at 8:13 AM, Rahul Channe <dr...@googlemail.com> wrote:

> Hi All,
>
> Whenever I am logging to hive from any directory it's creating new
> metastore_db
>
> I also update the hive-default.xml to change the metastore location to
> different location but it's not working
>
> Any help appreciated
>
> Rahul
>