[
https://issues.apache.org/jira/browse/BEAM-12288?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17382866#comment-17382866
]
Beam JIRA Bot commented on BEAM-12288:
--------------------------------------
This issue was marked "stale-P2" and has not received a public comment in 14
days. It is now automatically moved to P3. If you are still affected by it, you
can comment and move it back to P2.
> 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
> Priority: P3
>
> 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)
