25.3.8.10041 Altinity Stable

Altinity Stable release v25.3.8.10041 (cfe75cb) as compared to upstream/v25.3.8.23-lts (4149650741851dc48fd43371b686804db152aca3)

New Feature

• Added new SQL statement EXECUTE AS to support user impersonation (ClickHouse#70775 by @shiyer7474 via #1125)
• Allow altering a database comment (ClickHouse#75622 by @NamHoaiNguyen via #1118)

Improvement

• Fixes handling of users with a dot in the name when added via config file (ClickHouse#86633 by @mkmkme via #1121)

Performance Improvement

• SELECT query with FINAL clause on a ReplacingMergeTree table with the is_deleted column now executes faster because of improved parallelization from 2 existing optimizations : 1) do_not_merge_across_partitions_select_final optimization for partitions of the table that have only a single part 2) Split other selected ranges of the table into intersecting / non-intersecting and only intersecting ranges have to pass through FINAL merging transform (ClickHouse#88090 by @shankar-iyer via #1126)

Critical Bug Fix (crash, data loss, RBAC) or LOGICAL_ERROR

• A Poco::TimeoutException exception thrown from Poco::Net::HTTPChunkedStreamBuf::readFromDevice leads to a crash with SIGABRT. (ClickHouse#88668 and ClickHouse#89090 by @mstetsyuk, ClickHouse#81597 by @CheSema via #1117)

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

• Fix table name encoding in data lake rest catalog (Backport of ClickHouse#87020 by @ianton-ru via #1127)
• Fixed incorrect query results and out-of-memory crashes when using match(column, '^…') with backslash-escaped characters (ClickHouse#79969 by @filimonov via #1122)
• Fixed move-to-prewhere optimization, which did not work in the presence of row policy (ClickHouse#87303 by @KochetovNicolai, ClickHouse#88017 by @novikd via #1129)

Build/Testing/Packaging Improvements

• Bump OpenSSL to fix CVE-2025-9230

Not for changelog

• Ignore parse error in system.distributed_ddl_queue (ClickHouse#79369 by @ilejn via #1128)

Packages

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

Docker images

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

Full Changelog: v25.3.8.23-lts...v25.3.8.10041.altinitystable

25.8.9.20238 Altinity Antalya

Altinity Antalya release v25.8.9.20238.altinityantalya (1a190de) as compared to v25.8.9.20207.altinityantalya (044fdbd)

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

• Proper handling of opt-in AWS regions for S3. (#1101 by @zvonand)
• Do not throw exception when reading Iceberg metadata failed in call to system.tables. (#1098 by @zvonand)

Missing ports from previous releases

• Iceberg addtional columns in system tables. (#959 and #1026 by @zvonand via #1095)
• Make DataLake metadata more lazy. (#742 by @ianton-ru via #1096)

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.8.9.20238.altinityantalya

Full Changelog

v25.8.9.20207.altinityantalya...v25.8.9.20238.altinityantalya

24.8.14.10544 Altinity Stable

Changes compared to v24.8.14.10501.altinitystable (d1f73c2)

Critical Bug Fixes (crash, data loss, RBAC) or LOGICAL_ERROR

• Fixes access validation on select for loop table function (ClickHouse#88802 by @pufit via #1099)

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

• Allow referencing any table in view(...) argument of remote table function with enabled analyzer (ClickHouse#83844 by @novikd via #995)
• Fixed error Block structure mismatch in several cases with tables with sparse columns (ClickHouse#79491 by @CurtizJ via #1003)
• ClickHouse crashes if ArrowStream file has non-unique dictionary (ClickHouse#87863 by @ilejn via #1067)
• Fixed move-to-prewhere optimization, which did not work in the presence of row policy (ClickHouse#87303 by @KochetovNicolai via #1080)

Improvements

• New MergeTree setting search_orphaned_parts_drives to limit scope to look for parts e.g. by disks with local metadata (ClickHouse#84710 by @ilejn via #977)
• Refreshable materialized view improvements: append mode (... REFRESH EVERY 1 MINUTE APPEND ...) to add rows to existing table instead of overwriting the whole table, retries (disabled by default, configured in SETTINGS section of the query), SYSTEM WAIT VIEW <name> query that waits for the currently running refresh, some fixes (ClickHouse#68249, ClickHouse#58934 by @al13n321 via #1066)
• Fixes handling of users with a dot in the name when added via config file (ClickHouse#86633 by @mkmkme via #1089)

Performance Improvements

• Performance improvements to all bloom filter types (ClickHouse#79800 by @dkratunov via #1062)

Build/Testing/Packaging Improvement

• Fix branding (#870, #871 by @Enmk #899 by @strtgbb)
• Specify that downloaded packages and logs correspond to the run (#964 by @MyroTk)
• Fix Grype Scan Job (#1029 by @strtgbb)
• Bump OpenSSL to fix CVE-2025-9230, bump Alpine in Keeper image to 3.21.5 (#1088 by @zvonand)
• Change openldap source from bitnami -> bitnamilegacy (#1100 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.10544.altinitystable

Full Changelog: v24.8.14.10501.altinitystable...v24.8.14.10544.altinitystable

25.8.9.20207 Altinity Antalya

Altinity Antalya release v25.8.9.20207 (044fdbd) as compared to upstream/v25.8.9.20-lts (a1f4cd9c23f)

New Feature

• Engine=hybrid implementation. (#1071 by @filimonov)

Experimental Feature

• Read optimization using Iceberg metadata Port of #1019 with many changes. (#1069, #1076 by @ianton-ru)

Improvement

• Fix data lake tables with a percent-encoded sequence in the name. (ClickHouse#87020 by @ianton-ru via #1060)
• Allow any partition strategy to accept part export. (#1083 by @arthurpassos)

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

• Fix for 'virtual' packet on connection lost (#1024 by @ianton-ru via #1059)
• Deduce Iceberg metadata from Glue's Location. (#1070 by @zvonand)

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.8.9.20207.altinityantalya

Full Changelog: v25.8.9.20-lts...v25.8.9.20207.altinityantalya

25.6.5.20420 Altinity Antalya

Changes compared to previous Altinity Antalya release v25.6.5.20363.altinityantalya (1baa927bf95feed16ccaa12ed3e8b141e257bd68)

Experimental Feature

• Read optimization using Iceberg metadata. (#1019 by @ianton-ru)

Improvement

• Added observability for EXPORT PART: system.exports table, profile events, etc (#1017 by @arthurpassos)
• Allow key-value arguments in S3 table engine (ClickHouse#85134 by @kssenii via #1028)

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

• Never put hive partition columns in the format header. Fixes [ClickHouse#87515] (ClickHouse#87515, ClickHouse#87621 by @arthurpassos via #1037)
• Only parse hive partition columns as LowCardinality if they are parsed as Strings. (#1037 by @arthurpassos)
• Fix lock_object_storage_task_distribution_ms when one of replica is lost, changed lock_object_storage_task_distribution_ms default value to 500. (#1042 by @ianton-ru)
• Fix handling of timestamp / timestamptz columns in Glue Catalog. Fixes #87609 (ClickHouse#87733 by @zvonand via #1053).

Build/Testing/Packaging Improvement

• Do not send crash reports to crash.clickhouse.com. (#1047 by @Enmk)
• Update artifact upload paths to be uniform and match 25.8. (#1055 by @MyroTk)

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