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)

Reply via email to