Before You Upgrade to Vertica 9.1 or 9.2
Before You Upgrade to Vertica 9.1 or 9.2
With releases 9.1 and 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 9.1 or higher, you are strongly urged to check your database for unsupported projections. If the upgrade encounters these projections, it is liable to fail. You must then revert to your previous installation.
Solution: Run the pre-upgrade script
Vertica has provided a pre-upgrade script that examines your current database and sends to standard output its analysis and recommendations. If it identifies unsupported projections, it lists them. If the script finds projection buddies with different SELECT and ORDER BY clauses, it also generates a deploy script. This script remedies projections so they comply with system K-safety.
The pre-upgrade script and details on usage are available for download here.
Comments
9.2 is out?
Soon, I think.
9.2 is out!
https://www.vertica.com/docs/9.2.x/HTML/Content/Home.htm
Is 9.3 stable to upgrade? Or shall I wait for some more time
@hdk0310 - Vertica 9.3 isn't out and probably never will be The next major release will be Vertica 10!
Note that Vertica 9.2 is at Version 9.2.0-1 (First hot fix):
See:
https://www.vertica.com/docs/ReleaseNotes/9.2.x/Vertica_9.2.x_Release_Notes.htm#9.2.0-1
Thanks Jim
Is 9.2 stable already? Or should we upgrade to 9.1 instead?
@jennie - Vertica 9.2 is very stable! In fact Vertica 9.2.1 (Service Pack 1) was just released
Fyi ... Vertica 9.2 significantly reduces how much memory the database catalog consumes. It does this by consolidating the amount of metadata it maintains to track ROS storage containers.
Check the following link to view all of the new features/resolved issues in Vertica 9.2.x:
https://www.vertica.com/docs/ReleaseNotes/9.2.x/Vertica_9.2.x_Release_Notes.htm
Thanks Jim! So I guess the next logical question is, is it okay to upgrade to 9.2.0 first rather than go directly to 9.2.1 given that the latter has just been release a couple of weeks ago? Or are there significant benefits to go directly to the latest? We're just a bit hesitant to be one of the early adopters, and have issues later on.