drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hanifi Gunes (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (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.
Date Thu, 14 Aug 2014 19:32:18 GMT

     [ https://issues.apache.org/jira/browse/DRILL-928?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Hanifi Gunes updated DRILL-928:
-------------------------------

    Assignee: DrillCommitter  (was: Hanifi Gunes)

> 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
>            Assignee: DrillCommitter
>             Fix For: 0.5.0
>
>
> 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)

Mime
View raw message