[
https://issues.apache.org/jira/browse/KYLIN-4184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16940719#comment-16940719
]
ASF GitHub Bot commented on KYLIN-4184:
---------------------------------------
wangxiaojing123 commented on pull request #867: fix KYLIN-4184 Real time OLAP
query gets wrong result
URL: https://github.com/apache/kylin/pull/867
issue link : https://issues.apache.org/jira/browse/KYLIN-4184
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
> 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
> 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)
