[FLINK-33397] FLIP-373: Support Configuring Different State TTLs using SQL Hint

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.19.0
• Fix Version/s: 1.19.0
• Component/s: Table SQL / API

Release Note

This is a new feature in Apache Flink 1.19 that enhances the flexibility and user experience when managing SQL state time-to-live (TTL) settings. Users can now specify custom TTL values for regular joins and group aggregations directly within their queries by [utilizing the STATE_TTL hint](https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/sql/queries/hints/#state-ttl-hints).

This improvement means that you no longer need to alter your compiled plan to set specific TTLs for these operators. With the introduction of STATE_TTL hints, you can streamline your workflow and dynamically adjust the TTL based on your operational requirements.

• Assignee: xuyang
• Reporter: Jane Chan
• Created: 30/Oct/23 09:28
• Updated: 21/Feb/24 06:12
• Resolved: 30/Jan/24 01:37

Description

Please refer to https://cwiki.apache.org/confluence/display/FLINK/FLIP-373%3A+Support+Configuring+Different+State+TTLs+using+SQL+Hint for more details.

Issue Links

• is related to: FLINK-33396 The table alias should be removed in the final plan when using join hints
• is related to: FLINK-33395 The join hint doesn't work when appears in subquery
• mentioned in: Page Loading...
• mentioned in: Page Loading...

Sub-Tasks

• Support state TTL hint for regular join: Closed
• Support state TTL hint for group aggregate: Closed
• Add documentation on how to use state TTL hint: Closed