[KYLIN-4011] Kyling grouping function

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: v2.6.2
• Component/s: Query Engine
• Assignee: Yaqian Zhang
• Reporter: tag
• Created: 21/May/19 12:43
• Updated: 05/Nov/19 10:05

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?