[ https://issues.apache.org/jira/browse/KYLIN-3285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Billy Liu updated KYLIN-3285: ----------------------------- Fix Version/s: v2.3.1 > "Value NNN not exists" error run executing query > ------------------------------------------------- > > Key: KYLIN-3285 > URL: https://issues.apache.org/jira/browse/KYLIN-3285 > Project: Kylin > Issue Type: Bug > Components: Query Engine > Affects Versions: v2.3.0 > Reporter: Shaofeng SHI > Priority: Major > Fix For: v2.3.1 > > Attachments: cube (1).json, kylin.log > > > Reported by community user zxxb...@163.com: > > {color:#b94a48}Kylin version update from 2.2.0 to 2.3.0; cube was build > before update, and query without error.{color} > {color:#b94a48}After updatge to version 2.3.0 and query {color}"select > count(userid) num,day_time from record_ap group by day_time LIMIT > 1000{color:#b94a48}”{color} > {color:#b94a48}show errors below:{color} > 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” > > {color:#b94a48}Where {color}{color:#b94a48}'2018-03-06’ come from? I was > fully confused.{color} > {color:#b94a48}Cube have several segments:{color} > {color:#b94a48}Starttime-endtime{color} > {color:#b94a48}20180101-20180225{color} > 20180225-20180304 > > Attached the log and cube JSON. -- This message was sent by Atlassian JIRA (v7.6.3#76005)