Teiid vs Trino
Teiid
teiid.ioTrino
trino.ioSide by side
| Figure | Teiid | Trino |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | — | — |
| Open source | — | — |
| Web | — | Yes |
| Linux | Yes | Yes |
| API | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 1 |
| Spec score · Data Federation Software | 8.0 (#8) | 7.4 (#17) |
| Spec score · Query Engine Software | 8.0 (#11) | 7.4 (#17) |
| Spec score · Data Virtualization Software | 8.1 (#10) | 7.4 (#20) |
| Client interfaces | Teiid supports JDBC, ODBC, OData, and REST access to virtualized data. | The Trino project maintains JDBC, Go, JavaScript, Python, and C# client drivers, plus a command-line interface and Grafana data-source plugin. |
| Deployment | The project describes Spring Boot, WildFly, embedded Java, and OpenShift deployment options. | Trino can run on Kubernetes, in Docker containers, or through a manually deployed server tarball. |
| Security | The site describes Teiid as providing secure data access and says Spring Boot projects can select security integration among their dependencies. | Trino supports TLS 1.2 and TLS 1.3, password-file, LDAP, Salesforce, OAuth 2.0, certificate, JWT, and Kerberos authentication, plus file-based, Open Policy Agent, and Ranger access control. |
| Support | The site directs users to community channels including Stack Overflow, a legacy forum, GitHub, and project issue trackers. | The project directs users to Slack for help and GitHub issues for bug reports. |
Plans
In their own words
Teiid
Teiid is a free, open-source data virtualization project that gives applications a uniform way to query multiple underlying sources. It works as a gateway rather than storing the data, and virtual databases can present separate sources together so applications can join or union their results. Access is available through JDBC, ODBC, OData, and REST. Built-in translators are listed for Oracle, DB2, SQL Server, MySQL, PostgreSQL, and files; custom translators can also be made. Its optimizer uses source capability information to send query work to underlying systems where possible. Documented runtimes include Spring Boot, WildFly, embedded Java, and OpenShift, with Spring Boot noted as less feature-complete than WildFly. Teiid is aimed especially at Java developers integrating enterprise data sources. Connecting to sources commonly requires third-party drivers that are not included. The FAQ cautions that big-data, LDAP-style, and primarily streaming workloads may not be a good fit. Teiid Designer is deprecated, with no further releases expected.
Trino
Trino is a distributed SQL query engine for analytics across large datasets held in different systems. It supports ANSI SQL and can query multiple sources together, such as joining S3 object storage data with MySQL in one query. Its parallel, distributed design is intended for efficient, low-latency analytics and data warehousing, not general-purpose relational database use or OLTP workloads. Connectors cover systems including BigQuery, Cassandra, ClickHouse, Elasticsearch, MongoDB, MySQL, Oracle, PostgreSQL, Redis, Snowflake, and SQL Server. Project-maintained client options include JDBC, Go, JavaScript, Python, and C#, alongside a command-line interface and Grafana data-source plugin. Trino runs in Kubernetes or Docker, or as a manually deployed server, and is optimized for cloud and on-premises environments including Amazon, Azure, and Google Cloud. AI functions support OpenAI and Anthropic directly and other models through Ollama, with the language model supplied as an external service. Trino is free under the Apache License 2.0 as self-managed software. It supports multiple authentication and access-control options, but a default installation has no security features enabled.