Presto-Teradata Connector

This is a PrestoDB connector to query data from Teradata

Queries "walk", but you can help us make them run! ;) You are welcome to stop by and contribute.

Download

presto-teradata-connector is available on Maven central repository.

<dependency>
    <groupId>ml.prestoconnectors</groupId>
    <artifactId>presto-teradata</artifactId>
    <version>0.130.1</version>
</dependency>

Development

Set up

We do not provide Teradata JDBC jars, since they require to agree on some terms due to US legislation. After cloning this repo, you should

• download Teradata JDBC drivers from here

• rename the jars

• place them in the following directories

    $PROJECT_HOME/lib/com/teradata/config/15.10.0/config-15.10.0.jar
    $PROJECT_HOME/lib/com/teradata/jdbc/15.10.0/jdbc-15.10.0.jar
  

Building the project

To build Presto Teradata Connector, execute:

mvn clean install

Installation

Connection configuration

Create new properties file inside etc/catalog dir:

connector.name=teradata
# connection-url is the Teradata JDBC URL. You may use different configurations per environment.
# For more information, please visit 
# [JDBC driver docs](https://developer.teradata.com/doc/connectivity/jdbc/reference/current/jdbcug_chapter_2.html)
connection-url=jdbc:teradata://aaa.bbb.ccc.ddd/TMODE=ANSI,CHARSET=UTF8
connection-user=someusername
connection-password=somepassword

To install the connector, copy presto-teradata-{version}.jar and jars at $PROJECT_HOME/presto-dependencies/ directory to some location, ex.: /tmp/teradata-jars/

cd $PRESTODB_HOME
mkdir -p plugin/teradata
cp /tmp/teradata-jars/* plugin/teradata

Known issues and limitations

• Presto may not support all keywords from Teradata SQL dialect
• Presto elaborates its own execution plan before submitting to Teradata, which may result in non optimal performance.

Related resources

Below we list resources related to Presto connectors. If you wrote a Presto connector to any database, we want to hear from you!

• Prestogres: connecting postgres to Presto

Contribute & Support!

Contributions are welcome! You can contribute by

• starring this repo!
• requesting or adding new features.
• enhancing existing code or documentation.
• testing.
• bringing suggestions and reporting bugs.
• spreading the word / telling us how you use it!