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:

• For auto-created projections, identical to ANCHOR_TABLE_NAME .
• For a manually-created projection, the name specified in the CREATE PROJECTION statement.

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:

• CREATE PROJECTION: A custom projection created using CREATE PROJECTION.
• CREATE TABLE: A superprojection that was automatically created when its associated table was created using CREATE TABLE.
• ALTER TABLE: The system automatically created the key projection in response to a non-empty table.
• CREATE TABLE WITH PROJ CLAUSE: A superprojection that was automatically created using CREATE TABLE.
• DELAYED_CREATION: A superprojection that was automatically created when data was loaded for the first time into a new table.
• DESIGNER: A projection created by Database Designer.
• SYSTEM TABLE: A projection that was automatically created for a system table.

Rebalancing does not change the CREATE_TYPE value for a projection.

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.

Specifies whether the projection is segmented.

The segmentation expression used for the projection. In the following example for the clicks_agg projection, the following values:

hash(clicks.user_id, (clicks.click_time)::date)

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 SEGMENT_RANGE value such as the following:

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:

• t: A key constraint projection that validates a key constraint. (Vertica uses the projection to efficiently enforce at least one enabled key constraint.)
• f: Not a projection that validates a key constraint.

Specifies whether this projection has expressions that define the column values. HAS_EXPRESSIONS is always true for live aggregate projections.

Specifies whether this projection is a live aggregate projection.

Specifies the type of live aggregate projection:

• GROUPBY
• TOPK