[jira] [Assigned] (FLINK-37889) Add new FlinkJoinToFlinkMultiJoinRule rule

["Timo Walther (Jira)" <ji...@apache.org>]

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

Timo Walther reassigned FLINK-37889:
------------------------------------

    Assignee: Gustavo de Morais

> Add new FlinkJoinToFlinkMultiJoinRule rule
> ------------------------------------------
>
>                 Key: FLINK-37889
>                 URL: https://issues.apache.org/jira/browse/FLINK-37889
>             Project: Flink
>          Issue Type: Sub-task
>            Reporter: Gustavo de Morais
>            Assignee: Gustavo de Morais
>            Priority: Major
>
> The current FlinkJoinToMultiJoinRule is implemented and only used for join reordering. We can use it as a base but we need a new set of optimizer rules for the multi way join operator. This ticket covers:
>  * Add FlinkLogicalMultiJoin with all parameters we need to create it
>  ** There are some parameters that calcite's MultiJoin does not contain as we require it. For example: we only have outerJoinConditions and we actually need all join conditions for each input level, including inner joins.
> Related:
>  * Add right join to left join rule - our operator only works with left joins
>  * Check if the join chain respects the multi join common key restrictions
>  ** If not, create one multi join for each group of joins that respect. That means 9 chained joins, 3 have one common key and 6 have another will generate two chained multi joins.
>  



--
This message was sent by Atlassian Jira
(v8.20.10#820010)