[jira] [Created] (FLINK-21482) Support grouping set syntax for WindowAggregate

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

[jira] [Created] (FLINK-21482) Support grouping set syntax for WindowAggregate

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

             Summary: Support grouping set syntax for WindowAggregate
                 Key: FLINK-21482
                 URL: https://issues.apache.org/jira/browse/FLINK-21482
             Project: Flink
          Issue Type: New Feature
          Components: Table SQL / Planner
            Reporter: Andy


Support grouping set syntax in window tvf, like

 
{code:java}
SELECT
  GROUPING_ID(`name`),
  `name`,
  window_start,
  window_end,
  COUNT(*),
  SUM(`bigdec`),
  MAX(`double`),
  MIN(`float`),
  COUNT(DISTINCT `string`),
  concat_distinct_agg(`string`)
FROM TABLE(
   CUMULATE(
     TABLE T1,
     DESCRIPTOR(rowtime),
     INTERVAL '5' SECOND,
     INTERVAL '15' SECOND))
GROUP BY GROUPING SETS((`name`),()), window_start, window_end{code}
 



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