Vertica 9.3 Supports UPDATE and DELETE Operations on Tables Having Live Aggregate Projections!
James Knicely, Vertica Field Chief Technologist
October 17, 2019
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 INSERT or COPY) Vertica recalculates aggregations with the new data and updates the...