[
https://issues.apache.org/jira/browse/KYLIN-1693?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15298021#comment-15298021
]
Shaofeng SHI commented on KYLIN-1693:
-------------------------------------
This is a valid requirement, especially when there are a couple of such "group
by" columns and their joint cardinality is ultra high;
> Support multiple group-by columns for TOP_N meausre
> ---------------------------------------------------
>
> Key: KYLIN-1693
> URL: https://issues.apache.org/jira/browse/KYLIN-1693
> Project: Kylin
> Issue Type: Wish
> Components: Query Engine
> Affects Versions: v1.5.1
> Reporter: JunAn Chen
> Assignee: Shaofeng SHI
> Priority: Minor
>
> For this case:
> table name : "tbl"
> columns: (dim_city, dim_industry, keyword, pv)
> the "keyword" column has a large cardinality, for about ten million.
> currently I can build "top100 pv" in (dim_city), (dim_industry).
> But I also want to build "top100 pv" in (dim_city, dim_industry) and "top100
> pv of keyword" in (dim_city), (dim_industry) and (dim_city, dim_industrt).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
