Upgrade and Installation

Identifying and Removing Unsupported Projections

Starting with release 9.1 and continuing with release 9.2, Vertica has removed support for the following projections:

Release 9.1: Projection buddies with different SELECT and ORDER BY clauses. All projection buddies must specify columns in the same order. Projections with non-compliant buddies are regarded by the Vertica database as unsafe.
Release 9.2: Pre-join and range segmentation projections. If a table's only super-projection is one of these projection types, the projection is also regarded as unsafe.

Before upgrading to any Vertica release higher than 9.0.x, you are strongly urged to check that all projection buddies in the current database comply with these new requirements.

Warning: If the upgrade encounters non-compliant projections, it is liable to fail. You must then revert to the previous installation.

Download and run the pre-upgrade script
Vertica provides a pre-upgrade script that analyzes your current database and identifies unsupported projections. You can download this script and obtain detailed information on its usage at this location:

https://vertica.com/pre-upgrade-script/

You can also obtain more information in Installing Vertica: Identifying Unsupported Projections.

AWS Installation Methods

As of release 9.1 you can install Vertica on Amazon Web Services (AWS) using the following products in the AWS Marketplace:

Vertica BYOL, Amazon Linux 2.0
Vertica by the Hour, Amazon Linux 2.0
Vertica BYOL, Red Hat
Vertica by the Hour, Red Hat

Each of these products have three CloudFormation Templatess and one AMI, as follows:

CFTs

Deploy Management Console into new VPC
Deploy Management Console into existing VPC
Management Console with 3 Vertica nodes

AMI

64-bit Amazon Machine Image (AMI)

For more information see Installing Vertica with CloudFormation Templates.