The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
How to create super projection with out insert operation when i create table??

How to create super projection with out insert operation when i create table??
0
Answers
I think you mean how to create Auto-Projection without loading the data. You can see the condition for creating it on the following page.
https://www.vertica.com/docs/10.0.x/HTML/Content/Authoring/AdministratorsGuide/Projections/AutoProjections.htm
But, Auto-Projection is not optimized. We recommend the customers to create the optimized super projection. If the projection has all columns of the anchor table, Vertica recognizes it as a super projection as follows.