Apache Drill
6.7#3 in data federation softwareFree planFree planAPILinuxmacOSSelf-hosted
Visit| Fact | Apache Drill | Presto |
|---|---|---|
| Deployment | Drill can run embedded on a laptop or in distributed mode on a cluster of servers. | The documentation describes installing Presto from a server tarball and deploying it with Homebrew, Docker, or Helm. |
| Security | Documented security features include Kerberos, username and password authentication, Digest authentication, authorization and user impersonation. | Documented security options include Kerberos, LDAP, password-file authentication, access control, secure internal communication, and OAuth 2.0 authentication. |
| What it does | Apache Drill is a schema-free SQL query engine for Hadoop, NoSQL databases, and cloud storage. | Presto is a distributed SQL query engine for querying large datasets across heterogeneous data sources. |
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.
Presto suits teams that need SQL access to data held across multiple systems, including those building reports, dashboards, or open lakehouse workloads. Its self-hosted deployment options and range of connectors may fit organizations managing their own data infrastructure.