# presto-teradata-connector

**Repository Path**: mirrors_jmrozanec/presto-teradata-connector

## Basic Information

- **Project Name**: presto-teradata-connector
- **Description**: Presto-Teradata connector
- **Primary Language**: Unknown
- **License**: Apache-2.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2020-08-09
- **Last Updated**: 2026-07-18

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# Presto-Teradata Connector

This is a [PrestoDB](https://prestodb.io/) connector to query data from [Teradata](http://www.teradata.com/)

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

[![Gitter Chat](http://img.shields.io/badge/chat-online-brightgreen.svg)](https://gitter.im/jmrozanec/presto-teradata-connector)
[![Project stats by OpenHub](https://www.openhub.net/p/presto-teradata-connector/widgets/project_thin_badge.gif)](https://www.openhub.net/p/presto-teradata-connector/)
[![Presto-Connectors Member](https://img.shields.io/badge/presto--connectors-member-green.svg)](http://presto-connectors.ml)

## Download

presto-teradata-connector is available on [Maven central](http://search.maven.org/#search%7Cga%7C1%7Ca%3A%22presto-teradata%22) 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](https://downloads.teradata.com/download/connectivity/jdbc-driver)
* 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](https://groups.google.com/forum/#!topic/presto-users/tXBuNa19hg8)
* [Presto elaborates its own execution plan before submitting to Teradata](https://groups.google.com/forum/#!topic/presto-users/tXBuNa19hg8), 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](http://www.slideshare.net/frsyuki/presto-meetup)

## 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!