[FLINK-21253] Support grouping set syntax for GroupWindowAggregate

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Jing Zhang
• Created: 03/Feb/21 09:46
• Updated: 18/Oct/21 09:08
• Resolved: 29/Apr/21 09:52

Description

Support grouping set syntax in WindowAggregate, like the following example.

 

//代码占位符
SELECT
    a,
    TUMBLE_START(rowtime, INTERVAL '15' MINUTE),
    TUMBLE_END(rowtime, INTERVAL '15' MINUTE),
    COUNT(1)
FROM MyTable
    GROUP BY GROUPING SETS (`a`, ()), TUMBLE(rowtime, INTERVAL '15' MINUTE)

 

Issue Links

• is related to: FLINK-19604 FLIP-145: Support SQL windowing table-valued function
• relates to: FLINK-21482 Support grouping set syntax for Window TVF based aggregation
• links to: GitHub Pull Request #15004