kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From hongbin ma <mahong...@apache.org>
Subject Re: cube query error in Cuboid.translateToValidCuboid
Date Thu, 04 Aug 2016 15:00:17 GMT
someone reported similar issues in
https://issues.apache.org/jira/browse/KYLIN-1785, but we cannot reproduce
it. can you please provide your cube desc to us? If that's sensitive, can
you please try to reproduce the issue with the sample cube in Kylin?

On Thu, Aug 4, 2016 at 4:25 PM, 赵天烁 <zhaotianshuo@meizu.com> wrote:

> just have same problem while cube building,mr job log detail are the same
> with that query time error.
>
> ------------------------------
>
> 赵天烁
>
> Kevin Zhao
>
> *zhaotianshuo@meizu.com <zhaotianshuo@meizu.com>*
>
>
>
> 珠海市魅族科技有限公司
>
> MEIZU Technology Co., Ltd.
>
> 广东省珠海市科技创新海岸魅族科技楼
>
> MEIZU Tech Bldg., Technology & Innovation Coast
>
> Zhuhai, 519085, Guangdong, China
>
> meizu.com
>
>
> *发件人:* 赵天烁 <zhaotianshuo@meizu.com>
> *发送时间:* 2016-08-04 15:01
> *收件人:* user <user@kylin.apache.org>
> *主题:* cube query error in Cuboid.translateToValidCuboid
> Error happen while executing the sql below:
>
> select FID,MIN(CRASHTIME) as FIRST_CRASHTIME,MAX(CRASHTIME) as LAST_CRASHTIME,count(1)
as CRASH_CNT,count(distinct FIMEI) as AFFECT_USER,FPACKAGE_NAME,FCRASH_POINT from EDL_FDT_OUC_UPLOAD_FILES
where UPLOAD_TIME>20160705000000 and UPLOAD_TIME<20160707000000 group by FID,FPACKAGE_NAME,FCRASH_POINT
order by count(1) desc limit 20
> ============
> Caused by: java.util.NoSuchElementException
>         at java.util.ArrayList$Itr.next(ArrayList.java:834)
>         at java.util.Collections.min(Collections.java:665)
>
>         at org.apache.kylin.cube.cuboid.Cuboid.translateToValidCuboid(Cuboid.java:217)
>
>         at org.apache.kylin.cube.cuboid.Cuboid.translateToValidCuboid(Cuboid.java:141)
>         at org.apache.kylin.cube.cuboid.Cuboid.findById(Cuboid.java:83)
>
>         at org.apache.kylin.cube.cuboid.Cuboid.identifyCuboid(Cuboid.java:68)
>
>         at org.apache.kylin.storage.gtrecord.GTCubeStorageQueryBase.search(GTCubeStorageQueryBase.java:97)
>
>         at org.apache.kylin.query.enumerator.OLAPEnumerator.queryStorage(OLAPEnumerator.java:120)
>
>         at org.apache.kylin.query.enumerator.OLAPEnumerator.moveNext(OLAPEnumerator.java:69)
>         at Baz$1$1.moveNext(Unknown Source)
>
>         at org.apache.calcite.linq4j.EnumerableDefaults.groupBy_(EnumerableDefaults.java:819)
>
>         at org.apache.calcite.linq4j.EnumerableDefaults.groupBy(EnumerableDefaults.java:754)
>
>         at org.apache.calcite.linq4j.DefaultEnumerable.groupBy(DefaultEnumerable.java:302)
>         at Baz.bind(Unknown Source)
>
>         at org.apache.calcite.jdbc.CalcitePrepare$CalciteSignature.enumerable(CalcitePrepare.java:326)
>
>         at org.apache.calcite.jdbc.CalciteConnectionImpl.enumerable(CalciteConnectionImpl.java:281)
>
>         at org.apache.calcite.jdbc.CalciteMetaImpl._createIterable(CalciteMetaImpl.java:545)
>
>         at org.apache.calcite.jdbc.CalciteMetaImpl.createIterable(CalciteMetaImpl.java:536)
>
>         at org.apache.calcite.avatica.AvaticaResultSet.execute(AvaticaResultSet.java:187)
>
>         at org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:65)
>
>         at org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:44)
>
>         at org.apache.calcite.avatica.AvaticaConnection$1.execute(AvaticaConnection.java:566)
>
>         at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:578)
>
>         at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:571)
>
>         at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:135)
>         ... 80 more
>
> looks like it is doing a further agg, may be agg.getJoints() is
> empty,need to do a empty check before Collections.min:
>
>
>  org.apache.kylin.cube.cuboid.Cuboid.translateToValidCuboid(Cuboid.java:217)
> =======================================
>
> return cuboidID | Collections.min(agg.getJoints(), cuboidSelectComparator);
> ------------------------------
>
> 赵天烁
>
> Kevin Zhao
>
> *zhaotianshuo@meizu.com <zhaotianshuo@meizu.com>*
>
>
>
> 珠海市魅族科技有限公司
>
> MEIZU Technology Co., Ltd.
>
> 广东省珠海市科技创新海岸魅族科技楼
>
> MEIZU Tech Bldg., Technology & Innovation Coast
>
> Zhuhai, 519085, Guangdong, China
>
> meizu.com
>
>


-- 
Regards,

*Bin Mahone | 马洪宾*

Mime
View raw message