PROJECTION_CHECKPOINT_EPOCHS
Records when each projection checkpoint epoch changes.
Column Name | Data Type | Description |
---|---|---|
NODE_ID |
INTEGER |
Unique numeric ID assigned by the Vertica catalog, which identifies the node for which information is listed |
NODE_NAME |
VARCHAR |
Node name for which information is listed. |
PROJECTION_SCHEMA_ID |
INTEGER |
Unique numeric ID assigned by the Vertica catalog, which identifies the specific schema that contains the projection. |
PROJECTION_SCHEMA |
VARCHAR |
Schema containing the projection. |
PROJECTION_ID |
INTEGER |
Unique numeric ID assigned by the Vertica catalog, which identifies the projection. |
PROJECTION_NAME |
VARCHAR |
Projection name for which information is listed. |
IS_UP_TO_DATE |
BOOLEAN |
Indicates whether the projection is up to date, where t is true and f is false. Projections must be up to date for queries to use them. |
CHECKPOINT_EPOCH |
INTEGER |
Checkpoint epoch of the projection on the corresponding node. Data up to and including this epoch is in persistent storage. If the node were to fail, without moving more data out of the WOS, data after this epoch would need to be recovered. |
Privileges
No explicit privileges are required. You only see the records for tables that you have privileges to view.
Examples
=> SELECT epoch FROM t; epoch ------- 52 52 53 (3 rows) => SELECT node_name, projection_schema, projection_name, is_up_to_date, checkpoint_epoch FROM projection_checkpoint_epochs; node_name | projection_schema | projection_name | is_up_to_date | checkpoint_epoch --------------------+-------------------+------------------+---------------+------------------ v_vmart_node0001 | public | t_super | t | 51 v_vmart_node0001 | public | p_super | t | 51 (2 rows)
=> SELECT DO_TM_TASK('moveout',''); do_tm_task -------------------------------------------------------------------------- Task: moveout (Table: public.t) (Projection: public.t_super) (Table: public.p) (Projection: public.p_super) (1 row)
=> SELECT node_name, projection_schema, projection_name, is_up_to_date, checkpoint_epoch FROM projection_checkpoint_epochs; node_name | projection_schema | projection_name | is_up_to_date | checkpoint_epoch --------------------+-------------------+-----------------+---------------+------------------ v_vmart_node0001 | public | t_super | t | 53 v_vmart_node0001 | public | p_super | t | 53 (2 rows)