25.8.16.20001 Altinity Antalya

Altinity Antalya release v25.8.16.20001.altinityantalya (027f871) as compared to upstream/v25.8.16.34-lts (7938087aa80508fb6d40b8bf024d025809a8880c)

Improvement

• Disable crash report in more places: some embedded config files did not have crash reporting disabled (#1387 by @strtgbb)
• Add query id to system.part_log, system_exports and system.replicated_partition_exports (#1330 by @arthurpassos)

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

• Fix 'Invalid dict indices bit width: 0' in parquet reader v3 (ClickHouse#87258 by @al13n321 via #1408)

CI Fix or Improvement

• Automated upload and sanity check for binaries to include symtable; Fixes for package installation as signing runner was updated to ubuntu 24.04 (#1374 by @MyroTk)
• Set regression job.name properly in new reusable suite; copy known broken tests from stable 25.8; remove references to upstream packages from server/keeper dockerfile (#1439 by @strtgbb)

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

Full Changelog: https://github.com/ClickHouse/ClickHouse/compare/v25.8.16.34-lts...Altinity:ClickHouse:v25.8.16.20001.altinityantalya?expand=1

25.8.16.10001 Altinity Stable

Changes compared to upstream's v25.8.16.34-lts

Backward Incompatible Changes

• ALTER MODIFY COLUMN now requires explicit DEFAULT when converting nullable columns to non-nullable types. Previously such ALTERs could get stuck with cannot convert null to not null errors, now NULLs are replaced with column's default expression (ClickHouse#84770 by @vdimir via #1344)

New Features

• Added new SQL statement EXECUTE AS to support user impersonation (ClickHouse#70775 by @shiyer7474, ClickHouse#90437 by @alexbakharew via #1340)

Critical Bug Fixes

• Fix crash in StorageDistributed when parsing malformed shard directory names (ClickHouse#90243 by @AVMusorin via #1343)

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

• Now datalakes catalogs will be shown in system introspection tables only if show_data_lake_catalogs_in_system_tables explicitly enabled (ClickHouse#88341 by @alesapin via #1331)
• Now ClickHouse will show data lake catalog database in SHOW DATABASES query by default (ClickHouse#89914 by @alesapin via #1331)
• Possible crash/undefined behavior in IN function where primary key column types are different from IN function right side column types (ClickHouse#89367 by @ilejn via #1339)
• Fixed move-to-prewhere optimization, which did not work in the presence of row policy (ClickHouse#87303 by @KochetovNicolai via #1345)
• Fixes a bug where certain distributed queries with ORDER BY could return ALIAS columns with swapped values (i.e., column a showing column b’s data and vice versa) (ClickHouse#94644 by @filimonov via #1346)
• Split part ranges by volume characteristics to enable TTL drop merges for cold volumes. After this patch, parts with a max TTL < now will be removed from cold storage. The algorithm will schedule only single part drops. (ClickHouse#90059 by @Michicosun via #1363)
• Check and mark the interserver IO address active in DDL worker (ClickHouse#92339 by @tuanpach via #1403)
• Disable write_marks_for_substreams_in_compact_parts by default to preserve downgrade compatibility (#1407 by @zvonand)

Improvements

• Fix handling of users with a dot in the name when added via config file (ClickHouse#86633 by @mkmkme via #1342)
• S3Queue auxiliary Zookeeper support using keeper_path setting from s3Queue (ClickHouse#95203 by @lesandie via #1357)

Performance Improvements

• 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 (ClickHouse#88090 by @shankar-iyer via #1332)
• Reduce INSERT/merges memory usage with wide parts for very wide tables by enabling adaptive write buffers. Add support of adaptive write buffers for encrypted disks (ClickHouse#92250 by @azat via #1341)

Not for changelog

• 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.8.16.10001.altinitystable

25.8.14.20001 Altinity Antalya

Altinity Antalya release v25.8.14.20001.altinityantalya (783cf36) as compared to upstream/v25.8.14.17-lts (85bdcee459593cd55faef3154a5e487b60119ff4)

New Feature

Improvement

• Google cloud storage support for data lakes (ClickHouse#93866 by @scanhex12 via #1318)
• Allow merge tree materialized / alias columns to be exported through part export (#1324 by @arthurpassos)
• Add export_merge_tree_part_throw_on_pending_mutations and export_merge_tree_part_throw_on_pending_patch_parts to control the behavior of pending mutations / patch parts on the export part feature (#1294 by @arthurpassos)
• Now engine=Hybrid can access columns which are defined as ALIAS in segments (#1272 by @filimonov)
• Add query id to system.part_log, system_exports and system.replicated_partition_exports (#1330 by @arthurpassos)
• Accept table function as destination for part export, inherit schema if not explicitly provided (#1320 by @arthurpassos)

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

• Fix simple parquet reader v3 assert on bool column min/max (ClickHouse#87095 by @al13n321 via #1269)
• Now ClickHouse will show data lake catalog database in SHOW DATABASES query by default (ClickHouse#89914 by @alesapin via #1283)
• Fixes an issue when Iceberg columns with dot in names returned NULL as values (#1319 by @mkmkme)
• Fixed two-level aggregation when using Merge over Distributed (ClickHouse#87687 by @c-end + ClickHouse#88406 by @azat via #1328)

CI Fix or Improvement

• Use reusable suite for regression workflow (#1267 by @strtgbb)
• A missing semicolon resulted in regression jobs always being green (#1286 by @strtgbb)

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

Full Changelog: https://github.com/ClickHouse/ClickHouse/compare/v25.8.14.17-lts...Altinity:ClickHouse:v25.8.14.20001.altinityantalya?expand=1

25.8.12.20747 Altinity Antalya

Altinity Antalya release v25.8.12.20747.altinityantalya (f5fb292) as compared to upstream/v25.8.12.129-lts (a53ebd72b2d)

New Feature

• Introduce token-based authentication and authorization (#1078 by @zvonand)
• Split large parquet files on part export, preserve entire settings object in part export (#1229 by @arthurpassos)

Improvement

• Profile events for task distribution in ObjectStorageCluster requests (#1172 by @ianton-ru)
• Set max message size on parquet v3 reader to avoid getting DB::Exception: apache::thrift::transport::TTransportException: MaxMessageSize reached (#1198 by @arthurpassos)

Performance Improvement

• Parquet reader v3 is enabled by default (ClickHouse#79012, ClickHouse#87735 and ClickHouse#88827 by @al13n321 via #1232)
• Distributed execution: better split tasks by row groups IDs, not by files (ClickHouse#87508 by @scanhex12 via #1237)

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

• Fix segfault on unexpected node shutdown (#1201 @ianton-ru)
• Fix segfault in requests to system,table when table in Iceberg catalog does not have snapshot (#1211 by @ianton-ru)
• Now datalakes catalogs will be shown in system introspection tables only if show_data_lake_catalogs_in_system_tables explicitly enabled (ClickHouse#88341 by @alesapin via #1239)

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

• Fix IN with Iceberg table (#1168 by @ianton-ru)
• Fix for task distribution in cluster requests (#1178 by @ianton-ru)
• Fix min/max value in Iceberg writes (#1192 by @ianton-ru)
• Fixes a bug where toDateTimeOrNull of a negative argument returns NULL (ClickHouse#90490 by @yariks5s via #1206)
• Fix missing leading slash for some local iceberg tables (#1212 by @zvonand)
• Revert "Fix redundant host resolution in DDL Worker" (#1219 by @ianton-ru)
• explicit POCO request for REST-polaris catalog (ClickHouse#91437 by @scanhex12 via #1224)
• Fix confusing cluster name and named collection name in cluster functions (#1234 by @ianton-ru)

Build/Testing/Packaging Improvement

• Fix test 03644_object_storage_correlated_subqueries (#1203 by @ianton-ru)

Documentation

• Documentation for Swarm features in Antalya branch (#1165 by @ianton-ru)

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

Full Changelog: https://github.com/ClickHouse/ClickHouse/compare/v25.8.12.129-lts...Altinity:ClickHouse:v25.8.12.20747.altinityantalya?expand=1

25.8.9.20496 Altinity Antalya

Altinity Antalya release v25.8.9.20496.altinityantalya (f5fb292) as compared to v25.8.9.20238.altinityantalya (1a190de)

New Feature

• Setting iceberg_timezone_for_timestamptz for Iceberg timestamptz type. (#1103 by @ianton-ru)
• icebergLocalCluster table function. (#1120 by @ianton-ru)
• Export partition support for ReplicatedMergeTree engine (#1124, #1161, #1167 by @arthurpassos)

Improvement

• Allow to read Iceberg data from any location. (#1092, #1163 by @zvonand)
• Preserve a few file format settings in the export part manifest to be able to better control parallelism. (#1106 by @arthurpassos)
• Do not send min/max info on swarm nodes when setting allow_experimental_iceberg_read_optimization is turned off. (#1109 by @ianton-ru)
• More metrics for Iceberg, S3, and Azure. (#1123 by @ianton-ru)
• Fix parquet writing not preserving original order when using single threaded writing with the native writer. (#1143 by @arthurpassos)
• Preserve the entire format settings object in export part manifest. (#1144 by @arthurpassos)
• Added experimental support in the Hybrid table engine to automatically reconcile column-type mismatches across segments via hybrid_table_auto_cast_columns (analyzer only). This allows queries to return consistent headers even when the underlying tables use different physical types. (#1156 by @filimonov)

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

• Fixed an issue when the missing "field_id" would cause the query to fail. (#1171 by @mkmkme)
• Fix joins with Iceberg tables Solved #1063. (#1082 by @ianton-ru)
• Check multiplexed connection before usage. (#1102 by @ianton-ru)
• Fix SYSTEM DROP FILESYSTEM CACHE ON CLUSTER. (#1130 by @ianton-ru)
• Fixed PREWHERE for StorageObjectStorageCluster. (#1137 by @ianton-ru)
• Never put hive partition columns in the format header. Fixes #87515. (ClickHouse#87528 by @arthurpassos via #1149)
• Fix crash due to incompatible headers when mutation changed the schema between scheduling and executing part exports. (#1150 by @arthurpassos)
• Revert support for 'IN' in cluster requests. (#1160 by @ianton-ru)
• Fixed logical errors in _row_number virtual column and iceberg positioned deletes. (ClickHouse#87220 by @al13n321 via #1136)
• Fix JSON Exception in iceberg table with timestamp column when using glue catalog. Resolves #90210. (ClickHouse#90209 by @alsugiliazova via #1151)
• Make parquet reader v3 preserve decimal precision information. (ClickHouse#87444 by @al13n321 via #1140)
• More fixes for parquet reader v3, enable it in stateless tests. (ClickHouse#87600 by @al13n321 via #1138)

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

Full Changelog: v25.8.9.20238.altinityantalya...v25.8.9.20496.altinityantalya

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)