different outer join plan between hive 0.9 and hive 0.10

2013-03-23 Thread wzc
Recently we tried to upgrade our hive from 0.9 to 0.10, but found some of our hive queries almost 7 times slow. One of such query consists multiple table outer join on the same key. By looking into the query, we found the query plans generate by hive 0.9 and hive 0.10 are different. Here is the

Hive index rebuild

2013-03-23 Thread Echo Li
Hi, I created index and try to rebuild by partitions, however it did not work. Here is my script to create and rebuild index: create index ix_name_cid on table a (customer_id) as 'org.apache.hadoop.hive.ql.index.compact.CompactIndexHandler' WITH DEFERRED REBUILD; alter index ix_name_cid on a pa