Vertica Analytics Platform Version 10.0.x Documentation

SUBCLUSTERS

This table lists all of the subclusters defined in the database. It contains an entry for each node in the database listing which subcluster it belongs to. Any subcluster that does not contain a node has a single entry in this table with empty NODE_NAME and NODE_OID columns. This table is only populated if the database is running in Eon Mode.

Column Name Data Type Description
SUBCLUSTER_OID

INTEGER

Unique identifier for the subcluster.
SUBCLUSTER_NAME VARCHAR The name of the subcluster.
NODE_OID INTEGER The catalog-assigned ID of the node.
NODE_NAME VARCHAR The name of the node.
PARENT_OID INTEGER The unique ID of the parent of the node (the database).
PARENT_NAME VARCHAR The name of the parent of the node (the database name).
IS_DEFAULT BOOLEAN Whether the subcluster is the default cluster.
IS_PRIMARY BOOLEAN Whether the subcluster is a primary subcluster.
CONTROL_SET_SIZE INTEGER The number of control nodes defined for this subcluster. This value is -1 when the large cluster feature is not enabled, or when every node in the subcluster must be a control node. See Large Cluster for more information.

Example

=> \x
Expanded display is on.
dbadmin=> SELECT * FROM SUBCLUSTERS;
-[ RECORD 1 ]----+---------------------
subcluster_oid   | 45035996273704978
subcluster_name  | default_subcluster
node_oid         | 45035996273704982
node_name        | v_verticadb_node0001
parent_oid       | 45035996273704976
parent_name      | verticadb
is_default       | t
is_primary       | t
control_set_size | -1
-[ RECORD 2 ]----+---------------------
subcluster_oid   | 45035996273704978
subcluster_name  | default_subcluster
node_oid         | 45035996273840970
node_name        | v_verticadb_node0002
parent_oid       | 45035996273704976
parent_name      | verticadb
is_default       | t
is_primary       | t
control_set_size | -1
-[ RECORD 3 ]----+---------------------
subcluster_oid   | 45035996273704978
subcluster_name  | default_subcluster
node_oid         | 45035996273840974
node_name        | v_verticadb_node0003
parent_oid       | 45035996273704976
parent_name      | verticadb
is_default       | t
is_primary       | t
control_set_size | -1

See Also