[jira] [Updated] (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:all-tabpanel ]

Beam JIRA Bot updated BEAM-12288:
---------------------------------
    Labels: stale-P2  (was: )

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