v.25.3New Feature

Add keccak256 hash

Official CH changelog text
Added the keccak256 hash function, commonly used in blockchain implementations, especially in EVM-based systems. #76669 (Arnaud Briche).
Added the keccak256 hash function, widely used in blockchain applications, particularly in Ethereum Virtual Machine (EVM)-based systems.

Why it matters

The addition of the keccak256 function addresses the need for a native hash function compatible with blockchain technologies, enabling users to compute cryptographic hashes in ClickHouse that align with industry standards used in smart contracts and blockchain verification.

How to use it

Users can invoke the keccak256 function in their SQL queries to compute the hash of input data. For example:

SELECT keccak256('data_to_hash')

This returns the 256-bit Keccak hash of the input string.

Related resources

PreviousNext