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
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