description Trino Overview
Trino (formerly PrestoSQL) is a distributed SQL query engine designed for high-performance interactive analytics. Unlike traditional databases, Trino does not store data itself; instead, it queries data where it liveswhether in HDFS, S3, Cassandra, or MySQL. This makes it an ideal 'query layer' for modern data lakes and warehouses.
It allows users to run standard SQL queries across heterogeneous data sources simultaneously, providing a unified view of the organization's data without the need for expensive ETL processes.
balance Trino Pros & Cons
- Fast federated queries
- Broad connector ecosystem
- Standards-based SQL support
- Scales across large clusters
- Complex cluster tuning
- Limited transactional capabilities
- Memory usage can spike
help Trino FAQ
Does Trino store data, or does it only query other systems?
Trino is a distributed query engine, not a storage database. Connectors let it query systems such as Hive, Iceberg, PostgreSQL, MySQL, Cassandra, Kafka, and object storage.
Can one Trino query join data from two different sources?
Yes. A single SQL statement can join tables exposed through separate Trino catalogs, such as an Iceberg table in S3 and a customer table in PostgreSQL.
Why was PrestoSQL renamed Trino?
The PrestoSQL project adopted the Trino name in December 2020. Trino and PrestoDB have since continued as separate open-source projects with different governance and release histories.
How does Trino divide a query across a cluster?
A Trino coordinator plans the query and breaks it into stages and tasks. Worker nodes process splits in parallel, which is why Trino can scan large datasets interactively without moving everything into one database first.
explore Explore More
Similar to Trino
See all arrow_forward
Reviews & Comments
Write a Review
Be the first to review
Share your thoughts with the community and help others make better decisions.
