Introduction
Every new release includes new features, enhancements, and numerous bug fixes, and the ChistaDATA team always stays on top of the latest releases. On July, 2024, ClickHouse version 24.6 was released, and this version contains the following;
- 23 new features,
- 24 performance optimizations,
- 59 bug fixes.
For further details, please see the official ClickHouse docs here.
- v24.6 Source Code : GitHub Link
- v24.6 Release Webinar : Slides
- Installation: ClickHouse Docs
This article will look at the critical features of the ClickHouse 24.6 release.
Comparison of IPv4 and IPv6
Add support for comparing IPv4 and IPv6 types using the = operator.
:) SELECT toIPv4('127.0.0.1') == toIPv6('::ffff:127.0.0.1')
1
:) SELECT toIPv4('127.0.0.1') == toIPv6('::1')
0
:) SELECT toIPv4('127.0.0.1') == toIPv6('::127.0.0.1')
0
Hilbert Curves
Added Hilbert Curve encode and decode functions.
CREATE TABLE t (x UInt32, y UInt32, ...) ORDER BY hilbertEncode(x, y);
Inline Documentation For System Tables
Now you can read description of system parameters of ClickHouse.
:) SELECT table, comment FROM system.tables WHERE database = 'system' Row 1: ────── table: aggregate_function_combinators comment: Contains a list of all available aggregate function combinators, which could be applied to aggregate functions and change the way they work. Row 2: ────── table: asynchronous_insert_log comment: Contains a history for all asynchronous inserts executed on the current server.
Limits On The Number Of Tables
A new server settings:
- max_database_num_to_warn, max_table_num_to_warn: The user will receive a warning in the client.
- max_database_num_to_throw, max_table_num_to_throw: The user will receive an exception when attempting to create a new database or table beyond the limit.
An Option To Skip Secondary Indices On Insert
Accelerate INSERT operations and defer the computation of secondary indices to background merging processes.
SET materialize_skip_indexes_on_insert = 0; SET materialize_statistics_on_insert = 0;
- Beneficial when dealing with numerous indices.
- Does not notably impact the efficiency of SELECT queries.
Conclusion
In summary, these updates, implemented by the ClickHouse database, represent a substantial stride forward in optimizing performance, scalability, and resource efficiency. By focusing on improving parallelism, cache locality, and reducing memory usage, ClickHouse has demonstrated a commitment to enhancing the user experience and meeting the evolving demands of modern data management. The introduction of new modes for distributed DDL output handling further underscores ClickHouse’s dedication to providing flexibility and control to its users. These updates collectively reinforce ClickHouse’s position as a leading solution for high-performance analytical workloads.
These are the ClickHouse 24.4 features. To find out more details, please visit the official ClickHouse Docs.
