CODEWITHSUNDEEP
sqlversionvertica
Eakan Gopalakrishnan
Eakan Gopalakrishnan

Reputation: 890

Is there a way to query and find out the version of Vertica installed?

I searched the Vertica documentation for the keywords Version and Version Number. But I couldn't really get any mention of SQL query to select the version of Vertica installed. I thought there would be some system table that had some version information but couldn't find any.

Is it not possible to get the version of Vertica installed using an SQL query? Or is it only possible to access version by logging into the Vertica host and checking some directory?

Upvotes: 7

Views: 9272

Answers (2)

Harish Masand
Harish Masand

Reputation: 359

Run below Query:

SELECT VERSION();

Sample Output:

Vertica Analytic Database v9.0.1-9

Upvotes: 0

Guillaume
Guillaume

Reputation: 2909

It can be found here: https://www.vertica.com/docs/latest/HTML/index.htm#Authoring/AdministratorsGuide/Diagnostics/DeterminingYourVersionOfVertica.htm

db=> SELECT VERSION();
              VERSION
------------------------------------
 Vertica Analytic Database v9.1.0-2
(1 row)

Edit from the comments: hopefully a link to a permanent page, which will not become obsolete when new versions come: https://www.vertica.com/blog/version-vertica-running/

Upvotes: 21

Related Questions