Skip to content

Latest commit

 

History

History
81 lines (53 loc) · 3.17 KB

README.md

File metadata and controls

81 lines (53 loc) · 3.17 KB

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.

Gitter Chat Project stats by OpenHub Presto-Connectors Member

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

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!

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!