Getting Started with Presto

Introduction

This repository contains the files used to present the F8 2019 classroom demo: Getting Started with Presto: Run SQL at any Scale. They will setup a Presto cluster with MySQL and MongoDB instances that you can query from Presto.

Requirements

• Docker (you can use Docker CE)
• Docker Compose

The demo was develop on Mac OS X.

Quick Start

To start the Presto cluster and its dependencies:

docker-compose up

Then open the Jupyter Notebook at localhost:8888.

The Jupyter Notebook password is demo. You can override it by changing the SHA1 hash of --NotebookApp.password='sha1:2017f6d8a65d:4f2115202d4cd8c081f1c135bc2b41292bcb4ec4' in docker-compose.yml.

The Presto UI is available at localhost:8080.

To run the Presto CLI:

docker exec -it f8-2019-demo_presto_1 bin/presto-cli

You can find Presto's documentation on prestodb.io/docs/current/.

If you update a Dockerfile, use docker-compose up --build to ignore cache and rebuild the images.

Next Steps

In this demo, we run all Presto nodes on the same machine. Presto has two types of nodes:

• The coordinator is the main server that compiles SQL And manages its execution
• The worker is a node that executes tasks scheduled by the coordinator

To run Presto in a distributed way, you will create a new instance with coordinator=false in etc/config.properties.

• More about deploying Presto
• Configuration properties reference
• Developing extensions and integrations for Presto

References

• https://prestodb.io
• https://github.com/prestodb/presto
• http://tinyurl.com/presto-paper
• https://prestodb.io/resources.html#libraries
• https://jupyter.org

Contributing

See the CONTRIBUTING file for how to help out.

License

f8-2019-demo is Apache 2.0 licensed, as found in the LICENSE file.