Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-4011

Kyling grouping function

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: v2.6.2
    • Fix Version/s: None
    • Component/s: Query Engine
    • Labels:
      None

      Description

      ```

      select dim1, case grouping(dim2) when 1 then 'ALL' else dim2 end, sum(col) as metric1 from table group by grouping sets((dim1, dim2), (dim1));

      ```

      `case grouping(dim2) when 2 then 'All' else dim2 end` can work  in version v2.5.2, but invalid in version v2.6.2. 

      How to query aggregate by grouping sets?

        Attachments

        1. image-2019-11-05-18-04-46-639.png
          199 kB
          Yaqian Zhang

          Activity

            People

            • Assignee:
              zhangyaqian Yaqian Zhang
              Reporter:
              tagtang tag
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: