Deepak Jaiswal created HIVE-17792: ------------------------------------- Summary: Enable Bucket Map Join when there are extra keys other than bucketed columns Key: HIVE-17792 URL: https://issues.apache.org/jira/browse/HIVE-17792 Project: Hive Issue Type: Bug Reporter: Deepak Jaiswal Assignee: Deepak Jaiswal
Currently this wont go through Bucket Map Join(BMJ) CREATE TABLE tab_part (key int, value string) PARTITIONED BY(ds STRING) CLUSTERED BY (key) INTO 4 BUCKETS STORED AS TEXTFILE; CREATE TABLE tab(key int, value string) PARTITIONED BY(ds STRING) STORED AS TEXTFILE; select a.key, a.value, b.value from tab a join tab_part b on a.key = b.key and a.value = b.value; -- This message was sent by Atlassian JIRA (v6.4.14#64029)