Administration

Projection Create Types

1

This post outlines the different type of create types available for projections.

Looking at projection definitions, there’s typically a createtype that is associated with the projection. For example:

Here is what those letters mean:

Create TypeDefinition
UCREATE PROJECTION
ACREATE TABLE
LDelayed Creation
TIMPLEMENT_TEMP_DESIGN
CDesigner Candidate
DDesigner
SSystem Table
PCREATE TABLE with Projection Clause

About the author / 

Norbert Krupa

Norbert is the founder of vertica.tips and a Solutions Engineer at Talend. He is an HP Accredited Solutions Expert for Vertica Big Data Solutions. He has written the Vertica Diagnostic Queries which aim to cover monitoring, diagnostics and performance tuning. The views, opinions, and thoughts expressed here do not represent those of the user’s employer.

1 Comment

  1. Daniel September 1, 2014 at 9:57 AM -  Reply

    Delayed Creation – created during LOAD (COPY/INSERT) , so letter “L”.

Leave a Reply

Upcoming Events

  • No upcoming events
AEC v1.0.4

Subscribe to Blog via Email

Enter your email address to subscribe and receive notifications of new posts by email.

Read more use cases here.

Notice

This site is not affiliated, endorsed or associated with HPE Vertica. This site makes no claims on ownership of trademark rights. The author contributions on this site are licensed under CC BY-SA 3.0 with attribution required.
%d bloggers like this: