[FLINK-23544] Window TVF Supports session window

• Type: Sub-task
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Fix Version/s: 1.14.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: Jing Zhang
• Reporter: Jing Zhang
• Created: 29/Jul/21 10:11
• Updated: 03/Sep/21 08:02
• Resolved: 11/Aug/21 12:20

Description

Window TVF would support SESSION window in the following case:

1. SESSION Window TVF followed by Window Aggregate, in this case SESSION window TVF would be pulled up into WindowAggregate, so Window assigner would happen in WindowAggrgeate  

 

Note, SESSION window TVF only works in limited cases currently, the following user cases is not supported yet:

1. SESSION WINDOW TVF followed by Window JOIN
2. SESSION WINDOW TVF followed by Window RANK**

BESIDES, SESSION window Aggregate does not support the following performance improvement yet:

     1. Split Distinct Aggregation

     2. Local-global Aggregation

     3. Mini-batch Aggregate

Issue Links

• is duplicated by: FLINK-23565 Window TVF Supports session window in runtime
• is duplicated by: FLINK-23543 Window TVF Supports session window
• relates to: FLINK-24024 Support session Window TVF
• relates to: CALCITE-4337 Support PARTITION BY clause in table function call
• links to: GitHub Pull Request #16669