[jira] [Commented] (BEAM-12288) Support GROUP BY ROLLUP

["Beam JIRA Bot (Jira)" <ji...@apache.org>]

    [ 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)