Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Connection to Presto.
Added on October 11, 2016 12:01AM
Likes: 1
Replies: 2
UserBird
Dataiker, Alpha Tester Posts: 535 Dataiker
Hi,
I have several data sources that I would like to consolidate via Presto and use Dataiku to connect to it.
How can I connect to Presto?
Thanks,
Buelent
I have several data sources that I would like to consolidate via Presto and use Dataiku to connect to it.
How can I connect to Presto?
Thanks,
Buelent
Best Answer
-
Hi,
DSS does not have support for Presto at the moment.
You can try installing the JDBC driver for Presto as explained here: https://doc.dataiku.com/dss/latest/installation/jdbc.html and then use the "Other databases (JDBC)" dataset, but this generally only provides limited read-only support, and may not work.
Answers
-
Thank you.
Prestogres (https://github.com/treasure-data/prestogres/) might be better choice at this stage. It is based on PLPython and it does replicate the Presto dataset into PostgreSQL tables and uses UDFs to select directly from Presto. The setup looks straightforward as well.
I will try it out and see how it goes. We might be able to remap some of the column definitions in PostgreSQL.
It would be great if Presto can be on the Roadmap. It is a "distributed SQL query engine designed to query large data sets distributed over one or more heterogeneous data sources".
Thanks,
Buelent
