[jira] [Created] (FLINK-21253) Support grouping set/cube/rollup syntax in WindowAggregate

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (FLINK-21253) Support grouping set/cube/rollup syntax in WindowAggregate

Shang Yuanchun (Jira)
Andy created FLINK-21253:
----------------------------

             Summary: Support grouping set/cube/rollup 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


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)