godfrey he created FLINK-27815:
----------------------------------
Summary: Improve the join reorder strategy for batch sql job
Key: FLINK-27815
URL: https://issues.apache.org/jira/browse/FLINK-27815
Project: Flink
Issue Type: New Feature
Components: Table SQL / Planner
Reporter: godfrey he
Join is heavy operation in the execution, the join order in a query can have a
significant impact on the query’s performance.
Currently, the planner has one join reorder strategy which is provided by
Apache Calcite,
but it strongly depends on the statistics. It's better we can provide different
join reorder strategies for different situations, such as:
1. provide a join reorder strategy without statistics, e.g. eliminate cross
joins
2. improve current join reorders strategy with statistics
3. provide hints to allow users to choose join order strategy
4. ...
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
