hash function

Applies to: Databricks SQL Databricks Runtime

Returns a hash value of the arguments.

Syntax

hash(expr1, ...)

Arguments

• exprN: An expression of any type.

Returns

An INTEGER.

Note

The hash value depends on the input data type. For example, hash(1::INT) produces a different result than hash(1::BIGINT). If your use case requires stable hash values across different data types, consider explicitly casting values to the desired type.

Examples

> SELECT hash('Spark', array(123), 2);
 -1321691492

Related functions

• crc32 function
• md5 function
• sha function
• sha1 function
• sha2 function
• xxhash64 function