[ https://issues.apache.org/jira/browse/KYLIN-3410?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16787651#comment-16787651 ]
Shaofeng SHI commented on KYLIN-3410: ------------------------------------- Duplicated with KYLIN-3416 > kylin > ------ > > Key: KYLIN-3410 > URL: https://issues.apache.org/jira/browse/KYLIN-3410 > Project: Kylin > Issue Type: Bug > Components: Query Engine > Affects Versions: v2.3.1 > Reporter: Lemont > Priority: Critical > > I set city_id , pt and periods_time to Mandatory Dimensions and My query is : > select > floor((1528732800 - biz_time)*1.0/(7*86400)) pt, > count(DISTINCT online_rider) > from rider > where > pt='20180612' > and periods_time in (0) > and city_id = 1 > group by floor((1528732800 - biz_time)*1.0/(7*86400)) > and the error is > Caused by: java.lang.NullPointerException > at > org.apache.kylin.measure.bitmap.RoaringBitmapCounter.getMutableBitmap(RoaringBitmapCounter.java:58) > but the interesting thing is that when i set > pt=from_unixtime(unix_timestamp('20180612','yyyyMMdd'),'yyyyMMdd') > {from_unixtime(unix_timestamp('20180612','yyyyMMdd'),'yyyyMMdd')='20180612'} > the query is success. > > The fail query: > Query Id: 5f591843-8510-440a-b0be-87a2e23a58b1 > SQL: select > floor((1528732800 - biz_time)*1.0/(7*86400)) pt, > count(DISTINCT online_rider) onlineRiders > > from rpt.hawkeye_rider_view > where > pt = '20180612' > and biz_time > (1528732800 - 49*86400) > and periods_time in (0) > and city_id = 1 > group by floor((1528732800 - biz_time)*1.0/(7*86400)) > User: ADMIN > Success: false > Duration: 0.269 > Project: kylin_test > Realization Names: [CUBE[name=rpt_hawkeye_rider_cube]] > Cuboid Ids: [3078] > Total scan count: 110 > Total scan bytes: 1880692 > Result row count: 0 > Accept Partial: true > Is Partial Result: false > Hit Exception Cache: false > Storage cache used: false > Is Query Push-Down: false > Is Prepare: false > Trace URL: null > Message: null > > The success query: > > Query Id: 174c37a4-e5a6-435c-986a-064c8c096cc5 > SQL: select > floor((1528732800 - biz_time)*1.0/(7*86400)) pt, > count(DISTINCT online_rider) onlineRiders > > from rpt.hawkeye_rider_view > where > pt = from_unixtime(unix_timestamp('20180612','yyyyMMdd'),'yyyyMMdd') > and biz_time > (1528732800 - 49*86400) > and periods_time in (0) > and city_id = 1 > group by floor((1528732800 - biz_time)*1.0/(7*86400)) > User: ADMIN > Success: true > Duration: 0.249 > Project: kylin_test > Realization Names: [CUBE[name=rpt_hawkeye_rider_cube]] > Cuboid Ids: [3078] > Total scan count: 207 > Total scan bytes: 1992369 > Result row count: 7 > Accept Partial: true > Is Partial Result: false > Hit Exception Cache: false > Storage cache used: false > Is Query Push-Down: false > Is Prepare: false > Trace URL: null > Message: null > > > > > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)