drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jason Altekruse (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-2060) Support constant folding in expressions in Filter
Date Mon, 09 Mar 2015 21:25:38 GMT

    [ https://issues.apache.org/jira/browse/DRILL-2060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14353636#comment-14353636

Jason Altekruse commented on DRILL-2060:

There have been some difficulties with the constant folding rule and a number of current system
tests. To allow a subset of this work to be merged into the codebase while these issues are
being debugged, I have opened a new JIRA for the bulk of the refactoring DRILL-2406. The only
part of these patches that will remain in association with this JIRA is the actual constant
folding rule itself and the extra pieces needed to hook it up to calcite, will post a revised
patch soon.

> Support constant folding in expressions in Filter
> -------------------------------------------------
>                 Key: DRILL-2060
>                 URL: https://issues.apache.org/jira/browse/DRILL-2060
>             Project: Apache Drill
>          Issue Type: New Feature
>          Components: Execution - Flow, Query Planning & Optimization
>            Reporter: Aditya Kishore
>            Assignee: Jacques Nadeau
>             Fix For: 0.8.0
>         Attachments: DRILL-2060-const-folding-feb-6.diff, DRILL-2060-part1-const-folding-feb-27.patch,
DRILL-2060-part2-const-folding-feb-27.patch, DRILL-2060.patch
> If one side of a filter condition is a constant expression, we should be able to evaluate
the expression in the planning phase and replace the expression with the constant value.
> For example, the following filter
> {{Where shipdate < date '1997-01-01' + interval '1' year}}
> can be re-written as
> {{Where shipdate < date '1998-01-01'}}
> Or 
> {{Where age + 5 < 42}}
> can be re-written as
> {{Where age < 37}}

This message was sent by Atlassian JIRA

View raw message