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)