Btw, i have a cube, there are topN(sum(clicks),groupby appid), count(distinct deviceid), ... measures. According to the blog http://www.infoq.com/cn/news/2016/08/Apache-Kylin-Top-N?utm_campaign=infoq_content&utm_source=infoq&utm_medium=feed&utm_term=global from shaofeng, it will combine appid and sum(clicks) to a measure and reduce the cube data size, also it can improve the query preformance. Now my question is comming: when my query involves in topN(sum(clicks),groupby appid) and count(distinct deviceid) measures, whether it is also a optimization for count(distinct deviceid) measures, or just for topN(sum(clicks),groupby appid)?
张天生 <[email protected]>于2016年8月9日周二 上午11:54写道： > I have a question: whether multiple column groupby is better performance > than a single column groupby in topN measure. As i known it all can agg > other dimensions. > Whether it there was performance optimization in mulitple column groupby > in topN measure. > > ShaoFeng Shi <[email protected]>于2016年8月8日周一 下午6:20写道： > >> Alberto is correct; SUM(1) and multiple columns are implemented in Kylin >> core, but from UI you couldn't define that; You need manually edit metadata >> for that. >> >> 2016-08-08 18:02 GMT+08:00 赵天烁 <[email protected]>: >> >>> ok,I'll have a try >>> >>> ------------------------------ >>> >>> 赵天烁 >>> >>> Kevin Zhao >>> >>> *[email protected] <[email protected]>* >>> >>> >>> >>> 珠海市魅族科技有限公司 >>> >>> MEIZU Technology Co., Ltd. >>> >>> 广东省珠海市科技创新海岸魅族科技楼 >>> >>> MEIZU Tech Bldg., Technology & Innovation Coast >>> >>> Zhuhai, 519085, Guangdong, China >>> >>> meizu.com >>> >>> >>> *From:* Alberto Ramón <[email protected]> >>> *Date:* 2016-08-08 17:59 >>> *To:* [email protected] >>> *CC:* ShaoFeng Shi <[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]>: >>> >>>> 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 >>>> >>>> >>> >> >> >> -- >> Best regards, >> >> Shaofeng Shi >> >>
