index.html

---
layout: default
permalink: /
---
<link href="{{ site.baseurl }}/css/home.css" rel="stylesheet" type="text/css"/>

<!-- HERO -->
<section class="h-hero">
  <div class="in">
    <div>
      <h1><em>SQL on the data</em> you already have</h1>
      <p class="sub">Apache Drill is a distributed SQL engine for files, object storage and
        NoSQL databases. Point it at a directory, a bucket or a collection and query it in
        place, with nothing loaded and no schema declared.</p>
      <div class="acts">
        <a class="h-btn" href="{{ site.baseurl }}/download/">Download {{ site.data.version.display_version }}</a>
        <a class="h-btn sec" href="{{ site.baseurl }}/docs/">Read the documentation</a>
      </div>
      <p class="meta">Released {{ site.data.version.release_date }} &middot; Mac, Linux and Windows &middot;
        <a href="https://www.apache.org/licenses/">Apache License 2.0</a></p>
    </div>

    <div>
      <div class="h-ui" data-ui>
        <div class="bar">
          <b>Drill</b>
          <span class="on">Query</span><span>Profiles</span><span>Storage</span><span>Metrics</span>
          <span class="src" id="drill-src">s3</span>
        </div>
        <div id="drill-pane" aria-live="polite">
          <!-- The first example is rendered server-side so the console is never
               empty if js/home.js fails or is blocked. The script replaces it. -->
          <div class="pane">
            <div class="ed">
<pre><span class="cm">-- a prefix full of JSON. no table, no schema</span>
<span class="kw">SELECT</span> country, <span class="kw">count</span>(*) <span class="kw">AS</span> hits
<span class="kw">FROM</span>   <span class="pa">s3.`logs/2025/*.json`</span>
<span class="kw">GROUP BY</span> country <span class="kw">ORDER BY</span> 2 <span class="kw">DESC</span>;</pre>
              <div class="run"><button type="button">Run</button><em>Completed in 1.41 s</em></div>
            </div>
            <table>
              <thead><tr><th>country</th><th class="n">hits</th></tr></thead>
              <tbody>
                <tr><td>United States</td><td class="n">418,203</td></tr>
                <tr><td>India</td><td class="n">233,944</td></tr>
                <tr><td>Germany</td><td class="n">96,510</td></tr>
              </tbody>
            </table>
            <div class="foot">822,845 records scanned &middot; 1.41 s &middot; 6 minor fragments</div>
          </div>
        </div>
      </div>
      <div class="h-car">
        <div class="tabs" role="tablist" aria-label="Data source examples"></div>
        <button class="pause" type="button" id="drill-pause" aria-label="Pause the examples">
          <svg viewBox="0 0 12 12" fill="currentColor" aria-hidden="true"><rect x="2" y="1.5" width="3" height="9" rx="1"/><rect x="7" y="1.5" width="3" height="9" rx="1"/></svg>
        </button>
      </div>
    </div>
  </div>
</section>

<!-- USED IN PRODUCTION -->
<section class="h-logos">
  <div class="h-wrap">
    <h2>Used in production</h2>
    <div class="grid">
      <img class="lg" src="{{ site.baseurl }}/images/logos/erricssonLogo.png" alt="Ericsson" loading="lazy">
      <img class="sm" src="{{ site.baseurl }}/images/logos/intuitLogo.png" alt="Intuit" loading="lazy">
      <img class="sm" src="{{ site.baseurl }}/images/logos/transunionLogo.png" alt="TransUnion" loading="lazy">
      <img src="{{ site.baseurl }}/images/logos/antFinancialLogo.png" alt="Ant Financial" loading="lazy">
      <img src="{{ site.baseurl }}/images/logos/redbusLogo.png" alt="RedBus" loading="lazy">
      <img src="{{ site.baseurl }}/images/logos/sanchezLogo.png" alt="Sanchez Energy" loading="lazy">
      <img class="lg" src="{{ site.baseurl }}/images/logos/IORA_NUS.png" alt="IORA, NUS" loading="lazy">
    </div>
    <p class="more"><a class="h-btn sec" href="{{ site.baseurl }}/poweredBy/">See how they use Drill</a></p>
  </div>
</section>

<!-- THREE UP -->
<section class="h-sec">
  <div class="h-wrap">
    <div class="h-three">
      <div class="h-rz">
        <h3>Agility</h3>
        <p>No data loading, no schema creation and maintenance, no transformations standing
          between a question and an answer.</p>
      </div>
      <div class="h-rz">
        <h3>Flexibility</h3>
        <p>Query multi-structured and nested data in non-relational stores directly, without
          flattening or restricting it first.</p>
      </div>
      <div class="h-rz">
        <h3>Familiarity</h3>
        <p>ANSI SQL:2003 with ODBC and JDBC drivers, so existing skills and BI tools work
          unchanged.</p>
      </div>
    </div>
  </div>
</section>

<!-- POINT AND QUERY -->
<section class="h-sec h-plugs" style="border-bottom:0">
  <div class="h-wrap">
    <div class="h-head h-rz">
      <h2>Point and query</h2>
      <p>Traditional SQL-on-Hadoop engines need the data prepared before anyone can ask a
        question. Drill removes those steps rather than automating them.</p>
    </div>
    <table class="h-cmp h-rz">
      <thead>
        <tr><th></th><th class="drill">Apache Drill</th><th>Hive, Impala and similar</th></tr>
      </thead>
      <tbody>
        <tr><td>User experience</td>
            <td class="drill">Point and query</td>
            <td>Ingest the data, define schemas, maintain them, then query</td></tr>
        <tr><td>Use case</td>
            <td class="drill">Self-service, in-situ, SQL-based analytics</td>
            <td>Data warehouse offload</td></tr>
        <tr><td>Data sources</td>
            <td class="drill">Files, object storage, NoSQL and relational databases, several at once in one query</td>
            <td>A single Hadoop cluster</td></tr>
        <tr><td>Data model</td>
            <td class="drill">Schema-free JSON, the same model as MongoDB</td>
            <td>Relational, fixed schema</td></tr>
      </tbody>
    </table>
  </div>
</section>

<!-- NESTED DATA -->
<section class="h-sec">
  <div class="h-wrap h-split">
    <div class="h-rz">
      <h2 style="font-size:clamp(1.6rem,1rem + 1.8vw,2.3rem);font-weight:600;letter-spacing:-.022em;margin:0">Nested data stays nested</h2>
      <p style="color:var(--muted);margin-top:16px;font-size:17px">Drill is the only columnar
        execution engine that handles complex, schema-free data. Documents are shredded into an
        in-memory columnar representation, so nested JSON runs at columnar speed without being
        flattened first.</p>
      <ul>
        <li>Queries compile and recompile at runtime, so performance does not depend on knowing
          the shape of the data in advance.</li>
        <li>Vectorised execution using the SIMD instructions in modern processors.</li>
        <li>Memory is managed off-heap, so long queries are not interrupted by garbage collection.</li>
        <li>A cost-based optimizer pushes filters and projections down into the source.</li>
      </ul>
    </div>
    <div class="h-code h-rz">
<pre><span class="cm">-- reach into a nested document without flattening it</span>
<span class="kw">SELECT</span> t.payload.device.os     <span class="kw">AS</span> os,
       t.payload.device.model  <span class="kw">AS</span> model,
       <span class="kw">count</span>(*)                <span class="kw">AS</span> sessions
<span class="kw">FROM</span>   <span class="pa">dfs.`/events/2025/*.json`</span> t
<span class="kw">WHERE</span>  t.payload.app.version &gt; '4.2'
<span class="kw">GROUP BY</span> 1, 2
<span class="kw">ORDER BY</span> 3 <span class="kw">DESC</span>;

<span class="cm">-- join a Mongo collection to a directory of logs</span>
<span class="kw">SELECT</span> u.plan, <span class="kw">sum</span>(e.bytes)
<span class="kw">FROM</span>   <span class="pa">mongo.web.users</span> u
<span class="kw">JOIN</span>   <span class="pa">dfs.`/events/`</span> e <span class="kw">ON</span> e.uid = u._id
<span class="kw">GROUP BY</span> u.plan;</pre>
    </div>
  </div>
</section>

<!-- DATA SOURCES -->
<section class="h-sec h-plugs" id="data-sources">
  <div class="h-wrap">
    <div class="h-head h-rz">
      <h2>Every data source in the distribution</h2>
      <p>Storage plugins and format readers ship with Drill. Adding one that is not here is a
        Java class and a JSON configuration; many of these were contributed that way.</p>
    </div>
    <div class="cols">
      <div class="g">
        <h3>File systems and object stores</h3>
        <a href="{{ site.baseurl }}/docs/file-system-storage-plugin/">Local files and NAS <code>dfs</code></a>
        <a href="{{ site.baseurl }}/docs/file-system-storage-plugin/">HDFS <code>dfs</code></a>
        <a href="{{ site.baseurl }}/docs/s3-storage-plugin/">Amazon S3 <code>s3</code></a>
        <a href="{{ site.baseurl }}/docs/azure-blob-storage-plugin/">Azure Blob Storage <code>azure</code></a>
        <a href="{{ site.baseurl }}/docs/file-system-storage-plugin/">Google Cloud Storage <code>gcs</code></a>
        <a href="{{ site.baseurl }}/docs/oci-os-storage-plugin/">Oracle Cloud Object Storage <code>oci</code></a>
        <a href="{{ site.baseurl }}/docs/dropbox-storage-plugin/">Dropbox <code>dfs</code></a>
      </div>
      <div class="g">
        <h3>Non-relational stores</h3>
        <a href="{{ site.baseurl }}/docs/mongodb-storage-plugin/">MongoDB <code>mongo</code></a>
        <a href="{{ site.baseurl }}/docs/hbase-storage-plugin/">Apache HBase <code>hbase</code></a>
        <a href="{{ site.baseurl }}/docs/connect-a-data-source/">Apache Accumulo <code>accumulo</code></a>
        <a href="{{ site.baseurl }}/docs/cassandra-storage-plugin/">Apache Cassandra <code>cassandra</code></a>
        <a href="{{ site.baseurl }}/docs/connect-a-data-source/">Apache Kudu <code>kudu</code></a>
        <a href="{{ site.baseurl }}/docs/connect-a-data-source/">Apache Phoenix <code>phoenix</code></a>
        <a href="{{ site.baseurl }}/docs/druid-storage-plugin/">Apache Druid <code>druid</code></a>
        <a href="{{ site.baseurl }}/docs/elasticsearch-plugin/">Elasticsearch <code>elastic</code></a>
        <a href="{{ site.baseurl }}/docs/kafka-storage-plugin/">Apache Kafka <code>kafka</code></a>
        <a href="{{ site.baseurl }}/docs/opentsdb-storage-plugin/">OpenTSDB <code>openTSDB</code></a>
        <a href="{{ site.baseurl }}/docs/splunk-storage-plugin/">Splunk <code>splunk</code></a>
      </div>
      <div class="g">
        <h3>Databases and services</h3>
        <a href="{{ site.baseurl }}/docs/hive-storage-plugin/">Apache Hive <code>hive</code></a>
        <a href="{{ site.baseurl }}/docs/rdbms-storage-plugin/">Any JDBC database <code>jdbc</code></a>
        <a href="{{ site.baseurl }}/docs/http-storage-plugin/">REST APIs <code>http</code></a>
        <a href="{{ site.baseurl }}/docs/google-sheets-plugin/">Google Sheets <code>googlesheets</code></a>
        <a href="{{ site.baseurl }}/docs/connect-a-data-source/">Another Drill cluster <code>drill</code></a>
      </div>
      <div class="g">
        <h3>Table formats</h3>
        <a href="{{ site.baseurl }}/docs/parquet-format/">Parquet <code>parquet</code></a>
        <a href="{{ site.baseurl }}/docs/data-sources-and-file-formats/">Apache Avro <code>avro</code></a>
        <a href="{{ site.baseurl }}/docs/data-sources-and-file-formats/">Delta Lake <code>delta</code></a>
        <a href="{{ site.baseurl }}/docs/data-sources-and-file-formats/">Apache Iceberg <code>iceberg</code></a>
        <a href="{{ site.baseurl }}/docs/data-sources-and-file-formats/">Apache Paimon <code>paimon</code></a>
        <a href="{{ site.baseurl }}/docs/mapr-db-format/">MapR-DB and Streams <code>maprdb</code></a>
      </div>
      <div class="g">
        <h3>Documents and text</h3>
        <a href="{{ site.baseurl }}/docs/json-data-model/">JSON <code>json</code></a>
        <a href="{{ site.baseurl }}/docs/text-files-csv-tsv-psv/">CSV, TSV and PSV <code>text</code></a>
        <a href="{{ site.baseurl }}/docs/data-sources-and-file-formats/">XML <code>xml</code></a>
        <a href="{{ site.baseurl }}/docs/data-sources-and-file-formats/">Excel <code>excel</code></a>
        <a href="{{ site.baseurl }}/docs/data-sources-and-file-formats/">PDF tables <code>pdf</code></a>
        <a href="{{ site.baseurl }}/docs/data-sources-and-file-formats/">Microsoft Access <code>msaccess</code></a>
        <a href="{{ site.baseurl }}/docs/data-sources-and-file-formats/">LTSV <code>ltsv</code></a>
      </div>
      <div class="g">
        <h3>Logs and packets</h3>
        <a href="{{ site.baseurl }}/docs/data-sources-and-file-formats/">Log files, any format <code>logRegex</code></a>
        <a href="{{ site.baseurl }}/docs/data-sources-and-file-formats/">HTTPD and NGINX logs <code>httpd</code></a>
        <a href="{{ site.baseurl }}/docs/data-sources-and-file-formats/">Syslog <code>syslog</code></a>
        <a href="{{ site.baseurl }}/docs/data-sources-and-file-formats/">PCAP and PCAP-NG <code>pcap</code></a>
      </div>
      <div class="g">
        <h3>Scientific and spatial</h3>
        <a href="{{ site.baseurl }}/docs/data-sources-and-file-formats/">SAS <code>sas</code></a>
        <a href="{{ site.baseurl }}/docs/data-sources-and-file-formats/">SPSS <code>spss</code></a>
        <a href="{{ site.baseurl }}/docs/data-sources-and-file-formats/">HDF5 <code>hdf5</code></a>
        <a href="{{ site.baseurl }}/docs/data-sources-and-file-formats/">Esri shapefiles <code>shp</code></a>
        <a href="{{ site.baseurl }}/docs/data-sources-and-file-formats/">Apache Daffodil <code>daffodil</code></a>
        <a href="{{ site.baseurl }}/docs/data-sources-and-file-formats/">Image metadata <code>image</code></a>
      </div>
    </div>
    <p class="note h-rz"><a href="{{ site.baseurl }}/docs/connect-a-data-source/">How to configure a storage plugin &rarr;</a></p>
  </div>
</section>

<!-- GET STARTED -->
<section class="h-sec h-start">
  <div class="h-wrap in">
    <div class="h-rz">
      <h2>Running in two minutes</h2>
      <p>Download the tarball, unpack it and start Drill in embedded mode. It runs on a laptop
        and on a cluster of thousands of nodes with the same symmetrical architecture.</p>
      <div class="acts">
        <a class="h-btn" href="{{ site.baseurl }}/download/">Download {{ site.data.version.display_version }}</a>
        <a class="h-btn sec" href="{{ site.baseurl }}/docs/getting-started/">Getting started guide</a>
      </div>
    </div>
    <div class="box h-rz">
<pre>$ tar xzf apache-drill-{{ site.data.version.full_version }}.tar.gz
$ cd apache-drill-{{ site.data.version.full_version }}
$ bin/drill-embedded

<span class="ps">apache drill&gt;</span> <span class="kw">SELECT</span> * <span class="kw">FROM</span> <span class="pa">dfs.`~/Downloads/*.csv`</span> <span class="kw">LIMIT</span> 3;
<span class="cm">-- nothing was loaded to make that work</span></pre>
    </div>
  </div>
</section>

<script src="{{ site.baseurl }}/js/home.js"></script>