ok,I'll have a try ________________________________ 赵天烁 Kevin Zhao [email protected]<mailto:[email protected]>
珠海市魅族科技有限公司 MEIZU Technology Co., Ltd. 广东省珠海市科技创新海岸魅族科技楼 MEIZU Tech Bldg., Technology & Innovation Coast Zhuhai, 519085, Guangdong, China meizu.com From: Alberto Ramón<mailto:[email protected]> Date: 2016-08-08 17:59 To: [email protected]<mailto:[email protected]> CC: ShaoFeng Shi<mailto:[email protected]> Subject: Re: Re: does kylin support top-N on a count or count distinct measure? In teorical en v1.5.3, you can Group by 'n' columns: https://issues.apache.org/jira/browse/KYLIN-1693 I don't tested 1.5.3 yet, and I don't know if has been implemented in UI Kylin, perhaps you can add this columns to JSON manually :) BR, Alberto 2016-08-08 11:37 GMT+02:00 赵天烁 <[email protected]<mailto:[email protected]>>: 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<http://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
