[KYLIN-3285] "Value NNN not exists" error run executing query

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: v2.3.0
• Component/s: Query Engine
• Assignee: Unassigned
• Reporter: Shao Feng Shi
• Created: 09/Mar/18 10:23
• Updated: 25/Jun/18 04:08
• Resolved: 25/Jun/18 04:08

Description

Reported by community user [e-mail]:

 
Kylin version update from 2.2.0 to 2.3.0; cube was build before update, and query without error.
After updatge to version 2.3.0 and query "select count(userid) num,day_time from record_ap group by day_time LIMIT 1000”
show errors below:
Column 0 value '2018-03-06' met dictionary error: Value '2018-03-06' (2018-03-06) not exists! while executing SQL: "select count(userid) num,day_time from record_ap group by day_time LIMIT 1000”
 
Where '2018-03-06’ come from? I was fully confused.
Cube have several segments:
Starttime-endtime
20180101-20180225
20180225-20180304
 
Attached the log and cube JSON.

Issue Links

• duplicates: KYLIN-3287 When a shard by column is in dict encoding, dict building error.