Re: Alter table Set Locations for all partitions

2011-08-21 Thread David Burley
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',

Re: MySQL Metastore migration

2011-01-06 Thread David Burley
se? > 3) Any other gotchas we should be aware about? > > I believe we are running 0.5. > > Thanks! > -- David Burley Systems Programmer/Analyst Geeknet, Inc. e: da...@geek.net e: bur...@sourceforge.net metastoreprocess Description: Binary data