ApsaraDB for ClickHouse:Community-compatible edition

Version

Description

Related documents

25.3.2.1-1.4.1

kernel: Merged the latest community 25.3 LTS version, v25.3.14.14-lts, including 49 bug fixes.

None

Version

Description

Related documents

25.3.2.1-1.3.2

• Parameter adjustments

  • Enabled ttl_only_drop_parts.

  • Disabled use_uncompressed_cache.

• Other

  Integrated community version v25.3.11.20-lts.

None

Version

Description

Related documents

25.3-1.3.1

• Parameter adjustment

  The ttl_only_drop_parts, query_profiler_cpu_time_period_ns, and query_profiler_real_time_period_ns parameters now use the default kernel values.

• Bug fixes

  • Fixed the TTL merge logic for cold and hot data tiering to ensure that TTL remains effective on cold storage even when merge operations are disabled.

  • TTLMerge is no longer affected by the max_bytes_to_merge_at_max_space_in_pool parameter.

• Other updates

  Updated to community 25.3 LTS version v25.3.8.23-lts.

None

Version

Description

Related documents

25.3-1.3.0

• Bug fix

  Fixed the TTL merge logic for hot/cold tiering to ensure TTL remains effective on cold storage with merge disabled.

• Other

  Upgraded to community 25.3 LTS v25.3.7.194-lts.

None

Version

Description

Related documentation

25.3-1.1.2

Parameter changes

• Reset max_expanded_ast_elements to its kernel default value.

• Reset max_insert_block_size to its kernel default value.

• Set merge_with_ttl_timeout to 3600s.

None

23.8-1.4.3

Parameter changes

• Reset max_expanded_ast_elements to its kernel default value.

• Reset max_insert_block_size to its kernel default value.

• Set merge_with_ttl_timeout to 3600s.

New feature

Added support for the min_free_disk_ratio_to_perform_insert and min_free_disk_bytes_to_perform_insert configuration parameters, which throw an exception on write operations if free disk space is insufficient.

Bug fix

Fixed an instance crash caused by a "Nullptr dereference in FindOriginalNodeForOutputName" error.

Nullptr dereference in FindOriginalNodeForOutputName

Version

Description

Related documentation

25.3-1.1.1

Enhancement

Added support for Kafka sasl configuration parameters.

Kafka

25.3-1.1.0

Release of the community-compatible edition 25.3.

• New features

  • A new, production-ready JSON data type that is fully integrated with query acceleration.

    • More compact than compressed files on disk.

    • Orders of magnitude faster than traditional JSON storage solutions like MongoDB.

    • The only JSON storage that fully supports dynamic JSON paths without type casting.

  • The new estimateCompressionRatio function lets you estimate the data compression ratio to evaluate the potential impact of different compression algorithms.

  • Now supports bloom filters for the Parquet data type.

  • Now supports the WithProgress format for HTTP event streams.

  • Introduced a table-level MinMax index that stores the minimum and maximum values of index expressions for each block.

  • Non-equi JOINs are now supported by default.

  • BFloat16 data type for representing vector embeddings, beneficial for AI and vector search applications.

• Optimizations

  • The new query condition cache accelerates repeatedly executed queries, optimizing selective WHERE clauses that do not benefit from the primary index in dashboard or observability scenarios.

  • Faster parallel hash join.

  • Transitive condition inference now enables transitive inference across comparison chains. For example, given WHERE a < b AND b < c AND c < 5, the optimizer automatically infers and uses the additional conditions (a < 5 AND b < 5) to enhance filtering efficiency.

  • The new query_plan_join_swap_table setting enables automatic JOIN reordering to optimize the selection of the build table for JOINs.

  • JOIN expression optimization, enabled by the new optimize_extract_common_expressions setting, reduces the number of hash tables and improves predicate pushdown.

  • You can now clone a table using the CLONE AS clause. This operation uses no additional storage space, and modifications to the clone and the original are independent.

  • Refreshable materialized views now support an APPEND mode, which appends new rows to the end of the table instead of replacing the view.

• Performance improvements

  Improved performance by approximately 11% compared to version 23.8.

• For more details, see 2025 Changelog.

• Official clickbench version comparison test

Version number

Description

Documentation

None

ApsaraDB for ClickHouse Community-compatible Edition clusters support ESSD PL0 cloud disks.

Community-compatible Edition storage pricing

Version

Description

References

23.8

New features

You can now use the console to migrate data from a self-managed ClickHouse cluster to an ApsaraDB for ClickHouse community-compatible edition cluster.

Migrate from a self-managed ClickHouse cluster to ApsaraDB for ClickHouse community-compatible edition

Version number

Description

References

None

ApsaraDB for ClickHouse is now available in the Saudi Arabia (Riyadh) region.

None

Version number

Description

Related documentation

22.8-1.19.0

• The Kafka table engine now supports the kafka_auto_offset_reset parameter. You can set this parameter to 'earliest' or 'latest' when creating a table to specify the starting offset for data synchronization.

• The MergeTree table engine now supports delaying mutations or throwing an exception for excessive mutations. The usage is the same as in version 23.8.

• The sort key for the 'text_log' system table is now event_time_microseconds.

• Synchronize data from Kafka

• Delay mutation

23.8-1.4.1

• The Kafka table engine now supports the kafka_auto_offset_reset parameter. You can set this parameter to 'earliest' or 'latest' when creating a table to specify the starting offset for data synchronization.

• The sort key for the 'text_log' system table is now event_time_microseconds.

Synchronize data from Kafka

Version number

Description

References

23.8-1.3.2

Fixed an issue where a ReplicatedMergeTree table became read-only after an abnormal restart.

None

23.8-1.3.1

• Updated to the official community version v23.8.16.40.

• Enabled text_log by default to record Warning, Error, or Fatal logs. These logs can be queried from system.text_log.

• Disabled query_thread_log by default due to excessive disk space consumption.

• Fixed an issue where an unexpected shutdown blocked data distribution for a distributed table.

Comparing changes

Version number

Description

References

22.8-1.18.0

• Fixed a crash in the Kafka engine.

• Fixed an issue where an unexpected shutdown could block data distribution for distributed tables.

None

Version

Description

Related documentation

23.8

• New features

  • You can now stream data from Amazon S3 by using the S3Queue table engine.

  • You can now directly import compressed files in zip, tar, and 7zip formats.

  • You can now use the TRUNCATE DATABASE statement.

  • You can now directly add and subtract vectors.

  • You can now concatenate tuples.

  • Error messages now include correction suggestions for database and table names.

• Performance optimizations

  Improves query performance for Parquet, ORC, TSV, CSV, and JSON files by 40% on average, with some queries running 4 to 5 times faster.

• ClickHouse 23.8

• S3Queue

• Direct import from ZIP, TAR, and 7zip

• TRUNCATE DATABASE

• Parquet performance optimizations

Version

Description

Related documentation

22.8

• Enhancements

  • Data imports from MaxCompute external tables now support exclusive tunnels and network data compression.

  • The text_log feature is now enabled by default to record Warning, Error, and Fatal logs. You can query them in the system.text_log table.

  • The query_thread_log feature is now disabled by default to prevent excessive disk space usage.

• Bug fixes

  • Fixed issues with data type conversions and value comparisons between the DateTime64 and DateTime/Date data types.

  • Fixed the "Invalid number of rows in Chunk" error.

Import data from MaxCompute

21.8

• New features

  ApsaraDB for ClickHouse now uses a fallback session lifetime mechanism for ZooKeeper connections to better balance the load across ZooKeeper nodes.

• Bug fixes

  Fixed an OOM issue caused by index_granularity=0.

None

Feature

Description

References

New region availability

New feature

ApsaraDB for ClickHouse clusters are now available in the Malaysia (Kuala Lumpur) region.

• Create a cluster

• Community-compatible Edition compute node pricing

• Community-compatible Edition storage pricing

• Community-compatible Edition backup storage pricing

Community-compatible Edition 22.8

Bug fix

Fixed an issue that caused the Date function to return an unexpected query result.

None

Specification changes

The C4 and S4 specifications are discontinued.

None

Feature

Description

Related documentation

Disable data backup

New feature

You can now disable data backup for ApsaraDB for ClickHouse clusters.

data backup

Feature

Description

References

Scheduled instance restart

New feature

Scheduled restarts are now supported for your ApsaraDB for ClickHouse instances.

Restart a Community Edition instance

tag management

New feature

ApsaraDB for ClickHouse clusters support tag management.

Tag management

ZooKeeper configuration

New feature

By default, ApsaraDB for ClickHouse clusters include a 4-core, 8 GB ZooKeeper configuration at no charge.

None

Feature

Description

References

Monitoring and alerting

New feature

View monitoring data in the ApsaraDB for ClickHouse console

Major engine version upgrade

New feature

You can now upgrade the major engine version for ApsaraDB for ClickHouse Community Edition clusters by migrating data between clusters.

Upgrade the major engine version through data migration

Feature

Description

Related documents

Release and mount Classic Load Balancer (CLB) instances

You can now release and mount a Classic Load Balancer (CLB) instance for an ApsaraDB for ClickHouse Community-compatible Edition cluster created after December 1, 2021.

Release and mount a CLB instance

Account management

You can now configure database accounts for Community-compatible Edition clusters by executing SQL statements.

• Manage database accounts of an ApsaraDB for ClickHouse cluster

• CREATE USER

• GRANT

Feature

Description

References

Community-compatible edition 22.8

• New features

  • The storage time range for Date32 and DateTime64 has been extended. The supported range is from 1900-01-01 to 2299-12-31.

  • Supports lightweight delete.

  • Supports SQL user-defined functions and executable user-defined functions.

  • Supports partition-level preprocessing using projections to optimize pre-aggregation.

• Performance optimizations

  • Doubles the performance of INSERT operations.

  • Triples the performance of IN queries on long lists.

• Date32

• DateTime64

• DELETE statement

• SQL user-defined functions

• Executable user-defined functions

• Projections

Feature

Description

References

Parameter configuration

New feature

You can now modify config.xml parameters in XML mode and view the change history for ApsaraDB for ClickHouse clusters created after December 1, 2021.

Configure config.xml parameters

Feature

Description

Related topics

Upgrade the minor engine version

New feature

You can upgrade the minor engine version for clusters purchased after December 1, 2021. Minor engine version upgrades include performance improvements, new features, and bug fixes.

Upgrade the minor engine version

Set a maintenance window

New feature

You can set a maintenance window for one or more ApsaraDB for ClickHouse clusters. The system performs upgrades within the specified maintenance window to ensure cluster stability.

Set a maintenance window

Feature

Description

References

Monitoring and alerting

• New feature

  The following new metrics have been added:

  • Number of Inactive Data Parts

  • Number of TCP connections

  • Number of Init Query runs

  • Number of HTTP connections

  • Number of MaterializeMySQL

  • Number of failed Insert queries

  • Number of Kafka external tables

  • Number of failed Select queries

  • Number of MaterializeMySQL synchronization failures

  • Number of Kafka External Table Consumption Errors

• Enhancements

  This update enhances cluster availability and exception monitoring, improving operational stability.

View monitoring data in the ApsaraDB for ClickHouse console

Feature

Description

References

Data backup and recovery

New feature

ApsaraDB for ClickHouse clusters running versions 20.3, 20.8, and 21.8 now support data backup and data recovery.

• Data backup

• Data recovery

Feature

Description

References

HTTPS

New feature

This release adds support for HTTPS to encrypt data in transit.

• Enable HTTPS

• Connect to ClickHouse over HTTPS

MaterializeMySQL engine upgrade

• New feature

  The MaterializeMySQL engine supports dirty data in ENUM types.

• Optimizations

  • Full data synchronization is now optimized to avoid locking tables, reducing the impact on business operations.

  • DDL synchronization has been optimized. Synchronization errors are now written to the system table.

None

TCP keepalive enabled by default

New feature

TCP keepalive is enabled by default to ensure connection reliability.

None

Feature

Description

Related documents

MaterializeMySQL engine upgrade

The MaterializeMySQL engine now supports the DECIMAL data type.

None

Feature

Description

References

Community-compatible Edition V21.8

• New features

  • Supports more SQL and JSON standards.

  • Adds the MaterializedPostgreSQL table engine and database engine, which enable synchronous replication of databases and tables.

  • Adds the leftPad(), rightPad(), leftPadUTF8(), and rightPadUTF8() functions.

  • Adds the bin and unbin functions.

  • Extends the ADD INDEX command with the FIRST keyword to add an index to the beginning of the index list.

  • Adds support for the Map, UInt128, Int128, UInt256, and Int256 data types in the MapAdd and MapSubTract functions.

  • Adds support for the DISTINCT ON (columns) expression.

• Optimization

  Reduces short query latency when reading multiple columns.

None

Feature

Description

References

binlog reservation feature

The MaterializeMySQL engine supports a binlog reservation feature that is enabled by setting the enable_binlog_reserved parameter. This feature prevents data synchronization failures caused by binlog cleanup, improving the engine's stability.

MaterializeMySQL engine

Feature

Description

References

Cluster restart

ApsaraDB for ClickHouse lets you restart a cluster if it becomes unavailable or needs a restart to fix an issue.

Restart an ApsaraDB for ClickHouse cluster

Monitoring page optimization

The monitoring page has been optimized for a smoother user experience.

None

Support for ApsaraDB RDS for MySQL analytic instance

ApsaraDB for ClickHouse lets you synchronize data from an ApsaraDB RDS for MySQL analytic instance to an ApsaraDB for ClickHouse cluster for centralized business data analysis.

Create an ApsaraDB for ClickHouse cluster

Feature

Description

References

Data migration between ApsaraDB for ClickHouse clusters

Use the data migration feature in the ApsaraDB for ClickHouse console to migrate data between ApsaraDB for ClickHouse clusters that run the same engine version or from an earlier version to a later one.

Migrate data between ClickHouse community-compatible clusters

Feature

Description

References

Multiple scale-out methods

Adds the simple scale-out method. You can now choose between:

• Migration-based scale-out

• Simple scale-out

Scale-out and scale-in

MaterializeMySQL engine upgrade

• Improved support for the JSON, TIME, and YEAR data types.

• Fixed bugs involving the key keyword and incremental table creation.

• Added support for the following parameters:

  • skip_error_count

  • alter include_tables

MaterializeMySQL engine

Horizontal scaling performance optimization

Optimized clickhouse-copier to improve horizontal scaling performance.

Vertical and horizontal scaling for Community-Compatible Edition clusters

Feature

Description

References

Backup and recovery

The backup and recovery feature prevents accidental data loss and improves data security.

Data backup

Feature

Description

References

Tiered storage of hot and cold data

This feature automatically moves data between hot and cold storage tiers to reduce storage costs by over 80% without affecting performance.

Tiered storage of hot and cold data

Support for ESSD PL2 and PL3 cloud disks

Enables storage on ESSD PL2 and PL3 cloud disks, multiplying I/O throughput.

None

Cloud disk encryption

Encrypts the entire data disk using block storage, rendering data unreadable and secure even if a backup is compromised.

Cloud disk encryption

Feature

Description

References

Support for China (Hohhot) and China (Hong Kong) regions

None

None

Log delivery optimization

You can now deliver log data from Log Service to ApsaraDB for ClickHouse for real-time log analysis.

Sync from Log Service

Feature

Description

Related documentation

ApsaraDB for ClickHouse is now available in the China (Zhangjiakou), China (Chengdu), and Japan (Tokyo) regions.

None

None

Account and permission management for databases and data dictionaries

You can now manage database accounts and permissions in the console. This includes creating accounts, changing passwords, and setting permissions on databases and data dictionaries.

Manage database accounts of an ApsaraDB for ClickHouse cluster

Global parameter modification

You can now modify global parameters directly in the ApsaraDB for ClickHouse console. Changes take effect after the cluster is restarted.

Configure config.xml parameters

Feature

Description

Related documentation

Balanced data scale-out

Distributes data evenly when adding nodes to a cluster to prevent data skew.

N/A

Query management

Allows you to identify slow SQL queries and interrupt running queries.

Manage SQL queries

New 4-core, 16 GB specifications

Introduces 4-core, 16 GB specifications to improve single-node processing capability.

Billable items

Data dictionary

You can now configure data dictionaries in the console. For business data containing constants or structured with fact and dimension tables, using a data dictionary instead of a dimension table improves query efficiency through direct data lookups.

Data dictionary

Resource queue

Prevents large queries from consuming excessive resources, which can cause instance failures in open source ClickHouse.

ClickHouse resource queues

Feature

Description

References

Integration with Quick BI

Build BI systems in Quick BI by adding ApsaraDB for ClickHouse as a data source.

Add a ClickHouse data source

Parameter

Description

References

Version 20.3

This release provides engine version 20.3.10.75, which fixes multiple engine bugs and improves stability.

None

Support for data migration and real-time synchronization from MySQL

ApsaraDB for ClickHouse now supports data migration and real-time synchronization from MySQL, enabling real-time, interactive analysis of your operational data.

Import data from MySQL.

Online log delivery and analysis

By creating a delivery task in ApsaraDB for ClickHouse to deliver user behavioral log data from SLS to ClickHouse, you can perform multi-dimensional log data analysis online by using ApsaraDB for ClickHouse.

Sync from Log Service

Feature

Description

References

Integration with Data Management Service (DMS)

ApsaraDB for ClickHouse integrates with Data Management Service (DMS), allowing you to manage databases and tables, run data queries, and orchestrate and schedule SQL tasks.

None

Feature

Description

References

New specifications

Building on the C8 specification, four new specifications are now available: C4, C24, C64, and C104. This update also enables the HTTP port.

Billable items