[jira] [Created] (HIVE-13932) Hive SMB Map Join with small set of LIMIT failed with NPE

["Yongzhi Chen (JIRA)" <ji...@apache.org>]

Yongzhi Chen created HIVE-13932:
-----------------------------------

             Summary: Hive SMB Map Join with small set of LIMIT failed with NPE
                 Key: HIVE-13932
                 URL: https://issues.apache.org/jira/browse/HIVE-13932
             Project: Hive
          Issue Type: Bug
    Affects Versions: 2.0.0, 1.0.0
            Reporter: Yongzhi Chen
            Assignee: Yongzhi Chen


1) prepare sample data:
a=1
while [[ $a -lt 100 ]]; do echo $a ; let a=$a+1; done > data

2) prepare source hive table:
CREATE TABLE `s`(`c` string);
load data local inpath 'data' into table s;

3) prepare the bucketed table:
set hive.enforce.bucketing=true;
set hive.enforce.sorting=true;
CREATE TABLE `t`(`c` string) CLUSTERED BY (c) SORTED BY (c) INTO 5 BUCKETS;
insert into t select * from s;

4) reproduce this issue:
SET hive.auto.convert.sortmerge.join = true;
SET hive.auto.convert.sortmerge.join.bigtable.selection.policy = org.apache.hadoop.hive.ql.optimizer.LeftmostBigTableSelectorForAutoSMJ;
SET hive.auto.convert.sortmerge.join.noconditionaltask = true;
SET hive.optimize.bucketmapjoin = true;
SET hive.optimize.bucketmapjoin.sortedmerge = true;
select * from t join t t1 on t.c=t1.c limit 1;



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