Apache Drill
drill.apache.org
- Free plan
- Windows
- macOS
- Linux
- API
- Self-hosted
What Apache Drill is
Apache Drill is a schema-free SQL query engine for Hadoop, NoSQL databases, and cloud storage. It can query raw data where it resides without first loading it, defining schemas, or transforming it. Its JSON data model supports complex and nested structures, and a single query can join data across multiple datastores. Listed sources include HBase, MongoDB, HDFS, Amazon S3, Azure Blob Storage, Google Cloud Storage, Swift, NAS, and local files. JDBC and ODBC drivers connect Drill to tools such as Tableau, Qlik, MicroStrategy, Spotfire, SAS, and Excel; developers can also use its REST API from custom applications. Drill can run embedded on a laptop or in distributed mode on a server cluster, and the homepage lists Linux, Mac, and Windows support. Documented security options include Kerberos, username and password authentication, Digest authentication, authorization, and user impersonation. The software is free under Apache License 2.0. Official support for Hadoop 2 and Java 8 was dropped with Drill 1.22.0.
Who it suits
Apache Drill may suit data teams that need to query varied raw data sources with SQL, including nested JSON, without preparing schemas first. Developers can also use its REST API, while BI users can connect through JDBC or ODBC.
Good to know, and what to watch
- Queries raw data in place without schema setup
- Joins data from multiple datastores in one query
- Supports JDBC and ODBC connections to BI tools
- Can run embedded or across a server cluster
- Documents authentication, authorization, and impersonation
- Official support for Hadoop 2 was dropped with Drill 1.22.0
- Official support for Java 8 was dropped with Drill 1.22.0
Plans
Every plan and priceApache Drill
Open source
Getting started
- Open the Apache Drill website
- Download the Apache Drill software
- Choose an embedded laptop deployment or distributed cluster deployment
- Run it on Linux, macOS, or Windows
- Connect BI tools through JDBC or ODBC, or use the REST API
Limits to check
Official support for Hadoop 2 and Java 8 ended with Drill 1.22.0. The software is self-hosted, so deployment is handled in your own environment.
The verdict
Drill is built for querying heterogeneous data in place, with SQL access across local, cluster, and cloud sources. Check its support changes for Hadoop 2 and Java 8 against your environment before adopting it.
Questions people ask
Is Apache Drill free?
Yes. The listed Apache Drill plan costs nothing and is open source under Apache License 2.0.
Which platforms does Drill support?
The listed platforms are API, Linux, macOS, self-hosted, and Windows.
Can Drill query multiple sources together?
Yes. A single query can join data from multiple datastores, including the listed Hadoop, NoSQL, cloud, NAS, and local-file sources.
Does Drill provide API access?
Yes. Developers can use its REST API from custom applications.
What security options are documented?
Documentation covers Kerberos, username and password authentication, Digest authentication, authorization, impersonation, and SSL/TLS encryption configuration.
What the maker publishes
- Authentication
- Documented authentication options include Kerberos, username and password through Plain or a custom authenticator, and Digest. source
- Authorization and impersonation
- Drill documents authorization to restrict authenticated users' capabilities and impersonation to run queries on behalf of a client. source
- BI connections
- Drill provides JDBC and ODBC drivers for tools including Tableau, Qlik, MicroStrategy, Spotfire, SAS and Excel. source
- BI integrations
- The site names Tableau, Qlik, MicroStrategy, Spotfire, SAS, and Excel as tools that can connect using Drill's JDBC and ODBC drivers. source
- Complex data
- Its JSON data model supports queries on complex and nested data structures. source
- Cross-source queries
- A single query can join data from multiple datastores. source
- Data sources
- The site lists support for sources including HBase, MongoDB, HDFS, Amazon S3, Azure Blob Storage, Google Cloud Storage, Swift, NAS, and local files. source
- Deployment
- Drill can run embedded on a laptop or in distributed mode on a cluster of servers. source
- Developer API
- Developers can use Drill's REST API in custom applications. source
- Developer interface
- Developers can use Drill's REST API from custom applications. source
- Encryption
- The security documentation describes client-to-drillbit encryption with Kerberos and links to SSL/TLS encryption configuration. source
- Execution features
- The site describes columnar execution, runtime query compilation and recompilation, locality-aware execution, and a cost-based optimizer that can push processing into datastores. source
- License
- The Apache Drill site identifies the project as licensed under the Apache License, Version 2.0. source
- Nested data
- Its JSON data model supports queries on complex and nested data structures. source
- Notable limit
- Official support for Hadoop 2 and Java 8 was dropped with Drill 1.22.0. source
- Operating systems
- The homepage says Drill runs on Mac, Windows, and Linux. source
- Purpose
- Apache Drill is a schema-free SQL query engine for Hadoop, NoSQL and cloud storage. source
- Querying
- It lets users query raw data in place without first loading it, creating schemas or transforming it. source
- Query in place
- Drill lets users query raw data in place without first loading it, creating schemas, or transforming it. source
- Release compatibility
- The download page says official support for Hadoop 2 and Java 8 was dropped with Drill 1.22.0. source
- Security
- Documented security features include Kerberos, username and password authentication, Digest authentication, authorization and user impersonation. source
- Support
- The project directs questions to its drill-dev mailing list and welcomes contributions. source
- What it does
- Apache Drill is a schema-free SQL query engine for Hadoop, NoSQL databases, and cloud storage. source
Checked against the maker's pages on 3 Oct 2026.