[jira] [Updated] (DRILL-2702) Support more advanced constant expression folding

["Jinfeng Ni (JIRA)" <ji...@apache.org>]

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

Jinfeng Ni updated DRILL-2702:
------------------------------
    Fix Version/s:     (was: 1.2.0)
                   Future

> Support more advanced constant expression folding
> -------------------------------------------------
>
>                 Key: DRILL-2702
>                 URL: https://issues.apache.org/jira/browse/DRILL-2702
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Query Planning & Optimization
>            Reporter: Jason Altekruse
>            Assignee: Jinfeng Ni
>             Fix For: Future
>
>
> A variety of constant expressions are now folded at planning time with the work completed for DRILL-2060. One of the examples listed in the issue is not currently supported. Supporting an expression re-write like this will require more work, this issue is here to track that enhancement request. These types of rewrites are particularly useful for Drill because the speed of Drill is often limited by the types of filter pushdowns supported by the underlying storage system. For system that support range scans, we can rewrite inequalities to range scans in simple cases. Currently we cannot re-write more complicated inequalities like this one below, this query would prompt a full table scan with a filter, but the transformation shown can turn it into a range scan.
> Where age + 5 < 42
> can be re-written as
> Where age < 37



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)