Skip to main content

HASH

HASH(expressionlist)

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

The HASH function returns a 32-bit hash value derived from all the values in the expressionlist. Trailing spaces are trimmed from string (or UNICODE) fields before the value is calculated (casting to DATA prevents this).

Example:

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

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