Ramana Inukonda Nagaraj created DRILL-928:
---------------------------------------------
Summary: Regression: Forcing a merge join instead of a hash join
results in a Failure while reading vector. Expected vector class of
org.apache.drill.exec.vector.BigIntVector but was holding vector class
org.apache.drill.exec.vector.VarBinaryVector.
Key: DRILL-928
URL: https://issues.apache.org/jira/browse/DRILL-928
Project: Apache Drill
Issue Type: Bug
Components: Query Planning & Optimization
Reporter: Ramana Inukonda Nagaraj
Priority: Critical
Test case:
alter session set `planner.enable_hashjoin` = false;
select count(*)
from supplier s, lineitem l, orders o
where s.s_suppkey = l.l_suppkey
and o.o_orderkey = l.l_orderkey
and l.l_shipdate between date '1995-01-01' and date '1995-12-31' ;
If the alter session is removed the query works fine. Which leads me to believe
its something in either the mergejoin or the sort before the mergejoin step.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
