hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jon Bender <>
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 <>

> 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

View raw message