Skip to main content

HASH64

HASH64(expressionlist)

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

The HASH64 function returns a 64-bit FNV (Fowler/Noll/Vo) 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:

OUTPUT(Person,{per_ssn,HASH64(per_ssn)});
    //output SSN and its 64-bit hash value

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