Added: incubator/drill/site/trunk/content/drill/sandbox.html
URL:
http://svn.apache.org/viewvc/incubator/drill/site/trunk/content/drill/sandbox.html?rev=1637515&view=auto
==============================================================================
--- incubator/drill/site/trunk/content/drill/sandbox.html (added)
+++ incubator/drill/site/trunk/content/drill/sandbox.html Sat Nov 8 06:06:09
2014
@@ -0,0 +1,156 @@
+<!doctype html>
+<html>
+ <head>
+ <meta charset="UTF-8">
+ <title>Sandbox (VMs)for Apache Drill</title>
+
+ <link href="css/style.css" rel="stylesheet" type="text/css">
+ <link href="css/arrows.css" rel="stylesheet" type="text/css">
+ <link href="css/button.css" rel="stylesheet" type="text/css">
+
+ <script language="javascript" type="text/javascript"
src="js/lib/jquery-1.11.1.min.js"></script>
+ <script language="javascript" type="text/javascript"
src="js/lib/jquery.easing.1.3.js"></script>
+ <script language="javascript" type="text/javascript"
src="js/modernizr.custom.js"></script>
+ <script language="javascript" type="text/javascript"
src="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/index.html"></a></li>
+
+ <li>
+ <a
href="https://cwiki.apache.org/confluence/display/DRILL/Apache+Drill+Wiki";
target="_blank">Documentation</a>
+ <ul>
+ <li><a href="overview.html">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="https://cwiki.apache.org/confluence/display/DRILL/Connecting+to+Data+Sources#ConnectingtoDataSources-QueryingaFileSystem";
target="_blank">Query Files</a></li>
+ <li><a
href="https://cwiki.apache.org/confluence/display/DRILL/Connecting+to+Data+Sources#ConnectingtoDataSources-QueryingHBaseTables";
target="_blank">Query HBase</a></li>
+ <li><a
href="https://cwiki.apache.org/confluence/display/DRILL/Connecting+to+Data+Sources#ConnectingtoDataSources-QueryingHiveTables";
target="_blank">Query Hive</a></li>
+ <li><a
href="https://cwiki.apache.org/confluence/display/DRILL/SQL+Overview";
target="_blank">SQL Support</a></li> <li><a
href="architecture.html">Architecture</a></li>
+ </ul>
+ </li>
+ <li>
+ <a href="community.html">Community</a>
+ <ul>
+ <li><a href="community.html#events">Events and
Meetups</a></li>
+ <li><a href="community.html#mailinglists">Mailing
Lists</a></li>
+ <li><a href="community.html#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="faq.html">FAQ</a></li>
+ <li><a
href="sandbox.html">Sandbox</a></li>
+ <li><a
href="http://drill-user.org"; target="_blank">Blog</a></li>
+ <li class="l"><span> </span></li>
+ <li class="d"><a href="download.html">Download</a></li>
+ </ul>
+
+ </div>
+
+ <h2>Get started with Drill easily - visit the tutorials.</h2>
+
+ <div class="int_text download">
+
+
+
+ <table>
+ <tr>
+ <td> </td>
+ <td><a
href="https://www.mapr.com/products/mapr-sandbox-hadoop/download-sandbox-drill";
rel="nofollow" target="_blank" class="dl">SANDBOX WITH DRILL*</a></td>
+<td> </td>
+ </tr>
+ </table>
+
+ <h2>Sandbox Tutorials</h2>
+ <p><a
href="http://doc.mapr.com/display/MapR/Apache+Drill+Tutorial";
target="_blank">Click here</a></p>
+
+
+
+
+ <p>*Please note that Sandbox is provided by a
third-party under a non-Apache license.</p>
+ </div>
+
+ <div id="footer" class="mw">
+ <div class="wrapper">
+ Copyright © 2012 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>
+
+ <script type="text/javascript">
+
+ var downloadLink =
document.getElementById('apachemirror');
+ addListener(downloadLink, 'click', function() {
+ ga('send', 'event', 'button', 'click', 'download');
+ });
+
+
+ /**
+ * Utility to wrap the different behaviors between
W3C-compliant browsers
+ * and IE when adding event handlers.
+ *
+ * @param {Object} element Object on which to attach
the event listener.
+ * @param {string} type A string representing the event
type to listen for
+ * (e.g. load, click, etc.).
+ * @param {function()} callback The function that
receives the notification.
+ */
+ function addListener(element, type, callback) {
+ if (element.addEventListener)
element.addEventListener(type, callback);
+ else if (element.attachEvent) element.attachEvent('on'
+ type, callback);
+ }
+
+ </script>
+
+
+ <script type="text/javascript">
+
+ var downloadLinkdirect =
document.getElementById('directdownload');
+ addListener(downloadLinkdirect, 'click', function() {
+ ga('send', 'event', 'buttondirect', 'clickdirect',
'downloaddirect');
+ });
+
+
+ /**
+ * Utility to wrap the different behaviors between
W3C-compliant browsers
+ * and IE when adding event handlers.
+ *
+ * @param {Object} element Object on which to attach
the event listener.
+ * @param {string} type A string representing the event
type to listen for
+ * (e.g. load, click, etc.).
+ * @param {function()} callback The function that
receives the notification.
+ */
+ function addListener(element, type, callback) {
+ if (element.addEventListener)
element.addEventListener(type, callback);
+ else if (element.attachEvent) element.attachEvent('on'
+ type, callback);
+ }
+
+ </script>
+
+ </body>
+</html>
Propchange: incubator/drill/site/trunk/content/drill/sandbox.html
------------------------------------------------------------------------------
svn:executable = *
Modified: incubator/drill/site/trunk/content/drill/team.html
URL:
http://svn.apache.org/viewvc/incubator/drill/site/trunk/content/drill/team.html?rev=1637515&r1=1637514&r2=1637515&view=diff
==============================================================================
--- incubator/drill/site/trunk/content/drill/team.html (original)
+++ incubator/drill/site/trunk/content/drill/team.html Sat Nov 8 06:06:09 2014
@@ -1 +1,120 @@
-<meta http-equiv="refresh" content="0; index.html" >
\ No newline at end of file
+<!doctype html>
+<html>
+ <head>
+ <meta charset="UTF-8">
+ <title>Apache Drill - Team</title>
+
+ <link href="css/style.css" rel="stylesheet" type="text/css">
+ <link href="css/arrows.css" rel="stylesheet" type="text/css">
+ <link href="css/button.css" rel="stylesheet" type="text/css">
+
+ <script language="javascript" type="text/javascript"
src="js/lib/jquery-1.11.1.min.js"></script>
+ <script language="javascript" type="text/javascript"
src="js/lib/jquery.easing.1.3.js"></script>
+ <script language="javascript" type="text/javascript"
src="js/modernizr.custom.js"></script>
+ <script language="javascript" type="text/javascript"
src="js/script.js"></script>
+
+ </head>
+
+ <body onResize="resized();">
+
+ <div class="bui"></div>
+
+ <div id="search">
+ <input type="text" placeholder="Enter search term here">
+ </div>
+
+ <!-- MENU -->
+ <div id="menu" class="mw">
+
+ <ul>
+ <li class="logo"><a href="index.html"></a></li>
+<li>
+ <a href="overview.html">Documentation</a>
+ <ul>
+ <li><a
href="overview.html">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="top-10-reasons-for-using-drill.html">Why Drill?
</a>
+
<li><a href="architecture.html">Architecture</a></li>
+
+
+ </ul>
+ </li>
+ <li>
+ <a href="community.html">Community</a>
+ <ul>
+
<li><a href="team.html">Team</a></li>
+ <li><a href="community.html#events">Events and
Meetups</a></li>
+ <li><a href="community.html#mailinglists">Mailing
Lists</a></li>
+ <li><a href="community.html#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="faq.html">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="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="download.html">Download</a></li>
+ </ul>
+
+ </div>
+ <!-- last line -->
+
+ <div class="int_title int_title_img community">
+ <h1>Team</h1>
+ </div>
+
+ <div class="int_text">
+
+ <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 (ordered by
date):</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:
incubator/drill/site/trunk/content/drill/top-10-reasons-for-using-drill.html
URL:
http://svn.apache.org/viewvc/incubator/drill/site/trunk/content/drill/top-10-reasons-for-using-drill.html?rev=1637515&view=auto
==============================================================================
---
incubator/drill/site/trunk/content/drill/top-10-reasons-for-using-drill.html
(added)
+++
incubator/drill/site/trunk/content/drill/top-10-reasons-for-using-drill.html
Sat Nov 8 06:06:09 2014
@@ -0,0 +1,234 @@
+<!doctype html>
+<html>
+
+ <head>
+ <meta charset="UTF-8">
+ <title>Apache Drill - Overview</title>
+
+ <link href="css/style.css" rel="stylesheet" type="text/css">
+ <link href="css/arrows.css" rel="stylesheet" type="text/css">
+ <link href="css/button.css" rel="stylesheet" type="text/css">
+
+ <script language="javascript" type="text/javascript"
src="js/lib/jquery-1.11.1.min.js"></script>
+ <script language="javascript" type="text/javascript"
src="js/lib/jquery.easing.1.3.js"></script>
+ <script language="javascript" type="text/javascript"
src="js/modernizr.custom.js"></script>
+ <script language="javascript" type="text/javascript"
src="js/script.js"></script>
+
+
<style>
+pre, code {
+background-color: #f7f7f7;
+border: 1px solid #ddd;
+font-size: 15px;
+line-height: 19px;
+overflow-x: auto;
+overflow-y: auto;
+padding: 2px 4px;
+border-radius: 3px;
+word-wrap: normal;
+white-space: pre !important;"
+font-family: Consolas, "Liberation Mono", Courier, monospace;
+}
+
+.li1
+{ line-height: 140%;
+}
+</style>
+
+ </head>
+
+ <body onResize="resized();">
+
+ <div class="bui"></div>
+
+ <div id="search">
+ <input type="text" placeholder="Enter search term here">
+ </div>
+
+ <!-- MENU -->
+ <div id="menu" class="mw">
+
+ <ul>
+ <li class="logo"><a href="index.html"></a></li>
+<li>
+ <a href="overview.html">Documentation</a>
+ <ul>
+ <li><a
href="overview.html">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="top-10-reasons-for-using-drill.html">Why Drill?
</a>
+
<li><a href="architecture.html">Architecture</a></li>
+
+
+ </ul>
+ </li>
+ <li>
+ <a href="community.html">Community</a>
+ <ul>
+
<li><a href="team.html">Team</a></li>
+ <li><a href="community.html#events">Events and
Meetups</a></li>
+ <li><a href="community.html#mailinglists">Mailing
Lists</a></li>
+ <li><a href="community.html#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="faq.html">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="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="download.html">Download</a></li>
+ </ul>
+
+ </div>
+ <!-- last line -->
+
+ <div class="int_title">
+ <h1>Why Drill?</h1><br><p>Top 10 Reasons For Using Apache
Drill</p>
+ </div>
+
+ <div class="int_text" align="left">
+
+ <!-- Blog -->
+
+
+<p>There are several options available for SQL-on-Hadoop today. What makes
Drill different? </p>
+<p>Here are the top 10 reasons why Drill is a valuable and innovative
technology in your toolset for interactive data exploration on big data</p>
+<div align="center">
+<p><img alt="Apache Drill"
src="https://www.mapr.com/sites/default/files/blogimages/Apache-Drill.png";
style="height:39px; width:551px"></p>
+<p style="margin-left:40px"><img alt="quick and easy ramp up for apache drill"
src="https://www.mapr.com/sites/default/files/blogimages/Quick-Easy-Ramp-Up-2.png";
style="height:329px; width:550px; padding-right:35px"></p>
+</div>
+
+<h2>1. Quick and easy ramp up</h2>
+<p>First and foremost, it takes just minutes to start working with Apache
Drill. Install it on a local Windows or Mac machine and do queries right away -
you don't even need Hadoop.</p><p>Here are three simple steps to run your first
query with Drill.</p>
+
+<pre>
+
+// Install, launch SQLLine CLI and query a JSON file on local file system
+$ tar -xvf apache-drill-0.5.0-incubating.tar
+
+$ apache-drill-0.5.0-incubating/bin/sqlline -u jdbc:drill:zk=local
+
+0: jdbc:drill:zk=local> SELECT * FROM cp.`employee.json` limit 5;
++-------------+------------------+------------+------------+-------------+----------------------+------------+---------------+-----
+| employee_id | full_name | first_name | last_name | position_id |
position_title | store_id | department_id | birt
++-------------+------------------+------------+------------+-------------+----------------------+------------+---------------+------+
+
+| 1 | Sheri Nowmer | Sheri | Nowmer | 1 |
President | 0 | 1 | 19
+| 2 | Derrick Whelply | Derrick | Whelply | 2 | VP
Country Manager | 0 | 1 |
+| 4 | Michael Spence | Michael | Spence | 2 | VP
Country Manager | 0 | 1 |
+| 5 | Maya Gutierrez | Maya | Gutierrez | 2 | VP
Country Manager | 0 | 1 |
+| 6 | Roberta Damstra | Roberta | Damstra | 3 | VP
Information Systems | 0 | 2 |
++-------------+------------------+------------+------------+-------------+----------------------+------------+---------------+-----
+
+</pre>
+
+
+
+
+
+
+
+
+<h2>2. Supports ANSI SQL - as you know it</h2><p>Apache Drill is compatible
with ANSI SQL standards. This means that users don't need to learn a new query
language or know the nuances of "SQL Like" to work with Drill or migrate
existing workloads to Drill. </p><p>Drill supports SQL 2003 syntax and
provides all the key SQL data types (such as DATE, INTERVAL, TIMESTAMP,
VARCHAR, DECIMAL) and query constructs (such as correlated sub-queries, joins
in WHERE clause) to provide a smooth and familiar analytics experience.
</p><p>Here is an example of a TPC-H standard query that runs in Drill "as is".
</p>
+<pre>
+# TPC-H query 4
+SELECT o.o_orderpriority, count(*) AS order_count
+FROM orders o
+WHERE o.o_orderdate >= date '1996-10-01'
+ AND o.o_orderdate < date '1996-10-01' + interval '3' month
+ AND EXISTS(
+ SELECT * FROM lineitem l
+ WHERE l.l_orderkey = o.o_orderkey
+ AND l.l_commitdate < l.l_receiptdate
+ )
+ GROUP BY o.o_orderpriority
+ ORDER BY o.o_orderpriority;
+</pre>
+
+<h2>3. Works with your BI tools</h2><p>Apache Drill integrates with the BI/SQL
tools such as Tableau, MicroStrategy, Pentaho and Jaspersoft using JDBC/ODBC
drivers. This means that users can now use same BI/Analytics tools they are
deeply familiar with in order to perform proactive business intelligence using
more raw data, up-to-date data and new types of data available in Hadoop/NoSQL
stores at a significantly low cost and rapid time to market. </p><p>Here is a
quick look at the Drill ODBC Driver DSN UI - Drill explorer - a data
exploration environment to understand Drill data and create views along with a
BI visualization using Drill as a data source. </p><p
style="margin-left:40px"><img alt="MapR Drill ODBC Driver DSN Setup"
src="https://www.mapr.com/sites/default/files/blogimages/MapR-Drill-ODBC-Driver-DSN-Setup.png";
style="height:498px; width:450px"></p><p style="margin-left:40px"><img
alt="data exploration enviroment"
src="https://www.mapr.com/sites/default/files/blogimages
/Data-exploration-enviroment.png" style="height:354px; width:600px"></p><p
style="margin-left:40px"><img alt="Tableau example"
src="https://www.mapr.com/sites/default/files/blogimages/Tableau-example.png";
style="height:583px; width:600px"></p><h2>4. Supports self-describing data with
no ETL</h2><p>Self-describing data is where schema is specified as part of the
data itself. File formats such as Parquet, JSON, Protobuf, XML, Avro and NoSQL
databases are all examples of self-describing data. Some of these data formats
are also dynamic and complex in that every record in the data can have its own
set of columns/attributes and each column can be semi-structured/nested.
</p><p>Think about a JSON document with multiple levels of nesting and
optional/repeated elements at each level or a wide HBase table with 100s-1000s
of columns with varying schema across rows. How about third party data that you
are looking to leverage in BI/Analytics, but you have no control on how schemas
will evolve?
</p><p>Drill supports querying self-describing data without defining and
managing any centralized schema definitions in Hive metastore. Schema is
discovered dynamically on the fly when the queries come in. </p><p>Dynamic
schema discovery with no upfront modeling/schema management means that
companies now can eliminate time delays of weeks/months of ETL before data is
available to users for data exploration. Users can get more
up-to-date/real-time data in order to make informed and timely decisions.
</p><p>Here are a few quick examples on querying files and directories using
Drill. </p>
+<pre>
+//clicks.json is a file and logs is a partitioned directory by year & month on
Hadoop
+
+0: jdbc:drill:> select * from `clicks/clicks.json` limit 2;
+0: jdbc:drill:> select cust_id, dir1 month_no, count(*) month_count from logs
+where dir0=2014 group by cust_id, dir1 order by cust_id, month_no limit 10;
+</pre>
+
+
+
+
+<h2>5. Handles Complex Data Types</h2><p>Drill comes with a flexible JSON-like
data model to natively query and process complex/multi-structured data. The
data doesn't need to be flattened or transformed either at the design time or
runtime providing high performance for queries on complex data. Drill provides
intuitive extensions to SQL to work with nested data using MAP and ARRAY data
types. </p><p>Here is an example indicating how Drill queries a JSON file and
accesses the nested maps and array fields. </p>
+<pre>
+// prod_id is an array field in clicks.json file
+
+select * from (select t.trans_id, t.trans_info.prod_id[0] as prodid,
+t.trans_info.purch_flag as purchased
+from `clicks/clicks.json` t) sq
+where sq.prodid between 700 and 750 and sq.purchased='true' order by sq.prodid;
+</pre>
+
+<h2>6. Plays Well with Hive</h2><p>Apache Drill lets you reuse investments
made in existing Hive deployments. You can do queries on Hive tables and access
100+ Hive input/output formats (including custom serdes) with no re-work. Drill
serves as a complement to Hive deployments by offering low latency
queries.</p><p>Here is a sample Hive storage plugin configuration looks like in
Drill, followed by a query on a Hive table. </p>
+<pre>
+//Storage plugin configuration for Hive
+hive
+
+{
+ "type": "hive",
+ "enabled": true,
+ "configProps": {
+ "hive.metastore.uris": "thrift://localhost:9083",
+ "hive.metastore.sasl.enabled": "false"
+ }
+}
+
+//Query on a Hive table 'orders'
+0: jdbc:drill:> select `month`, state, sum(order_total) as sales from
hive.orders
+group by `month`, state order by 3 desc limit 5;
+
+</pre>
+
+
+
+<h2>7. Works with Hadoop and Beyond</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, MapR-FS), HBase, or Hive.
The storage plugin interface is extensible to other NoSQL stores (such as
Couchbase, Elasticsearch, MongoDB) or relational databases (such as Postgres,
MySQL, etc.) or your own custom store. Drill can also combine data from all
these data sources in a single query on the fly without any central metadata
definitions.</p><p>Here is an example Drill that combines data from Hive, HBase
and JSON. </p>
+
+<pre>
+// Hive table 'orders', HBase view 'custview' and JSON file 'clicks.json' are
joined together
+
+select custview.membership, sum(orders.order_total)
+as sales from hive.orders, custview,
dfs.`/mapr/demo.mapr.com/data/nested/clicks/clicks.json` c
+where orders.cust_id=custview.cust_id and orders.cust_id=c.user_info.cust_id
+group by custview.membership order by 2;
+</pre>
+
+<h2>8. Ease of UDFs</h2><p>Drill exposes an easy and high performance Java API
to build custom functions (UDFs and UDAFs) and extend SQL for the data and the
business logic that is specific to your organization. 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. Provides low latency
queries</h2><p>Drill is built from the ground up for short and low-latency
queries on large datasets. Drill doesn't use MapReduce; instead it comes with a
distributed SQL MPP engine to execute queries in parallel on a cluster. Any of
the Drillbits (core service in Drill) is capable of receiving requests from
users. The optimizer in Drill is sophisticated and leverages various rule-
based and cost-based techniques, optimization capabilities of the data sources,
along with data locality to determine the most
efficient query plan and then distribute the execution across multiple nodes
in the cluster. Drill also provides a columnar and vectorized execution engine
to offer high memory and CPU efficiencies along with rapid performance for a
wide variety of analytic queries. </p><h2>10. Supports large
datasets</h2><p>Drill is built to scale to big data needs and is not restricted
by memory available on the cluster nodes. For performance, Drill tries to do
query execution in-memory when possible, using an optimistic/pipelined model
and spills to disk only if the working dataset doesn't fit in memory.
</p><p>For more examples on how to use Drill, download <a
href="https://www.mapr.com/products/mapr-sandbox-hadoop/download-sandbox-drill";>Apache
Drill sandbox</a> and try out the <a
href="http://doc.mapr.com/display/MapR/Apache+Drill+Tutorial";>sandbox
tutorial</a>.
+
+ <!-- Last Line -->
+ </div>
+
+ </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>
Propchange:
incubator/drill/site/trunk/content/drill/top-10-reasons-for-using-drill.html
------------------------------------------------------------------------------
svn:executable = *
![svn commit: r1637515 [2/2] - in /incubator/drill/site/trunk/content/drill: architecture.html community.html faq.html images/twitterbw.png index.html js/script.js overview.html sandbox.html team.html top-10-reasons-for-using-drill.html](/search?l=drill-commits@incubator.apache.org&q=subject:%22svn+commit%5C%3A+r1637515+%5C%5B2%5C%2F2%5C%5D+%5C-+in+%5C%2Fincubator%5C%2Fdrill%5C%2Fsite%5C%2Ftrunk%5C%2Fcontent%5C%2Fdrill%5C%3A+architecture.html+community.html+faq.html+images%5C%2Ftwitterbw.png+index.html+js%5C%2Fscript.js+overview.html+sandbox.html+team.html+top%5C-10%5C-reasons%5C-for%5C-using%5C-drill.html%22&o=newest){kind=link}
![https://www.mapr.com/sites/default/files/blogimages/Apache-Drill.png"](https://www.mapr.com/sites/default/files/blogimages/Apache-Drill.png"){kind=link}
![https://www.mapr.com/sites/default/files/blogimages/Quick-Easy-Ramp-Up-2.png"](https://www.mapr.com/sites/default/files/blogimages/Quick-Easy-Ramp-Up-2.png"){kind=link}
![https://www.mapr.com/sites/default/files/blogimages/MapR-Drill-ODBC-Driver-DSN-Setup.png"](https://www.mapr.com/sites/default/files/blogimages/MapR-Drill-ODBC-Driver-DSN-Setup.png"){kind=link}
![https://www.mapr.com/sites/default/files/blogimages/Tableau-example.png"](https://www.mapr.com/sites/default/files/blogimages/Tableau-example.png"){kind=link}
