Trino: The Definitive Guide

Chapter 2. Installing and Configuring Trino

In Chapter 1, you learned about Trino and its possible use cases. Now you are ready to try it out. In this chapter, you learn how to install Trino, configure a data source, and query the data.

Trying Trino with the Docker Container

The Trino project provides a Docker container. It allows you to easily start up a configured demo environment of Trino for a first glimpse and exploration.

To run Trino in Docker, you must have Docker installed on your machine. You can download Docker from the Docker website, or use the packaging system of your operating systems.

Use docker to download the container image, save it with the name trino-trial, and start it to run in the background:

docker run -d --name trino-trial trinodb/trino

Now let’s connect to the container and run the Trino command-line interface (CLI), trino, on it. It connects to the Trino server running on the same container. In the prompt, you then execute a query on a table of the tpch benchmark data:

$ docker exec -it trino-trial trino
trino> select count(*) from tpch.sf1.nation;
 _col0
-------
    25
(1 row)

Query 20181105_001601_00002_e6r6y, FINISHED, 1 node
Splits: 21 total, 21 done (100.00%)
0:06 [25 rows, 0B] [4 rows/s, 0B/s]

Note

If you try to run Docker and see an error message resembling Query 20181217_115041_00000_i6juj failed: Trino server is still initializing, try waiting a bit and then retrying your last command.

You can continue to explore the data set with your SQL knowledge, ...