[ 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)