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: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
