v.22.12New Feature

New xxh3 Hash Function Added and Performance Improvements for xxHash32 and xxHash64 on ARM

Official CH changelog text
New hash function xxh3 added. Also, the performance of xxHash32 and xxHash64 are improved on ARM thanks to a library update. #43411 (Nikita Taranov).
Introduces a new hash function xxh3 to ClickHouse and improves the performance of existing xxHash32 and xxHash64 functions on ARM architectures through an updated library.

Why it matters

The addition of xxh3 provides users with a faster and more efficient hash function option, enhancing overall query performance and collision resistance. The performance improvements to xxHash32 and xxHash64 on ARM platforms optimize processing speed and resource utilization for such architectures.

How to use it

Users can start using the new hash function in their queries by calling xxh3 just like other hash functions, for example:

SELECT xxh3(column) FROM table;

The improved xxHash32 and xxHash64 functions require no additional configuration and benefit ARM users automatically after upgrading to this ClickHouse version.

Related resources

PreviousNext