Skip to content
BENIBIX Learn

Trino

Data📊 Analytics & BIQuery Engines

Also known as PrestoSQL, Trino SQL

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

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.

Example

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

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.

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 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.
Trino is the engine in the middle. One main node plans, many workers do the work, and each source has a connector.

Common mistake

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

Key takeaways

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

Compare