kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From xixin <zxxb...@163.com>
Subject Re: Sql execute error
Date Thu, 08 Mar 2018 06:03:16 GMT
I did a test, when I set mandatory dimension on aggression groups lead this error

> 在 2018年3月8日,11:54,xixin <zxxbuaa@163.com> 写道:
> 
> Hi Kylin team,
> 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
> 20180304-20180305
> 20180305-20180306
> 20180306-20180307


Mime
View raw message