Uploaded image for project: 'Kylin'
  1. Kylin
  2. KYLIN-4184

Real time OLAP query gets wrong result

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: v3.0.0-beta
    • Fix Version/s: v3.0.0-beta
    • Component/s: Real-time Streaming
    • Labels:
      None

      Description

      • 1、Kylin RT OLAP query error,sometimes result count more than right ,sometimes less than right;
      • 2、Kylin RT OLAP query error,some dimissions content error, eg:minute_start,hour_start;
      • query sql
        select MINUTE_START, EVENTCODE as NAME, RUNTIME, TASKID, count(1) as CNT from TASK_SNAPSHOT 
        where MINUTE_START >= '2019-09-25 18:32:00' and MINUTE_START<='2019-09-25 18:33:00'
        and EVENTCODE = 'faceAntispam' 
        group by MINUTE_START, EVENTCODE, RUNTIME, TASKID order by RUNTIME desc

        content error result

      • item error result
      #this sql can get result with 132 items
      select MINUTE_START, EVENTCODE as NAME, RUNTIME, TASKID, count(1) as CNT from TASK_SNAPSHOT 
      where MINUTE_START = '2019-09-25 18:32:00' --and MINUTE_START<='2019-09-25 18:33:00'
      and EVENTCODE = 'faceAntispam' 
      group by MINUTE_START, EVENTCODE, RUNTIME, TASKID order by RUNTIME desc

       

      #this sql can get result with no items ,it get the error result ,the rigth result it's 132 items
      select MINUTE_START, EVENTCODE as NAME, RUNTIME, TASKID, count(1) as CNT from TASK_SNAPSHOT 
      where MINUTE_START >= '2019-09-25 18:32:00' and MINUTE_START<='2019-09-25 18:33:00'
      and EVENTCODE = 'faceAntispam' 
      group by MINUTE_START, EVENTCODE, RUNTIME, TASKID order by RUNTIME desc

        Attachments

        1. image-2019-09-30-13-54-13-312.png
          137 kB
          wangxiaojing

          Issue Links

            Activity

              People

              • Assignee:
                wangxiaojing wangxiaojing
                Reporter:
                wangxiaojing wangxiaojing
              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: