v.19.1New Features

Added Hashing Functions Javahash, Hivehash

Added hashing functions javaHash, hiveHash. #3811 (shangshujie365)
Added new hashing functions javaHash and hiveHash to ClickHouse.

Why it matters

These new hashing functions provide compatibility with Java and Apache Hive's hashing algorithms, enabling easier data integration and consistency when working across systems that use these hash formats.

How to use it

Use the new functions javaHash() and hiveHash() in your SELECT queries to compute hash values compatible with Java and Hive respectively, for example:

SELECT javaHash(some_column), hiveHash(some_column) FROM table_name;