You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Shaofeng SHI (JIRA)" <ji...@apache.org> on 2018/09/14 03:13:00 UTC
[jira] [Closed] (KYLIN-3410) kylin
[ https://issues.apache.org/jira/browse/KYLIN-3410?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shaofeng SHI closed KYLIN-3410.
-------------------------------
Resolution: Duplicate
> 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)