I think you should be able to copy the data to a different location and then drop the old db, and create a new one with the new location.
On Tue, Jul 1, 2014 at 1:54 AM, Jon Bender <jonathan.ben...@gmail.com> wrote: > 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.ben...@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 >> > >