Do you ❤️ Trino? Give us a 🌟 on GitHub

Trino, a query engine that runs at ludicrous speed

Fast distributed SQL query engine for big data analytics that helps you explore your data universe.

Download Trino Chat with the community Join Trino events

December 11th and 12th, 2024

Join the fastest growing open-source analytics project

Learn how these and many other organizations use Trino

Why Trino?

speed

Speed

Trino is a highly parallel and distributed query engine, that is built from the ground up for efficient, low latency analytics.

scale

Scale

The largest organizations in the world use Trino to query exabyte scale data lakes and massive data warehouses alike.

simple

Simplicity

Trino is an ANSI SQL compliant query engine, that works with BI tools such as R, Tableau, Power BI, Superset and many others.

versatile

Versatile

Supports diverse use cases: ad-hoc analytics at interactive speeds, massive multi-hour batch queries, and high volume apps that perform sub-second queries.

analysis

In-place analysis

You can natively query data in Hadoop, S3, Cassandra, MySQL, and many others, without the need for complex, slow, and error-prone processes for copying the data.

federation

Query federation

Access data from multiple systems within a single query. For example, join historic log data stored in an S3 object storage with customer data stored in a MySQL relational database.

everywhere

Runs everywhere

Trino is optimized for both on-premise and cloud environments such as Amazon, Azure, Google Cloud, and others.

trusted

Trusted

Trino is used for critical business operations, including financial results for public markets, by some of the largest organizations in the world.

open

Open

The Trino project is community driven project under the non-profit Trino Software Foundation.


Use cases

Interactive data analytics

A primary driver for Trino usage is interactive analytics. A user enters the query either directly using SQL or generated through a user interface, and is waiting for the results to come back as quickly as possible. Trino returns results to the user as soon as they are available. This offers data analysts and data scientists the ability to query large amounts of data, test hypotheses, run A/B testing, and build visualizations or dashboards.

High performance analytics of object storage with SQL

The original use case for the development of Trino, is enabling SQL-based analytics of HDFS/Hive object storage systems. Trino is so performant that it enables analytics that used to be impossible or take hours. Migrating from Hive-based systems and querying cloud object storage systems is still a major use case for Trino.

Centralized data access and analytics with query federation

The ability to query many disparate datasource in the same system with the same SQL greatly simplifies analytics that require understanding the large picture of all your data. Federated queries in Trino can access your object storage, your main relational databases, and your new streaming or NoSQL system, all in the same query. Trino completely changes what is possible in this central data consumption layer.

Batch ETL processing across disparate systems

Large Extract, Transform, Load (ETL) processes running in batches are generally very resource intensive. Routinely run by engineers, they are low priority to return as long as they eventually finish. Trino is able to tremendously speed up ETL processes, allow them all to use standard SQL statement, and work with numerous data sources and targets all in the same system.


Resources

Reading material

Get a copy of the definitive guide about the Trino distributed query engine. Useful for beginners and existing users.

For technical background, read our paper: Presto: SQL on Everything

Community chat

The community is very active and helpful on Slack, with users and developers from all around the world. If you need help using or running Trino, this is the place to ask.

  Join us on Slack

Subscribe to our blog

Curious to learn new insights into the community behind this incredible query engine? Subscribe to our blog where the project maintainers, contributors, and users share updates, stories, knowledge, and lessons learned.

Subscribe

Sponsored by

Starburst
GitHub