[
https://issues.apache.org/jira/browse/DRILL-2702?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau updated DRILL-2702:
----------------------------------
Fix Version/s: 1.2.0
> 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: 1.2.0
>
>
> 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)
