Welcome to the Trino getting started tutorial repository. This is a home for a set of preconfigured Docker Compose environments that are used to set up simple environments and showcase basic configurations in isolation to get new and existing users started on all the different containers we have, and more importantly learn and have fun with Trino.
Trino is a distributed SQL query engine designed to query large data sets distributed over one or more heterogeneous data sources. Check out some of the use cases to understand what Trino is and is not. We also have a rascally little bunny mascot named Commander Bun Bun 🐇.
Trino was originally called Presto, and was a seperate fork that renamed itself to PrestoSQL. It shares the first 7 years of development with PrestoDB . Trino resulted from a disagreement in the governance leading the four original creators of Presto and the majority of its contributors to using Trino.
For beginners, I recommend using Docker to run your service containers. I do not use the version tag for compose files and therefore don't provide support for legacy compose versions. Make sure you have the correct Docker Compose version by having one of the following installed.
- Docker Desktop >= 4.1.0(latest recommended)
or
- Docker Engine and Docker Compose with compose version >= 1.27.0.
Tutorials are organized by a concept, most commonly a connector. Concepts such as security, clients, or basics should use their own directory as well. There may also be another directory that contains the actual environment and tutorial directories themselves. When running a tutorial command, ensure you're in the correct directory and that it contains a docker-compose.yml file in it.
Important
The layout of this repository has migrated most concept tutorials to the community-tutorials/ directory or adopted into other repositories to minimize the scope of this repository to the most common Trino use cases.
The community-tutorials/ directory contains a list of tutorials that have little to no testing and may contain outdated versions, bugs, or missing container images. Feel free to open up an issue if you would like to adopt one of these tutorials on your own repository or website and we will link them in the following list. Otherwise, feel free to provide Pull requests for any functionality in these tutorials, or submit a new one. See more information here
| Tutorial | Description |
|---|---|
| Trino on Backblaze b2 | These tutorials by @metadaddy demonstrate how to use Trino with Backblaze B2 as an S3 object storage with connectors like Hive and Iceberg. |
docker compose up -d
docker compose stop
cleans images, containers, and network
docker system prune --all --force
cleans volumes
docker volume prune --force
docker images
docker container exec -it <container_id> /bin/bash
docker logs <container_id>
docker container ls
docker compose ps
See trademark and other legal notices.