[jira] [Commented] (KYLIN-3318) Kylin 2.3 UI top n group by only show dimension columns
[ https://issues.apache.org/jira/browse/KYLIN-3318?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16415363#comment-16415363 ] Billy Liu commented on KYLIN-3318: -- [~Shaofengshi] +1, very smart solution. > Kylin 2.3 UI top n group by only show dimension columns > --- > > Key: KYLIN-3318 > URL: https://issues.apache.org/jira/browse/KYLIN-3318 > Project: Kylin > Issue Type: Bug >Reporter: Le Anh Vu >Priority: Major > > In Kylin 2.3.0 Web UI, when I use TopN measure, the group by column drop down > only show me dimension columns. Is it the expected behavior or a bug? -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3318) Kylin 2.3 UI top n group by only show dimension columns
[ https://issues.apache.org/jira/browse/KYLIN-3318?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16415252#comment-16415252 ] Shaofeng SHI commented on KYLIN-3318: - Hi Le Anh Vu, you can keep "user_id" as dimension on the data model, but exclude it from the dimension list of the Cube. Then the cube won't have this UHC dimension. > Kylin 2.3 UI top n group by only show dimension columns > --- > > Key: KYLIN-3318 > URL: https://issues.apache.org/jira/browse/KYLIN-3318 > Project: Kylin > Issue Type: Bug >Reporter: Le Anh Vu >Priority: Major > > In Kylin 2.3.0 Web UI, when I use TopN measure, the group by column drop down > only show me dimension columns. Is it the expected behavior or a bug? -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3318) Kylin 2.3 UI top n group by only show dimension columns
[ https://issues.apache.org/jira/browse/KYLIN-3318?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16415214#comment-16415214 ] Le Anh Vu commented on KYLIN-3318: -- I have an UHC column (user_id) that I want to use COUNT_DISTINCT and TOPN user_id have largest SUM measure but never filter on user_id. If set user_id as dimension, I think it will likely be included in row key combination which will make the number of row key grow very large. > Kylin 2.3 UI top n group by only show dimension columns > --- > > Key: KYLIN-3318 > URL: https://issues.apache.org/jira/browse/KYLIN-3318 > Project: Kylin > Issue Type: Bug >Reporter: Le Anh Vu >Priority: Major > > In Kylin 2.3.0 Web UI, when I use TopN measure, the group by column drop down > only show me dimension columns. Is it the expected behavior or a bug? -- This message was sent by Atlassian JIRA (v7.6.3#76005)
[jira] [Commented] (KYLIN-3318) Kylin 2.3 UI top n group by only show dimension columns
[ https://issues.apache.org/jira/browse/KYLIN-3318?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16415155#comment-16415155 ] Shaofeng SHI commented on KYLIN-3318: - I think this is expected. Logically, the "group by" column in Top-N is a dimension. It was a mistake that treating it as a measure column, now it is corrected I remember. [~Zhixiong Chen] can double confirm this. > Kylin 2.3 UI top n group by only show dimension columns > --- > > Key: KYLIN-3318 > URL: https://issues.apache.org/jira/browse/KYLIN-3318 > Project: Kylin > Issue Type: Bug >Reporter: Le Anh Vu >Priority: Major > > In Kylin 2.3.0 Web UI, when I use TopN measure, the group by column drop down > only show me dimension columns. Is it the expected behavior or a bug? -- This message was sent by Atlassian JIRA (v7.6.3#76005)