drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aman Sinha (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2479) Correlated EXISTS containing an IN subquery fails to plan
Date Tue, 17 Mar 2015 00:00:48 GMT
Aman Sinha created DRILL-2479:

             Summary: Correlated EXISTS containing an IN subquery fails to plan
                 Key: DRILL-2479
                 URL: https://issues.apache.org/jira/browse/DRILL-2479
             Project: Apache Drill
          Issue Type: Bug
    Affects Versions: 0.8.0
            Reporter: Aman Sinha
            Assignee: Aman Sinha
             Fix For: 0.9.0

The following correlated EXISTS query gives a CannotPlanException : 
 select count(*) from lineitem l where exists (select ps.ps_suppkey from partsupp ps where
ps.ps_suppkey = l.l_suppkey and ps.ps_partkey in (select p.p_partkey from part p));
The query succeeds if the IN clause in the EXISTS subquery is removed or replaced with an
IN list of constants.  It also succeeds on the latest version of Calcite.  Drill is quite
out of date with Calcite and there were decorrelation related changes in Calcite sometime
mid to late 2014.  This issue should get resolved once Drill is rebased on recent Calcite.

This message was sent by Atlassian JIRA

View raw message