Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (
Alternatives To Trino
Project NameStarsDownloadsRepos Using ThisPackages Using ThisMost Recent CommitTotal ReleasesLatest ReleaseOpen IssuesLicenseLanguage
Superset52,16828 hours ago3April 29, 20221,358apache-2.0TypeScript
Apache Superset is a Data Visualization and Data Exploration Platform
Modin8,6709179 hours ago62June 25, 2022903apache-2.0Python
Modin: Scale your Pandas workflows by changing a single line of code
Trino7,865399 hours ago51December 29, 20202,310apache-2.0Java
Official repository of Trino, the distributed SQL query engine for big data, formerly known as PrestoSQL (
Mage Ai4,711
a day ago9June 27, 202274apache-2.0Python
🧙 The modern replacement for Airflow. Build, run, and manage data pipelines for integrating and transforming data.
Sql Translator2,821
2 months agomitTypeScript
SQL Translator is a tool for converting natural language queries into SQL code using artificial intelligence. This project is 100% free and open source.
Data Science Best Resources2,466
2 days ago5mit
Carefully curated resource links for data science in one place
Data Diff2,336
5 days ago16July 06, 202272mitPython
Compare tables within or across databases
Data Science Question Answer2,239
8 months ago4mitJupyter Notebook
A repo for data science related questions and answers
a day ago126mitTypeScript
Quadratic | Data Science Spreadsheet with Python & SQL
Awesome Business Intelligence1,747
2 months ago8mit
Actively curated list of awesome BI tools. PRs welcome!
Alternatives To Trino
Select To Compare

Alternative Project Comparisons

Trino Logo

Trino is a fast distributed SQL query engine for big data analytics.

See the User Manual for deployment instructions and end user documentation.

Trino download Trino Slack Trino: The Definitive Guide book download


See DEVELOPMENT for information about code style, development process, and guidelines.

See CONTRIBUTING for contribution requirements.


See the project security policy for information about reporting vulnerabilities.

Build requirements

  • Mac OS X or Linux
  • Java 17.0.4+, 64-bit
  • Docker

Building Trino

Trino is a standard Maven project. Simply run the following command from the project root directory:

./mvnw clean install -DskipTests

On the first build, Maven downloads all the dependencies from the internet and caches them in the local repository (~/.m2/repository), which can take a while, depending on your connection speed. Subsequent builds are faster.

Trino has a comprehensive set of tests that take a considerable amount of time to run, and are thus disabled by the above command. These tests are run by the CI system when you submit a pull request. We recommend only running tests locally for the areas of code that you change.

Running Trino in your IDE


After building Trino for the first time, you can load the project into your IDE and run the server. We recommend using IntelliJ IDEA. Because Trino is a standard Maven project, you easily can import it into your IDE. In IntelliJ, choose Open Project from the Quick Start box or choose Open from the File menu and select the root pom.xml file.

After opening the project in IntelliJ, double check that the Java SDK is properly configured for the project:

  • Open the File menu and select Project Structure
  • In the SDKs section, ensure that JDK 17 is selected (create one if none exist)
  • In the Project section, ensure the Project language level is set to 17

Running a testing server

The simplest way to run Trino for development is to run the TpchQueryRunner class. It will start a development version of the server that is configured with the TPCH connector. You can then use the CLI to execute queries against this server. Many other connectors have their own *QueryRunner class that you can use when working on a specific connector.

Running the full server

Trino comes with sample configuration that should work out-of-the-box for development. Use the following options to create a run configuration:

  • Main Class: io.trino.server.DevelopmentServer
  • VM Options: -ea -Dconfig=etc/ -Dlog.levels-file=etc/ -Djdk.attach.allowAttachSelf=true
  • Working directory: $MODULE_DIR$
  • Use classpath of module: trino-server-dev

The working directory should be the trino-server-dev subdirectory. In IntelliJ, using $MODULE_DIR$ accomplishes this automatically.

If VM options doesn't exist in the dialog, you need to select Modify options and enable Add VM options.

Running the CLI

Start the CLI to connect to the server and run SQL queries:


Run a query to see the nodes in the cluster:

SELECT * FROM system.runtime.nodes;

Run a query against the TPCH connector:

SELECT * FROM tpch.tiny.region;
Popular Sql Projects
Popular Data Science Projects
Popular Data Processing Categories
Related Searches

Get A Weekly Email With Trending Projects For These Categories
No Spam. Unsubscribe easily at any time.
Data Science
Big Data
Distributed Systems
Distributed Database