hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rui Li (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-7956) When inserting into a bucketed table, all data goes to a single bucket [Spark Branch]
Date Thu, 04 Sep 2014 04:05:51 GMT

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

Rui Li commented on HIVE-7956:
------------------------------

[~xuefuz], I copied the extra fields ({{hashCode}},{{distKeyLength}}) for HiveKey. Now all
the reducers get some data but I got another issue here: most of the records go to just one
reducer and records with the same key can go to different reducers. I'll investigate more
into this.

> When inserting into a bucketed table, all data goes to a single bucket [Spark Branch]
> -------------------------------------------------------------------------------------
>
>                 Key: HIVE-7956
>                 URL: https://issues.apache.org/jira/browse/HIVE-7956
>             Project: Hive
>          Issue Type: Bug
>          Components: Spark
>            Reporter: Rui Li
>
> I created a bucketed table:
> {code}
> create table testBucket(x int,y string) clustered by(x) into 10 buckets;
> {code}
> Then I run a query like:
> {code}
> set hive.enforce.bucketing = true;
> insert overwrite table testBucket select intCol,stringCol from src;
> {code}
> Here {{src}} is a simple textfile-based table containing 40000000 records (not bucketed).
The query launches 10 reduce tasks but all the data goes to only one of them.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message