Aiven for ClickHouse^® upgraded to 24.8

Aiven for ClickHouse® has been upgraded to version 24.8, which contains new features, improvements to existing functionality, and fixes on top of the previous version.

Highlights

• JOIN improvements, including disk spillover for cross joins
• Ability to iterate over archive container files in S3
• Recursive CTEs
• New table engines and related functions:
  • loop allows to return query results in an infinite loop.
  • fuzzQuery allows to randomly mutate query strings.
• New functions such as generateUUIDv7, generateSnowflakeID (along with conversion functions for date times such as snowflakeIDToDateTime), and base64 functions base64URLEncode & base64URLDecode
• New numpy array output format NPy
• New system tables:
  • detached_tables to keep track of currently detached tables
  • error_log to persist error history
  • text_log for logging entries
• More information added to the existing query_log and part_log system tables
• Lightweight deletes improvements, along with a new lightweight_deletes_sync setting to control their behavior
• Filesystem cache improvements through contention minimization and usage optimization
• Performance improvements

Data types

• JSON, Dynamic, Variant are now supported as experimental column data types and will be made widely available during the next version upgrade.
• The Object('json') data type and its JSON alias
  • After the upgrade, Object('json') and JSON are two different data types. Start using Object('json') now.
  • Migration from the Object('json') type to the JSON type will be needed, and Aiven will provide guidance to support you through the process.

Query analyzer

The new query analyzer has graduated from experimental to beta. It will be enabled for all services during the next version release. We’d love to already hear and consider your feedback on using it. To try out the new query analyzer, use the following setting:

SELECT *

FROM table

SETTINGS enable_analyzer=1;

Table engines

• Experimental TimeSeries table engine has been added, allowing to store metrics using the Prometheus protocol. The engine is not production-ready and hasn’t been enabled yet.
• S3Queue storage engine is undergoing testing and stabilization. The engine is not production-ready and hasn’t been enabled yet.