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] [Updated] (DRILL-3690) Partitioning pruning produces wrong results when there are nested expressions in the filter
Date Sun, 23 Aug 2015 01:26:46 GMT

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

Aman Sinha updated DRILL-3690:
------------------------------
    Component/s: Query Planning & Optimization

> 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
>          Components: Query Planning & Optimization
>            Reporter: Mehant Baid
>            Assignee: Aman Sinha
>            Priority: Blocker
>             Fix For: 1.2.0
>
>
> Consider the following query:
> select 1 from foo where dir0 not in (1994) and col1 not in ('bar');
> The filter condition is: AND(NOT(=($1, 1994)), NOT(=($2, 'bar')))
> 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)). 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