Displaying the Vertica Code Name

Jim_Knicely · April 2019

Every major release of Vertica has a code name.

CODE NAME      VERSION  
-----------    -----------
Grader         9.x 
Frontloader    8.x 
Excavator      7.2.x
Dragline       7.1.x
Crane          7.0.x
Bulldozer      6.1.x
Bunkerhill     6.0.x
Catania        5.1.x/5.0.x

To find out the Vertica code name of your database, you can query the DC_STARTUPS Data Collector table.

Example:

dbadmin=> SELECT version, codename
dbadmin->   FROM dc_startups
dbadmin->  ORDER BY time DESC
dbadmin->  LIMIT 1;
              version               | codename
------------------------------------+----------
Vertica Analytic Database v9.2.1-0 | Grader
(1 row)

Helpful Link:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/Monitoring/Vertica/QueryingDataCollectorTables.htm

Have fun!