[FLINK-27583] Improve the plan for TPC-DS queries

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 1.20.0
• Component/s: Table SQL / Planner
• Assignee: Unassigned
• Reporter: godfrey he
• Created: 12/May/22 08:58
• Updated: 11/Mar/24 12:44

Description

This jira is an umbrella issue, which aims to fix and improve the plan for TPC-DS
including: fix join order bad case, improve multiple input, fix some cost model bad case, etc

Sub-Tasks

• Fix calcite method RelMdUtil$numDistinctVals() wrongly return zero if the method input domainSize much larger than numSelected: Closed
• Fix FlinkFilterJoinRule push wrong filters to another side while join type is left/right outer join: Closed
• Introduce a new flink bushy join reorder rule which based on greedy algorithm: Closed
• Improve the accuracy of estimating the row count of LocalHashAgg to make more two-phase HashAgg operators effective: Open