v.24.10New Feature

Added RIPEMD160 Function for Cryptographic Hashing in ClickHouse

Added RIPEMD160 function, which computes the RIPEMD-160 cryptographic hash of a string. Example: SELECT HEX(RIPEMD160('The quick brown fox jumps over the lazy dog')) returns 37F332F68DB77BD9D7EDD4969571AD671CF9DD3B. #70087 (Dergousov Maxim).
Added the RIPEMD160 function to compute the RIPEMD-160 cryptographic hash of a given string.

Why it matters

This feature enables users to generate a RIPEMD-160 hash, a widely used cryptographic hash function, directly in ClickHouse. It provides a reliable and efficient way to produce fixed-length hash values useful for data integrity verification, fingerprinting, and security-related operations within queries.

How to use it

Use the RIPEMD160 function in SQL statements by passing the input string as an argument. For example:

SELECT HEX(RIPEMD160('The quick brown fox jumps over the lazy dog'))

This returns the RIPEMD-160 hash encoded in hexadecimal format.