[FLINK-16165] NestedLoopJoin fallback to HashJoin when build records number is very large

• Type: Improvement
• Status: Open
• Priority: Not a Priority
• Resolution: Unresolved
• Component/s: Table SQL / Runtime
• Labels: auto-deprioritized-critical auto-deprioritized-major auto-deprioritized-minor
• Assignee: Unassigned
• Reporter: Jingsong Lee
• Created: 19/Feb/20 10:49
• Updated: 24/Aug/23 22:35

Description

Now, if the statistic is not so accurate, maybe choose wrong join type to nested loop join.

If build records number is very large, this lead to very slow join, the user looks like the join is in Hang.

It is a stability problem, We should fallback to hash join in runtime to avoid this hang.