Trino website screenshot

Trino

Trino is an open-source, distributed SQL query engine built for lightning-fast analytics over large, heterogeneous data sets. Originally forked from Presto (which emerged at Facebook), it supports ANSI-compliant SQL across a wide range of storage systems from data lakes (S3, HDFS, Iceberg) to relational and NoSQL databases (MySQL, PostgreSQL, Cassandra, MongoDB, Elasticsearch, Kafka, and more).

1 APIs 126 Features
AnalyticsBig DataDistributed SQLMySQLNoSQLQueriesSQL

APIs

Trino Client REST API

The Trino Client REST API enables clients to submit SQL queries to a Trino coordinator and retrieve results. Clients POST SQL to /v1/statement, then poll GET on the returned nex...

Collections

Pricing Plans

Trino Plans Pricing

3 plans

PLANS

Rate Limits

Trino Rate Limits

5 limits

RATE LIMITS

FinOps

Trino Finops

FINOPS

Features

C# Client Driver
Go Client Driver
JDBC
ODBC
Python Client Driver
Elixir Client Driver
Simba JDBC Client Driver
R Client Driver
Ruby Client Driver
Rust Client Driver
Command Line Interface
Grafana
Apache Airflow
Apache DolphinScheduler
Coginiti
Cube
DBeaver
dbt
DbVisualizer
Emacs
FugueSQL
Great Expectations
Harlequin
Hue
Ibis
IBM Cognos Analytics
JetBrains Datagrip
Jupy SQL
Logi Symphony
Looker
Metabase
Microstrategy
Mitzu
Mode
PopSQL
Power BI
Querybook
Quix
Redash
SQuirrel SQL
Tableau
VSCode
waii
Wren AI
yanagishima
Zing Data
Spill to disk
Resource groups
Session property managers
Distributed sort
Dynamic filtering
Graceful shutdown
Fault-tolerant execution
HTTP event listener
Kafka event listener
MySQL event listener
OpenLineage event listener
Client protocol
HTTP server
Resource management
Query management
Catalog management
SQL environment
Spilling
Exchange
Task
Write partitioning
Writer scaling
Node scheduler
Optimizer
Logging
Web UI
Regular expression function
HTTP client
Table statistics
Cost in EXPLAIN
Cost-based optimizations
Pushdown
Adaptive plan optimizations
Amazon Redshift
Apache Cassandra
Apache Druid
Apache Ignite
Apache Kafka
Apache Pinot
Clickhouse
Datafaker
Elasticsearch
Exasol
Google BigQuery
Google Sheets
MariaDB
Microsoft SQL Server
MongoDB
MySQL
OpenSearch
Oracle
PostgreSQL
Prometheus
Redis
SingleStore
Snowflake
TPC
Vertica
Amazon Kinesis
Apache Accumulo
Apache Kudu
Apache Phoenix
Git
OpenAPI
VAST
JMX
Kubernetes
OpenLineage
Open Policy Agent
OpenTelemetry
Trino Gateway
Datadog
Gurubase
jOOQ
Minitrino
RudderStack
SQL Formatter
Testcontainers
Trino-lb
Workload Analyzer

Integrations

BigQuery
Black Hole
Cassandra
ClickHouse
Delta Lake
Druid
DuckDB
Elasticsearch
Exasol
Faker
Google Sheets
Hive
Hudi
Iceberg
Ignite
JMX
Kafka
Loki
MariaDB
Memory
MongoDB
MySQL
OpenSearch
Oracle
Pinot
PostgreSQL
Prometheus
Redis
Redshift
SingleStore
Snowflake
SQL Server
System
Thrift
TPC-DS
TPC-H
Vertica

Semantic Vocabularies

Trino Context

25 classes · 21 properties

JSON-LD

API Governance Rules

Trino API Rules

8 rules · 2 errors 6 warnings

SPECTRAL

JSON Structure

Trino Query Results Structure

0 properties

JSON STRUCTURE

Example Payloads

Trino Cancel Query Example

2 fields

EXAMPLE

Resources

👥
GitHubOrganization
GitHubOrganization
📦
PythonSDK
PythonSDK
📦
GoSDK
GoSDK
📦
JavaScriptSDK
JavaScriptSDK
🔗
HelmChart
HelmChart
🔗
CLI
CLI
🔗
JSONLDContext
JSONLDContext
🔗
JSONSchema
JSONSchema
🔗
Vocabulary
Vocabulary
🔗
SpectralRules
SpectralRules
🔗
Website
Website
🔗
Documentation
Documentation
🔗
Security
Security
🔗
Glossary
Glossary
📄
ChangeLog
ChangeLog
🚀
GettingStarted
GettingStarted
🔗
Events
Events
📰
Blog
Blog
🔗
Forums
Forums

Sources

Raw ↑
opencollection: 1.0.0
info:
  name: Trino Client REST API
  version: '480'
items:
- info:
    name: Queries
    type: folder
  items:
  - info:
      name: Submit SQL Statement
      type: http
    http:
      method: POST
      url: http://{host}:{port}/v1/statement
      headers:
      - name: X-Trino-User
        value: alice
      - name: X-Trino-Catalog
        value: hive
      - name: X-Trino-Schema
        value: default
      - name: X-Trino-Source
        value: my-app
      - name: X-Trino-Session
        value: query_max_memory=10GB,query_max_run_time=5m
      - name: X-Trino-Transaction-Id
        value: NONE
      - name: X-Trino-Client-Tags
        value: ''
      - name: X-Trino-Client-Info
        value: ''
      - name: X-Trino-Time-Zone
        value: America/New_York
      - name: X-Trino-Language
        value: en-US
      - name: X-Trino-Trace-Token
        value: ''
      - name: X-Trino-Extra-Credential
        value: ''
    docs: Submits an SQL query string for execution. Returns an initial QueryResults response which may contain the first
      batch of results and/or a nextUri for polling subsequent results. Clients must include the X-Trino-User header at minimum.
      Additional context headers (catalog, schema, session properties) may be provided to configure the query environment.
  - info:
      name: Get Query Results
      type: http
    http:
      method: GET
      url: http://{host}:{port}/v1/statement/:queryId/:token
      headers:
      - name: X-Trino-User
        value: ''
      params:
      - name: queryId
        value: 20240101_120000_00001_abcde
        type: path
        description: The unique query identifier returned by POST /v1/statement
      - name: token
        value: '1'
        type: path
        description: Sequential token for paging through results
      - name: maxWait
        value: 2s
        type: query
        description: Maximum duration to wait for results before returning empty batch
      - name: targetResultSize
        value: 1MB
        type: query
        description: Desired result batch size hint
    docs: Retrieves the next batch of results for a running query. Clients should follow the nextUri from a previous QueryResults
      response. When no nextUri is present in the response, the query is complete.
  - info:
      name: Cancel Query
      type: http
    http:
      method: DELETE
      url: http://{host}:{port}/v1/statement/:queryId/:token
      headers:
      - name: X-Trino-User
        value: ''
      params:
      - name: queryId
        value: ''
        type: path
        description: The unique query identifier
      - name: token
        value: ''
        type: path
        description: Sequential token matching the current position
    docs: Cancels a running query. Clients should DELETE the nextUri returned by the most recent QueryResults response to
      abort execution.
  - info:
      name: List Active Queries
      type: http
    http:
      method: GET
      url: http://{host}:{port}/v1/query
      params:
      - name: state
        value: ''
        type: query
        description: Filter queries by state
      - name: limit
        value: ''
        type: query
        description: Maximum number of queries to return
    docs: Returns a list of currently running and recently completed queries on the Trino coordinator. Useful for monitoring
      and management UIs.
- info:
    name: Cluster
    type: folder
  items:
  - info:
      name: Get Cluster Info
      type: http
    http:
      method: GET
      url: http://{host}:{port}/v1/info
    docs: Returns general information about the Trino cluster including version, uptime, and whether the coordinator is still
      starting up. Used by load balancers and Trino Gateway to verify cluster health.
  - info:
      name: List Cluster Nodes
      type: http
    http:
      method: GET
      url: http://{host}:{port}/v1/node
    docs: Returns a list of all active worker nodes in the Trino cluster, including their node ID, URI, last heartbeat time,
      and resource usage.
bundled: true