Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: v2.3.1
    • Fix Version/s: None
    • Component/s: Query Engine
    • Labels:
      None

      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

       

       

       

       

       

       

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              lemontsr Lemont
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: