HASHAMP ( [ hash_bucket_number_expr ] )
Syntax Elements
-
hash_bucket_number_expr
-
{ expression [ MAP = sparsemap_name COLOCATE 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.