Changelog

ClickHouse 25.8 LTS support

    Improved
    Aiven for ClickHouse®

Aiven for ClickHouse® now supports ClickHouse 25.8 LTS. This release adds new table engines and expands support for data lake and object storage integrations.

Key highlights

  • Vector search GA with binary quantization for lower memory usage and faster indexing
  • Lightweight projections act as secondary indexes without duplicating data
  • Lightweight updates (beta) — UPDATE ... SET ... WHERE on MergeTree tables
  • Correlated subqueries and lag/lead window functions for broader SQL compatibility
  • Iceberg and Delta Lake improvements including write support, catalog integration, and position/equality deletes
  • Parquet reader v3 with filter pushdown for faster queries on external files
  • Lazy materialization and query condition cache for improved query performance

More engines supported

  • MergeTree family
    • CoalescingMergeTree
    • ReplicatedCoalescingMergeTree
  • Integration
    • GCS
  • Data lake
    • DeltaLakeAzure
    • DeltaLakeS3

Table engines supported in ClickHouse 25.3 remain available in ClickHouse 25.8. For the complete list of upstream changes, see ClickHouse 2025 Changelog.