HASHBAKAMP Function Syntax | Teradata Vantage - 17.00 - 17.05 - HASHBAKAMP Function Syntax - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-30
dita:mapPath
tpt1555966086716.ditamap
dita:ditavalPath
lze1555437562152.ditaval
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.