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