Hashrow in Teradata

HASHROW function in teradata identifies hash value of the input data. Hashrow function generates the same hash if the input value is same, hash value helps in distributing the data over buckets and amps.

HASHROW ('Teradata')   AS "Hash Value"

Hashrow function is applied on the primary key /index column and the bucket and amp is decided based on HASHBUCKET and HASHAMP functions respectively. To uniformly distribute the data across amp's ensure data evaluated in primary index is unique.

SELECT HASHROW(product_name || country) AS "HASH VALUE" FROM SALES