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.