3 Projections created in 7.2.1

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

 

 

 

Comments

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.