Xin Hao created HIVE-17565:
------------------------------
Summary: NullPointerException occurs when hive.optimize.skewjoin
and hive.auto.convert.join are switched on at the same time
Key: HIVE-17565
URL: https://issues.apache.org/jira/browse/HIVE-17565
Project: Hive
Issue Type: Bug
Reporter: Xin Hao
NullPointerException occurs when hive.optimize.skewjoin and
hive.auto.convert.join are switched on at the same time.
Could pass when hive.optimize.skewjoin=true and hive.auto.convert.join=false.
Workload:
(1)TPCx-BB Q19
(2) A small case as below，which was actually simplified from Q19：
SELECT *
FROM store_returns sr,
(
SELECT d1.d_date_sk
FROM date_dim d1, date_dim d2
WHERE d1.d_week_seq = d2.d_week_seq
) sr_dateFilter
WHERE sr.sr_returned_date_sk = d_date_sk;
Exception Error Message:
Error: java.lang.RuntimeException: java.lang.NullPointerException
at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.map(ExecMapper.java:179)
at org.apache.hadoop.mapred.MapRunner.run(MapRunner.java:54)
at org.apache.hadoop.mapred.MapTask.runOldMapper(MapTask.java:453)
at org.apache.hadoop.mapred.MapTask.run(MapTask.java:343)
at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:164)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:415)
at
org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1796)
at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
Caused by: java.lang.NullPointerException
at
org.apache.hadoop.hive.ql.exec.MapJoinOperator.loadHashTable(MapJoinOperator.java:194)
at
org.apache.hadoop.hive.ql.exec.MapJoinOperator.cleanUpInputFileChangedOp(MapJoinOperator.java:223)
at
org.apache.hadoop.hive.ql.exec.Operator.cleanUpInputFileChanged(Operator.java:1051)
at
org.apache.hadoop.hive.ql.exec.Operator.cleanUpInputFileChanged(Operator.java:1055)
at
org.apache.hadoop.hive.ql.exec.Operator.cleanUpInputFileChanged(Operator.java:1055)
at
org.apache.hadoop.hive.ql.exec.MapOperator.process(MapOperator.java:490)
at org.apache.hadoop.hive.ql.exec.mr.ExecMapper.map(ExecMapper.java:170)
... 8 more
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
