[jira] [Created] (KYLIN-4011) Kyling grouping function

[tag (JIRA)]

tag created KYLIN-4011:
--

 Summary: Kyling grouping function
 Key: KYLIN-4011
 URL: https://issues.apache.org/jira/browse/KYLIN-4011
 Project: Kylin
  Issue Type: Bug
  Components: Query Engine
Affects Versions: v2.6.2
Reporter: tag


{{```}}

{{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?}}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

[jira] [Commented] (KYLIN-4011) Kyling grouping function

[tag (JIRA)]

[ 
https://issues.apache.org/jira/browse/KYLIN-4011?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16846492#comment-16846492
 ] 

tag commented on KYLIN-4011:


 [~Shaofengshi] Thanks for you reply.

`Grouping()` function works in v2.5.2 which blog you pose. 

But it invalid in v2.6.2.

 

 

> Kyling grouping function
> 
>
> Key: KYLIN-4011
> URL: https://issues.apache.org/jira/browse/KYLIN-4011
> Project: Kylin
>  Issue Type: Bug
>  Components: Query Engine
>Affects Versions: v2.6.2
>Reporter: tag
>Priority: Major
>
> {{```}}
> {{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?}}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)