Hi Team,
We have a 3 node cluster and recently upgraded to 7.2.1 version. We have created a table and manually created 2 projections but we see that 3 projections are specified.
Assume I have created table 'xxx' having around 500M load data and I can see list of projections as below,
xxx_prj, xxx_prj_b0, xxx_prj_b1.
Why 3 projections are created? and How can we remove one of the projection?
Please help on this.
Regards,
Yeswanth
+1HI,
Vertica automatically creates a default projection for each table created through the CREATE TABLE and CREATE TEMPORARY TABLE statements, to get your database up and running quickly,. Each projection created automatically (or manually) includes a base projection name prefix. For more details, please visit the below URL
You can remove a projection by issuing DROP PROJECTION <projection-name>
Please vist the below URL for more information
Sruthi
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
