REBALANCE_OPERATIONS
Contains information on historic and ongoing rebalance operations.
Column Name | Data Type | Description |
---|---|---|
OBJECT_TYPE |
VARCHAR |
The type of the object being rebalanced. Valid types are:
|
OBJECT_ID |
INT | The ID of the object being rebalanced. |
OBJECT_NAME |
VARCHAR | The name of the object being rebalanced. Objects can be tables, projections, or other Vertica objects. |
PATH_NAME |
VARCHAR | The DFS path for unstructured data being rebalanced. |
TABLE_NAME |
VARCHAR | The name of the table being rebalanced. This value is NULL for DFS files. |
TABLE_SCHEMA |
VARCHAR | The schema of the table being rebalanced. This value is NULL for DFS files. |
TRANSACTION_ID |
INT | The identifier for the transaction within the session. |
STATEMENT_ID |
INT | The unique numeric ID for the currently-running statement. |
NODE_NAME |
VARCHAR | Name of the node that is rebalancing. |
OPERATION_NAME |
VARCHAR |
Identifies the specific rebalance operation being performed, set to one of the following:
|
OPERATION_STATUS |
VARCHAR |
Returns
|
IS_EXECUTING |
BOOLEAN | When TRUE, the operation is currently running. |
REBALANCE_METHOD |
VARCHAR |
The method that Vertica is using to perform the rebalance. Valid methods are:
|
SESSION_ID |
VARCHAR | Identifier for this session. This identifier is unique within the cluster at any point in time but can be reused when the session closes. |
OPERATION_START_TIMESTAMP |
TIMESTAMPZ | The time that the rebalance began. |
OPERATION_END_TIMESTAMP |
TIMESTAMPZ | The time that the rebalance ended. If the rebalance is ongoing, this value is NULL. |
ELASTIC_CLUSTER_VERSION |
INT |
The Elastic Cluster has a version. Each time the cluster topology changes, this version increments. |
IS_LATEST |
BOOLEAN | True if this row pertains to the most recent rebalance activity. |
Privileges
Superuser