You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Shaofeng SHI (JIRA)" <ji...@apache.org> on 2018/03/09 10:25:00 UTC
[jira] [Updated] (KYLIN-3285) "Value NNN not exists" error run
executing query
[ https://issues.apache.org/jira/browse/KYLIN-3285?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shaofeng SHI updated KYLIN-3285:
--------------------------------
Description:
Reported by community user zxxbuaa@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.
> "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
> Attachments: cube (1).json, kylin.log
>
>
> Reported by community user zxxbuaa@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)