This is a plugin for Presto that allow you to use IBM DB2 Jdbc Connection
Create new properties file like <catalog-name>.properties inside etc/catalog dir:
connector.name=db2
connection-url=jdbc:db2://ip:port/database
connection-user=myuser
connection-password=mypassword
For a connection with SSL, uses following JDBC URL strings as connection-url:
connection-url=jdbc:db2://ip:port/database:sslConnection=true;
Notices:
- the trailing semi-colon is required. Or it will thrown SQLException
Invalid database URL syntax. - You can use
db2.iam-api-keyto specify API Key instead of user/password if IAM authentication is supported.
See official document of DB2 JDBC details from the article Connecting programmatically with JDBC.
| Property Name | Description |
|---|---|
| db2.varchar-max-length | max length of VARCHAR type in a CREATE TABLE or ALTER TABLE command. default is 32672 |
| db2.iam-api-key | API Key of IBM Cloud IAM. Use this when choosing IAM authentication instead of user/password |
Notice: you may need to customize value of db2.varchar-max-length to 32592 when using Db2 warehouse.
Since release 324, it starts to support the idea of extra credentials where it allows prestosql client user to provide DB2 username and password as extra credentials that are passed directly to the backend DB2 server when running a Presto query.
- configure this for the DB2 connector catalog properties file:
user-credential-name=db2_user
password-credential-name=db2_password
- passing credentials directly to DB2 server:
presto --extra-credential db2_user=user1 --extra-credential db2_password=secret
See details from this answer.
mvn clean install