Installing Presto for Mac

Presto is a “Distributed SQL Query Engine for Big Data” that gives you the ability to join across data stores! 🎉

Server

The easiest way to install Presto is with Homebrew.

brew install presto

Next, add a connector. Here’s the list of available ones.

For PostgreSQL, create /usr/local/opt/presto/libexec/etc/catalog/mydb.properties with:

connector.name=postgresql
connection-url=jdbc:postgresql://localhost:5432/mydbname
connection-user=myuser
connection-password=mysecret

And start the server with:

presto-server run

Client

Presto comes with a CLI

presto --catalog mydb --schema public

And run:

SHOW TABLES;

Try one of your tables with:

SELECT * FROM mytable;

There are also clients in many different languages you can use.

🐰 🎩 ✨