You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Shaofeng SHI (JIRA)" <ji...@apache.org> on 2016/05/24 10:06:12 UTC
[jira] [Commented] (KYLIN-1693) Support multiple group-by columns
for TOP_N meausre
[ 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)