[DRILL-928] 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.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.5.0
• Component/s: Query Planning & Optimization
• Assignee: DrillCommitter
• Reporter: Ramana Inukonda Nagaraj
• Due: 15/Aug/14
• Created: 07/Jun/14 19:06
• Updated: 18/Aug/14 16:35
• Resolved: 18/Aug/14 16:35

Description

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.