About Trino
Trino is a distributed SQL query engine built for analytics on large data sets. It was formerly called PrestoSQL, and it lets analysts and engineers run interactive SQL against data wherever it lives rather than first moving it into a single warehouse.
The project's topics point to its role in the data lake ecosystem, with connectors and integrations for systems such as Hive, Hadoop, Iceberg and Delta Lake, and a JDBC driver for applications. Trino is a Maven project written in Java, and its repository covers development guidelines, plugin implementors, a security policy and reproducible builds. It runs as a cluster of servers and has a web UI.
Trino is released under the Apache-2.0 licence and is deployed and operated by the user, with deployment instructions and end-user documentation in the project's user manual. It is a fit for data platform teams that need fast, standards-based SQL over many sources, rather than for individual analysts looking for a point-and-click tool.
Key features
- Distributed SQL query engine
- Fast analytics on big data
- Connectors for data lake formats like Iceberg
- JDBC access for applications
- Plugin architecture for custom connectors
- Reproducible builds since version 449
Good fit for
- →Interactive SQL over a data lake
- →Querying multiple data sources from one engine
- →Big data analytics for data platform teams
- Built with
- Java
- Tags
- sql
- query-engine
- big-data
- analytics
- data-lake
- distributed
- java
- presto
- iceberg
Open-source alternatives to Trino
See all
Dremio OSS
Data Pipelines & ETL
Dremio - the missing link in modern data
Apache-2.0vs Snowflake★ 1.5k
StarRocks
Databases
The world's fastest open query engine for sub-second analytics both on and off the data la
Apache-2.0vs Snowflake★ 12k
Apache Hive
Databases
Apache Hive
Apache-2.0vs Snowflake★ 6k
Apache Doris
Databases
Apache Doris is a real-time analytics and hybrid search database for AI agents.
Apache-2.0vs Snowflake★ 16k
ClickHouse
Databases
ClickHouse is a fast open-source column-oriented database management system that allows ge
Apache-2.0vs Snowflake★ 50k
Databend
Databases
Data Agent Ready Warehouse : One for Analytics, Search, AI, Python Sandbox. — rebuilt fr
OSSvs Snowflake★ 9.5k
SaaS alternatives to Trino
See all
Amazon Redshift
Databases
Managed cloud data warehouse on AWS for SQL analytics at scale
SaaS
Teradata
Databases
Cloud data analytics platform and data warehouse for large-scale enterprise workloads
SaaS
Amazon Athena
Databases
Serverless interactive query service for analyzing data in Amazon S3 with SQL
SaaS
Azure Synapse Analytics
Databases
Microsoft analytics service combining data warehousing, big data and data integration
SaaS
Starburst
Databases
Data lakehouse analytics platform built on the Trino query engine
SaaS
Cloudera
Data Pipelines & ETL
Hybrid data platform for data engineering, warehousing and machine learning on Hadoop and Spark
SaaS

