HASHBUCKET Function Syntax | Teradata Vantage - 17.10 - HASHBUCKET Function Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1145-171K
Language
English (United States)
HASHBUCKET ( expression )

Syntax Elements

expression
An optional expression that evaluates to a valid BYTE(4) row hash value.
If expression results in a UDT, Vantage performs implicit type conversion on the UDT, provided that the UDT has an implicit cast to a predefined byte type.
To define an implicit cast for a UDT, use the CREATE CAST statement and specify the AS ASSIGNMENT clause. For more information on CREATE CAST, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.
Implicit type conversion of UDTs for system operators and functions, including HASHBUCKET, is a Teradata extension to the ANSI SQL standard. To disable this extension, set the DisableUDTImplCastForSysFuncOp field of the DBS Control Record to TRUE.
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.