Presto OraclePlugin

This is a plugin for Presto that allow you to use Oracle Jdbc Connection

Connection Configuration

Create new properties file inside etc/catalog dir:

connector.name=oracle
# connection-url must me the URL to access Oracle via JDBC. It can be different depending on your environment.
# Another example of the URL would be jdbc:oracle:thin:@ip:port/database. For more information, please go to the JDBC driver docs
connection-url=jdbc:oracle:thin:@ip:port/database
connection-user=myuser
connection-password=

Building Presto Oracle JDBC Plugin

gradle build

Plugin installation

First build the plugin.

Then create a dir inside plugin dir called oracle. To make it easier you could copy mysql dir to oracle and remove the mysql-connector and prestodb-mysql jars. Finally put the prestodb-oracle in plugin/oracle folder. Here is the sptes:

cd $PRESTODB_HOME
cp -r plugin/mysql plugin/oracle
rm plugin/oracle/mysql-connector*
rm plugin/oracle/presto-mysql*
cp $ORACLE_PLUGIN_REPO/lib/* plugin/oracle
cp $ORACLE_PLUGIN_REPO/build/libs/presto-oracle*.jar plugin/oracle