Apache Drill

Input—per 1M tokens

Output—per 1M tokens

Context—tokens

WeightsClosed

About

Apache Drill is ranked #4 of 30 in SQL query tools on Inferse. It runs on API, Linux, macOS, Self-hosted, Windows. There is a free plan.

Compared on SQL query tools

Self-hosted: Yesdrill.apache.org
SQL querying: Yesdrill.apache.org
API access: Yesdrill.apache.org

Facts

What it does: Apache Drill is a schema-free SQL query engine for Hadoop, NoSQL databases, and cloud storage.drill.apache.org · 3 Oct 2026
Query in place: Drill lets users query raw data in place without first loading it, creating schemas, or transforming it.drill.apache.org · 3 Oct 2026
Nested data: Its JSON data model supports queries on complex and nested data structures.drill.apache.org · 3 Oct 2026
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.drill.apache.org · 3 Oct 2026
Cross-source queries: A single query can join data from multiple datastores.drill.apache.org · 3 Oct 2026
BI integrations: The site names Tableau, Qlik, MicroStrategy, Spotfire, SAS, and Excel as tools that can connect using Drill's JDBC and ODBC drivers.drill.apache.org · 3 Oct 2026
Developer interface: Developers can use Drill's REST API from custom applications.drill.apache.org · 3 Oct 2026
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.drill.apache.org · 3 Oct 2026
Deployment: Drill can run embedded on a laptop or in distributed mode on a cluster of servers.drill.apache.org · 3 Oct 2026
Operating systems: The homepage says Drill runs on Mac, Windows, and Linux.drill.apache.org · 3 Oct 2026
Authentication: Documented authentication options include Kerberos, username and password through Plain or a custom authenticator, and Digest.drill.apache.org · 3 Oct 2026
Authorization and impersonation: Drill documents authorization to restrict authenticated users' capabilities and impersonation to run queries on behalf of a client.drill.apache.org · 3 Oct 2026
Encryption: The security documentation describes client-to-drillbit encryption with Kerberos and links to SSL/TLS encryption configuration.drill.apache.org · 3 Oct 2026
License: The Apache Drill site identifies the project as licensed under the Apache License, Version 2.0.drill.apache.org · 3 Oct 2026
Release compatibility: The download page says official support for Hadoop 2 and Java 8 was dropped with Drill 1.22.0.drill.apache.org · 3 Oct 2026
Purpose: Apache Drill is a schema-free SQL query engine for Hadoop, NoSQL and cloud storage.drill.apache.org · 3 Oct 2026
Querying: It lets users query raw data in place without first loading it, creating schemas or transforming it.drill.apache.org · 3 Oct 2026
Complex data: Its JSON data model supports queries on complex and nested data structures.drill.apache.org · 3 Oct 2026
BI connections: Drill provides JDBC and ODBC drivers for tools including Tableau, Qlik, MicroStrategy, Spotfire, SAS and Excel.drill.apache.org · 3 Oct 2026
Developer API: Developers can use Drill's REST API in custom applications.drill.apache.org · 3 Oct 2026
Security: Documented security features include Kerberos, username and password authentication, Digest authentication, authorization and user impersonation.drill.apache.org · 3 Oct 2026
Support: The project directs questions to its drill-dev mailing list and welcomes contributions.drill.apache.org · 3 Oct 2026
Notable limit: Official support for Hadoop 2 and Java 8 was dropped with Drill 1.22.0.drill.apache.org · 3 Oct 2026