[
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
