# Install apache-drill with Homebrew, apt, Nix Schema-free SQL Query Engine for Hadoop, NoSQL and Cloud Storage. Version 1.22.0 via Homebrew; verified 2026-06-28. ## Install ```sh sudo av install brew:apache-drill ``` Additional install commands: ### macOS - Homebrew (100%): ```sh brew install apache-drill ``` Evidence: local Homebrew formula metadata ### Linux - Debian apt (92%): ```sh sudo apt install sqlline ``` Evidence: Debian stable package indexes: sqlline from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz - Nix (92%): ```sh nix profile install nixpkgs#sqlline ``` Evidence: nixpkgs package indexes: pkgs/by-name/sq/sqlline/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1 ## Package facts - **Package key:** brew:apache-drill - **Package manager:** Homebrew - **Package manager page:** - **Version:** 1.22.0 - **Source summary:** Schema-free SQL Query Engine for Hadoop, NoSQL and Cloud Storage - **Homepage:** - **Repository:** - **Upstream docs:** - **License:** Apache-2.0 - **Source archive:** - **Last updated:** 2026-06-28T00:38:43-04:00 - **Generated:** 2026-07-08T07:18:31+00:00 ## Executables - auto-setup.sh (cli) - drill-am.sh (cli) - drill-conf (cli) - drill-config.sh (cli) - drill-embedded (cli) - drill-localhost (cli) - drill-on-yarn.sh (cli) - drillbit.sh (cli) - runbit (cli) - sqlline (cli) - submit_plan (cli) - yarn-drillbit.sh (cli) - auto-setup.sh (alias) - drill-am.sh (alias) - drill-conf (alias) - drill-config.sh (alias) - drill-embedded (alias) - drill-localhost (alias) - drill-on-yarn.sh (alias) - drillbit.sh (alias) - runbit (alias) - sqlline (alias) - submit_plan (alias) - yarn-drillbit.sh (alias) ## Dependencies - openjdk@21 ## Install behavior - Post-install hook: not defined - Bottle: available on all ## Freshness - Page generated: 2026-07-08 - Package-manager version: 1.22.0 - Package-manager updated: 2026-06-28 - Local data: ok - Upstream repository: https://drill.apache.org - info: Release/tag comparison is only available for GitHub repositories. ## Project history and usage Apache Drill is a distributed SQL query engine for self-describing data, aimed at interactive analysis over Hadoop, NoSQL systems, cloud object stores, files, and other semi-structured sources without forcing users to predefine schemas. ### Project history Drill was created in the Apache ecosystem as an implementation inspired by Google's Dremel paper and entered the Apache Incubator in 2012. The project graduated as an Apache top-level project in November 2014, with ASF materials emphasizing both the Dremel lineage and the goal of letting analysts query large, changing datasets directly. The 1.0 release followed in May 2015. By then Drill was positioned as a self-service SQL layer for Hadoop, HBase, NoSQL, and files, with ordinary SQL clients, JDBC/ODBC tooling, and the bundled sqlline shell acting as the day-to-day interface. ### Adoption history ASF's top-level project announcement described a community with contributors from MapR, Hortonworks, Pentaho, Cisco, and others. Its adoption pitch was less about replacing a warehouse and more about shortening the path from raw data to exploratory SQL, especially where schemas were late-binding or data lived outside a single database. Drill's package-manager appeal comes from that same shape: install a JVM-based query layer, point storage plugins at local files, HDFS, S3, MongoDB, HBase, Hive, Kafka, and similar systems, then query them from a shell or BI client without running a separate ingestion pipeline first. ### How it is used The Homebrew package exposes Drill launch and helper scripts such as drill-embedded, drill-localhost, drillbit.sh, and sqlline. In practice, package users tend to start with embedded or localhost mode for local file and object-store exploration, then move configuration into drill-override.conf for distributed or secured deployments. Drill configuration is split between the HOCON-style drill-override.conf and environment overrides such as drill-env.sh. Apache's docs state that Drill loads these from /etc/drill/conf when present, otherwise from $DRILL_HOME/conf, which matches the Unix paths useful to package maintainers. ### Why package nerds care Drill is interesting to package nerds because it ships as a large Java data system but still offers a concrete CLI workflow: install it, run sqlline or drill-embedded, and query local JSON, Parquet, CSV, or remote systems through storage plugins. The package boundary matters because Java version, config directory, launch scripts, and optional native clients can all affect the first five minutes. It also represents the Hadoop-era style of packaging: a tarball-style distribution with $DRILL_HOME, conf files, shell wrappers, and cluster-oriented defaults, wrapped by Homebrew into something developers can run locally. ### Timeline - 2012: Drill enters the Apache Incubator. - 2014: Drill graduates as an Apache top-level project. - 2015: Apache Drill 1.0 is announced. - 2025: Apache Drill 1.22.0 appears in the official release notes index. ### Related projects - Google Dremel is the research system that inspired Drill's interactive, nested-data SQL direction. - Apache Calcite, Hadoop, Hive, HBase, Parquet, Kafka, MongoDB, and cloud object stores are common neighboring technologies in Drill deployments. ### Sources - - - - ## Security Notes broad file, network, media, or database tool signal. infrastructure mutation or orchestration signal. - **Geiger risk:** orange / medium - broad file, network, media, or database tool signal - infrastructure mutation or orchestration signal ## Configuration and credential file locations These source-backed paths show where this package keeps local settings or durable credentials. Automic Vault can use them as review targets for secret scanning, migration, and command approval. ## Configuration files - Unix: /etc/drill/conf/drill-override.conf, /etc/drill/conf/drill-env.sh, $DRILL_HOME/conf/drill-override.conf, $DRILL_HOME/conf/drill-env.sh ## Source Database Details - **Source Database:** Homebrew formula API - **Tap:** homebrew/core - **Full Name:** apache-drill - **Version Scheme:** 0 - **Revision:** 0 - **Bottle Stable Root URL:** - **Deprecated:** no - **Disabled:** no - **Keg Only:** no - **URL Keys:** stable ## Other Package-Manager Records - Debian apt - sqlline - 1.0.2-9: installed executable or alias match | Debian stable package indexes: sqlline from https://deb.debian.org/debian/dists/stable/main/binary-amd64/Packages.xz | JDBC command-line utility for issuing SQL | https://sqlline.sourceforge.net - Nix - sqlline: installed executable or alias match | nixpkgs package indexes: pkgs/by-name/sq/sqlline/package.nix from https://api.github.com/repos/NixOS/nixpkgs/git/trees/master?recursive=1 - Ubuntu apt - sqlline - 1.0.2-8: installed executable or alias match | Ubuntu 24.04 LTS package indexes: sqlline from https://archive.ubuntu.com/ubuntu/dists/noble/universe/binary-amd64/Packages.gz | JDBC command-line utility for issuing SQL | http://sqlline.sourceforge.net ## Related links - [Secret-risk packages](https://www.automicvault.com/pkg/secret-risk-packages/) - Has protected-tool coverage, approval-gate, or non-low Geiger security signals. - [Terminal utility packages](https://www.automicvault.com/pkg/terminal-utilities/) - Matched terminal and command-line workflow metadata. - [Text processing packages](https://www.automicvault.com/pkg/text-processing-tools/) - Matched text, document, or structured-data processing metadata. - [Networking and protocol packages](https://www.automicvault.com/pkg/networking-protocol-tools/) - Matched network, protocol, or remote-service metadata. - [openjdk@21](https://www.automicvault.com/pkg/brew/openjdk-21/) - Runtime dependency declared by Homebrew. - [anyquery](https://www.automicvault.com/pkg/brew/anyquery/) - Shares av.db curated category or tags: cli, data, query-engine, query-engines, sql. - [prestodb](https://www.automicvault.com/pkg/brew/prestodb/) - Shares av.db curated category or tags: big-data, cli, data, query-engines, sql. - [trino](https://www.automicvault.com/pkg/brew/trino/) - Shares av.db curated category or tags: big-data, cli, data, query-engine, sql. - [datafusion](https://www.automicvault.com/pkg/brew/datafusion/) - Shares av.db curated category or tags: cli, data, query-engine, sql. - [hive](https://www.automicvault.com/pkg/brew/hive/) - Shares av.db curated category or tags: big-data, cli, data, sql. - [apache-arrow](https://www.automicvault.com/pkg/brew/apache-arrow/) - Shares av.db curated category or tags: apache, cli, data. - [apache-flink](https://www.automicvault.com/pkg/brew/apache-flink/) - Shares av.db curated category or tags: apache, cli, data. - [apache-flink-cdc](https://www.automicvault.com/pkg/brew/apache-flink-cdc/) - Shares av.db curated category or tags: apache, cli, data. - [apache-spark](https://www.automicvault.com/pkg/brew/apache-spark/) - Package names and metadata indicate a similar tool family. Shared terms: apache, cli, data, engine, openjdk. ## Combined YAML source View the package source record on GitHub. [combined/apache-drill.yml](https://github.com/automic-vault/db/blob/main/combined/apache-drill.yml) ## Sources - Nucleus package database - Geiger risk classifier - package-page enrichment - curated configuration and credential file locations - curated package history - package version freshness - av.db category and tag curation - package relationship graph - external package-manager database matches - cross-ecosystem install command graph