Andrew Pilloud created BEAM-12288:
-------------------------------------
Summary: Support GROUP BY ROLLUP
Key: BEAM-12288
URL: https://issues.apache.org/jira/browse/BEAM-12288
Project: Beam
Issue Type: New Feature
Components: dsl-sql
Reporter: Andrew Pilloud
From
https://lists.apache.org/thread.html/r49f3dbfb333d1e23ebb32f35d3c1ff9aaae75019649299887302cf9b%40%3Cuser.beam.apache.org%3E
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.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
