This is a plugin for Presto that allow you to use Vertica Jdbc Connection
Create new properties file inside etc/catalog dir:
connector.name=vertica
connection-url=jdbc:vertica://ip:port/database
connection-user=username
connection-password=userpassword
Create a dir inside plugin dir called vertica. To make it easier you could copy mysql dir to vertica and remove the mysql-connector and prestodb-mysql jars. Finally put the prestodb-vertica and the vertica-jdbc in plugin/vertica folder. Here is the hint:
cd $PRESTODB_HOME
cp -r plugin/mysql plugin/vertica
rm plugin/vertica/mysql-connector*
rm plugin/vertica/presto-mysql*
mv /home/Downloads/presto-vertica*.jar plugin/vertica
mv /home/Downloads/vertica-jdbc-*.jar plugin/vertica
To build Presto Vertica Connector, execute:
mvn clean install
Vertica Driver is not available in common repositories, so you will need to download it and install manually in your repository. It can be downloaded from https://my.vertica.com/download/vertica/client-drivers/
You could install lib in your local repository using command
mvn install:install-file -Dfile=<path-to-file> -DgroupId=<group-id> -DartifactId=<artifact-id> -Dversion=<version> -Dpackaging=<packaging>
In our case for vertica-jdbc
mvn install:install-file -Dfile=path/vertica-jdbc-9.1.1-0.jar -DgroupId=com.vertica.jdbc -DartifactId=vertica.jdbc -Dversion=9.1.1-0 -Dpackaging=jar