trouble a gain,in "top-n" , what's diffrent between "Param Type Column" and "group by Column"
------------------ ???????? ------------------ ??????: "ShaoFeng Shi"<[email protected]>; ????????: 2016??3??31??(??????) ????11:32 ??????: "user"<[email protected]>; ????: Re: error with TOP_N in kylin 1.5.0 There is a bug on UI, it should be "group by column", not "order by column".?0?2 2016-03-31 11:16 GMT+08:00 ?????????? <[email protected]>: does top-n ?0?2means : ?0?2 ?0?2 select count(1) as c, saller_id from sales group by saller_id order by c desc ?0?2limit 10 ? ?0?2if so, why should I specify a ?0?2"order by column"? ------------------?0?2?????????0?2------------------ ??????: "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 -- Best regards, Shaofeng Shi
