Re: Pointing multiple external tables to the same location

2014-01-15 Thread Navis류승우
I thinks it's back to original problem. What you wanted is separated scan(task) for different view. But hive does not work like that. If two tables or views (or mix of them) has same location, it's regarded as same table with same table description (will be overridden by lastly visited table or vi

Re: [DISCUSS] Proposed Changes to the Apache Hive Project Bylaws

2014-01-15 Thread Thejas Nair
Adding another sentence to clarify that with a -1, the patch can be reverted "If the code has been committed before the -1, the code can be reverted until the vote is over." Approval : Code Change : The code can be committed after the first +1. Committers should wait for reasonable time after pat

Re: Hive Import/Export

2014-01-15 Thread Stephen Sprague
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 depend

Hive Import/Export

2014-01-15 Thread P lva
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