16.20 - Result - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Functions, Expressions, and Predicates

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1145-162K

HASHBUCKET returns an INTEGER data type.

IF expression THEN …
does not appear in the argument list HASHBUCKET returns an INTEGER value that is the highest hash bucket number.
evaluates to NULL HASHBUCKET returns NULL.
evaluates to a valid BYTE(4) row hash value HASHBUCKET returns the hash bucket number corresponding to the row hash value.
The range of values for hash bucket numbers depends on the system setting of the hash bucket size.
  • If the hash bucket size is 16 bits, the hash bucket numbers can have a value from 0 to 65535.
  • If the hash bucket size is 20 bits, the hash bucket numbers can have a value from 0 to 1048575.