| layout | title |
|---|---|
default |
Distributed SQL query engine for big data |
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
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.
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.
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.
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.
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
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 SlackCurious 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