# Trino

> A free tool that runs SQL on many data sources at once.

**Field:** Data Engineering  
**Category:** Analytics & BI  
**Also known as:** PrestoSQL, Trino SQL

## Think of it like

It is like a team of runners who share one big errand. Each fetches a part, and one of them puts it all together.

## Definition

Trino is a free, open source query engine that runs SQL across many machines. One main node plans the query, and many workers read and process the data. Plug-ins called connectors let it read data lakes, databases, Kafka and more. One query can join tables from different systems. Trino began in 2019 as a fork of Presto, made by the people who first built Presto. It was called PrestoSQL until 2020.

## Example

A firm points Trino at its data lake and its customer list. One query then joins web clicks to customers.

## Example code

```bash
trino --server http://localhost:8080 --catalog hive --schema web
```

Open the Trino command line on one catalog. Each catalog is one data source.

## Why it matters

It is one of the most used engines for querying a data lake with SQL. Many hosted services are built on it.

## Common mistake

Running huge nightly jobs on it as if it were a batch system. Its default mode is built for fast interactive queries.

## Three principles

- **Coordinator and workers.** One plans, many do the work.
- **Connectors.** Lakes, databases, streams.
- **Fork of Presto.** By Presto's original creators.

## Related terms

- [Presto](https://learn.benibix.com/term/data/presto)
- [Query Engine](https://learn.benibix.com/term/data/query-engine)
- [Federated Query](https://learn.benibix.com/term/data/federated-query)
- [Apache Iceberg](https://learn.benibix.com/term/data/apache-iceberg)
- [Data Lake](https://learn.benibix.com/term/data/data-lake)
- [Amazon Athena](https://learn.benibix.com/term/data/amazon-athena)

## Told apart from

- [Trino vs Presto](https://learn.benibix.com/compare/trino-vs-presto): People think Trino and Presto are the same tool. They were, until 2019. That year the people who first built Presto left and started a fork, now called Trino. Presto stayed with the Presto Foundation. The two share a design, but their features have drifted apart since.

![One SQL query goes into a query engine made of a coordinator and three workers. Connectors lead from the workers to three places the data lives: a PostgreSQL database, Parquet files in a data lake and a Kafka topic. The answer comes back as one table.](https://learn.benibix.com/diagrams/query-engine.svg)

---

Source: https://learn.benibix.com/term/data/trino
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
