hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yongzhi Chen (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-13932) Hive SMB Map Join with small set of LIMIT failed with NPE
Date Thu, 02 Jun 2016 21:45:59 GMT
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)

Mime
View raw message