[KYLIN-2098] TopN support query UHC column without sorting by sum value

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: v1.6.0
• Assignee: Shao Feng Shi
• Reporter: Shao Feng Shi
• Created: 17/Oct/16 05:49
• Updated: 26/Nov/16 08:12
• Resolved: 18/Oct/16 07:03

Description

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.