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

Jin Xing updated CALCITE-3925:
------------------------------
    Description: LogicalCorrelate is widely used in user SQLs to performs 
nested-loop join.  We need to support substitution based materialized view 
matching for it. The matching algorithm should be able to do Project & Filter 
compensation when matching query with materialized view.  (was: 
LogicalCorrelate is widely used in user SQLs to performs nested-loop join.  We 
need to support substitution based materialized view matching for it. The 
matching algorithm should support Project & Filter compensation when matching 
query with materialized view.)

> Support materialized view matching for LogicalCorrelate in SubsitutionVisitor
> -----------------------------------------------------------------------------
>
>                 Key: CALCITE-3925
>                 URL: https://issues.apache.org/jira/browse/CALCITE-3925
>             Project: Calcite
>          Issue Type: Bug
>            Reporter: Jin Xing
>            Priority: Major
>
> LogicalCorrelate is widely used in user SQLs to performs nested-loop join.  
> We need to support substitution based materialized view matching for it. The 
> matching algorithm should be able to do Project & Filter compensation when 
> matching query with materialized view.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to