trino-vertica

Trino JDBC connector to Vertica

This is an experiment based on trino-example-jdbc. Currently it supports:

Data types: BOOLEAN, INT, DOUBLE, CHAR, VARCHAR, BINARY, VARBINARY, DATE, TIME, TIMESTAMP, UUID

I've added some aggregate and expression support copied from the Postgres connector as well as join pushdown (enabled by config, see below), but this is very much a work in progress with many missing features. File an issue if you need me to prioritize something.

How to install

The master branch of this connector works with Trino release version 425. Tags and binary releases exist for several older branches.

INSTALL FROM BINARY RELEASE: Download the ZIP and unzip in your Trino plugins directory. Rename the directory to "vertica". Create a catalog file as shown below. Restart Trino.

INSTALL FROM GITHUB SOURCE:

Download and unpack the Trino 425 tag from the official GitHub.

Clone or download this repo and copy trino-vertica into the plugins directory

Import the project into IntelliJ IDEA. Open the root pom.xml and add "plugin/trino-vertica" as a module in the modules list.

Reload Maven and wait for everything to settle.

Open the Maven panel and expand trino-vertica lifecycle. Tests are implemented using TestContainers and can take a long time to run, so you might ant to skip tests. Run Clean, then Install.

Now go to the source tree into plugins/trino-vertica/target. Copy the ZIP file to the plugins directory in your Trino install.

Expand the ZIP and rename the directory to "vertica".

CREATE A CATALOG FILE:

Add a minimal catalog file, e.g.:

$ cat etc/catalog/vertica.properties
connector.name=vertica
connection-url=jdbc:vertica://localhost:5433/xxx
connection-user=xxx
connection-password=xxx
# uncomment/set the following to EAGER to enable join pushdown
#join-pushdown.strategy=EAGER

Restart Trino. You should be able to get something like this to work (outputs simplified here):

$ vsql -U trino
d2=> select * from trino.test ;
 i |  f   |     d      |             ts             |    v
---+------+------------+----------------------------+---------
 1 | 1.23 | 2023-06-07 | 2023-06-07 11:36:19.250644 | Vertica
[bryan@hpbox trino]$ ./trino
trino> show tables in vertica.trino;
 Table
-------
 test
(1 row)

trino> select * from vertica.trino.test;
 i |  f   |     d      |           ts            |    v
---+------+------------+-------------------------+---------
 1 | 1.23 | 2023-06-07 | 2023-06-07 11:36:19.251 | Vertica
(1 row)