xxhash64 function
Applies to: Databricks SQL
Databricks Runtime
Returns a 64-bit hash value of the arguments.
Syntax
xxhash64(expr1 [, ...] )
Arguments
exprN: An expression of any type.
Returns
A BIGINT.
note
The hash value depends on the input data type. For example, xxhash64(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
SQL
> SELECT xxhash64('Spark', array(123), 2);
5602566077635097486