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] [Updated] (HIVE-17792) Enable Bucket Map Join when there are extra keys other than bucketed columns
Date Fri, 13 Oct 2017 19:21:00 GMT

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

Deepak Jaiswal updated HIVE-17792:
----------------------------------
    Attachment: HIVE-17792.2.patch

Fixed the failing tests.

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