CREATE PROJECTION public.test_super /*+basename(test),createtype(L)*/
(
c1
)
AS
SELECT test.c1
FROM public.test
ORDER BY test.c1
SEGMENTED BY hash(test.c1) ALL NODES OFFSET 0;
In the above example the create type is L for “Lazy”, meaning that I inserted data into the table when no projections existed yet.
Here is a list of the projection create types you’ll encounter along with the Vertica method used to create them:
U - CREATE PROJECTION
A - CREATE TABLE
L - DELAYED CREATION
T - IMPLEMENT_TEMP_DESIGN
C - DESIGNER CANDIDATE
D - DESIGNER
S - SYSTEM TABLE
P - CREATE TABLE WITH PROJ CLAUSE
N - ALTER TABLE
Have Fun!
About the Author
Soniya Shah
Information Developer
Currently, a first year law student with a background in science and technology. Experienced technical writer, with specializations in software documentation, big data, blog development, and website development. I build user-centered content to communicate complex and technical information more easily.
I used to work for Vertica full time for about 3 years. I still work at Vertica part time while going to law school.
Update: Soniya is now doing her law internship, and no longer working at Vertica. Good luck, Soniya!
