Vertica Analytics Platform Version 10.1.x Documentation
Provides information about projections.
|Column Name||Data Type||Description|
A unique numeric ID that identifies the specific schema that contains the projection and is assigned by the Vertica catalog.
The name of the schema that contains the projection.
A unique numeric ID that identifies the projection and is assigned by the Vertica catalog.
The projection name for which information is listed.
The base name used for other projections:
A unique numeric ID that identifies the projection owner and is assigned by the Vertica catalog.
The name of the projection's owner.
The unique numeric identification (OID) of the projection's anchor table.
The name of the projection's anchor table.
A unique numeric ID (OID) for any nodes that contain any unsegmented projections.
The names of any nodes that contain the projection. This column returns information for unsegmented projections only.
Deprecated, always set to f (false).
The epoch in which the projection was created.
The method in which the projection was created:
Rebalancing does not change the
The projection K-safe value. This value can be greater than the database K-safety value (if more replications of a projection exist than are required to meet the database K-safety). This value cannot be less than the database K-safe setting.
Specifies whether projection data is up to date. Only up-to-date projections are available to participate in query execution.
Specifies whether there are statistics for any column in the projection. HAS_STATISTICS returns true only when all non-epoch columns for a table or table partition have full statistics. For details, see Collecting Table Statistics and Collecting Partition Statistics.
Projections that have no data never have full statistics. Query system table PROJECTION_STORAGE to determine whether your projection contains data.
Specifies whether the projection is segmented.
The segmentation expression used for the projection. In the following example for the
indicate that the projection was created with the following expression:
The percentage of projection data stored on each node, according to the segmentation expression. For example, segmenting a projection by the HASH function on all nodes results in a
implicit range: v_vmart_node0002[33.3%] v_vmart_node0003[33.3%] v_vmart_node0001[33.3%]
Specifies whether a projection is a superprojection.
Indicates whether a projection is a key constraint projection:
Specifies whether this projection has expressions that define the column values.
Specifies whether this projection is a live aggregate projection.
Specifies the type of live aggregate projection:
|IS_SHARED||BOOLEAN||Indicates whether the projection is located on shared storage.|
Was this topic helpful?