packtpublishing/getting-started-with-trino

Getting Started with Trino, published by Packt

Getting Started with Trino

Published by Packt

Welcome to the Getting Started with Trino book exercise repository. This is a home for the some 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.

If you're entirely new to Trino, you're not alone. 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 our use cases to understand what Trino is and is not. We also have a rascally little bunny mascot named Commander Bun Bun 🐇.

Another thing to know about Trino is that it was originally called Presto® SQL and it shares the first 7 years of code with the well known Presto® DB. Trino houses the four original creators of Presto® and the majority code contributors of both Presto® and Trino. You can read more about why this split happened in the Trino rebrand blog.

Prerequisites

In order to use this repository you need to have Docker installed to run your service containers. Check if you have Docker installed by running docker --version. If Docker isn't found, please refer to the install insructions and install Docker before trying to run these tutorials. If you're on mac or windows, you will just need to install docker desktop. If you're on a linux distribution, you will just need to install the docker engine.

Layout

The first level of directories in this repo are generally organized by connector. Concepts such as security, clients, or basics will have their own directory as well. The second level of directories contain the actual environment and tutorial directories themselves. In order to run the environment, you need to be in one of these directories that have a docker-compose.yml file in it. The second level of directories contain the actual environment and tutorial directories themselves. In order to run the environment, you need to be in one of these directories that have a docker-compose.yml file in it.

Helpful Docker commands

Start Service

docker-compose up -d

Stop Service

docker-compose stop

Clean Service

cleans images, containers, and network

docker system prune --all --force

cleans volumes

docker volume prune --force

Show Service Images

docker images

Login to Container

docker container exec -it <container_id> /bin/bash

Show Service Logs

docker logs <container_id>

List Services

docker container ls

List Service Process information

docker-compose ps

See trademark and other legal notices.