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

> SELECT xxhash64('Spark', array(123), 2);
 5602566077635097486

Related functions

• hash function
• crc32 function