[
https://issues.apache.org/jira/browse/BEAM-12288?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17374334#comment-17374334
]
Beam JIRA Bot commented on BEAM-12288:
--------------------------------------
This issue is P2 but has been unassigned without any comment for 60 days so it
has been labeled "stale-P2". If this issue is still affecting you, we care!
Please comment and remove the label. Otherwise, in 14 days the issue will be
moved to P3.
Please see https://beam.apache.org/contribute/jira-priorities/ for a detailed
explanation of what these priorities mean.
> 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: P2
> Labels: stale-P2
>
> 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)
