v.18.10New Feature

Added new MurmurHash functions to ClickHouse

Official CH changelog text
Added the functions murmurHash2_64, murmurHash3_32, murmurHash3_64, and murmurHash3_128 in addition to the existing murmurHash2_32. #2791
Introduced new hashing functions murmurHash2_64, murmurHash3_32, murmurHash3_64, and murmurHash3_128 to extend the existing murmurHash2_32 functionality in ClickHouse.

Why it matters

These new hashing functions provide users with more options for generating hash values of different sizes and versions, improving flexibility and compatibility with various hashing requirements. This helps in better distribution of data, more efficient indexing, and improved performance in hashing-related operations.

How to use it

Users can apply these new functions directly in their SQL queries similarly to existing hash functions, for example: SELECT murmurHash3_128(column_name) FROM table_name;. No additional configuration is required beyond using the new function names in SQL statements.

Related resources

PreviousNext