- Java 11.0.11
- Netezza JDBC jar
- Ref: https://www.ibm.com/support/knowledgecenter/SSULQD_7.2.1/com.ibm.nz.datacon.doc/c_datacon_jdbc_driver_installation_unix_linux_sup.html
- Download nzjdbc-3.jar and place it under the directory
resources/repo/org/netezza/nzjdbc/3/
$ cd trino-netezza
$ ./mvnw clean install
This will create taregt folder in the current directory. It should create folder trino-netezza-351
$ cd target/trino-netezza-359/
$ $ ls target/trino-netezza-359/
HdrHistogram-2.1.9.jar error_prone_annotations-2.7.1.jar jackson-datatype-guava-2.12.2.jar jmxutils-1.21.jar nzjdbc-3.jar trino-netezza-359.jar
aopalliance-1.0.jar failsafe-2.4.0.jar jackson-datatype-jdk8-2.12.2.jar joda-time-2.10.9.jar parameternames-1.4.jar trino-plugin-toolkit-359.jar
bootstrap-207.jar failureaccess-1.0.1.jar jackson-datatype-joda-2.12.2.jar json-207.jar slf4j-api-1.7.30.jar units-1.6.jar
bval-jsr-2.0.5.jar guava-30.1.1-jre.jar jackson-datatype-jsr310-2.12.2.jar jsr305-3.0.2.jar slf4j-jdk14-1.7.30.jar validation-api-2.0.1.Final.jar
byte-buddy-1.10.22.jar guice-5.0.1.jar jackson-module-parameter-names-2.12.2.jar log-207.jar stats-207.jar
checker-qual-3.14.0.jar j2objc-annotations-1.3.jar javax.annotation-api-1.3.2.jar log-manager-207.jar trino-base-jdbc-359.jar
concurrent-207.jar jackson-core-2.12.2.jar javax.inject-1.jar log4j-over-slf4j-1.7.30.jar trino-matching-359.jar
configuration-207.jar jackson-databind-2.12.2.jar jcl-over-slf4j-1.7.30.jar logback-core-1.2.3.jar trino-netezza-359-services.jar
- rename trino-netezza-359 directory to netezza
$ mv trino-netezza-359 netezza
- Copy target/netezza to trino installation directory
Example:
scp -r target/netezza user@trino-server:/usr/lib/trino/plugins
- Create catalog file under presto installation directory /etc
$vi /usr/lib/trino/etc/catalog/netezza.properties
Configure following properties to netezza.proprties
connector.name=netezza
connection-url=jdbc:netezza://X.X.X.X:5480/db_name
connection-user=username
connection-password=password
- Restart the presto server
$/usr/lib/trino/bin/launcher restart
- Confirm the data
trino:default> show catalogs;
Catalog
---------
hive
netezza
system
(3 rows)
- Currently this connector does not support
DELETEandUPDATEqueries.
Please read CONTRUBUTIONS.md and feel free to send PR or create issue to improve this connector.