3 Projections created in 7.2.1

Yeswanth

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

 

 

 

SruthiA

HI,

 

      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

 

https://my.vertica.com/docs/7.2.x/HTML/Content/Authoring/AdministratorsGuide/Tables/CreatingBaseTables.htm

 

 

You can remove a projection by issuing DROP PROJECTION <projection-name>

 

Please vist the below URL for more information

 

https://my.vertica.com/docs/7.2.x/HTML/Content/Authoring/SQLReferenceManual/Statements/DROPPROJECTION.htm

 

 

Sruthi