drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aditya Kishore (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-2060) Support constant folding in expressions in Filter
Date Fri, 23 Jan 2015 05:55:37 GMT
Aditya Kishore created DRILL-2060:

             Summary: 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

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'}}

{{Where age + 5 < 42}}
can be re-written as
{{Where age < 37}}

This message was sent by Atlassian JIRA

View raw message