drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mehant Baid (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-3690) Partitioning pruning produces wrong results when there are nested expressions in the filter
Date Sat, 22 Aug 2015 17:32:45 GMT
Mehant Baid created DRILL-3690:
----------------------------------

             Summary: Partitioning pruning produces wrong results when there are nested expressions
in the filter
                 Key: DRILL-3690
                 URL: https://issues.apache.org/jira/browse/DRILL-3690
             Project: Apache Drill
          Issue Type: Bug
            Reporter: Mehant Baid
            Assignee: Mehant Baid
            Priority: Blocker
             Fix For: 1.2.0


Consider the following query:
select 1 from foo where dir0 not in (1994) and dir1 not in (1995);

The filter condition is: AND(NOT(=($1, 1994)), NOT(=($2, 1995)))
In FindPartitionCondition we rewrite the filter to cherry pick the partition column conditions
so the interpreter can evaluate it, however when the expression contains more than two levels
of nesting (in this case AND(NOT(=))) ) the expression does not get rewritten correctly. In
this case the expression gets rewritten as: AND(=($1, 1994), =($2, 1995)). NOT is missing
from the rewritten expression producing wrong results.





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message