Hi All,

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.

Thanks
Anup

Reply via email to