also need to support order by desc as well as asc On Thu, Jan 28, 2016 at 6:30 PM, Shaofeng SHI (JIRA) <[email protected]> wrote:
> Shaofeng SHI created KYLIN-1377: > ----------------------------------- > > Summary: TopN measure should support more expressions > Key: KYLIN-1377 > URL: https://issues.apache.org/jira/browse/KYLIN-1377 > Project: Kylin > Issue Type: New Feature > Reporter: Shaofeng SHI > Fix For: v2.1 > > > TopN should support not only SUM, but also MAX, MIN as the expression. > > A possible case is, find out the sellers which sold the top expensive > items: > > select seller_id, max(price) from sals_records where region = 'US' and > year = '2015' order by max(price) desc limit 100; > > > > -- > This message was sent by Atlassian JIRA > (v6.3.4#6332) > -- Regards, *Bin Mahone | 马洪宾* Apache Kylin: http://kylin.io Github: https://github.com/binmahone
