Trino

Open source

A distributed SQL query engine for big data analytics that runs fast queries across many data sources, formerly known as PrestoSQL.

trino.io
Trino homepage screenshot
GitHub stars
14k
Last 30 days
+182(+1%)
Last commit
today
Repository age
7 years
Version
484
Licence
Apache-2.0
Self-hosted
Yes

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 tools
Tags
sql
query-engine
big-data
analytics
data-lake
distributed
java
presto
iceberg

Trino: questions and answers

What is Trino used for?
Trino is a distributed SQL query engine for big data analytics that runs fast queries across many data sources, formerly known as PrestoSQL. It is a good fit for interactive SQL over a data lake, querying multiple data sources from one engine and big data analytics for data platform teams.
Is Trino open source?
Yes. Trino is open source under the Apache-2.0 licence. Its source code is on GitHub at trinodb/trino and is written mainly in Java.
Is Trino free?
Yes. Trino is open source, so the software itself is free to use.
Can I self-host Trino?
Yes. Trino can be self-hosted on your own server or infrastructure.
What is Trino an alternative to?
Trino is an open-source alternative to Amazon Redshift, Teradata, Amazon Athena and Azure Synapse Analytics. Other open-source alternatives to Amazon Redshift include ClickHouse, Dremio OSS and StarRocks.
Is Trino actively maintained?
Yes. The most recent commit to Trino was on 12 November 2026, and the latest release is 484, published on 16 October 2026. The project has 14k stars on GitHub, with 182 added in the last 30 days.

Open-source alternatives to Trino

See all

SaaS alternatives to Trino

See all