Re: Sql execute error

2018-03-10 Thread 赵希欣
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

2018-03-10 Thread ShaoFeng Shi
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