+Andrew Pilloud <apill...@google.com> do you know if this is a bug? On Tue, May 4, 2021 at 7:38 AM D, Anup (Nokia - IN/Bangalore) < anu...@nokia.com> wrote:
> Hi All, > > > > 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. > > > > Thanks > > Anup >
