I am very new the vertica . Can somebody tell me, how to use projection ? Also at what time we shoul


  • Prasanta_PalPrasanta_Pal Employee, Registered User, VerticaExpert
    Please follow the link what Amelia sent you to know in detail, in a nutshell -

    Projections are the storage of data of tables for each table, there should be at least one projection (called super projection) for each table you create and may have also other projections based on the requirements but those are duplication of full/part data for some purpose.

    These are created automatically when you load the data in the table ( by insert/COPY) although before loading you can create them manually using certain syntax. Also they are created if you use DBD in admintools.

  • Soumya_BeheraSoumya_Behera Registered User
    Thanks for sharing the link.. It has more details in it. For any clarification i will revert back to you.
  • Soumya_BeheraSoumya_Behera Registered User
    Thank you Prasanta for answering.
    That means in normal other SQL table all the data will store in Table level , but in vertica it stores in Projects level( this is the major difference).
    So one clarification i need , that means it will not create projection when we will just create table ??
  • Navin_CNavin_C Registered User

    A single projection is automatically created when the first row of a table is inserted. This projection is called super projection
    So lets say you create table A, at this point there is no projection for Table A.
    When you insert your first record into Table A, at this point of time a Super projection will be created for table A automatically.

    This was about Super projections.
    You can also design and create projection manually with a simple SQL CREATE PROJECTION statement.

    For more info on Projections in Vertica, you can refer this link


    Hope this helps.
  • Soumya_BeheraSoumya_Behera Registered User
    Thanks Navin. I am clear now.

Leave a Comment

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