presto connector

[rkacham17]

We are working on presto does talend has presto connector?

presto is providign JDBC  drivers  can i use these drivers and connect from talend

Thanks,

Ramesh

[TRF]

Hi,

Never try to use Presto with Talend, but should works (as usual with Talend).

For that, you'll have to import the jdbc driver from Presto.

You may also use the Presto REST API.

As this subject could be useful for others, can you please share your job design and give us some details regarding the approach you finally adopted?

Regards,

[rkacham17]

Thanks,Sure I will update my findings and share my experience

[Anonymous]

Hello @rkacham17 do you have any findings regarding presto connection?

if yes then can you please share with us?

[badri-nair]

Thank you , 

The Presto driver file worked and I was able to unload data from Presto table .

I am facing an issue with using the same in a Big data spark job .

Can you please let me know if there is any other driver required for a spark job  ?

The message i get is.

"java.sql.SQLException: Unsupported type JAVA_OBJECT"

Thanks

Badri Nair 

---

@TRF wrote:

Hi,

Never try to use Presto with Talend, but should works (as usual with Talend).

For that, you'll have to import the jdbc driver from Presto.

You may also use the Presto REST API.

As this subject could be useful for others, can you please share your job design and give us some details regarding the approach you finally adopted?

Regards,

---