v.23.12New Feature

Add SHA512_256 Function

Add SHA512_256 function. #57645 (Bharat Nallan).
Added the SHA512_256 function to ClickHouse.

Why it matters

This function provides users with the ability to compute the SHA-512/256 hash digest, which is a truncated variant of the SHA-512 algorithm producing a 256-bit hash. It enhances ClickHouse's cryptographic hashing capabilities for scenarios requiring strong but shorter hash outputs.

How to use it

Use the SHA512_256 function in your SQL queries to generate SHA-512/256 hashes from input strings or binary data. For example:

SELECT SHA512_256('your_input_string');