Skip to the content
Know your tech before you buy it. Makers: get listed from $49/mo

Apache Drill

drill.apache.org

  • Free plan
  • Windows
  • macOS
  • Linux
  • API
  • Self-hosted
7.9 Club score Visit drill.apache.org

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

Apache Drill

Free

Open source

Getting started

  1. Open the Apache Drill website
  2. Download the Apache Drill software
  3. Choose an embedded laptop deployment or distributed cluster deployment
  4. Run it on Linux, macOS, or Windows
  5. 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.