There is a bug on UI, it should be "group by column", not "order by column".
2016-03-31 11:16 GMT+08:00 热爱大发挥 <[email protected]>: > does top-n means : select count(1) as c, saller_id from sales group > by saller_id order by c desc limit 10 ? > if so, why should I specify a "order by column"? > > > > ------------------ 原始邮件 ------------------ > *发件人:* "ShaoFeng Shi"<[email protected]>; > *发送时间:* 2016年3月31日(星期四) 中午11:04 > *收件人:* "user"<[email protected]>; > *主题:* Re: error with TOP_N in kylin 1.5.0 > > Hi, TopN measure need define two parameters, it seems you didn't specify > the second one. The first parameter is the metric column (which will be > used for sum() and sort); The second parameter is the entity ID, like > "seller_id". Please refer the doc: > https://kylin.apache.org/docs15/tutorial/create_cube.html > > 2016-03-31 9:38 GMT+08:00 热爱大发挥 <[email protected]>: > >> env: >> hbase 0.986 >> hive 0.13.1 >> kylin 1.5.0 >> >> when I use TOP-N, exception occured >> >> java.lang.IndexOutOfBoundsException: Index: 1, Size: 1 >> at java.util.ArrayList.rangeCheck(ArrayList.java:635) >> at java.util.ArrayList.get(ArrayList.java:411) >> at >> org.apache.kylin.measure.topn.TopNMeasureType.getColumnsNeedDictionary(TopNMeasureType.java:170) >> at >> org.apache.kylin.cube.model.CubeDesc.getAllColumnsNeedDictionary(CubeDesc.java:975) >> at >> org.apache.kylin.cube.CubeManager.getAllDictColumnsOnFact(CubeManager.java:904) >> at >> org.apache.kylin.engine.mr.steps.FactDistinctColumnsJob.run(FactDistinctColumnsJob.java:80) >> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:70) >> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:84) >> at >> org.apache.kylin.engine.mr.common.MapReduceExecutable.doWork(MapReduceExecutable.java:118) >> at >> org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:114) >> at >> org.apache.kylin.job.execution.DefaultChainedExecutable.doWork(DefaultChainedExecutable.java:50) >> at >> org.apache.kylin.job.execution.AbstractExecutable.execute(AbstractExecutable.java:114) >> at >> org.apache.kylin.job.impl.threadpool.DefaultScheduler$JobRunner.run(DefaultScheduler.java:124) >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) >> at java.lang.Thread.run(Thread.java:745) >> > > > > -- > Best regards, > > Shaofeng Shi > > -- Best regards, Shaofeng Shi
