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?0?2entity ID, like "seller_id".?0?2 Please refer the doc:?0?2https://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
