[FLINK-32053] Introduce StateMetadata to ExecNode to support configure operator-level state TTL via CompiledPlan

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.18.0
• Fix Version/s: 1.18.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: Jane Chan
• Reporter: Jane Chan
• Created: 11/May/23 06:46
• Updated: 21/Jul/23 03:19
• Resolved: 05/Jun/23 11:19

Description

This subtask should introduce StateMetadata to all ExecNodes that translate to stateful operators, changing the way how `#translateToPlanInternal` get the state retention time. The affected `ExecNode` list

    StreamExecChangelogNormalize
    StreamExecDeduplicate
    StreamExecGlobalGroupAggregate
    StreamExecGroupAggregate
    StreamExecIncrementalGroupAggregate
    StreamExecJoin
    StreamExecLimit
    StreamExecLookupJoin
    StreamExecRank
    StreamExecSink
    StreamExecSortLimit

Since we have upgraded some `ExecNode`s to version 2, we have to test the following 3 parts:
1. the plans serialized using version 1 can be deserialized using the current version.
2. the plans with the current version SerDe work as expected.
3. The way by modifying the JSON content to change state TTL works as expected.

Issue Links

• links to: GitHub Pull Request #22593
• links to: GitHub Pull Request #22593