[jira] [Created] (KYLIN-2098) TopN support query UHC column without sorting by sum value

["Shaofeng SHI (JIRA)" <ji...@apache.org>]

Shaofeng SHI created KYLIN-2098:
-----------------------------------

             Summary: TopN support query UHC column without sorting by sum value
                 Key: KYLIN-2098
                 URL: https://issues.apache.org/jira/browse/KYLIN-2098
             Project: Kylin
          Issue Type: Improvement
            Reporter: Shaofeng SHI
            Assignee: Shaofeng SHI
             Fix For: v1.6.0


In previous version, TopN doesn't support to query the UHC column directly (as it is not in dimension), like this SQL: "select distinct seller_id
 from test_kylin_fact where cal_dt >date'2012-06-01' 
" (assume "seller_id" is a "group by" column in TopN measure)

In some BI tool, it need fetch the distinct values of the dimension before generating the chart, so it's better to serve such query directly.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)