Sergey Shelukhin created HIVE-16017: ---------------------------------------
Summary: MM tables - buckets + union is broken Key: HIVE-16017 URL: https://issues.apache.org/jira/browse/HIVE-16017 Project: Hive Issue Type: Sub-task Reporter: Sergey Shelukhin This duplicates the data (given that the original query is a self-union, essentially outputs it 4 times instead of 2) for either MM or non-MM tables, on MM branch. It seems to be adding correct inputs (esp. in non-MM case the inputs are the same as before). Presumably something in the output changes in the branch is broken for this case. Not sure what yet. {noformat} CREATE TABLE tbl1_mm(key int, value string) CLUSTERED BY (key) SORTED BY (key) INTO 2 BUCKETS; insert overwrite table tbl1_mm select * from src where key < 10; select key, value from tbl1_mm a where key < 6 union all select key, value from tbl1_mm a where key < 6; {noformat} -- This message was sent by Atlassian JIRA (v6.3.15#6346)