16.20 - Result - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1145-162K
Language
English (United States)

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.