Vertica Analytics Platform Version 9.2.x Documentation
Live Aggregate Projections
A live aggregate projection contains columns with values that are aggregated from columns in its anchor table. When you load data into the table, Vertica aggregates the data before loading it into the live aggregate projection. On subsequent loads—for example, through INSERTor COPY—Vertica recalculates aggregations with the new data and updates the projection.
In This Section
Was this topic helpful?