[DRILL-2060] Support constant folding in expressions in Filter

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.9.0
• Component/s: Execution - Flow, Query Planning & Optimization
• Assignee: Jason Altekruse
• Reporter: Aditya Kishore
• Created: 23/Jan/15 05:55
• Updated: 06/Apr/15 23:00
• Resolved: 06/Apr/15 23:00

Description

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

Issue Links

• depends upon: DRILL-2143 Remove RecordBatch from setup method of DrillFunc interface
• depends upon: DRILL-2406 Fix expression interpreter to allow executing expressions at planning time
• is depended upon by: DRILL-2173 Enable querying partition information without reading all data