v.25.3New Feature

Add three new

Official CH changelog text
Add three new functions. icebergTruncate according to specification. https://iceberg.apache.org/spec/#truncate-transform-details, toYearNumSinceEpoch and toMonthNumSinceEpoch. Support truncate transform in partition pruning for Iceberg engine. #77403 (alesapin).
Introduces three new functions: icebergTruncate (following the Apache Iceberg specification), toYearNumSinceEpoch, and toMonthNumSinceEpoch. Adds support for the truncate transform in partition pruning within the Iceberg table engine.

Why it matters

This feature enables more efficient query execution and data partitioning for Iceberg tables by implementing the truncate transform according to the Iceberg specification. The new functions facilitate advanced date/time transformations aligning with Iceberg's partitioning logic, thereby improving partition pruning and query performance.

How to use it

Use the new functions icebergTruncate, toYearNumSinceEpoch, and toMonthNumSinceEpoch in your SQL queries as needed. For Iceberg tables, the partition pruning will now support the truncate transform automatically during query processing when applicable.

Related resources

PreviousNext