Re: Sql execute error

Further feedback:After I set userid(high cardinality) for sharding, query can be executed without error, but no records is shown. Best regards, cube2.json Description: application/json Zhao Xixin 在 2018年3月10日，23:24，赵希欣 写道： Hi Shaofeng,day_time type is

Re: Sql execute error

Hi Shaofeng, day_time type is String, and it is partition col. But I confirmed that 2018-03-01 have records. Problem comes when quering with the setting day_time “shard by” to true. If set all dimensions to false no problem for querying. Maybe I’m not fully understand “shard by” function

Re: Sql execute error

Hi Xixin, I'm analyzing this, which should be a bug. As I don't have the model and table definition, could you please provide the data type of the col "day_time"? And I think "day_time" is the partition column, and in your cube, there was no record for the day '2018-03-01' when you run the

Re: Sql execute error

Hi Xixin, JIRA created for this issue: https://issues.apache.org/jira/browse/KYLIN-3285 Please book it and let's track there; thank you! 2018-03-09 12:46 GMT+08:00 xixin : > Hi Shaofeng, > Please see the attachments:Kylin.log and cube.json > > the problem maybe from the "shard

Re: Sql execute error

Hi Shaofeng,Please see the attachments:Kylin.log and cube.jsonthe 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. cube.json Description: application/json kylin.log

Re: Sql execute error

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 : > I did a test, when I set mandatory dimension on

Re: Sql execute error

I did a test, when I set mandatory dimension on aggression groups lead this error > 在 2018年3月8日，11:54，xixin 写道： > > 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

Sql execute error

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