[jira] [Created] (FLINK-28599) Adding FlinkJoinToMultiJoinRule to support left/right outer join can be translated to multi join

["Yunhong Zheng (Jira)" <ji...@apache.org>]

Yunhong Zheng created FLINK-28599:
-------------------------------------

             Summary: 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
             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)