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@example.com>
于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 赵天烁 <firstname.lastname@example.org>:ok,I'll have a try
BR, AlbertoIn teorical en v1.5.3, you can Group by 'n' columns: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 :)
2016-08-08 11:37 GMT+02:00 赵天烁 <email@example.com>:
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?
For sorting on count, you can use SUM(1) as the expression;
For sorting on other measure, it is on roadmap: https://issues.
We welcome the community to contribute on such enhancements, anyone want to have a try?
2016-08-05 15:24 GMT+08:00 赵天烁 <firstname.lastname@example.org>:
right now top-N measure need to specify a sum column, does kylin support
top-N on a count or count distinct measure?
--Best regards,Shaofeng Shi