v.21.11New Features

Added MD4 and SHA384 Functions

Official CH changelog text
Added MD4 and SHA384 functions. MD4 is an obsolete and insecure hash function, it can be used only in rare cases when MD4 is already being used in some legacy system and you need to get exactly the same result. #29602 (Nikita Tikhomirov).
Added new hash functions MD4 and SHA384 to ClickHouse.

Why it matters

The MD4 hash function is provided mainly for compatibility with legacy systems that require the exact same hashing result, despite it being obsolete and insecure. The addition of SHA384 offers a more secure hashing option for users needing stronger cryptographic functions.

How to use it

Users can call the new functions directly in their SQL queries, for example: SELECT MD4('input_string') or SELECT SHA384('input_string').

Related resources

PreviousNext