[
https://issues.apache.org/jira/browse/DRILL-2060?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14353636#comment-14353636
]
Jason Altekruse commented on DRILL-2060:
----------------------------------------
There have been some difficulties with the constant folding rule and a number
of current system tests. To allow a subset of this work to be merged into the
codebase while these issues are being debugged, I have opened a new JIRA for
the bulk of the refactoring DRILL-2406. The only part of these patches that
will remain in association with this JIRA is the actual constant folding rule
itself and the extra pieces needed to hook it up to calcite, will post a
revised patch soon.
> 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
> Fix For: 0.8.0
>
> Attachments: DRILL-2060-const-folding-feb-6.diff,
> DRILL-2060-part1-const-folding-feb-27.patch,
> DRILL-2060-part2-const-folding-feb-27.patch, DRILL-2060.patch
>
>
> 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)
