Trino

Trino. Is the community fork of Presto: a distributed SQL query engine for interactive analytics across lakes, warehouses, and RDBMS sources.

Summary

What it is: Coordinator plus workers, connector plugins (Iceberg, Delta, Hive, PostgreSQL, etc.), ANSI SQL with MPP execution.

When to use: Query data in object storage without copying everything into one warehouse; multi-source joins for analytics teams.

When to skip: Simple single-warehouse BI. Ops team cannot run another stateful cluster.

Key features: Fault-tolerant execution, dynamic filtering, role-based access via connectors, Kubernetes Helm charts.

Details

References

• Trino documentation