[FLINK-31535] Extend watermark-related features for SQL

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.18.0
• Component/s: Table SQL / Runtime
• Labels: pull-request-available
• Release Note: Flink now enable user config watermark emit strategy/watermark alignment/watermark idle-timeout in flink sql job with dynamic table options and 'Options' hint.
• Assignee: Yuan Kui
• Reporter: Yuan Kui
• Created: 21/Mar/23 11:28
• Updated: 17/Jul/23 11:38
• Resolved: 17/Jul/23 10:10

Description

This issue aims to extend watermark-related features which are discussed in https://cwiki.apache.org/confluence/display/FLINK/FLIP-296%3A+Extend+watermark-related+features+for+SQL

Features to extends:

• Configurable watermark emit strategy
• Dealing with idle sources
• Watermark alignment

Issue Links

• links to: GitHub Pull Request #22767
• links to: pr-22767

Sub-Tasks

• Support to set watermark emit strategy in sql layer: Resolved
• Support to configure watermark alignment in sql layer: Resolved
• Support to set source idle-timeout options in sql layer: Resolved
• Add document for using watermark advanced functions in sql: Resolved