hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jon Bender <jonathan.ben...@gmail.com>
Subject Re: Alter location of database in Hive
Date Tue, 01 Jul 2014 00:54:37 GMT
Answered my own question, no there is not.  The way to do is is to modify
the DB_LOCATION_URI field in metastore.DBS (at least if you're using MySQL)


On Mon, Jun 30, 2014 at 5:14 PM, Jon Bender <jonathan.bender@gmail.com>
wrote:

> Hey all,
>
> I'm on Hive 0.10.0 on one of my clusters.  We had a namenode hostname
> change, so I'm trying to point all of our tables, partitions and databases
> to the new locations.
>
> When i describe database mydb, the location shows up as
> "hdfs://<old_hostname>/user/hive/warehouse/mydb.db", and i want to set it
> to "hdfs://<new_hostname>/user/hive/warehouse/mydb.db"
>
> Is there a way to do this.  Or do I need to go poking around in the mysql
> metadata to actually carry this out?
>
> Regards,
> Jon
>

Mime
View raw message