【详述】创建了一个分区物化视图,分区列为dt,命中物化视图的查询,限制 dt>=20241001 and dt <= 20241002报错,但是dt>=20241001或者dt between 20241001 and 20241002可以正常查询
【背景】
【StarRocks版本】3.2.6-2585333;
【集群规模】3FE+9BE ;
【机器信息】16c64g
【联系方式】WX:lzl15797793623
【报错信息】java.util.concurrent.ExecutionException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Invalid plan: PhysicalOlapScanOperator {table=1245129, selectedPartitionId=[1349807, 1349929], outputColumns=[79: dt], projection=null, predicate=DictMapping(79: dt{43: dt >= 20241001}), limit=-1}Input dependency cols check failed. The required cols {43} cannot obtain from input cols {79}.
dt between 20241001 and 20241002也报错了,之前查询的时候还是可以的
我修过一个对应的bug https://github.com/StarRocks/starrocks/pull/48773 在3.3里,你升级到3.3.3试试看。或者你backport到3.2里把fe build下试试看
好嘞,我试试看
可以了,感谢~