[
https://issues.apache.org/jira/browse/FLINK-28599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17568287#comment-17568287
]
Yunhong Zheng commented on FLINK-28599:
---------------------------------------
Hi, [~godfreyhe] , could you assign this to me ! Thanks !
> Adding FlinkJoinToMultiJoinRule to support left/right outer join can be
> translated to multi join
> ------------------------------------------------------------------------------------------------
>
> Key: FLINK-28599
> URL: https://issues.apache.org/jira/browse/FLINK-28599
> Project: Flink
> Issue Type: Improvement
> Components: Table SQL / Planner
> Affects Versions: 1.16.0
> Reporter: Yunhong Zheng
> Priority: Major
> Fix For: 1.16.0
>
>
> Now, Flink use Calcite's rule
> {code:java}
> JOIN_TO_MULTI_JOIN{code}
> to convert multiple joins into a join set, which can be used by join
> reorder. However, calcite's rule can not adapte to all outer joins. For left
> or right outer join, if they meet certain conditions, it can also be
> converted to multi join.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
