Trino: The Definitive Guide, 2nd Edition

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 system.

Use docker to download the container image, save it with the name trino-trial, start it to run in the background, and map the port 8080 from inside the container to port 8080 on your workstation:

docker run -d -p 8080:8080 --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 xyz failed: Trino server is still initializing, try waiting a bit and then retrying your last ...