Support GROUP BY ROLLUP #20879
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.
Imported from Jira BEAM-12288. Original Jira may contain additional context.
Reported by: apilloud.