Repolode
Submit
trinodb

trinodb/trino

Trino is a distributed SQL query engine for running fast analytical queries across big data sources.

Open-source alternative to:Amazon Athena

View on GitHubWebsite
Stars
13,476
Forks
3,856
Open issues
2,732
Last commit
16 hours ago

What is it?

Trino is a distributed SQL query engine designed for big data analytics. It runs SQL queries across many data sources in a single statement, so data stored in different systems can be queried without first moving it into one place. It was formerly known as PrestoSQL.

The project is written in Java and built with Maven. Developers can build it locally, run a development server with a TPCH sample connector, and use the included command-line client to run SQL against it. The README also covers IDE setup for IntelliJ IDEA, plugin loading, and catalog configuration through properties files.

The repository provides the engine itself along with its connectors and plugin system. Full deployment instructions and end-user documentation are hosted on the project's website.

Key features

  • 01Runs SQL queries across multiple data sources in one statement.
  • 02Includes a command-line client for executing queries against a server.
  • 03Supports a plugin system where connectors and plugins are loaded from Maven coordinates, JARs, or local paths.
  • 04Ships with a TPCH connector for local development and testing.
  • 05Can be built with a standard Maven command and developed in IntelliJ IDEA.

Use cases

  • Running interactive analytical queries over a data lake without copying data into a warehouse.
  • Querying data across separate databases or storage systems in a single SQL statement.
  • Developing or testing a custom Trino connector or plugin.

Quick start

  1. 1

    Install Java 25.0.1+ and Docker as build requirements

  2. 2

    Build Trino with Maven from the project root

    ./mvnw clean install -DskipTests
  3. 3

    Run the CLI against the running server

    client/trino-cli/target/trino-cli-*-executable.jar

Things to know

  • Building requires Java 25, Docker, and a long first Maven dependency download.
  • Web UI npm packages need Rosetta 2 on Apple Silicon Macs.

In collections

Databases & SQL toolsData science courses & toolsMicroservice frameworks & service infrastructure

Topics

#sql#query-engine#distributed-systems#big-data#analytics#data-lake#java#data-science#database#databases

FAQ

What is trino?
Trino is a distributed SQL query engine for running fast analytical queries across big data sources. Trino is a distributed SQL query engine designed for big data analytics. It runs SQL queries across many data sources in a single statement, so data stored in different systems can be queried without first moving it into one place. It was formerly known as PrestoSQL.
Is trino free to use? What license does it have?
trino is open source under the Apache-2.0 license. Check the license terms before using it in commercial products.
Is trino still maintained?
Actively maintained. The last commit to trino was on Nov 6, 2026.
What can I use trino for?
Running interactive analytical queries over a data lake without copying data into a warehouse. Querying data across separate databases or storage systems in a single SQL statement. Developing or testing a custom Trino connector or plugin.
How do I install trino?
Install Java 25.0.1+ and Docker as build requirements Build Trino with Maven from the project root: ./mvnw clean install -DskipTests Run the CLI against the running server: client/trino-cli/target/trino-cli-*-executable.jar
Where can I get trino?
The source code and installation instructions are on GitHub: https://github.com/trinodb/trino

Summary generated by AI from the project's README. GitHub stats refresh daily.

Related projects