Re: Sql execute error

Thu, 08 Mar 2018 20:48:03 -0800

Hi Shaofeng,
Please see the attachments:Kylin.log and cube.json

the problem maybe from the "shard by" setting, after I set the day_time "shard by” to true,the issue comes when I query.
If set all shard by to false, query can be done successfully.

Attachment: cube.json
Description: application/json

Attachment: kylin.log
Description: Binary data


在 2018年3月8日，20:48，ShaoFeng Shi <[email protected]> 写道：

Hi Xixin,

Thanks for reporting. Would you please share the kylin.log and how you define the Cube? If you can reproduce the error with the sample cube "kylin_sales", that would be appreciated.

2018-03-08 14:03 GMT+08:00 xixin <[email protected]>:
I did a test, when I set mandatory dimension on aggression groups lead this error


在 2018年3月8日，11:54，xixin <[email protected]> 写道：

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




--
Best regards,

Shaofeng Shi 史少锋


Reply via email to