hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Edward Capriolo (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (HIVE-3237) hive.enforce.bucketing option seemed not working on test platform
Date Fri, 06 Jul 2012 14:15:35 GMT

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

Edward Capriolo resolved HIVE-3237.
-----------------------------------

    Resolution: Duplicate
    
> hive.enforce.bucketing option seemed not working on test platform
> -----------------------------------------------------------------
>
>                 Key: HIVE-3237
>                 URL: https://issues.apache.org/jira/browse/HIVE-3237
>             Project: Hive
>          Issue Type: Bug
>          Components: Testing Infrastructure
>    Affects Versions: 0.10.0
>            Reporter: Navis
>
> {noformat}
> create table hive_test_smb_bucket1 (key int, value string) partitioned by (ds string)
clustered by (key) sorted by (key) into 2 buckets;
> create table hive_test_smb_bucket2 (key int, value string) partitioned by (ds string)
clustered by (key) sorted by (key) into 4 buckets;
> set hive.enforce.bucketing = true;
> set hive.enforce.sorting = true;
> insert overwrite table hive_test_smb_bucket1 partition (ds='2010-10-15') select key,
value from src;
> insert overwrite table hive_test_smb_bucket2 partition (ds='2010-10-15') select key,
value from src;
> set hive.optimize.bucketmapjoin = true;
> explain extended
> SELECT /* + MAPJOIN(b) */ * FROM hive_test_smb_bucket1 a JOIN hive_test_smb_bucket2 b
ON a.key = b.key;
> {noformat}
> in hive console, bucket context is shown correctly
> {noformat}
> b {000000_0=[000000_0, 000002_0], 000001_0=[000001_0, 000003_0]}
> {noformat}
> But in test platform, only one bucket is shown
> {noformat}
> b {000000_0=[000000_0]}
> {noformat}
> This prevents writing test cases for BMJoin/SMBJoin. 

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message