PROJECTION_CHECKPOINT_EPOCHS
Provides details on checkpoint epochs.
Column Name | Data Type | Description |
---|---|---|
NODE_ID
|
INTEGER
|
Unique numeric identifier of this projection's node. |
NODE_NAME
|
VARCHAR
|
Name of this projection's node. |
PROJECTION_SCHEMA_ID
|
INTEGER
|
Unique numeric identifier of the projection schema. |
PROJECTION_SCHEMA
|
VARCHAR
|
Name of the projection schema. |
PROJECTION_ID
|
INTEGER
|
Unique numeric identifier of this projection. |
PROJECTION_NAME
|
VARCHAR
|
Name of this projection. |
IS_UP_TO_DATE
|
BOOLEAN
|
Specifies whether the projection is up to date and available to participate in query execution. |
CHECKPOINT_EPOCH
|
INTEGER
|
Checkpoint epoch of the projection on the corresponding node. Data up to and including this epoch is in persistent storage, and can be recovered in the event of node failure. |
WOULD_RECOVER
|
BOOLEAN
|
Determines whether data up to and including
See also: |
IS_BEHIND_AHM
|
BOOLEAN
|
Specifies whether See also: |
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)