Overview
Trino (formerly PrestoSQL) is a fast distributed SQL query engine designed for interactive analytics. It can query data across multiple sources—data lakes, databases, and APIs—with a single SQL query. Created by the original Presto founders after leaving Facebook.
Key Features
- ✓ Federated Queries: Query across multiple data sources
- ✓ ANSI SQL: Standard SQL compliance
- ✓ Connectors: 30+ data source connectors
- ✓ Performance: Optimized for interactive queries
- ✓ Scalability: Scales to petabytes
- ✓ Cost-based Optimizer: Smart query planning
Pros
- 👍 True open-source (no vendor control)
- 👍 Excellent query performance
- 👍 Query any data source
- 👍 Active community
- 👍 No data movement required
Cons
- 👎 Requires cluster management
- 👎 No built-in storage
- 👎 Complex to tune at scale
- 👎 Memory-intensive workloads
Best For
Organizations wanting to query data lakes and multiple sources without moving data. Ideal for interactive analytics on large datasets.
Founded: 2019 HQ: Trino Software Foundation