[
https://issues.apache.org/jira/browse/HIVE-17792?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16208908#comment-16208908
]
Deepak Jaiswal commented on HIVE-17792:
---------------------------------------
Yes. I will do it shortly.
> 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
> Components: Query Planning, Tez
> Reporter: Deepak Jaiswal
> Assignee: Deepak Jaiswal
> Fix For: 3.0.0
>
> Attachments: HIVE-17792.1.patch, HIVE-17792.2.patch,
> HIVE-17792.3.patch, HIVE-17792.4.patch, HIVE-17792.5.patch
>
>
> 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)
