wow. that's the craziest thing i've ever seen. my approach to moving tables (partitioned or not) is:
1. run the ddl to create the table on the new cluster 2. distcp the hdfs data. 3. you might have to use "hdfs dfs -mv" on the new cluster to position your table properly under /warehouse/db depending on your distcp command. 4. run "msck repair table <table>" in hive to discover the partitions and populate the metastore accordingly. works very well for me. cheers, Stephen. PS no need to "export" or "import" data. On Wed, Jan 15, 2014 at 10:25 AM, P lva <ruvi...@gmail.com> wrote: > Hello, > > I'm trying to move a hive table to a different cluster. My table is > partitioned. However when I use hive export-distcp-import, the partitions > are reversed. /warehouse/db/table/a/b/c in old cluster is > /warehouse/db/table/c/b/a in the new cluster. > > How do I avoid this ? > > > Thanks > >
