hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deepak Jaiswal (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-17792) Enable Bucket Map Join when there are extra keys other than bucketed columns
Date Tue, 17 Oct 2017 00:45:00 GMT

    [ https://issues.apache.org/jira/browse/HIVE-17792?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16206838#comment-16206838
] 

Deepak Jaiswal commented on HIVE-17792:
---------------------------------------

Thanks for the review [~jdere].

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

Mime
View raw message