Skip to main content

xxhash64 function

Applies to: check marked yes Databricks SQL check marked yes 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