[FLINK-17446] Blink supports cube and window together in group by

• Type: New Feature
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Component/s: API / Core
• Assignee: Unassigned
• Reporter: Liu
• Created: 29/Apr/20 01:56
• Updated: 06/Apr/21 14:08
• Resolved: 06/Apr/21 14:08

Description

      Blink planner supports CUBE. CUBE can be used together with a field but not window. For example, the following SQL is not supported:

 
      SELECT A, B, sum(C)
      FROM person
      GROUP BY cube(A, B), TUMBLE(curTimestamp, interval '1' minute)
 
      It is a missing feature. Maybe it should be supported. Detail is in http://apache-flink-user-mailing-list-archive.2336050.n4.nabble.com/Blink-window-and-cube-td34761.html#a34768

Issue Links

• is fixed by: FLINK-21482 Support grouping set syntax for Window TVF based aggregation