HASHBAKAMP Function Syntax | Teradata Vantage - 17.10 - HASHBAKAMP 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)
HASHBAKAMP ( [ hash_bucket_number_expr ] )

Syntax Elements

hash_bucket_number_expr
{ expression [ MAP = sparsemap_name COALESCE USING = colocation_name ] |
  [ expression ] MAP = contiguousmap_name
}
expression
An expression that evaluates to a valid hash bucket number.
MAP
An object that specifies which AMPs store the rows of a table.
sparsemap_name
The name of the sparse map, the map that includes a subset of AMPs from a contiguous map.
COLOCATE USING
A clause that forces tables that use the same sparse map to be stored on the same subset of AMPs.
COLOCATE USING is required with a sparse map. It cannot be used with a contiguous map.
colocation_name
The colocation name, usually databasename_tablename.
contiguousmap_name
The name of the contiguous map, the map that includes all AMPs within a specified range.