I did have the exact scenario but w/o partitioned tables. I took the more hackish but definitive approach. I wrote a script to read "desc formatted <tablename>" for every db and then parse them and replace the name-node string and re-fire the create table call on new cluster. It worked well for me. -Ayon See My Photos on Flickr Also check out my Blog for answers to commonly asked questions.
________________________________ From: Bhupesh Bansal <bhup...@groupon.com> 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/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 is one command alter table table_name set location new_location but it doesnt work for partitioned tables, is there a way we can do it for *ALL* partitions easily ?? Best Bhupesh