[FLINK-27853] FLIP-229: Introduces Join Hint for Flink SQL Batch Job

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.16.0
• Fix Version/s: 1.16.0
• Component/s: Table SQL / Planner
• Assignee: Unassigned
• Reporter: xuyang
• Created: 31/May/22 15:10
• Updated: 30/Sep/22 08:57
• Resolved: 30/Sep/22 08:57

Description

Introduce join hint for Flink SQL batch job. Join hint is provided for users to intervene in optimizing the plan, to avoid the optimizer use the wrong join strategy.

More details can be found here: https://cwiki.apache.org/confluence/display/FLINK/FLIP-229%3A+Introduces+Join+Hint+for+Flink+SQL+Batch+Job

Sub-Tasks

• Support SQL hint for Filter, SetOp, Sort, Window, Values: Closed
• support join hint in flink batch: Closed
• Add document to describe join hints for batch sql: Closed