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)