Added: websites/staging/drill/trunk/content/drill/team/index.html ============================================================================== --- websites/staging/drill/trunk/content/drill/team/index.html (added) +++ websites/staging/drill/trunk/content/drill/team/index.html Tue Nov 11 05:54:32 2014 @@ -0,0 +1,120 @@ +<!DOCTYPE html> +<html> + +<head> + +<meta charset="UTF-8"> + + +<title>Team - Apache Drill</title> + +<link href="/drill/css/syntax.css" rel="stylesheet" type="text/css"> +<link href="/drill/css/style.css" rel="stylesheet" type="text/css"> +<link href="/drill/css/arrows.css" rel="stylesheet" type="text/css"> +<link href="/drill/css/button.css" rel="stylesheet" type="text/css"> + +<link rel="shortcut icon" href="/drill/favicon.ico" type="image/x-icon"> +<link rel="icon" href="/drill/favicon.ico" type="image/x-icon"> + +<script language="javascript" type="text/javascript" src="/drill/js/lib/jquery-1.11.1.min.js"></script> +<script language="javascript" type="text/javascript" src="/drill/js/lib/jquery.easing.1.3.js"></script> +<script language="javascript" type="text/javascript" src="/drill/js/modernizr.custom.js"></script> +<script language="javascript" type="text/javascript" src="/drill/js/script.js"></script> + +</head> + +<body onResize="resized();"> + +<div class="bui"></div> + +<div id="search"> +<input type="text" placeholder="Enter search term here"> +</div> + +<div id="menu" class="mw"> +<ul> + <li class="logo"><a href="/drill/"></a></li> + <li> + <a href="/drill/overview/">Documentation</a> + <ul> + <li><a href="/drill/overview/">Overview </a></li> + <li><a href="https://cwiki.apache.org/confluence/display/DRILL/Apache+Drill+in+10+Minutes"; target="_blank">Drill in 10 Minutes</a></li> + <li><a href="/drill/why/">Why Drill? </a></li> + <li><a href="/drill/architecture/">Architecture</a></li> + </ul> + </li> + <li> + <a href="/drill/community/">Community</a> + <ul> + <li><a href="/drill/team/">Team</a></li> + <li><a href="/drill/community/#events">Events and Meetups</a></li> + <li><a href="/drill/community/#mailinglists">Mailing Lists</a></li> + <li><a href="/drill/community/#getinvolved">Get Involved</a></li> + <li><a href="https://issues.apache.org/jira/browse/DRILL/"; target="_blank">Issue Tracker</a></li> + <li><a href="https://github.com/apache/incubator-drill"; target="_blank">GitHub</a></li> + </ul> + </li> + <li><a href="/drill/faq/">FAQ</a></li> + <li><a href="http://drill-user.org"; target="_blank">Blog</a></li> + <li style="width:30px; padding-left: 2px; padding-right:10px"><a href="https://twitter.com/apachedrill"; target="_blank"><img src="/drill/images/twitterbw.png" alt="" align="center" width="22" style="padding: 0px 10px 1px 0px;"></a> </li> + <li class="l"><span> </span></li> + <li class="d"><a href="/drill/download/">Download</a></li> +</ul> +</div> + +<div class="int_title"> +<h1>Team</h1> + +</div> + +<div class="int_text" align="left"> <p> + Apache Drill developer community now has a growing set of committers and over 40 contributors from different companies and universities. + Prominent Drill contributions today come from MapR Technologies, LinkedIn, Hortonworks, University of Wisconsin Madison, Pentaho and Cisco. <br><br> + <a href="https://cwiki.apache.org/confluence/display/DRILL/Apache+Drill+Contribution+Guidelines?from=iZHHAg";>Click here</a> if you are interested in contributing to the development of Drill. + </p> + <p><strong>Current list of Drill committers:</strong></p> + <p> +<strong>Jacques Nadeau</strong> <jacques at apache dot org> +<br><strong>Tomer Shiran</strong> <tshiran at apache dot org> +<br><strong>Ted Dunning</strong> <tdunning at apache dot org> +<br><strong>Jason Frantz</strong> <jason at apache dot org> +<br><strong>MC Srivas</strong> <srivas at apache dot org> +<br><strong>Keys Botzum</strong> <kbotzum at apache dot org> +<br><strong>Julian Hyde</strong> <jhyde at apache dot org> +<br><strong>Tim Chen</strong> <tnachen at apache dot org> +<br><strong>Mehant Baid</strong> <mehant at apache dot org> +<br><strong>Jinfeng Ni</strong> <jni at apache dot org> +<br><strong>Venki Korukanti</strong> <venki at apache dot org> +<br><strong>Jason Altekruse</strong> <json at apache dot org> +<br><strong>Aditya Kishore</strong> <adi at apache dot org> +<br><strong>Parth Chandra</strong> <parthc at apache dot org> +<br><strong>Aman Sinha</strong> <amansinha at apache dot org> +<br><strong>Steven Phillips</strong> <smp at apache dot org> + </p> + +</div> + + +<div id="footer" class="mw"> +<div class="wrapper"> +Copyright © 2012-2014 The Apache Software Foundation, licensed under the Apache License, Version 2.0.<br> +Apache Incubator, Apache, and the Apache feather logo are trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.<br/><br/> +<strong>DISCLAIMER</strong><br/> +Apache Drill is an effort undergoing incubation at The Apache Software Foundation sponsored by the Apache Incubator PMC. Incubation is required of all newly accepted projects until a further<br/> +review indicates that the infrastructure, communications, and decision making process have stabilized in a manner consistent with other successful ASF projects. While incubation status is not<br/> +necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF. +</div> +</div> + +<script> +(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ +(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), +m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) +})(window,document,'script','//www.google-analytics.com/analytics.js','ga'); + +ga('create', 'UA-53379651-1', 'auto'); +ga('send', 'pageview'); +</script> + +</body> +</html>
Added: websites/staging/drill/trunk/content/drill/why/index.html ============================================================================== --- websites/staging/drill/trunk/content/drill/why/index.html (added) +++ websites/staging/drill/trunk/content/drill/why/index.html Tue Nov 11 05:54:32 2014 @@ -0,0 +1,158 @@ +<!DOCTYPE html> +<html> + +<head> + +<meta charset="UTF-8"> + + +<title>Why Drill - Apache Drill</title> + +<link href="/drill/css/syntax.css" rel="stylesheet" type="text/css"> +<link href="/drill/css/style.css" rel="stylesheet" type="text/css"> +<link href="/drill/css/arrows.css" rel="stylesheet" type="text/css"> +<link href="/drill/css/button.css" rel="stylesheet" type="text/css"> + +<link rel="shortcut icon" href="/drill/favicon.ico" type="image/x-icon"> +<link rel="icon" href="/drill/favicon.ico" type="image/x-icon"> + +<script language="javascript" type="text/javascript" src="/drill/js/lib/jquery-1.11.1.min.js"></script> +<script language="javascript" type="text/javascript" src="/drill/js/lib/jquery.easing.1.3.js"></script> +<script language="javascript" type="text/javascript" src="/drill/js/modernizr.custom.js"></script> +<script language="javascript" type="text/javascript" src="/drill/js/script.js"></script> + +</head> + +<body onResize="resized();"> + +<div class="bui"></div> + +<div id="search"> +<input type="text" placeholder="Enter search term here"> +</div> + +<div id="menu" class="mw"> +<ul> + <li class="logo"><a href="/drill/"></a></li> + <li> + <a href="/drill/overview/">Documentation</a> + <ul> + <li><a href="/drill/overview/">Overview </a></li> + <li><a href="https://cwiki.apache.org/confluence/display/DRILL/Apache+Drill+in+10+Minutes"; target="_blank">Drill in 10 Minutes</a></li> + <li><a href="/drill/why/">Why Drill? </a></li> + <li><a href="/drill/architecture/">Architecture</a></li> + </ul> + </li> + <li> + <a href="/drill/community/">Community</a> + <ul> + <li><a href="/drill/team/">Team</a></li> + <li><a href="/drill/community/#events">Events and Meetups</a></li> + <li><a href="/drill/community/#mailinglists">Mailing Lists</a></li> + <li><a href="/drill/community/#getinvolved">Get Involved</a></li> + <li><a href="https://issues.apache.org/jira/browse/DRILL/"; target="_blank">Issue Tracker</a></li> + <li><a href="https://github.com/apache/incubator-drill"; target="_blank">GitHub</a></li> + </ul> + </li> + <li><a href="/drill/faq/">FAQ</a></li> + <li><a href="http://drill-user.org"; target="_blank">Blog</a></li> + <li style="width:30px; padding-left: 2px; padding-right:10px"><a href="https://twitter.com/apachedrill"; target="_blank"><img src="/drill/images/twitterbw.png" alt="" align="center" width="22" style="padding: 0px 10px 1px 0px;"></a> </li> + <li class="l"><span> </span></li> + <li class="d"><a href="/drill/download/">Download</a></li> +</ul> +</div> + +<div class="int_title"> +<h1>Why Drill</h1> +<p>Top 10 Reasons to Use Drill</p> +</div> + +<div class="int_text" align="left"><h2>1. Get started in minutes</h2> +<p>It only takes a couple minutes to start working with Drill. Untar it on your Mac or Windows laptop and run a query on a local file. No need to set up any infrastructure. No need to define schemas. Just point at the data and drill!</p> +<div class="highlight"><pre><code class="language-bash" data-lang="bash"><span class="nv">$ </span>tar -xvf apache-drill-0.6.0-incubating.tar.gz +<span class="nv">$ </span>apache-drill-0.6.0-incubating/bin/sqlline -u jdbc:drill:zk<span class="o">=</span><span class="nb">local</span> +0: jdbc:drill:zk<span class="o">=</span><span class="nb">local</span>> SELECT * FROM dfs.root.<span class="sb">`</span>path/to/employee.json<span class="sb">`</span> limit 5<span class="p">;</span> ++-------------+------------------+------------+------------+-------------+----------------------+------------+---------------+----- +<span class="p">|</span> employee_id <span class="p">|</span> full_name <span class="p">|</span> first_name <span class="p">|</span> last_name <span class="p">|</span> position_id <span class="p">|</span> position_title <span class="p">|</span> store_id <span class="p">|</span> department_id <span class="p">|</span> birt ++-------------+------------------+------------+------------+-------------+----------------------+------------+---------------+------+ +<span class="p">|</span> <span class="m">1</span> <span class="p">|</span> Sheri Nowmer <span class="p">|</span> Sheri <span class="p">|</span> Nowmer <span class="p">|</span> <span class="m">1</span> <span class="p">|</span> President <span class="p">|</span> <span class="m">0</span> <span class="p">|</span> <span class="m">1</span> <span class="p">|</span> <span class="m">19</span> +<span class="p">|</span> <span class="m">2</span> <span class="p">|</span> Derrick Whelply <span class="p">|</span> Derrick <span class="p">|</span> Whelply <span class="p">|</span> <span class="m">2</span> <span class="p">|</span> VP Country Manager <span class="p">|</span> <span class="m">0</span> <span class="p">|</span> <span class="m">1</span> <span class="p">|</span> +<span class="p">|</span> <span class="m">4</span> <span class="p">|</span> Michael Spence <span class="p">|</span> Michael <span class="p">|</span> Spence <span class="p">|</span> <span class="m">2</span> <span class="p">|</span> VP Country Manager <span class="p">|</span> <span class="m">0</span> <span class="p">|</span> <span class="m">1</span> <span class="p">|</span> +<span class="p">|</span> <span class="m">5</span> <span class="p">|</span> Maya Gutierrez <span class="p">|</span> Maya <span class="p">|</span> Gutierrez <span class="p">|</span> <span class="m">2</span> <span class="p">|</span> VP Country Manager <span class="p">|</span> <span class="m">0</span> <span class="p">|</span> <span class="m">1</span> <span class="p">|</span> +<span class="p">|</span> <span class="m">6</span> <span class="p">|</span> Roberta Damstra <span class="p">|</span> Roberta <span class="p">|</span> Damstra <span class="p">|</span> <span class="m">3</span> <span class="p">|</span> VP Information Systems <span class="p">|</span> <span class="m">0</span> <span class="p">|</span> <span class="m">2</span> <span class="p">|</span> ++-------------+------------------+------------+------------+-------------+----------------------+------------+---------------+-----</code></pre></div> +<h2>2. Schema-free JSON model</h2> +<p>Drill is the world's first and only distributed SQL engine that doesn't require schemas. It shares the same schema-free JSON model as MongoDB and Elasticsearch. Instead of spending weeks or months defining schemas, transforming data (ETL) and maintaining those schemas, simply point Drill at your data (file, directory, HBase table, etc.) and run your queries. Drill automatically understands the structure of the data. Drill's self-service approach reduces the burden on IT and increases the productivity and agility of analysts and developers.</p> + +<h2>3. Query complex, semi-structured data in-situ</h2><p>Drill's schema-free JSON model allows you to query complex, semi-structured data in situ. No need to flatten or transform the data prior to or during query execution. Drill also provides intuitive extensions to SQL to work with nested data. Here's a simple query on a JSON file demonstrating how to access nested elements and arrays:</p> +<div class="highlight"><pre><code class="language-sql" data-lang="sql"><span class="k">SELECT</span> <span class="o">*</span> <span class="k">FROM</span> <span class="p">(</span><span class="k">SELECT</span> <span class="n">t</span><span class="p">.</span><span class="n">trans_id</span><span class="p">,</span> + <span class="n">t</span><span class="p">.</span><span class="n">trans_info</span><span class="p">.</span><span class="n">prod_id</span><span class="p">[</span><span class="mi">0</span><span class="p">]</span> <span class="k">AS</span> <span class="n">prod_id</span><span class="p">,</span> + <span class="n">t</span><span class="p">.</span><span class="n">trans_info</span><span class="p">.</span><span class="n">purch_flag</span> <span class="k">AS</span> <span class="n">purchased</span> + <span class="k">FROM</span> <span class="o">`</span><span class="n">clicks</span><span class="o">/</span><span class="n">clicks</span><span class="p">.</span><span class="n">json</span><span class="o">`</span> <span class="n">t</span><span class="p">)</span> <span class="n">sq</span> +<span class="k">WHERE</span> <span class="n">sq</span><span class="p">.</span><span class="n">prod_id</span> <span class="k">BETWEEN</span> <span class="mi">700</span> <span class="k">AND</span> <span class="mi">750</span> <span class="k">AND</span> + <span class="n">sq</span><span class="p">.</span><span class="n">purchased</span> <span class="o">=</span> <span class="s1">'true'</span> +<span class="k">ORDER</span> <span class="k">BY</span> <span class="n">sq</span><span class="p">.</span><span class="n">prod_id</span><span class="p">;</span></code></pre></div> + +<h2>4. Real SQL - not "SQL-like"</h2> +<p>Drill supports the standard SQL:2003 syntax. No need to learn a new "SQL-like" language or struggle with a semi-functional BI tool. Drill supports many data types including DATE, INTERVAL, TIMESTAMP, VARCHAR and DECIMAL, as well as complex query constructs such as correlated sub-queries and joins in WHERE clauses. Here is an example of a TPC-H standard query that runs in Drill "as is":</p> +<div class="highlight"><pre><code class="language-sql" data-lang="sql"><span class="o">#</span> <span class="n">TPC</span><span class="o">-</span><span class="n">H</span> <span class="n">query</span> <span class="mi">4</span> +<span class="k">SELECT</span> <span class="n">o</span><span class="p">.</span><span class="n">o_orderpriority</span><span class="p">,</span> <span class="k">count</span><span class="p">(</span><span class="o">*</span><span class="p">)</span> <span class="k">AS</span> <span class="n">order_count</span> +<span class="k">FROM</span> <span class="n">orders</span> <span class="n">o</span> +<span class="k">WHERE</span> <span class="n">o</span><span class="p">.</span><span class="n">o_orderdate</span> <span class="o">>=</span> <span class="nb">date</span> <span class="s1">'1996-10-01'</span> + <span class="k">AND</span> <span class="n">o</span><span class="p">.</span><span class="n">o_orderdate</span> <span class="o"><</span> <span class="nb">date</span> <span class="s1">'1996-10-01'</span> <span class="o">+</span> <span class="nb">interval</span> <span class="s1">'3'</span> <span class="k">month</span> + <span class="k">AND</span> <span class="k">EXISTS</span><span class="p">(</span> + <span class="k">SELECT</span> <span class="o">*</span> <span class="k">FROM</span> <span class="n">lineitem</span> <span class="n">l</span> + <span class="k">WHERE</span> <span class="n">l</span><span class="p">.</span><span class="n">l_orderkey</span> <span class="o">=</span> <span class="n">o</span><span class="p">.</span><span class="n">o_orderkey</span> + <span class="k">AND</span> <span class="n">l</span><span class="p">.</span><span class="n">l_commitdate</span> <span class="o"><</span> <span class="n">l</span><span class="p">.</span><span class="n">l_receiptdate</span> + <span class="p">)</span> + <span class="k">GROUP</span> <span class="k">BY</span> <span class="n">o</span><span class="p">.</span><span class="n">o_orderpriority</span> + <span class="k">ORDER</span> <span class="k">BY</span> <span class="n">o</span><span class="p">.</span><span class="n">o_orderpriority</span><span class="p">;</span></code></pre></div> + +<h2>5. Leverage standard BI tools</h2> +<p>Drill works with standard BI tools. You can keep using the tools you love, such as Tableau, MicroStrategy, QlikView and Excel. No need to introduce yet another visualization or dashboard tool. Combine a self-service BI tool with the only self-service SQL engine to enable true self-service data exploration.</p> + +<h2>6. Interactive queries on Hive tables</h2><p>Apache Drill lets you leverage your investments in Hive. You can run interactive queries with Drill on your Hive tables and access all Hive input/output formats (including custom SerDes). You can join tables associated with different Hive metastores, and you can join a Hive table with an HBase table or a directory of log files. Here's a simple query in Drill on a Hive table:</p> +<div class="highlight"><pre><code class="language-sql" data-lang="sql"><span class="k">SELECT</span> <span class="o">`</span><span class="k">month</span><span class="o">`</span><span class="p">,</span> <span class="k">state</span><span class="p">,</span> <span class="k">sum</span><span class="p">(</span><span class="n">order_total</span><span class="p">)</span> <span class="k">AS</span> <span class="n">sales</span> +<span class="k">FROM</span> <span class="n">hive</span><span class="p">.</span><span class="n">orders</span> +<span class="k">GROUP</span> <span class="k">BY</span> <span class="o">`</span><span class="k">month</span><span class="o">`</span><span class="p">,</span> <span class="k">state</span> +<span class="k">ORDER</span> <span class="k">BY</span> <span class="mi">3</span> <span class="k">DESC</span> <span class="k">LIMIT</span> <span class="mi">5</span><span class="p">;</span></code></pre></div> + +<h2>7. Access multiple data sources</h2><p>Drill is designed with extensibility in mind. It provides out-of-the-box connectivity to file systems (local or distributed file systems such as S3, HDFS and MapR-FS), HBase and Hive. You can implement a storage plugin to make Drill work with any other data source. Drill can combine data from multiple data sources on the fly in a single query, with no centralized metadata definitions. Here's a query that combines data from a Hive table, an HBase table (view) and a JSON file:</p> +<div class="highlight"><pre><code class="language-sql" data-lang="sql"><span class="k">SELECT</span> <span class="n">custview</span><span class="p">.</span><span class="n">membership</span><span class="p">,</span> <span class="k">sum</span><span class="p">(</span><span class="n">orders</span><span class="p">.</span><span class="n">order_total</span><span class="p">)</span> <span class="k">AS</span> <span class="n">sales</span> +<span class="k">FROM</span> <span class="n">hive</span><span class="p">.</span><span class="n">orders</span><span class="p">,</span> <span class="n">custview</span><span class="p">,</span> <span class="n">dfs</span><span class="p">.</span><span class="o">`</span><span class="n">clicks</span><span class="o">/</span><span class="n">clicks</span><span class="p">.</span><span class="n">json</span><span class="o">`</span> <span class="k">c</span> +<span class="k">WHERE</span> <span class="n">orders</span><span class="p">.</span><span class="n">cust_id</span> <span class="o">=</span> <span class="n">custview</span><span class="p">.</span><span class="n">cust_id</span> <span class="k">AND</span> <span class="n">orders</span><span class="p">.</span><span class="n">cust_id</span> <span class="o">=</span> <span class="k">c</span><span class="p">.</span><span class="n">user_info</span><span class="p">.</span><span class="n">cust_id</span> +<span class="k">GROUP</span> <span class="k">BY</span> <span class="n">custview</span><span class="p">.</span><span class="n">membership</span> +<span class="k">ORDER</span> <span class="k">BY</span> <span class="mi">2</span><span class="p">;</span></code></pre></div> + +<h2>8. User-Defined Functions (UDFs)</h2><p>Drill exposes a simple and high-performance Java API to build custom functions (UDFs and UDAFs) so that you can add your own business logic. If you have already built UDFs in Hive, you can reuse them with Drill with no modifications. Refer to <a href="https://cwiki.apache.org/confluence/display/DRILL/Develop+Custom+Functions";>Developing Custom Functions</a> for more information. +</p> + +<h2>9. High performance</h2><p>Drill is designed fround the ground up for high throughput and low latency. It doesn't use a general purpose execution engine like MapReduce, Tez or Spark. As a result, Drill is able to deliver its unparalleled flexibility (schema-free JSON model) without compromising performance. Drill's optimizer leverages rule- and cost-based techniques, as well as data locality and operator push-down (the ability to push down query fragments into the back-end data sources). Drill also provides a columnar and vectorized execution engine, resulting in higher memory and CPU efficiency.</p> + +<h2>10. Scales from a single laptop to a 1000-node cluster</h2><p>Drill is available as a simple download you can run on your laptop. When you're ready to analyze larger datasets, simply deploy Drill on your Hadoop cluster (up to 1000 commodity servers). Drill leverages the aggregate memory in the cluster to execute queries using an optimistic pipelined model, and automatically spills to disk when the working set doesn't fit in memory.</p> +</div> + + +<div id="footer" class="mw"> +<div class="wrapper"> +Copyright © 2012-2014 The Apache Software Foundation, licensed under the Apache License, Version 2.0.<br> +Apache Incubator, Apache, and the Apache feather logo are trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.<br/><br/> +<strong>DISCLAIMER</strong><br/> +Apache Drill is an effort undergoing incubation at The Apache Software Foundation sponsored by the Apache Incubator PMC. Incubation is required of all newly accepted projects until a further<br/> +review indicates that the infrastructure, communications, and decision making process have stabilized in a manner consistent with other successful ASF projects. While incubation status is not<br/> +necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF. +</div> +</div> + +<script> +(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){ +(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o), +m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m) +})(window,document,'script','//www.google-analytics.com/analytics.js','ga'); + +ga('create', 'UA-53379651-1', 'auto'); +ga('send', 'pageview'); +</script> + +</body> +</html>
