topic Re: Presto DB to Redshift in Talend Studio

Presto DB to Redshift

Anonymous — Sat, 16 Nov 2024 05:16:04 GMT

Hello,

I'm trying to do a POC. Reading data from Presto DB, do transformations and dump into Redshift. I don't see resources on Presto DB with Talend.

I'm facing few issues connecting to Presto DB with JDBC parameters

JDBC URL: jdbcresto://server:8086/hive;AuthenticationType=LDAP Authentication;SSLTrustStorePath=abc.keystore;SSLTrustStorePwd=changeit;SSL=1

When I use JDBC connection, its keep on erroring me as either Invalid JDBC URL or SSL is required.

Can someone please help me with screenshots or something which can guide me through Presto with Talend.

Thanks,

Re: Presto DB to Redshift

Anonymous — Wed, 17 Jul 2019 03:31:20 GMT

Hi,

End of day, AWS Athena is a serverless version of Presto and below are some articles to connect to Amazon Athena. Could you please try them? I have not personally tried it in any Presto environment but it should be a good starting point for your analysis.

https://help.talend.com/reader/36FNvH4mND6uL3cKKzTU~w/~xQ_ZPcAetw8zVHCU31Xdg

https://community.talend.com/t5/Design-and-Development/Connecting-Talend-on-Amazon-Athena/td-p/55940

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: Presto DB to Redshift

Anonymous — Wed, 17 Jul 2019 16:06:54 GMT

Thanks, Nikhil. Maybe in future we might move to Athena.

I could able to resolve the issue with Presto Facebook Driver

This format should work if you anyone using LDAP Authentication with keystore and SSL

JDBC URL: jdbc:Presto://server:8086/hive?SSLTrustStorePath=abc.keystore&SSLTrustStorePassword=changeit&SSL=true