[
https://issues.apache.org/jira/browse/KYLIN-1921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Billy(Yiming) Liu resolved KYLIN-1921.
--------------------------------------
Resolution: Fixed
Fix Version/s: v1.5.4
> Support Grouping Funtions
> -------------------------
>
> Key: KYLIN-1921
> URL: https://issues.apache.org/jira/browse/KYLIN-1921
> Project: Kylin
> Issue Type: New Feature
> Components: Query Engine
> Affects Versions: v1.5.3
> Reporter: Yerui Sun
> Assignee: Yerui Sun
> Fix For: v1.5.4
>
> Attachments: KYLIN-1921.2.patch, KYLIN-1921.patch
>
>
> Usually we used 'group by dim1, dim2' to fetch the metrics with every value
> of dims, and we also want the summary metrics with the dim2 rolled up.
> This case could be resolved by union two query, like:
> {code}
> select dim1, dim2 metric from table group by dim1, dim2
> union all
> select dim1, 'ALL', metric from table group by dim1
> {code}
> Now with the expression cube/rollup/grouping sets in calcite, we can make the
> query sql more simple and more clearly:
> {code}
> select dim1, case(grouping(dim2) when 1 then 'ALL' else dim2 end), metric
> from table
> group by grouping sets((dim1, dim2), (dim1))
> {code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
