ALTER SUBCLUSTER
Syntax
ALTER SUBCLUSTER subcluster‑name { RENAME TO new-name | SET DEFAULT }
Parameters
| subcluster‑name | The name of the subcluster to alter. |
| RENAME TO new‑name | Changes the name of the subcluster to new-name. |
SET DEFAULT
|
Makes the subcluster the default subcluster. When you add new nodes to the database and do not specify a subcluster to contain them, Vertica adds them to the default subcluster. There can be only one default subcluster at a time. The subcluster that was previously the default subcluster becomes a non-default subcluster. |
Privileges
Examples
This example makes the analytics_cluster the default subcluster:
=> SELECT DISTINCT subcluster_name FROM SUBCLUSTERS WHERE is_default = true; subcluster_name -------------------- default_subcluster (1 row) => ALTER SUBCLUSTER analytics_cluster SET DEFAULT; ALTER SUBCLUSTER => SELECT DISTINCT subcluster_name FROM SUBCLUSTERS WHERE is_default = true; subcluster_name ------------------- analytics_cluster (1 row)
This example renames default_subcluster to load_subcluster:
=> ALTER SUBCLUSTER default_subcluster RENAME TO load_subcluster; ALTER SUBCLUSTER => SELECT DISTINCT subcluster_name FROM subclusters; subcluster_name ------------------- load_subcluster analytics_cluster (2 rows)
See Also