Open
Description
Steps to reproduce the behavior (Required)
- hive table info
CREATE TABLE tmp.test_partition(
id bigint COMMENT '',
name string COMMENT '')
COMMENT '测试表'
PARTITIONED BY (
dt string COMMENT 'date partition key');
insert into tmp.test_partition (id,name,dt) values (1,'test','20250210');
2.set allow_hive_without_partition_filter = false;
3.select * from tmp.test_partition where substr(dt, 1, 8) = '20250210';
4.
with from_dt as (
select
'20250209' as dt
)
SELECT
*
FROM
tmp.test_partition
WHERE
dt > (
select
dt
from
from_dt
);
Expected behavior (Required)
Query data normally.In the improvised analysis scenario, these SQL partition information fail to be pushed down, resulting in a large amount of data scanning and a query failure
Real behavior (Required)
report error Table test_partition partition pruning is invalid, please check: 1. The partition predicate must be included. 2. The left and right children of the partition predicate cannot be function parameters.
StarRocks version (Required)
3.3.4