Skip to main content

HASH32

HASH32(expressionlist)

expressionlistA comma-delimited list of values.
Return:HASH32 returns a single value.

The HASH32 function returns a 32-bit FNV (Fowler/Noll/Vo) hash value derived from all the values in the expressionlist. This uses a hashing algorithm that is faster and less likely than HASH to return the same values from different data. Trailing spaces are trimmed from string (or UNICODE) fields before the value is calculated (casting to DATA prevents this).

Example:

MySet := DISTRIBUTE(Person,HASH32(Person.per_ssn));
    //people with the same SSN go to same Data Refinery node

See Also: DISTRIBUTE, HASH, HASH64, HASHCRC, HASHMD5