apache/drill

Health v2 · maintenance only

Adoption not part of the score

2022 stars · 990 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

Apache Drill is a distributed MPP (massively parallel processing) SQL query engine for self-describing data such as JSON, Parquet, and other schema-free formats. It queries NoSQL databases, Hadoop, and cloud storage systems directly with ANSI SQL, without requiring schema definition or ETL.

Use cases

• run SQL queries on parquet files without loading them into a database
• query JSON and nested data in MongoDB or HDFS with SQL
• join data across multiple datastores like MongoDB and Hadoop in one query
• connect BI tools like Tableau or Excel to NoSQL data via JDBC/ODBC
• explore schema-free data in S3 or Azure Blob Storage with SQL
• avoid ETL overhead when analyzing multi-structured data

When to choose

• you need SQL over schema-less or evolving data in NoSQL stores, Hadoop, or cloud object storage
• you want to connect existing BI tools to non-relational data via JDBC/ODBC
• you need distributed, federated queries joining multiple data sources
• you want to skip schema creation and data loading before analysis

When to avoid

• your data lives in a traditional relational database with a fixed schema
• you need a lightweight embedded analytics engine for a single application
• you require a modern lakehouse stack with active ecosystem momentum (e.g., Trino, Presto, DuckDB)
• you need real-time streaming analytics rather than batch/interactive SQL

Facets

application · maturity maintenance

database search-engine etl data-science big-data databases analytics jvm windows self-hosted cloud sql-query-engine mpp schema-free hadoop nosql parquet jdbc odbc distributed-query apache-project data-engineering linux macos docker

Member repositories

For agents

markdown · JSON · MCP: product_card(name="apache/drill")