v.21.10New Features

Add SHA512 function

Official CH changelog text
Add function SHA512. #27830 (zhanglistar).
Added a new hash function SHA512 to ClickHouse for generating SHA-512 cryptographic hashes of input data.

Why it matters

This feature addresses the need for stronger cryptographic hashing by providing the SHA-512 algorithm, which produces a 512-bit hash value. It is valuable for security-sensitive applications such as data integrity verification, password hashing, and cryptographic operations within ClickHouse.

How to use it

Use the SHA512 function in your SQL queries to compute the SHA-512 hash of a string or binary data, for example: SELECT SHA512('your_data').

Related resources

PreviousNext