Vertica 7.2 SP3 Released


A new service pack, SP3, is now available for Vertica 7.2.

Below is a summary of the new features and changes in 7.2 SP3:

  • New Data Source Name (DSN) parameter for NOT NULL constraints in SAP Data Services
  • Live Aggregate Projections now support queries for DISTINCT qualified aggregate functions
  • Sequence caching has improved by requesting cache refills for all other nodes by the initiator node in the planning phase of query execution
  • Data load from Amazon S3 in Management Console is now supported
  • A full backup restore to an alternate cluster is now supported
  • Vertica now supports direct integration with Parquet files for creating external tables, loading data using the COPY statement, and using the HCatalog connector

Full the complete new features and changes, see the documentation.

For issues fixed in this service pack, see the release notes.

About the author / 

Norbert Krupa

Norbert is the founder of and a Solutions Engineer at Talend. He is an HP Accredited Solutions Expert for Vertica Big Data Solutions. He has written the Vertica Diagnostic Queries which aim to cover monitoring, diagnostics and performance tuning. The views, opinions, and thoughts expressed here do not represent those of the user's employer.


  1. Bryan Conlon May 24, 2016 at 11:05 AM -  Reply

    You no longer have to drop all Live Aggregates on a table to add a column now, right? That is the way I took this:


    DDL – Projection

    Previously, Vertica rolled back an ALTER TABLE … ADD COLUMN statement if you attempted to add a column to a table that included a live aggregate projection. This issue has been resolved.

    • Norbert Krupa May 24, 2016 at 12:37 PM -  Reply

      I’m not entirely sure without testing it. This may have just been a bug fix.

      You may need to re-create the LAP if columns are added.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Upcoming Events

  • No upcoming events
AEC v1.0.4

Subscribe to Blog via Email

Enter your email address to subscribe and receive notifications of new posts by email.

Read more use cases here.


This site is not affiliated, endorsed or associated with HPE Vertica. This site makes no claims on ownership of trademark rights. The author contributions on this site are licensed under CC BY-SA 3.0 with attribution required.
%d bloggers like this: