[GitHub] [beam] damccorm opened a new issue, #20879: Support GROUP BY ROLLUP

[GitBox <gi...@apache.org>]

damccorm opened a new issue, #20879:
URL: https://github.com/apache/beam/issues/20879

   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/#](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.
   
   Imported from Jira [BEAM-12288](https://issues.apache.org/jira/browse/BEAM-12288). Original Jira may contain additional context.
   Reported by: apilloud.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@beam.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org