| --- |
| layout: default |
| permalink: / |
| --- |
| <link href="https://cdnjs.cloudflare.com/ajax/libs/fancybox/2.1.5/jquery.fancybox.min.css" rel="stylesheet" type="text/css"/> |
| <link href="https://cdnjs.cloudflare.com/ajax/libs/slick-carousel/1.5.4/slick.min.css" rel="stylesheet" type="text/css"/> |
| <link href="https://cdnjs.cloudflare.com/ajax/libs/slick-carousel/1.5.4/slick-theme.min.css" rel="stylesheet" type="text/css"/> |
| |
| <script src="https://cdnjs.cloudflare.com/ajax/libs/fancybox/2.1.5/jquery.fancybox.min.js" language="javascript" type="text/javascript"></script> |
| <script src="https://cdnjs.cloudflare.com/ajax/libs/slick-carousel/1.5.4/slick.min.js" language="javascript" type="text/javascript"></script> |
| |
| <link href="{{ site.baseurl }}/css/home.css" rel="stylesheet" type="text/css"/> |
| |
| <script type="text/javascript"> |
| |
| $(document).ready(function() { |
| $(".various").fancybox({ |
| fitToView: true, |
| autoSize: true, |
| beforeLoad: function(){ |
| var url= $(this.element).attr("href"); |
| url = url.replace(new RegExp("watch\\?v=", "i"), 'v/'); |
| url += '?fs=1&autoplay=1'; |
| this.href = url |
| } |
| }); |
| |
| $('div#video-slider').slick({ |
| autoplay: true, |
| autoplaySpeed: 5000, |
| dots: true |
| }); |
| }); |
| |
| </script> |
| |
| <div id="header" class="mw"> |
| |
| <div class="nav-circlepop"> |
| <a class="aLeft prev"><span class="icon-wrap"></span></a> |
| <a class="aRight next"><span class="icon-wrap"></span></a> |
| </div> |
| |
| <div class="dots"></div> |
| <div class="scroller"> |
| <div class="item"> |
| <div class="headlines tc"> |
| <div id="video-slider" class="slider"> |
| <div class="slide"><a class="various fancybox.iframe" href="https://www.youtube.com/embed/UOmlhExchpk"><img src="{{ site.baseurl }}/images/thumbnail-0rurIzOkTIg.jpg" class="thumbnail" /><img src="{{ site.baseurl }}/images/play-mq.png" class="play" /></a><div class="title">Overview of Apache Drill Query Execution</div></div> |
| <div class="slide"><a class="various fancybox.iframe" href="https://www.youtube.com/embed/O6WeniFSa7c"><img src="{{ site.baseurl }}/images/thumbnail-lslA8kDr_jQ.jpg" class="thumbnail" /><img src="{{ site.baseurl }}/images/play-mq.png" class="play" /></a><div class="title">SQL Queries on Parquet Data </div></div> |
| <div class="slide"><a class="various fancybox.iframe" href="https://www.youtube.com/embed/EjxCy7RRUgM"><img src="{{ site.baseurl }}/images/thumbnail-65c42i7Xg7Q.jpg" class="thumbnail" /><img src="{{ site.baseurl }}/images/play-mq.png" class="play" /></a><div class="title">The Rise of the Non-Relational Datastore</div></div> |
| <div class="slide"><a class="various fancybox.iframe" href="https://www.youtube.com/embed/hv_hf_juEiQ"><img src="{{ site.baseurl }}/images/thumbnail-MYY51kiFPTk.jpg" class="thumbnail" /><img src="{{ site.baseurl }}/images/play-mq.png" class="play" /></a><div class="title">Deployment Options and BI Tools</div></div> |
| <div class="slide"><a class="various fancybox.iframe" href="https://www.youtube.com/embed/CGkCvgRwkbs"><img src="{{ site.baseurl }}/images/thumbnail-bhmNbH2yzhM.jpg" class="thumbnail" /><img src="{{ site.baseurl }}/images/play-mq.png" class="play" /></a><div class="title">Connecting to Data Sources</div></div> |
| <div class="slide"><a class="various fancybox.iframe" href="https://www.youtube.com/embed/evQwRwXZaVk"><img src="{{ site.baseurl }}/images/thumbnail-6pGeQOXDdD8.jpg" class="thumbnail" /><img src="{{ site.baseurl }}/images/play-mq.png" class="play" /></a><div class="title">High Performance with a JSON Data Model</div></div> |
| </div> |
| <h1 class="main-headline">Apache Drill</h1> |
| <h2 id="sub-headline">Schema-free SQL Query Engine <br class="mobile-break" />for Hadoop, NoSQL and <br class="mobile-break" />Cloud Storage</h2> |
| <a href="{{ site.baseurl }}/download/" class="download-headline btn btn-1 btn-1c"><span>DOWNLOAD NOW</span></a> |
| </div> |
| </div> |
| </div> |
| |
| </div><!-- header --> |
| <div class="alertbar"> |
| <div class="bookRelease"> |
| <div><i class="fa fa-book fa-lg"></i> |
| <a href="https://urldefense.proofpoint.com/v2/url?u=https-3A__amzn.to_2N6FvPy&d=DwMFaQ&c=cskdkSMqhcnjZxdQVpwTXg&r=JHIio7I3eUbbe91YRxcNOw&m=FVOxmSwXwRbEACbYa-aH38YvJ5_op8yng62tr8g-dOQ&s=gKK9ct8VGg0pm2BRRpLzx2sXXxhW0r3i32wugQwJwdI&e="> Learning |
| Apache Drill</a> |
| </div> |
| </div> |
| <div class="news">News: |
| </div> |
| {% assign post = site.categories.blog[0] %} |
| <div><a href="{{ post.url | prepend: site.baseurl }}">{% if post.news_title %}{{ post.news_title }}{% else %}{{ post.title }}{% endif %}</a><br/><span>({% include authors.html %})</span></div> |
| {% assign post = site.categories.blog[1] %} |
| <div><a href="{{ post.url | prepend: site.baseurl }}">{% if post.news_title %}{{ post.news_title }}{% else %}{{ post.title }}{% endif %}</a><br/><span>({% include authors.html %})</span></div> |
| </div> |
| <div class="mw introWrapper"> |
| <table class="intro" cellpadding="0" cellspacing="0" align="center"> |
| <tbody> |
| <tr> |
| <td class="ag"> |
| <h1>Agility</h1> |
| <p>Get faster insights without the overhead (data loading, schema creation and maintenance, transformations, etc.)</p> |
| </td> |
| <td class="fl"> |
| <h1>Flexibility</h1> |
| <p>Analyze the multi-structured and nested data in non-relational datastores directly without transforming or restricting the data</p> |
| </td> |
| <td class="fam"> |
| <h1>Familiarity</h1> |
| <p>Leverage your existing SQL skillsets and BI tools including Tableau, Qlikview, MicroStrategy, Spotfire, Excel and more</p> |
| </td> |
| </tr> |
| </tbody> |
| </table> |
| </div> |
| |
| <div class="home-row"> |
| <div class="big"><img src="{{ site.baseurl }}/images/home-any.png" style="width:300px" /></div> |
| <div class="description"> |
| <h1>Query any non-relational datastore (well, almost...)</h1> |
| <p>Drill supports a variety of NoSQL databases and file systems, including HBase, MongoDB, MapR-DB, HDFS, MapR-FS, Amazon S3, Azure Blob Storage, Google Cloud Storage, Swift, NAS and local files. A single query can join data from multiple datastores. For example, you can join a user profile collection in MongoDB with a directory of event logs in Hadoop.</p> |
| <p>Drill's datastore-aware optimizer automatically restructures a query plan to leverage the datastore's internal processing capabilities. In addition, Drill supports data locality, so it's a good idea to co-locate Drill and the datastore on the same nodes.</p> |
| </div> |
| <div class="small"><img src="{{ site.baseurl }}/images/home-any.png" style="width:300px" /></div> |
| </div> |
| |
| <div class="home-row"> |
| <div class="description"> |
| <h1>Kiss the overhead goodbye and enjoy data agility</h1> |
| <p>Traditional query engines demand significant IT intervention before data can be queried. Drill gets rid of all that overhead so that users can just query the raw data in-situ. There's no need to load the data, create and maintain schemas, or transform the data before it can be processed. Instead, simply include the path to a Hadoop directory, MongoDB collection or S3 bucket in the SQL query.</p> |
| <p>Drill leverages advanced query compilation and re-compilation techniques to maximize performance without requiring up-front schema knowledge.</p> |
| </div> |
| <div class="small big"><pre>SELECT * FROM <span class="code-underline">dfs.root.`/web/logs`</span>; |
| |
| SELECT country, count(*) |
| FROM <span class="code-underline">mongodb.web.users</span> |
| GROUP BY country; |
| |
| SELECT timestamp |
| FROM <span class="code-underline">s3.root.`clicks.json`</span> |
| WHERE user_id = 'jdoe';</pre></div> |
| </div> |
| |
| <div class="home-row"> |
| <div class="big"><img src="{{ site.baseurl }}/images/home-json.png" style="width:300px" /></div> |
| <div class="description"> |
| <h1>Treat your data like a table even when it's not</h1> |
| <p>Drill features a JSON data model that enables queries on complex/nested data as well as rapidly evolving structures commonly seen in modern applications and non-relational datastores. Drill also provides intuitive extensions to SQL so that you can easily query complex data. |
| <p>Drill is the only columnar query engine that supports complex data. It features an in-memory shredded columnar representation for complex data which allows Drill to achieve columnar speed with the flexibility of an internal JSON document model.</p> |
| </div> |
| <div class="small"><img src="{{ site.baseurl }}/images/home-json.png" style="width:300px" /></div> |
| </div> |
| |
| <div class="home-row"> |
| <div class="description"> |
| <h1>Keep using the BI tools you love</h1> |
| <p>Drill supports standard SQL. Business users, analysts and data scientists can use standard BI/analytics tools such as Tableau, Qlik, MicroStrategy, Spotfire, SAS and Excel to interact with non-relational datastores by leveraging Drill's JDBC and ODBC drivers. Developers can leverage Drill's simple REST API in their custom applications to create beautiful visualizations.</p> |
| <p>Drill's virtual datasets allow even the most complex, non-relational data to be mapped into BI-friendly structures which users can explore and visualize using their tool of choice.</p> |
| </div> |
| <div class="small big"><img src="{{ site.baseurl }}/images/home-bi.png" style="width:300px" /></div> |
| </div> |
| |
| <div class="home-row"> |
| <div class="big"><pre>$ curl -L "<url>" | tar xzf - |
| $ cd apache-drill-<version> |
| $ bin/drill-embedded</pre></div> |
| <div class="description"> |
| <h1>Scale from one laptop to 1000s of servers</h1> |
| <p>We made it easy to download and run Drill on your laptop. It runs on Mac, Windows and Linux, and within a minute or two you'll be exploring your data. When you're ready for prime time, deploy Drill on a cluster of commodity servers and take advantage of the world's most scalable and high performance execution engine. |
| <p>Drill's symmetrical architecture (all nodes are the same) and simple installation make it easy to deploy and operate very large clusters.</p> |
| </div> |
| <div class="small"><pre>$ curl <url> -o drill.tgz |
| $ tar xzf drill.tgz |
| $ cd apache-drill-<version> |
| $ bin/drill-embedded</pre></div> |
| </div> |
| |
| <div class="home-row"> |
| <div class="description"> |
| <h1>No more waiting for coffee</h1> |
| <p>Drill isn't the world's first query engine, but it's the first that combines both flexibility and speed. To achieve this, Drill features a radically different architecture that enables record-breaking performance without sacrificing the flexibility offered by the JSON document model. Drill's design includes:<ul> |
| <li>Columnar execution engine (the first ever to support complex data!)</li> |
| <li>Data-driven compilation and recompilation at execution time</li> |
| <li>Specialized memory management that reduces memory footprint and eliminates garbage collections</li> |
| <li>Locality-aware execution that reduces network traffic when Drill is co-located with the datastore</li> |
| <li>Advanced cost-based optimizer that pushes processing into the datastore when possible</li></ul></p> |
| </div> |
| <div class="small big"><img src="{{ site.baseurl }}/images/home-coffee.jpg" style="width:300px" /></div> |
| </div> |
