[
https://issues.apache.org/jira/browse/HIVE-5813?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13821613#comment-13821613
]
Ashutosh Chauhan commented on HIVE-5813:
----------------------------------------
To repro in unit test environment, use following .q file:
{code}
set hive.vectorized.execution.enabled=true;
set hive.auto.convert.join=true;
explain
select *
from alltypesorc c
left outer join alltypesorc cd
on cd.cint = c.cint
left outer join alltypesorc hd
on hd.ctinyint = c.ctinyint;
select *
from alltypesorc c
left outer join alltypesorc cd
on cd.cint = c.cint
left outer join alltypesorc hd
on hd.ctinyint = c.ctinyint;
set hive.auto.convert.join=false;
set hive.vectorized.execution.enabled=false;
{code}
Stacktrace:
{code}
Caused by: org.apache.hadoop.hive.ql.metadata.HiveException: Hive Runtime Error
while processing row
at
org.apache.hadoop.hive.ql.exec.vector.VectorMapOperator.process(VectorMapOperator.java:45)
... 8 more
Caused by: java.lang.NullPointerException
at
org.apache.hadoop.hive.ql.exec.vector.VectorColumnAssignFactory.buildAssigners(VectorColumnAssignFactory.java:363)
at
org.apache.hadoop.hive.ql.exec.vector.VectorMapJoinOperator.internalForward(VectorMapJoinOperator.java:235)
at
org.apache.hadoop.hive.ql.exec.CommonJoinOperator.createForwardJoinObject(CommonJoinOperator.java:439)
at
org.apache.hadoop.hive.ql.exec.CommonJoinOperator.genObject(CommonJoinOperator.java:530)
at
org.apache.hadoop.hive.ql.exec.CommonJoinOperator.genObject(CommonJoinOperator.java:527)
at
org.apache.hadoop.hive.ql.exec.CommonJoinOperator.genJoinObject(CommonJoinOperator.java:457)
at
org.apache.hadoop.hive.ql.exec.CommonJoinOperator.checkAndGenObject(CommonJoinOperator.java:768)
at
org.apache.hadoop.hive.ql.exec.MapJoinOperator.processOp(MapJoinOperator.java:218)
at
org.apache.hadoop.hive.ql.exec.vector.VectorMapJoinOperator.processOp(VectorMapJoinOperator.java:293)
at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:522)
at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:865)
at
org.apache.hadoop.hive.ql.exec.TableScanOperator.processOp(TableScanOperator.java:93)
at org.apache.hadoop.hive.ql.exec.Operator.process(Operator.java:522)
at org.apache.hadoop.hive.ql.exec.Operator.forward(Operator.java:865)
at
org.apache.hadoop.hive.ql.exec.vector.VectorMapOperator.process(VectorMapOperator.java:43)
... 9 more
{code}
> Multi-way Left outer join fails in vectorized mode
> --------------------------------------------------
>
> Key: HIVE-5813
> URL: https://issues.apache.org/jira/browse/HIVE-5813
> Project: Hive
> Issue Type: Bug
> Components: Vectorization
> Affects Versions: 0.13.0
> Reporter: Ashutosh Chauhan
>
> with hive.auto.convert.join=true
--
This message was sent by Atlassian JIRA
(v6.1#6144)
