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

["Jason Altekruse (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-2060?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jason Altekruse closed DRILL-2060.
----------------------------------
    Resolution: Fixed

Fixed in 8d70709ddaddc7111517f4bed883fc9908ef94de

> 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.9.0
>
>         Attachments: DRILL-2060-15-mar-15.patch, 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)