[FLINK-14455] Improve join reorder feature without table statistics

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Later
• Affects Version/s: 1.9.0
• Component/s: Table SQL / Planner
• Labels: stale-major
• Assignee: Unassigned
• Reporter: Leonard Xu
• Created: 18/Oct/19 12:37
• Updated: 29/Apr/21 13:03
• Resolved: 29/Apr/21 13:03

Description

tpc-ds query85.sql run fail when enable TABLE_OPTIMIZER_JOIN_REORDER_ENABLED, and run success when disable TABLE_OPTIMIZER_JOIN_REORDER_ENABLED .
I analyzed the optimized plan and thought it‘s a negative case for join reorder feature without table statistic.