-Re: Hive Import/Export
Stephen Sprague 2014-01-15, 23:17
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.
PS no need to "export" or "import" data.
On Wed, Jan 15, 2014 at 10:25 AM, P lva <[EMAIL PROTECTED]> wrote:
> 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 ?