PARTITION_STATUS

For each projection of each partitioned table, shows the fraction of its data that is actually partitioned according to the current partition expression. When the partitioning of a table is altered, the value in PARTITION_REORGANIZE_PERCENT for each of its projections drops to zero and goes back up to 100 when all the data is repartitioned.

Column Name Data Type Description
PROJECTION_ID

INTEGER

Unique numeric ID assigned by the Vertica catalog, which identifies the projection.

TABLE_SCHEMA

VARCHAR

Name of the schema that contains the partitioned table.

TABLE_NAME

VARCHAR

Table name that is partitioned.

TABLE_ID

INTEGER

Unique numeric ID assigned by the Vertica, which identifies the table.

PROJECTION_SCHEMA

VARCHAR

Schema containing the projection.

PROJECTION_NAME

VARCHAR

Projection name for which information is listed.

PARTITION_REORGANIZE_PERCENT

INTEGER

For each projection, drops to zero and goes back up to 100 when all the data is repartitioned after the partitioning of a table has been altered. Ideally all rows will show 100 (%).

Privileges

No explicit privileges are required. You only see the records for tables that you have privileges to view.