Details

    • New Feature
    • Status: Open
    • P3
    • Resolution: Unresolved
    • None
    • None
    • dsl-sql
    • None

    Description

      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.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              apilloud Andrew Pilloud
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: