[jira] [Updated] (CALCITE-925) Improving optimization using Materialized Views [CALCITE-786] by allowing strings and predicates that specify ranges.

["Amogh Margoor (JIRA)" <ji...@apache.org>]

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

Amogh Margoor updated CALCITE-925:
----------------------------------
    Summary: Improving optimization using Materialized Views [CALCITE-786] by allowing strings and predicates that specify ranges.  (was: Optimizing query using Materialized Views even when predicates specify ranges.)

> Improving optimization using Materialized Views [CALCITE-786] by allowing strings and predicates that specify ranges.
> ---------------------------------------------------------------------------------------------------------------------
>
>                 Key: CALCITE-925
>                 URL: https://issues.apache.org/jira/browse/CALCITE-925
>             Project: Calcite
>          Issue Type: Improvement
>            Reporter: Amogh Margoor
>            Assignee: Julian Hyde
>            Priority: Minor
>
> This is in continuation of CALCITE-786 where queries are optimized using materialized views. Earlier we were not supporting predicates that were specifying ranges over a variable, for e.g., x < 90 and x > 30. No we would be able to optimize even when such predicates are used either in query or to specify a view. 
> Also adding support for strings for the same optimization.



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