Skip to main content
Question

ranged projections aren't superprojections when adding columns?

  • February 15, 2024
  • 2 replies
  • 6 views
ftobin
Forum|alt.badge.img+1
  • ftobin
  • Participating Frequently

Are ranged projections not counted as superprojections, even if they have all columns?

The definition of a super-projection:

A projection that includes all columns in an anchor table. Vertica uses superprojections to ensure support for all queries and other DML operations.

I have ranged projections which have all columns on a table, but they don't aren't listed as is_super_projection, and that means when I add a column to the table, the column doesn't get added to the ranged projection unless specifically requested.

    2 replies

    mosheg
    Forum|alt.badge.img+2
    • mosheg
    • Participating Frequently
    • February 15, 2024

    Projections that include all columns and rows of the anchor table can be considered superprojections in Vertica.
    Therefore, ranged projections, even if they include all columns, would not be counted as superprojections
    as they do not cover all rows of the table.

    VValdar
    Forum|alt.badge.img+1
    • VValdar
    • Participating Frequently
    • February 15, 2024

    Hi Frank,

    Superprojections means the whole table lies within.
    That's why every table needs at least one superprojection, otherwise you would loose data!

    The definition of superprojection was written before the implementation of ranged projections, so I agree this brings a bit of confusion and should be edited.

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement