Apache Drill
Schema-free SQL query engine for Hadoop, NoSQL and cloud storage
Apache Drill is a schema-free SQL query engine for Hadoop, NoSQL databases and cloud object storage. It lets users query raw data in place without loading it into a separate system, defining schemas in advance, or performing transformations. Queries can reference paths to Hadoop directories, MongoDB collections or S3 buckets, and a single query can join data from multiple datastores.
Drill supports standard SQL and a JSON data model for complex and nested data, with SQL extensions for querying structures that evolve over time. It includes a columnar execution engine, data-driven compilation and recompilation at execution time, specialized memory management, locality-aware execution, and a cost-based optimizer that can push processing into the datastore. It connects to BI tools such as Tableau, Qlik, MicroStrategy, Spotfire, SAS and Excel through JDBC and ODBC drivers, and exposes a REST API for custom applications. Virtual datasets map complex non-relational data into BI-friendly structures.
Drill runs on Mac, Windows and Linux, from an embedded mode on a laptop to clusters of commodity servers. It is distributed under the Apache License, Version 2.0.
12 alternatives to Apache Drill
Ranked by how well each tool replaces Apache Drill: shared features, audience, price and popularity.
Open source, native analytic database for open data and table formats.
Covers 1 of 10 key features.
Open source61 out of 100 match—A schema-less document database that creates and optimizes its own indexes, with AI and RQ
Covers 1 of 10 key features.
Free planOpen source60 out of 100 matchFree- 59 out of 100 match$30/mo
A scalable, open source Big Data Management System (BDMS) for storing, indexing and semi-.
Covers 1 of 10 key features.
Open source59 out of 100 match—Open-source NoSQL database for large-scale data.
Covers 0 of 10 key features.
Free planOpen source59 out of 100 matchFreeProfessional database management software for 100+ data sources
Covers 1 of 10 key features.
Free planOpen source58 out of 100 matchContact salesOpen-source database solutions from the Apache Software Foundation
Covers 0 of 10 key features.
Open source58 out of 100 matchFree- 58 out of 100 matchUsage-based
Distributed data warehouse for massive-scale analytics.
Covers 2 of 10 key features.
Open source57 out of 100 match—Free open-source database client for Windows, Linux and macOS
Covers 0 of 10 key features.
Free planOpen source57 out of 100 matchFreeAccurate, fast, and secure data access for AI and digital experiences.
Covers 2 of 10 key features.
Free plan57 out of 100 match$5/mo