[HIVE-17792] Enable Bucket Map Join when there are extra keys other than bucketed columns

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0.0
• Component/s: Query Planning, Tez
• Assignee: Deepak Jaiswal
• Reporter: Deepak Jaiswal
• Created: 12/Oct/17 20:04
• Updated: 22/May/18 23:16
• Resolved: 17/Oct/17 22:08

Description

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;

Issue Links

• links to: Review Board