[ https://issues.apache.org/jira/browse/CALCITE-5109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17529439#comment-17529439 ]
Xurenhe commented on CALCITE-5109: ---------------------------------- Hi [~Chunwei Lei] I made a [PR|[https://github.com/apache/calcite/pull/2783]|https://github.com/apache/calcite/pull/2783],] Please review it, thanks > 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 > Labels: pull-request-available > Time Spent: 10m > Remaining Estimate: 0h > > > {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)