prestodb/presto repository overview

⁠Dockerfile Link

• latest⁠

⁠What is Presto?

Presto is an open-source SQL query engine that’s fast, reliable, and efficient at scale. Use Presto to run interactive/ad hoc queries at sub-second performance for your high-volume apps. You can learn more from here⁠ or find the source code from github.com/prestodb/presto⁠.

⁠How to use the images?

You can run a Presto server which performs the coordinator and worker with the following command:

docker run -p 8080:8080 -ti prestodb/presto:latest

Then you can access the Presto UI by opening localhost:8080⁠ on a browser after you see ======== SERVER STARTED ======== message from the outputs. By default, the Presto server is running on port 8080. You can bind it to another port if needed.

The image also contains the Presto CLI and can be used like this:

docker run -ti --entrypoint presto-cli prestodb/presto --server <IP:Port>

Remember to use the host IP to access the port you export from the Presto server container.

Or you can run the presto-cli command inside the Presto server container:

docker exec -ti <server container id> presto-cli

In this case, you don't have to assign the --server argument, since it uses localhost:8080 as the default server IP and Port.

⁠Advanced Usage

If you need special configurations for the Presto server, use Docker's mount volume⁠ feature to customize the Presto server. Presto binary is installed under the /opt/presto-server directory inside the image. Therefore, you can find most of the important configuration files under the /opt/presto-server/etc directory.

• To customize the config properties⁠, you can use mount volume to bind the customized config properties to /opt/presto-server/etc/config.properties. For example:

  docker run -p 8080:8080 -ti -v ./myconfig.properties:/opt/presto-server/etc/config.properties prestodb/presto:latest

• For JVM config⁠, you can also use mount volume to bind the customized JVM config to /opt/presto-server/etc/jvm.config. For example:

  docker run -p 8080:8080 -ti -v ./myjvm.config:/opt/presto-server/etc/jvm.config prestodb/presto:latest

• To add connector settings, bind the connector settings to /opt/presto-server/etc/catalog path. For example:

  docker run -p 8080:8080 -ti -v ./jmx.properties:/opt/presto-server/etc/catalog/jmx.properties prestodb/presto:latest