v.25.8New Feature

Merge all iceberg position delete files into

Official CH changelog text
Merge all iceberg position delete files into data files. This will reduce amount and sizes of parquet files in iceberg storage. Syntax: OPTIMIZE TABLE table_name. #85250 (Konstantin Vedernikov).
Merge all Iceberg position delete files into data files to reduce the number and size of parquet files in Iceberg storage.

Why it matters

This feature optimizes storage efficiency by consolidating position delete files into the data files themselves, which decreases the total number and size of Parquet files maintained in Iceberg tables. This reduction helps improve query performance and manageability of Iceberg data in ClickHouse.

How to use it

To apply this optimization, run the command:

OPTIMIZE TABLE table_name

Related resources

PreviousNext