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]>: > 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] <[email protected]>* > > > > 珠海市魅族科技有限公司 > > MEIZU Technology Co., Ltd. > > 广东省珠海市科技创新海岸魅族科技楼 > > MEIZU Tech Bldg., Technology & Innovation Coast > > Zhuhai, 519085, Guangdong, China > > meizu.com > > > *From:* ShaoFeng Shi <[email protected]> > *Date:* 2016-08-08 11:32 > *To:* user <[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]>: > >> 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] <[email protected]>* >> >> >> >> 珠海市魅族科技有限公司 >> >> MEIZU Technology Co., Ltd. >> >> 广东省珠海市科技创新海岸魅族科技楼 >> >> MEIZU Tech Bldg., Technology & Innovation Coast >> >> Zhuhai, 519085, Guangdong, China >> >> meizu.com >> > > > > -- > Best regards, > > Shaofeng Shi > >
