SUBCLUSTERS
| 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. |
Example
=> \x Expanded display is on. => select * from subclusters; -[ RECORD 1 ]---+--------------------- subcluster_oid | 45035996273704996 subcluster_name | default_subcluster node_oid | 45035996273704978 node_name | v_verticadb_node0001 parent_oid | 45035996273704976 parent_name | verticadb is_default | t is_primary | t -[ RECORD 2 ]---+--------------------- subcluster_oid | 45035996273704996 subcluster_name | default_subcluster node_oid | 45035996273836976 node_name | v_verticadb_node0002 parent_oid | 45035996273704976 parent_name | verticadb is_default | t is_primary | t -[ RECORD 3 ]---+--------------------- subcluster_oid | 45035996273704996 subcluster_name | default_subcluster node_oid | 45035996273836980 node_name | v_verticadb_node0003 parent_oid | 45035996273704976 parent_name | verticadb is_default | t is_primary | t -[ RECORD 4 ]---+--------------------- subcluster_oid | 45035996273841894 subcluster_name | analytics_cluster node_oid | node_name | parent_oid | 45035996273704976 parent_name | verticadb is_default | f is_primary | t
See Also