Apache Doris 中文技术论坛
Questions Tags Users Badges

分区表查询分区字段触发全表扫描

Asked Aug 25 Modified Jan 1, 0001
Viewed 27
2.1

在分区表中使用DT类型作为分区字段,当执行以下查询时会执行全表扫描,希望对该场景进行优化

SELECT max(dt_field) FROM table_name
edited Jan 1, 0001
GabrielHuang1
asked Aug 25
1 Answers

这个不好优化了,因为 fe 不知道分区里面有没有数据

edited Aug 29
徐振超@SelectDB7701
answered Aug 28
Related Questions
创建ROUTINE LOAD Kafka任务报错Failed to get real offsets of kafka topic
1 answers
Doris workload_group 的IO限制参数不生效
1 answers
有没有整理好的doris的函数表格,给共享下
1 answers
flink cdc on yarn报错
2 answers
服务器ip变化后fe启动失败
1 answers
doris2.1.11 配置ranger2.4权限不生效

Terms of service Privacy policy

Powered by Answer - the open-source software that powers Q&A communities.
Made with love © 2025 Apache Doris 中文技术论坛.