v.24.10New Feature
Added RIPEMD160 Function for Cryptographic Hashing in ClickHouse
AddedRIPEMD160function, which computes the RIPEMD-160 cryptographic hash of a string. Example:SELECT HEX(RIPEMD160('The quick brown fox jumps over the lazy dog'))returns37F332F68DB77BD9D7EDD4969571AD671CF9DD3B. #70087 (Dergousov Maxim).
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 theRIPEMD160 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.