v.25.12New Feature

Support ORDER In Iceberg Tables

Official CH changelog text
Support ORDER BY in CREATE operation for iceberg + sorting in INSERT. Resolves #89916. #90141 (Konstantin Vedernikov).
Support for specifying ORDER BY clause in CREATE operations with the Iceberg engine, as well as enabling sorting during INSERT operations.

Why it matters

This feature addresses the need for defining sorting order directly when creating Iceberg tables and maintaining this order during data insertion. It improves data organization and query efficiency by enabling predictable sorted storage in Iceberg tables.

How to use it

When creating an Iceberg table, users can include an ORDER BY clause in the CREATE TABLE statement to define the sorting key. Additionally, during INSERT operations, sorting according to the defined keys is now supported to maintain the desired data order.

Related resources

PreviousNext