You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@beam.apache.org by "Andrew Pilloud (Jira)" <ji...@apache.org> on 2021/05/05 17:07:00 UTC

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

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)