25.6.5.20363 Altinity Antalya

Changes compared to upstream/v25.6.5.41-stable (533d680)

New Feature

• Add support for hive partition style reads and writes. ([ClickHouse#76802](ClickHouse#76802 by @arthurpassos) via #934)
• Implement AWS S3 authentication with an explicitly provided IAM role. Implement OAuth for GCS. These features were recently only available in ClickHouse Cloud and are now open-sourced. Synchronize some interfaces such as serialization of the connection parameters for object storages. (ClickHouse#84011 by @alexey-milovidov via #986)

Experimental Feature

• Restart loading files from object storage on other nodes when one node down in a swarm query. (#780 by @ianton-ru)
• Simple MergeTree part export to object storage (#1009 by @arthurpassos)
• JOIN with *Cluster table functions and swarm queries. (#972 by @ianton-ru)
• SYSTEM STOP SWARM MODE command for graceful shutdown of swarm node. (#1014 by @ianton-ru)

Improvement

• Expose IcebergS3 partition_key and sorting_key in system.tables. (#959 by @zvonand)
• Fix an issue where the exception was thrown upon clickhouse-client connection to the server with a DataLakeCatalog database misconfigured. The exception will still be logged in the server log. (ClickHouse#83298 by @scanhex12 via #970)
• Now database Datalake throws a more convenient exception. Fixes ClickHouse#81211. (ClickHouse#82304 by @alesapin via #974)
• Turned on experimental catalog types for DataLakeCatalog database engine by default: iceberg, unity, and glue. (#988 by @Enmk)
• Support writing parquet enum as byte array as the spec dictates. (ClickHouse#81090 by @arthurpassos, ClickHouse#84169 by @Avogar via #989)
• Support TimestampTZ in Glue catalog. Fixes ClickHouse#81654 (ClickHouse#83132 by @scanhex12 via #992)
• Now clickhouse supports compressed metadata.json files for Iceberg. Fixes ClickHouse#70874. (ClickHouse#81451 by @alesapin via #1005)

Bug Fix (user-visible misbehavior in an official stable release)

• Now ClickHouse can read iceberg tables from Glue catalog after schema evolution. Fixes ClickHouse#81272 (ClickHouse#82301 by @alesapin via #991)
• Fail when all replicas are unavailable for *cluster functions. (ClickHouse#86414 by @jmaicher via #993)
• Few fixes to object storage hive reads & writes (ClickHouse#85538 by @arthurpassos via #1001)

And ALL Antalya features from previous releases

Packages

Available for both AMD64 and Aarch64 from https://builds.altinity.cloud/#altinityantalya as either .deb, .rpm, or .tgz

Docker images

Available for both AMD64 and Aarch64: altinity/clickhouse-server:25.6.5.20363.altinityantalya

Full Changelog: v25.6.5.41-stable...v25.6.5.20363.altinityantalya

25.3.6.10034 Altinity Stable

Changes compared to upstream's v25.3.6.56-lts

Bug Fixes (user-visible misbehavior in an official stable release)

• Skip indexes with lambda expressions could not be applied. Fix the case when high-level functions in the index definition exactly match the one in the query (ClickHouse#80025 by @KochetovNicolai via #918)
• Do not check for cyclic dependencies on create table with no dependencies. It fixes performance degradation of the use cases with creation of thousands of tables that was introduced in ClickHouse#65405 (ClickHouse#83077 by @Avogar via #916)
• Fix wrong results for grouping sets with ColumnConst and Analyzer (ClickHouse#79743 by @zvonand via #915)

Improvements

• Add _time virtual column in S3Queue engine (ClickHouse#78926 by @ianton-ru via #913)

CI Fixes or Improvements

• Remove guard pages for threads and async_socket_for_remote/use_hedge_requests. Change the allocation method in FiberStack from mmap to aligned_alloc. Since this splits VMAs and under heavy load vm.max_map_count can be reached. (ClickHouse#78423 by @azat, ClickHouse#79147 and ClickHouse#79533 by @CheSema via #917)

Not for changelog

• Ignore parse error in system.distributed_ddl_queue (ClickHouse#79369 by @ilejn via #914)
• Iceberg as alias for DataLakeCatalog with catalog_type='rest' (#822 by @ianton-ru via #912)
• Altinity branding patches

Build report

Release notes

Packages

Available for both AMD64 and Aarch64 from https://builds.altinity.cloud/ as either .deb, .rpm, or .tgz

Docker images

Available for both AMD64 and Aarch64: altinity/clickhouse-server/25.3.6.10034.altinitystable

25.3.3.20186 Altinity Antalya

Altinity Antalya release v25.3.3.20186.altinityantalya (143c05f) as compared to v25.3.3.20183.altinityantalya (1abef61)

New Feature

• Add iceberg_metadata_file_path to query when send it to swarm nodes (#898 by @ianton-ru)

Packages

Available for both AMD64 and Aarch64 from https://builds.altinity.cloud/ as either .deb, .rpm, or .tgz

Docker images

Available for both AMD64 and Aarch64: altinity/clickhouse-server:25.3.3.20186.altinityantalya

Full Changelog: v25.3.3.20183.altinityantalya...v25.3.3.20186.altinityantalya

25.3.3.20183 Altinity Antalya

Altinity Antalya release v25.3.3.20183.altinityantalya (1abef61) as compared to v25.3.3.20143.altinityantalya (98010fb)

New Feature

• Setting lock_object_storage_task_distribution_ms to improve cache locality with swarm cluster. (#866 by @ianton-ru)

Improvement

• Allow data and metadata with different paths. Support S3 tables as a warehouse. (#860 by @ianton-ru)
• This change the default behavior of partition pruning for Iceberg table. (ClickHouse#80583 by @melvynator via #881)
• Added support of compressed metadata.json files for Iceberg. (ClickHouse#81451 by @alesapin via #883)

Bug Fix (user-visible misbehavior in an official stable release)

• IcebergS3 supports count optimization, but IcebergS3Cluster does not. As a result, the count() result returned in cluster mode may be a multiple of the number of replicas. (ClickHouse#79844 by @wxybear via #878, #885)

Build/Testing/Packaging Improvement

• Fix branding (#870, #871, #886 by @Enmk)

Packages

Available for both AMD64 and Aarch64 from https://builds.altinity.cloud/ as either .deb, .rpm, or .tgz

Docker images

Available for both AMD64 and Aarch64: altinity/clickhouse-server:25.3.3.20183.altinityantalya

Full Changelog: v25.3.3.20143.altinityantalya...v25.3.3.20183.altinityantalya

24.8.14.10501 Altinity Stable

Changes compared to v24.8.14.10459.altinitystable (abce67b)

Bug Fixes (user-visible misbehavior in an official stable release)

• Wait for pair delimiter after flusing quoted value on extractKeyValuePairs (partial backport of ClickHouse#80657 by @arthurpassos via #865)
• Fix match(col, '^…') index analysis with escaped metacharacters to avoid wrong results and crashes (ClickHouse#79969 by @filimonov via #863)
• Fix wrong results for grouping sets with ColumnConst and Analyzer (ClickHouse#79743 by @zvonand via #862)
• Ignore parse error in system.distributed_ddl_queue (ClickHouse#79369 by @ilejn via #843)

Improvements

• Allow to add http_response_headers in http_handlers of any kind (ClickHouse#79975 by @zvonand via #832)
• Added support for Date32, DateTime64 in TTL (ClickHouse#80710 by @zvonand via #833)

Build/Testing/Packaging Improvement

• 24.8 update report to new format (#823 by @strtgbb)
• Add Grype Scan (#792 by @strtgbb)
• Smarter pr number fetching for grype and report and update report action (#845 by @strtgbb)

Packages

Available for both AMD64 and Aarch64 from https://builds.altinity.cloud/ as either .deb, .rpm, or .tgz

Docker images

Available for both AMD64 and Aarch64: altinity/clickhouse-server:24.8.14.10501.altinitystable

Full Changelog: v24.8.14.10459.altinitystable...v24.8.14.10501.altinitystable

25.3.3.20143 Altinity Antalya

Altinity Antalya release v25.3.3.20143.altinityantalya (98010fb) as compared to v25.2.2.28788.altinityantalya (c25e57f)

new base: upstream/v25.3.3.42-lts

New Feature

• Add icebergHash and icebergBucketTransform functions. Support data files pruning in Iceberg tables partitioned with bucket transfom. (ClickHouse#79262 by @divanik via #786)

Improvement

• Add several convenient ways to resolve root metadata.json file in an iceberg table function and engine. Closes #78455. (ClickHouse#78475 by @divanik via #841)
• Iceberg as alias for DataLakeCatalog with catalog_type='rest''. (#822 by @ianton-ru)

Bug Fix (user-visible misbehavior in an official stable release)

• Fixed Context expiration for Iceberg queries. (#839 by @ianton-ru)

Build/Testing/Packaging Improvement

• Fixed parquet metadata related tests. (#824 by @Enmk)

Docker images

Available for both AMD64 and Aarch64: altinity/clickhouse-server:25.3.3.20143.altinityantalya

24.3.18 Altinity Stable

Changes compared to upstream's v24.3.18.7-lts

Bug Fixes (user-visible misbehavior in an official stable release)

• Fix advanced SSL configuration for Keeper's internal communication (ClickHouse#72730 by @antonio2368 via #768)
• Regularly check if merges and mutations were cancelled even in case when the operation doesn't produce any blocks to write. (ClickHouse#77766 by @ antaljanosbenjamin via #729)

Improvements

• ALTER TABLE .. REPLACE PARTITION doesn't wait anymore for mutations/merges that happen in other partitions (ClickHouse#59138 by @Enmk and @zvonand via #729)
• Allow to use named collections in ODBC/JDBC (ClickHouse#80334 by @zvonand via #838)

Build/Testing/Packaging Improvement

• Fixed tests (#785)

Full Changelog: v24.3.12.58312.altinityhotfix...Altinity:ClickHouse:v24.3.18.10426.altinitystable

Packages

Available for both AMD64 and Aarch64 from https://builds.altinity.cloud/ as either .deb, .rpm, or .tgz

Docker images

Available for both AMD64 and Aarch64: altinity/clickhouse-server:24.3.18.10426.altinitystable

25.2.2.28788 Altinity Antalya

Changes compared to v25.2.2.27772.altinityantalya (319e424)

New Feature

• Cache for listobjects calls. (#743 by @arthurpassos)

Improvement

• Iceberg table pruning in cluster requests. (#770 by @ianton-ru)

Bug Fix (user-visible misbehavior in an official stable release)

• Fixed format detection for table function iceberg (fixes #732). (#746 by @ianton-ru)
• Fix filling addresses_with_failover with correct addresses. (#750 by @ianton-ru)
• Fix macros for autodiscovery clusters. (#757 by @ianton-ru)
• Rendevous hashing was not work properly in complex queries. (#760 by @ianton-ru)
• Fix some tests and virtual methods. (#761 by @ianton-ru)

Build/Testing/Packaging Improvement

• Migrate the GitLab CI/CD to GitHub and remove most jobs to focus on sign and release task. (#758 by @MyroTk)
• Fix build. (#747 by @ianton-ru)

Full Changelog: v25.2.2.27772.altinityantalya...v25.2.2.28788.altinityantalya

Packages

Available for both AMD64 and Aarch64 from https://builds.altinity.cloud/ as either .deb, .rpm, or .tgz

Docker images

Available for both AMD64 and Aarch64: altinity/clickhouse-server:25.2.2.28788.altinityantalya

25.2.2.27772 Altinity Antalya

Changes compared to v25.2.2.27732.altinityantalya (11d0423)

Performance Improvement

• Lazy load metadata for metadata for DataLake. (#742 by @ianton-ru)

Improvement

• Improve performance of hive path parsing by using extractKeyValuePairs instead of regex (ClickHouse#79067 by @arthurpassos via #734)

Bug Fix (user-visible misbehavior in an official stable release)

• Fix reading iceberg failed when min-max value is null. (ClickHouse#78764 by @ucasfl via #738)

Full Changelog: v25.2.2.27732.altinityantalya...v25.2.2.27772.altinityantalya

Packages

Available for both AMD64 and Aarch64 from https://builds.altinity.cloud/ as either .deb, .rpm, or .tgz

Docker images

Available for both AMD64 and Aarch64: altinity/clickhouse-server:25.2.2.27772.altinityantalya

25.2.2.27732 Altinity Antalya

Changes compared to v25.2.2.27662.altinityantalya (b9b80e4c)

Performance improvements

• Support Iceberg data pruning based on lower_bound and uppert_bound values for columns (ClickHouse#78242 by @alesapin via #733)
• Implement trivial count optimization for Iceberg. Now queries with count() and without any filters should be faster. (ClickHouse#78090 by @alesapin via #733)

Improvements

• Support partition pruning in delta lake. (ClickHouse#78486 by @kssenii via #733)
• In StorageDeltaLake with delta-kernel-rs implementation, fix performance and progress bar (ClickHouse#78368 by @kssenii via #733)
• Allow to explicitly specify metadata file to read for Iceberg with storage/table function setting iceberg_metadata_file_path (ClickHouse#77318 by @alesapin via #733)
• Implemented parsing enhancements (Sequence ID parsing: Added functionality to parse sequence identifiers in manifest files AND Avro metadata parsing: Redesigned the Avro metadata parser to be easily extendable for future enhancements) (ClickHouse#75010 by @divanik via #733)

New features

• Support IcebergMetadataFilesCache, which will store manifest files/list and metadata.json in one cache. (ClickHouse#77156 by @hanfei1991 via #733)
• Allows a user to query the state of an Iceberg table as it existed at a previous point in time. (ClickHouse#77439 by @divanik via #733)
• Add 3 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. (ClickHouse#77403 by @alesapin via #733)

Bug fixes

• The subpath inside the table directory is chosen in a more profound way (ClickHouse#76681 by @divanik via #733)

Full Changelog: v25.2.2.27662.altinityantalya...v25.2.2.27732.altinityantalya

Packages

Available for both AMD64 and Aarch64 from https://builds.altinity.cloud/ as either .deb, .rpm, or .tgz

Docker images

Available for both AMD64 and Aarch64: altinity/clickhouse-server:25.2.2.27732.altinityantalya