Apache Drill
6.7#3 in data federation softwareFree planFree planAPILinuxmacOSSelf-hosted
VisitApache Drill vs Trino
What both publish
| Fact | Apache Drill | Trino |
|---|---|---|
| Deployment | Drill can run embedded on a laptop or in distributed mode on a cluster of servers. | Trino can run on Kubernetes, in Docker containers, or through a manually deployed server tarball. |
| Security | Documented security features include Kerberos, username and password authentication, Digest authentication, authorization and user impersonation. | 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 project directs questions to its drill-dev mailing list and welcomes contributions. | The project directs users to Slack for help and GitHub issues for bug reports. |
| What it does | Apache Drill is a schema-free SQL query engine for Hadoop, NoSQL databases, and cloud storage. | Trino is a distributed SQL query engine for querying large datasets across heterogeneous data sources. |
Apache Drill plans
- Apache DrillFree
Trino plans
- Trino open sourceFree
Pick Apache Drill if…
It suits users who want to query raw data across Hadoop, NoSQL, cloud, or local sources, and developers building applications with its REST API. BI users can connect through the listed JDBC and ODBC drivers.
Pick Trino if…
Trino suits data teams querying and combining data across systems for warehousing and analytics. It is not intended for general-purpose relational database or OLTP workloads.