Hash Functions in Teradata

hash functions in teradata

There are four hash functions in Teradata.These are pre-defined functions in Teradata.
HASHROW
  1. Returns the hexadecimal row hash value for an expression or sequence of expressions. If no expression is specified, HASHROW returns the maximum hash code value.
  2. HASHBUCKET 
  3. Hashmap defines the correspondance between Hashbucket and AMP. The size of Hashbucket is corresponds to the number of busckets available in the system.
  4. HASHBAKAMP
  5. Returns the identification number of the fallback AMP corresponding to the specified hash bucket. If no hash bucket is specified, HASHBAKAMP returns one less than the maximum number of AMPs in the system.
  6. HASHAMP
  7. Returns the identification number of the primary AMP corresponding to the specified hash bucket number. If no hash bucket number is specified, HASHAMP returns one less than the maximum number of AMPs in the system.
Also read

Comments

Popular posts from this blog

SQL for Quantile Function in Teradata

3 Uses of SAMPLE function in Teradata

All You Need NULL Value Functions