Thanks David,
I will take a shot at this today.
Best
Bhupesh
On Sun, Aug 21, 2011 at 6:51 PM, David Burley wrote:
> Bhupesh,
>
> The following worked for us on a MySQL metastore:
>
> mysqldump metastore > metastore-backup-`date +%Y%m%d`.sql
> mysql metastore
> UPDATE SDS SET LOCATION=REPLACE(L
Bhupesh,
The following worked for us on a MySQL metastore:
mysqldump metastore > metastore-backup-`date +%Y%m%d`.sql
mysql metastore
UPDATE SDS SET LOCATION=REPLACE(LOCATION, 'hdfs://hadoop-namenode-1',
'hdfs://hadoop-namenode-2');
UPDATE DBS SET `DESC`=REPLACE(`DESC`, 'hdfs://hadoop-namenode-1',
--
> *From:* Bhupesh Bansal
> *To:* user@hive.apache.org
> *Sent:* Friday, August 19, 2011 2:26 PM
> *Subject:* Alter table Set Locations for all partitions
>
> Hey Folks,
>
> I am wondering what is the easiest way to migrate data off one hadoop
Photos on Flickr
Also check out my Blog for answers to commonly asked questions.
From: Bhupesh Bansal
To: user@hive.apache.org
Sent: Friday, August 19, 2011 2:26 PM
Subject: Alter table Set Locations for all partitions
Hey Folks,
I am wondering what is the easi
ell for me.
-Ayon
See My Photos on Flickr
Also check out my Blog for answers to commonly asked questions.
From: Bhupesh Bansal
To: user@hive.apache.org
Sent: Friday, August 19, 2011 2:26 PM
Subject: Alter table Set Locations for all partitions
Hey Folks,
I am wond
>
> That way you will have the data copied and all the partitions created
> correctly for you.
>
> Thanks
> Vaibhav
>
> From: Bhupesh Bansal [mailto:bhup...@groupon.com]
> Sent: Friday, August 19, 2011 2:27 PM
> To: user@hive.apache.org
> Subject: Alter table Set Locat
ou will have the data copied and all the partitions created correctly
for you.
Thanks
Vaibhav
From: Bhupesh Bansal [mailto:bhup...@groupon.com]
Sent: Friday, August 19, 2011 2:27 PM
To: user@hive.apache.org
Subject: Alter table Set Locations for all partitions
Hey Folks,
I am wondering what is the ea
Hey Folks,
I am wondering what is the easiest way to migrate data off one hadoop/hive
cluster to another.
I distcp all data to new cluster, and then copied the metadata directory to
new cluster.
hive comes up fine and show tables etc but the hive location is still
pointing to old cluster
There i