You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Deepak Jaiswal (JIRA)" <ji...@apache.org> on 2017/10/12 20:05:00 UTC

[jira] [Work started] (HIVE-17792) Enable Bucket Map Join when there are extra keys other than bucketed columns

     [ https://issues.apache.org/jira/browse/HIVE-17792?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Work on HIVE-17792 started by Deepak Jaiswal.
---------------------------------------------
> 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)