hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Prem Yadav <ipremya...@gmail.com>
Subject Re: Alter location of database in Hive
Date Tue, 01 Jul 2014 01:15:05 GMT
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.bender@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.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