foxtail463 opened a new pull request, #67182:
URL: https://github.com/apache/doris/pull/67182
Problem Summary:
Monotonic-function predicates were only converted into bare-column ranges
during partition pruning. Consequently, OLAP zone maps and Parquet/ORC min/max
indexes
could not use predicates such as date_trunc(dt, ...) = ..., date_format(dt,
...) = ..., or substring(col, ...) = ... to skip irrelevant storage ranges.
Solution:
- Reuse the monotonic predicate inference after CBO for OLAP scans, file
scans, file TVFs, and storage-layer aggregate wrappers.
- Preserve the original predicate and append only safety-checked necessary
conditions, avoiding changes to query semantics, cardinality estimation, join
planning,
and MV matching.
- Derive tighter two-sided ranges for supported prefix, date-format, and
date rounding equalities.
- Model adjacent bucket boundaries in date floor/ceil functions while
conservatively excluding unsafe origins, timestamp-with-time-zone values,
invalid
boundaries, and non-ASCII prefix successors.
- Prevent integer overflow when converting quarter periods into months.
related pr: #66965
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
