Trino — Distributed SQL Engine for Federated Queries

Trino lets you query data from multiple sources with a single SQL statement. Postgres, S3, Kafka — all connected.

One SQL Across All Data¶

Federation — a single query combines PostgreSQL, S3, and Kafka.

SELECT c.customer_name, o.total_revenue
FROM postgres.public.customers c
JOIN (
    SELECT customer_id, SUM(total_czk) AS total_revenue
    FROM datalake.analytics.fact_orders
    WHERE order_date >= DATE '2026-01-01'
    GROUP BY customer_id
) o ON c.id = o.customer_id
WHERE c.segment = 'enterprise';

Connectors¶

# catalog/postgres.properties
connector.name=postgresql
connection-url=jdbc:postgresql://db:5432/app

# catalog/datalake.properties
connector.name=iceberg
hive.metastore.uri=thrift://metastore:9083

Optimization¶

• Predicate pushdown
• Dynamic filtering
• Cost-based optimizer

Summary¶

Trino is ideal for federated queries. One SQL engine for your entire infrastructure without moving data.