SUM(1)? you mean just left ORDER|SUM by Column empty? ,then another prob is I can't configure more than one group by column to it,how to walk around that?
________________________________ 赵天烁 Kevin Zhao [email protected]<mailto:[email protected]> 珠海市魅族科技有限公司 MEIZU Technology Co., Ltd. 广东省珠海市科技创新海岸魅族科技楼 MEIZU Tech Bldg., Technology & Innovation Coast Zhuhai, 519085, Guangdong, China meizu.com From: ShaoFeng Shi<mailto:[email protected]> Date: 2016-08-08 11:32 To: user<mailto:[email protected]> Subject: Re: does kylin support top-N on a count or count distinct measure? For sorting on count, you can use SUM(1) as the expression; For sorting on other measure, it is on roadmap: https://issues.apache.org/jira/browse/KYLIN-1377 We welcome the community to contribute on such enhancements, anyone want to have a try? 2016-08-05 15:24 GMT+08:00 赵天烁 <[email protected]<mailto:[email protected]>>: right now top-N measure need to specify a sum column, does kylin support top-N on a count or count distinct measure? ________________________________ 赵天烁 Kevin Zhao [email protected]<mailto:[email protected]> 珠海市魅族科技有限公司 MEIZU Technology Co., Ltd. 广东省珠海市科技创新海岸魅族科技楼 MEIZU Tech Bldg., Technology & Innovation Coast Zhuhai, 519085, Guangdong, China meizu.com<http://meizu.com> -- Best regards, Shaofeng Shi
