[jira] [Created] (KYLIN-4184) RT OLAP (Real time OLAP) query get error result

["wangxiaojing (Jira)" <ji...@apache.org>]

wangxiaojing created KYLIN-4184:
-----------------------------------

             Summary: RT OLAP (Real time OLAP) query get error result
                 Key: KYLIN-4184
                 URL: https://issues.apache.org/jira/browse/KYLIN-4184
             Project: Kylin
          Issue Type: Bug
          Components: Real-time Streaming
    Affects Versions: v3.0.0-beta
            Reporter: wangxiaojing
         Attachments: image-2019-09-30-13-54-13-312.png

* 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
{code:java}
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{code}
 * content error result

!image-2019-09-30-13-54-13-312.png!
 * item error result

{code:java}
#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{code}

 
{code:java}
#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{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)