[jira] [Commented] (FLINK-21253) Support grouping set syntax in WindowAggregate

["Jark Wu (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/FLINK-21253?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17277865#comment-17277865 ] 

Jark Wu commented on FLINK-21253:
---------------------------------

I would recommend to support this feature with the new window syntax (the FLIP-145), because it would be much easier when the grouped window becomes physical columns. 

> Support grouping set syntax in WindowAggregate
> ----------------------------------------------
>
>                 Key: FLINK-21253
>                 URL: https://issues.apache.org/jira/browse/FLINK-21253
>             Project: Flink
>          Issue Type: New Feature
>          Components: Table SQL / Planner
>            Reporter: Andy
>            Priority: Major
>
> Support grouping set/cube/rollup syntax in WindowAggregate, like the following example.
>  
> {code:java}
> //代码占位符
> 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)
> {code}
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)