[FLINK-16332] Support un-ordered mode for async lookup join

• Type: New Feature
• Status: Closed
• Priority: Not a Priority
• Resolution: Fixed
• Component/s: Table SQL / Runtime
• Labels: auto-deprioritized-major auto-deprioritized-minor
• Assignee: Unassigned
• Reporter: Jark Wu
• Created: 28/Feb/20 11:09
• Updated: 18/Sep/22 13:21
• Resolved: 18/Sep/22 13:21

Description

Currently, we only support "ordered" mode for async lookup join. Because the ordering in streaming SQL is very important, the accumulate and retract messages shoudl be in ordered. If messages are out of order, the result will be wrong.

The "un-ordered" mode can be enabled by a job configuration. But it will be a prefered option. Only if it doesn't affect the order of acc/retract messages (e.g. it is just an append-only stream), the "un-ordered" mode will be enabled. 

Issue Links

• Is contained by: FLINK-16780 improve Flink lookup join
• is fixed by: FLINK-27622 Make `AsyncDataStream.OutputMode` configurable for table module