[jira] [Comment Edited] (CALCITE-5109) RelMdAllPredicates support to analyze left-out-join

["Chunwei Lei (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-5109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17526462#comment-17526462 ] 

Chunwei Lei edited comment on CALCITE-5109 at 4/22/22 2:20 PM:
---------------------------------------------------------------

+1 to support left/right join in RelMdAllPredicates. It is awesome if it can support rewriting queries with left/right join. 


was (Author: chunwei lei):
+1 to support left join in RelMdAllPredicates. It is awesome if it can support rewriting queries with left join. 

> RelMdAllPredicates support to analyze left-out-join
> ---------------------------------------------------
>
>                 Key: CALCITE-5109
>                 URL: https://issues.apache.org/jira/browse/CALCITE-5109
>             Project: Calcite
>          Issue Type: Wish
>          Components: core
>            Reporter: Xurenhe
>            Priority: Major
>
>  
> {code:java}
> select * from
>  left_sub_query {left_where_condition}
> join {join_type}
>  right_sub_query {right_where_condition}
> on {on_condition}
> where {where_condition}{code}
>  
> As we know:
>  * join_type is {*}left out join{*}:
>  ** *left_where_condition* could be pulled to *where_condition*
>  ** *right_where_condition* could be pulled to *on_condition*
>  * join_type is *right out join:* 
>  ** *left_where_condition* could be pulled to *on_condition*
>  ** *right_where_condition* could be pulled to *where_condition*
> ----
> There are a large number of star-model in the warehouse. Rewriting query by materialized view is a very effective way to speed up query.
>  
> I'm expanding [*MaterializedViewRule#perform*|#L175]]to support rewriting query when meeting left-out-join, and found that [*RelMdAllPredicates*|#L193]] didn't support to analyze left-join.
> Could calcite support it? This feature is very important for expanding *MaterializedViewRule#perform*
>  



--
This message was sent by Atlassian Jira
(v8.20.7#820007)