[jira] [Commented] (KYLIN-4184) Real time OLAP query gets wrong result

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

    [ https://issues.apache.org/jira/browse/KYLIN-4184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16975726#comment-16975726 ] 

Gang Ma commented on KYLIN-4184:
--------------------------------

Nice catch! I just try to reduce the array copy times to improve the performance, and cause this issue. I will add some ut for this case, also try to reduce unnecessary array copy in other way.

> Real time OLAP query gets wrong 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
>            Assignee: wangxiaojing
>            Priority: Blocker
>             Fix For: v3.0.0-beta
>
>         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)