[jira] [Created] (DRILL-2060) Support constant folding in expressions in Filter

["Aditya Kishore (JIRA)" <ji...@apache.org>]

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

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




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