[
https://issues.apache.org/jira/browse/KYLIN-4184?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16949200#comment-16949200
]
ASF subversion and git services commented on KYLIN-4184:
--------------------------------------------------------
Commit 10429e4cf0966e4dd46e9dcad4e4298a3fc6cc30 in kylin's branch
refs/heads/master from wangxiaojing
[ https://gitbox.apache.org/repos/asf?p=kylin.git;h=10429e4 ]
KYLIN-4184 Real time OLAP query gets wrong result
> 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)
