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.