Details
-
New Feature
-
Status: Open
-
P3
-
Resolution: Unresolved
-
None
-
None
-
None
Description
I was trying to use “GROUP BY WITH ROLLUP” (2.29.0 version) which I saw here - https://beam.apache.org/documentation/dsls/sql/calcite/query-syntax/#
"select warehouse, SUM(quantity) as quantity from PCOLLECTION group by ROLLUP(warehouse)"));
Warehouse | quantity
-----------------------------
Melbourne | 100
New York | 200
New York | 200
Output below seems to ignore ROLLUP.
Warehouse | quantity
-------------------------------
Melbourne | 100
New York | 400
Warehouse_Total | 500 => not generated
Could you please confirm if this is supported or I am missing something.
I tried to search JIRA/documentation to get some pointers but could not find.
Attachments
Issue Links
- relates to
-
BEAM-12289 Reject GROUP BY ROLLUP
- Resolved