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] [Assigned] (HIVE-17851) Bucket Map Join : Pick correct number of buckets
Date Thu, 19 Oct 2017 20:14:01 GMT

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

Deepak Jaiswal reassigned HIVE-17851:
-------------------------------------


> Bucket Map Join : Pick correct number of buckets
> ------------------------------------------------
>
>                 Key: HIVE-17851
>                 URL: https://issues.apache.org/jira/browse/HIVE-17851
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Deepak Jaiswal
>            Assignee: Deepak Jaiswal
>
> CREATE TABLE tab_part (key int, value string) PARTITIONED BY(ds STRING) CLUSTERED BY
(key) INTO 2 BUCKETS STORED AS TEXTFILE;
> CREATE TABLE tab(key int, value string) PARTITIONED BY(ds STRING) CLUSTERED BY (key)
INTO 4 BUCKETS STORED AS TEXTFILE;
> select a.key, a.value, b.value
> from tab a join tab_part b on a.key = b.key;
> In above case, if tab_part is bigger then it should be the streaming side and the smaller
side should create two hash tables. However, currently, it blindly picks 4 as number of buckets
as it is the maximum number of buckets among all the tables involved in the join and create
4 hash tables.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message