search

prestodb / presto

The official home of the Presto distributed SQL query engine for big data
http://prestodb.io
Apache License 2.0
15.76k stars 5.29k forks source link

Presto connecting to Teradata #15573

Open jmaxx37 opened 3 years ago

jmaxx37 commented 3 years ago

Hi, I am trying to use open source Presto to connect to Teradata. Do you know if this is possible?

  1. I am not finding connectors on Prestodb.io for Teradata.
  2. I do not have Teradata QueryGrid.

There should be a way to be able to use open source presto to connect to Teradata (without QueryGrid), right? Any assistance on this will be appreciated. Thanks!

tnatssb commented 3 years ago

Check out: https://docs.starburstdata.com/latest/connector/starburst-teradata.html

jmaxx37 commented 3 years ago

@tnatssb Thanks for this. I did see this as well. "The connectors require a valid Starburst Enterprise Presto license." I am trying to see if I can connect using the free open source Presto version, without having to pay for licenses. Are you aware of a way to do this?

tnatssb commented 3 years ago

Not that I'm aware of, sorry.

jmaxx37 commented 3 years ago

@tnatssb Thanks for looking into this. Anyone else tried this before?

ashishtadose commented 3 years ago

@jmaxx37 I had developed jdbc based teradata connector for presto in the past. This was definitely not as performant as QueryGrid (which required license and complex setup ) but helps to integrate with presto with Teradata with limitations of JDBC connectors.

Let me know if that will help, happy to contribute here to the community.

jmaxx37 commented 3 years ago

Hey @ashishtadose Oh that will be awesome! I want to try and see how it works. Will you be able to send the Teradata connector to me to try?

ashishtadose commented 3 years ago

Here you go - https://github.com/prestodb/presto/pull/15675 I didn't get much time to test it though.

You could override the columns mapping for additional type support or behavior.

jmaxx37 commented 3 years ago

Hey Ashish! Thanks a lot! Will you be able to send some instruction as to how and where to install this?

ashishtadose commented 3 years ago

You will have to configure the catalog with the below configs. etc/catalog/teradata.properties

connector.name=teradata connection-url=jdbc:teradata://terdata/DATABASE=teradatadb,DBS_PORT=1025,tmode=TERA,charset=UTF8,LOGMECH=LDAP connection-user= connection-password=