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 >