PROJECTIONS
Provides information about projections.
Column Name | Data Type | Description |
---|---|---|
PROJECTION_SCHEMA_ID
|
INTEGER
|
A unique numeric ID that identifies the specific schema that contains the projection and is assigned by the Vertica catalog. |
PROJECTION_SCHEMA
|
VARCHAR
|
The name of the schema that contains the projection. |
PROJECTION_ID
|
INTEGER
|
A unique numeric ID that identifies the projection and is assigned by the Vertica catalog. |
PROJECTION_NAME
|
VARCHAR
|
The projection name for which information is listed. |
PROJECTION_BASENAME
|
VARCHAR
|
The base name used for other projections. For auto-created projections, |
OWNER_ID
|
INTEGER
|
A unique numeric ID that identifies the projection owner and is assigned by the Vertica catalog. |
OWNER_NAME
|
VARCHAR
|
The name of the projection's owner. |
ANCHOR_TABLE_ID
|
INTEGER
|
The unique numeric identification (OID) of the projection's anchor table. |
ANCHOR_TABLE_NAME
|
VARCHAR
|
The name of the projection's anchor table. |
NODE_ID
|
INTEGER
|
A unique numeric ID (OID) for any nodes that contain any unsegmented projections. |
NODE_NAME
|
VARCHAR
|
The names of any nodes that contain the projection. This column returns information for unsegmented projections only. |
IS_PREJOIN
|
BOOLEAN
|
Deprecated, always set to f (false). |
CREATED_EPOCH
|
INTEGER
|
The epoch in which the projection was created. |
CREATE_TYPE
|
VARCHAR
|
The method in which the projection was created:
Rebalancing does not change the |
VERIFIED_FAULT_TOLERANCE
|
INTEGER
|
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. |
IS_UP_TO_DATE
|
BOOLEAN
|
Specifies whether projection data is up to date. Only up-to-date projections are available to participate in query execution. |
HAS_STATISTICS
|
BOOLEAN
|
Specifies whether there are statistics for any column in the projection:
|
IS_SEGMENTED
|
BOOLEAN
|
Specifies whether the projection is segmented. |
SEGMENT_EXRESSION
|
VARCHAR
|
The segmentation expression used for the projection. In the following example for the hash(clicks.user_id, (clicks.click_time)::date) indicate that the projection was created with the following expression:
|
SEGMENT_RANGE
|
VARCHAR
|
The percentage of projection data stored on each node, according to the segmentation expression. For example, segmenting a projection by the implicit range: v_testcr_node0005[33.3%] v_testcr_node0006[33.3%] v_testcr_node0004[33.3%] |
IS_SUPER_PROJECTION
|
BOOLEAN
|
Specifies whether a projection is a superprojection. |
IS_KEY_CONSTRAINT_PROJECTION
|
|
Indicates whether a projection is a key constraint projection:
|
HAS_EXPRESSIONS
|
BOOLEAN
|
Specifies whether this projection has expressions that define the column values. |
IS_AGGREGATE_PROJECTION
|
BOOLEAN
|
Specifies whether this projection is a live aggregate projection. |
AGGREGATE_TYPE
|
VARCHAR
|
Specifies the type of live aggregate projection:
|
IS_SHARED
|
BOOLEAN
|
Indicates whether the projection is located on shared storage. |