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
- [Required with sparse map, disallowed with contiguous map.] A clause that forces tables that use the same sparse map to be stored on the same subset of AMPs.
- colocation_name
- The colocation name, typically databasename_tablename.
- contiguousmap_name
- The name of the contiguous map, the map that includes all AMPs within a specified range.