Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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.








Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
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.