[FLINK-28899] Fix LOOKUP hint with retry option on async lookup mode

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.16.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: lincoln lee
• Reporter: lincoln lee
• Created: 10/Aug/22 06:14
• Updated: 16/Aug/22 02:23
• Resolved: 16/Aug/22 02:23

Description

Fix the broken path for async lookup with retry options in  LOOKUP hint.

Will use a `RetryableAsyncLookupFunctionDelegator` instead of `AsyncWaitOperator`

Issue Links

• links to: GitHub Pull Request #20531