Vertica

Note

You might want to start with our detailed tutorial for your first steps with SQL databases in DSS .

You might want to start with that tutorial. The rest of this page is reference information for Vertica.

DSS supports the full range of features on Vertica:

DSS is tested on Vertica 7.1 and 7.2

Installing the JDBC driver

The Vertica JDBC driver can be downloaded from the Vertica website .

  • If your database version is 7.1 or below, you need the 7.1 driver

  • Else, we recommend the latest driver

The driver is a single JAR file called vertica-driver-VERSION.jar

  • Copy the JAR file to the lib/jdbc driver of DSS

  • Restart DSS

Timezones support

Versions of the JDBC driver below 8.0 have some bugs related to timezones handling when reading “Timestamp (no timezone)” or “Date” kind of fields. Please use a more recent driver for full timezone support.