Skip to main content

XXHASH_32

Description​

Calculate the 32-bit xxhash value of the input string

-Note: When calculating hash values, it is recommended to use xxhash_32 instead of murmur_hash3_32.

Syntax​

XXHASH_32( <str> [ , <str> ... ] )

Parameters​

parameterdescription
<str>The 32-bit xxhash value to be calculated

Return Value​

Returns the 32-bit xxhash value of the input string.

Examples​

select xxhash_32(NULL), xxhash_32("hello"), xxhash_32("hello", "world");
+-----------------+--------------------+-----------------------------+
| xxhash_32(NULL) | xxhash_32('hello') | xxhash_32('hello', 'world') |
+-----------------+--------------------+-----------------------------+
| NULL | -83855367 | -920844969 |
+-----------------+--------------------+-----------------------------+