kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ShaoFeng Shi <shaofeng...@apache.org>
Subject Re: error with TOP_N in kylin 1.5.0
Date Thu, 31 Mar 2016 03:32:27 GMT
There is a bug on UI, it should be "group by column", not "order by
column".

2016-03-31 11:16 GMT+08:00 热爱大发挥 <385639827@qq.com>:

> 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"<shaofengshi@apache.org>;
> *发送时间:* 2016年3月31日(星期四) 中午11:04
> *收件人:* "user"<user@kylin.apache.org>;
> *主题:* 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 热爱大发挥 <385639827@qq.com>:
>
>> 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

Mime
View raw message