MurmurHash Example 2: 64-Bit Value (Specified) - Teradata Vantage

This example shows how specifying HashBit('64') affects the hash values. As in the 32-bit value example, when the temperature value in the input table is an integer, the hash values are the same for INTEGER and VARCHAR, but different for REAL. When the temperature value in the input table is real, the hash values are the same for REAL and VARCHAR, but different for INTEGER.

Input

• Input table: murmurhash_input, as in MurmurHash Example 1: 32-Bit Hash Value (by Default)

SQL Call

SELECT * FROM MurmurHash (
  ON murmurhash_input
  USING
  InputColumns ('[2:7]')
  HashBit (64) 
  Accumulate ('id')
) AS dt ORDER BY 1;

Output