[KYLIN-4184] Real time OLAP query gets wrong result

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: v3.0.0-beta
• Fix Version/s: v3.0.0-beta
• Component/s: Real-time Streaming
• Assignee: wangxiaojing
• Reporter: wangxiaojing
• Created: 30/Sep/19 05:54
• Updated: 16/Nov/19 15:34
• Resolved: 15/Nov/19 14:36

Description

• 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

  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

  content error result

• item error result

#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

 

#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

Issue Links

• links to: GitHub Pull Request #867