Skip to main content

Hash Functions

XxHash128 Guid String​

This function has no substrait equivalent

Computes a XxHash128 for one or multiple values and returns it as a guid in string representation. This function can be useful to create partition keys for instance.

SQL Usage​

SELECT xxhash128_guid_string(val) FROM ...
SELECT xxhash128_guid_string(val1, val2) FROM ...
SELECT xxhash128_guid_string(val1, val2, ...) FROM ...

XxHash64​

This function has no substrait equivalent

Computes a XxHash64 for one or multiple values and returns it as an Int64.

SQL Usage​

SELECT xxhash64(val) FROM ...
SELECT xxhash64(val1, val2) FROM ...
SELECT xxhash64(val1, val2, ...) FROM ...