Trino

Trino is an open source distributed SQL query engine built for fast analytics on large data. It lets you run one SQL query across many data sources, including data lakes, warehouses and relational databases.

Trino takes a SQL query, splits the work across a cluster of machines and returns results as fast as it can. It can read data where it already lives, such as object storage or a MySQL database, instead of copying it first. A single query can also join data from several systems, which saves a lot of manual export and import work.

• Runs standard ANSI SQL queries across many data sources
• Joins data from object storage and relational databases in one query
• Queries data in place without copying it first
• Works with BI tools such as Tableau and Power BI
• Runs on-premise or on Amazon, Azure and Google Cloud

Data analysts, data scientists and data engineers who need to query large datasets that sit in different systems. It is a good fit for teams that keep data in a data lake and want interactive SQL on top of it.

Trino is free to download and use under the Apache-2.0 license. It is a community project under a non-profit foundation. Running it means managing a cluster yourself, which takes some operations work. Query speed depends on the data sources and the size of the cluster.