Modified: drill/site/trunk/content/drill/docs/explain-commands/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/explain-commands/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/explain-commands/index.html (original) +++ drill/site/trunk/content/drill/docs/explain-commands/index.html Wed Mar 18 20:35:57 2015 @@ -120,7 +120,6 @@ query plan text may help you isolate the <p>Use the following syntax:</p> <div class="highlight"><pre><code class="language-text" data-lang="text">explain plan for <query> ; -explain plan with implementation for <query> ; </code></pre></div> <p>The following set command increases the default text display (number of characters). By default, most of the plan output is not displayed.</p> @@ -131,25 +130,18 @@ characters). By default, most of the pla <p>For example, here is the top portion of the explain output for a COUNT(DISTINCT) query on a JSON file:</p> <div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> !set maxwidth 10000 - -0: jdbc:drill:zk=local> explain plan for -select type t, count(distinct id) -from dfs.`/Users/brumsby/drill/donuts.json` -where type='donut' group by type; - -+------------+------------+ -| text | json | -+------------+------------+ -| 00-00 Screen -00-01 Project(t=[$0], EXPR$1=[$1]) -00-02 Project(t=[$0], EXPR$1=[$1]) -00-03 HashAgg(group=[{0}], EXPR$1=[COUNT($1)]) -00-04 HashAgg(group=[{0, 1}]) -00-05 SelectionVectorRemover -00-06 Filter(condition=[=(CAST($0):CHAR(5) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary", 'donut')]) -00-07 Project(type=[$1], id=[$2]) -00-08 ProducerConsumer -00-09 Scan(groupscan=[EasyGroupScan [selectionRoot=/Users/brumsby/drill/donuts.json, columns = null]]) +0: jdbc:drill:zk=local> explain plan for select type t, count(distinct id) from dfs.`/home/donuts/donuts.json` where type='donut' group by type; ++------------+------------+ +| text | json | ++------------+------------+ +| 00-00 Screen +00-01 Project(t=[$0], EXPR$1=[$1]) +00-02 Project(t=[$0], EXPR$1=[$1]) +00-03 HashAgg(group=[{0}], EXPR$1=[COUNT($1)]) +00-04 HashAgg(group=[{0, 1}]) +00-05 SelectionVectorRemover +00-06 Filter(condition=[=($0, 'donut')]) +00-07 Scan(groupscan=[EasyGroupScan [selectionRoot=/home/donuts/donuts.json, numFiles=1, columns=[`type`, `id`], files=[file:/home/donuts/donuts.json]]])... ... </code></pre></div> <p>Read the text output from bottom to top to understand the sequence of @@ -178,19 +170,17 @@ for submitting the query via Drill APIs. <p>Add the INCLUDING ALL ATTRIBUTES option to the EXPLAIN command to see cost estimates for the query plan. For example:</p> <div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> !set maxwidth 10000 -0: jdbc:drill:zk=local> explain plan including all attributes for -select * from dfs.`/Users/brumsby/drill/donuts.json` where type='donut'; - +0: jdbc:drill:zk=local> explain plan including all attributes for select * from dfs.`/home/donuts/donuts.json` where type='donut'; +------------+------------+ -| text | json | +| text | json | +------------+------------+ - -| 00-00 Screen: rowcount = 1.0, cumulative cost = {4.1 rows, 14.1 cpu, 0.0 io, 0.0 network}, id = 3110 -00-01 Project(*=[$0], type=[$1]): rowcount = 1.0, cumulative cost = {4.0 rows, 14.0 cpu, 0.0 io, 0.0 network}, id = 3109 -00-02 SelectionVectorRemover: rowcount = 1.0, cumulative cost = {3.0 rows, 6.0 cpu, 0.0 io, 0.0 network}, id = 3108 -00-03 Filter(condition=[=(CAST($1):CHAR(5) CHARACTER SET "ISO-8859-1" COLLATE "ISO-8859-1$en_US$primary", 'donut')]): rowcount = 1.0, cumulative cost = {2.0 rows, 5.0 cpu, 0.0 io, 0.0 network}, id = 3107 -00-04 ProducerConsumer: rowcount = 1.0, cumulative cost = {1.0 rows, 1.0 cpu, 0.0 io, 0.0 network}, id = 3106 -00-05 Scan(groupscan=[EasyGroupScan [selectionRoot=/Users/brumsby/drill/donuts.json, columns = null]]): rowcount = 1.0, cumulative cost = {0.0 rows, 0.0 cpu, 0.0 io, 0.0 network}, id = 3101 +| 00-00 Screen: rowcount = 1.0, cumulative cost = {5.1 rows, 21.1 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 889 +00-01 Project(*=[$0]): rowcount = 1.0, cumulative cost = {5.0 rows, 21.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 888 +00-02 Project(T1¦¦*=[$0]): rowcount = 1.0, cumulative cost = {4.0 rows, 17.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 887 +00-03 SelectionVectorRemover: rowcount = 1.0, cumulative cost = {3.0 rows, 13.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 886 +00-04 Filter(condition=[=($1, 'donut')]): rowcount = 1.0, cumulative cost = {2.0 rows, 12.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 885 +00-05 Project(T1¦¦*=[$0], type=[$1]): rowcount = 1.0, cumulative cost = {1.0 rows, 8.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 884 +00-06 Scan(groupscan=[EasyGroupScan [selectionRoot=/home/donuts/donuts.json, numFiles=1, columns=[`*`], files=[file:/home/donuts/donuts.json]]]): rowcount = 1.0, cumulative cost = {0.0 rows, 0.0 cpu, 0.0 io, 0.0 network, 0.0 memory}, id = 883 </code></pre></div> <h2 id="explain-for-logical-plans">EXPLAIN for Logical Plans</h2> @@ -199,27 +189,28 @@ query), use the EXPLAIN PLAN WITHOUT IMP <div class="highlight"><pre><code class="language-text" data-lang="text">explain plan without implementation for <query> ; </code></pre></div> <p>For example:</p> -<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> explain plan without implementation for -select a.id -from dfs.`/Users/brumsby/drill/donuts.json` a, dfs.`/Users/brumsby/drill/moredonuts.json` b -where a.id=b.id; - +<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> explain plan without implementation for select type t, count(distinct id) from dfs.`/home/donuts/donuts.json` where type='donut' group by type; +------------+------------+ -| text | json | +| text | json | +------------+------------+ | DrillScreenRel - DrillProjectRel(id=[$1]) - DrillJoinRel(condition=[=($1, $3)], joinType=[inner]) - DrillScanRel(table=[[dfs, /Users/brumsby/drill/donuts.json]], groupscan=[EasyGroupScan [selectionRoot=/Users/brumsby/drill/donuts.json, columns = null]]) - DrillScanRel(table=[[dfs, /Users/brumsby/drill/moredonuts.json]], groupscan=[EasyGroupScan [selectionRoot=/Users/brumsby/drill/moredonuts.json, columns = null]]) - | { + DrillProjectRel(t=[$0], EXPR$1=[$1]) + DrillAggregateRel(group=[{0}], EXPR$1=[COUNT($1)]) + DrillAggregateRel(group=[{0, 1}]) + DrillFilterRel(condition=[=($0, 'donut')]) + DrillScanRel(table=[[dfs, /home/donuts/donuts.json]], groupscan=[EasyGroupScan [selectionRoot=/home/donuts/donuts.json, numFiles=1, columns=[`type`, `id`], files=[file:/home/donuts/donuts.json]]]) | { + | { "head" : { "version" : 1, "generator" : { - "type" : "org.apache.drill.exec.planner.logical.DrillImplementor", - "info" : "" + "type" : "org.apache.drill.exec.planner.logical.DrillImplementor", + "info" : "" }, -... + "type" : "APACHE_DRILL_LOGICAL", + "options" : null, + "queue" : 0, + "resultMode" : "LOGICAL" + },... </code></pre></div></div>
Modified: drill/site/trunk/content/drill/docs/file-system-storage-plugin/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/file-system-storage-plugin/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/file-system-storage-plugin/index.html (original) +++ drill/site/trunk/content/drill/docs/file-system-storage-plugin/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><p>You can register a storage plugin instance that connects Drill to a local file +<div class="int_text" align="left"><p><a href="/docs/workspaces">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/hbase-storage-plugin">Next</a></p> + +<p>You can register a storage plugin instance that connects Drill to a local file system or a distributed file system registered in <code>core-site.xml</code>, such as S3 or HDFS. When you register a storage plugin instance for a file system, provide a unique name for the instance, and identify the type as â<code>file</code>â. By Modified: drill/site/trunk/content/drill/docs/flexibility/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/flexibility/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/flexibility/index.html (original) +++ drill/site/trunk/content/drill/docs/flexibility/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><p>The following features contribute to Drill's flexible architecture:</p> +<div class="int_text" align="left"><p><a href="/docs/architectural-highlights">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/performance">Next</a></p> + +<p>The following features contribute to Drill's flexible architecture:</p> <p><strong><em>Dynamic schema discovery</em></strong></p> Modified: drill/site/trunk/content/drill/docs/getting-started-tutorial/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/getting-started-tutorial/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/getting-started-tutorial/index.html (original) +++ drill/site/trunk/content/drill/docs/getting-started-tutorial/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><h2 id="goal">Goal</h2> +<div class="int_text" align="left"><p><a href="/docs/query-data">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/lesson-1-connect-to-data-sources">Next</a></p> + +<h2 id="goal">Goal</h2> <p>This tutorial covers how to query a file and a directory on your local file system. Files and directories are like standard SQL tables to Drill. If you Modified: drill/site/trunk/content/drill/docs/getting-to-know-the-drill-sandbox/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/getting-to-know-the-drill-sandbox/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/getting-to-know-the-drill-sandbox/index.html (original) +++ drill/site/trunk/content/drill/docs/getting-to-know-the-drill-sandbox/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><p>This section covers key information about the Apache Drill tutorial. After <a href="/docs/installing-the-apache-drill-sandbox">installing the Drill sandbox</a> and starting the sandbox, you can open another terminal window (Linux) or Command Prompt (Windows) and use the secure shell (ssh) to connect to the VM, assuming ssh is installed. Use the following login name and password: mapr/mapr. For +<div class="int_text" align="left"><p><a href="/docs/installing-the-mapr-sandbox-with-apache-drill-on-virtualbox">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/lession-1-learn-about-the-data-set">Next</a></p> + +<p>This section covers key information about the Apache Drill tutorial. After <a href="/docs/installing-the-apache-drill-sandbox">installing the Drill sandbox</a> and starting the sandbox, you can open another terminal window (Linux) or Command Prompt (Windows) and use the secure shell (ssh) to connect to the VM, assuming ssh is installed. Use the following login name and password: mapr/mapr. For example:</p> <div class="highlight"><pre><code class="language-text" data-lang="text">$ ssh mapr@localhost -p 2222 Password: Added: drill/site/trunk/content/drill/docs/handling-different-data-types/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/handling-different-data-types/index.html?rev=1667611&view=auto ============================================================================== --- drill/site/trunk/content/drill/docs/handling-different-data-types/index.html (added) +++ drill/site/trunk/content/drill/docs/handling-different-data-types/index.html Wed Mar 18 20:35:57 2015 @@ -0,0 +1,162 @@ +<!DOCTYPE html> +<html> + +<head> + +<meta charset="UTF-8"> + + +<title>Handling Different Data Types - Apache Drill</title> + +<link href="/css/syntax.css" rel="stylesheet" type="text/css"> +<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"> + +<link rel="shortcut icon" href="/favicon.ico" type="image/x-icon"> +<link rel="icon" href="/favicon.ico" type="image/x-icon"> + +<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="/"></a></li> + <li> + <a href="/overview/">Documentation</a> + <ul> + <li><a href="/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="/why/">Why Drill? </a></li> + <li><a href="/architecture/">Architecture</a></li> + </ul> + </li> + <li> + <a href="/community/">Community</a> + <ul> + <li><a href="/team/">Team</a></li> + <li><a href="/community/#events">Events and Meetups</a></li> + <li><a href="/community/#mailinglists">Mailing Lists</a></li> + <li><a href="/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/drill" target="_blank">GitHub</a></li> + </ul> + </li> + <li><a href="/faq/">FAQ</a></li> + <li><a href="/blog/">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/">Download</a></li> +</ul> +</div> + +<div class="int_title"> +<h1>Handling Different Data Types</h1> + +</div> + +<div class="int_text" align="left"><p><a href="/docs/supported-date-time-data-type-formats">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/lexical-structure">Next</a></p> + +<h2 id="handling-hbase-data">Handling HBase Data</h2> + +<p>To query HBase data in Drill, convert every column of an HBase table to/from byte arrays from/to an SQL data type using CONVERT_TO or CONVERT_FROM. For examples of how to use these functions, see "Convert and Cast Functions".</p> + +<h2 id="handling-textual-data">Handling Textual Data</h2> + +<p>In a textual file, such as CSV, Drill interprets every field as a VARCHAR, as previously mentioned. In addition to using the CAST function, you can also use to_char, to_date, to_number, and to_timestamp. If the SELECT statement includes a WHERE clause that compares a column of an unknown data type, cast both the value of the column and the comparison value in the WHERE clause.</p> + +<h2 id="handling-json-and-parquet-data">Handling JSON and Parquet Data</h2> + +<p>Complex and nested data structures in JSON and Parquet files are of map and array types.</p> + +<p>A map is a set of name/value pairs. A value in a map can be a scalar type, such as string or int, or a complex type, such as an array or another map. +An array is a repeated list of values. A value in an array can be a scalar type, such as string or int, or an array can be a complex type, such as a map or another array.</p> + +<p>Drill reads/writes maps and arrays from/to JSON and Parquet files. In Drill, you do not cast a map or array to another type.</p> + +<p>The following example shows a JSON map having scalar values:</p> +<div class="highlight"><pre><code class="language-text" data-lang="text">phoneNumber: +{ + areaCode: 622, + number: 1567845 +} +</code></pre></div> +<p>The following example shows a JSON map having an array as a value:</p> +<div class="highlight"><pre><code class="language-text" data-lang="text">{ citiesLived : + [ + { place : Los Angeles, + yearsLived : [ 1989, 1993, 1998, 2002] + } + ] +} +</code></pre></div> +<p>The following example shows a JSON array having scalar values:</p> +<div class="highlight"><pre><code class="language-text" data-lang="text">yearsLived: [1990, 1993, 1998, 2008] +</code></pre></div> +<p>The following example shows a JSON array having complex type values:</p> +<div class="highlight"><pre><code class="language-text" data-lang="text">children: + [ + { age : 10, + gender : Male, + name : Earl + }, + { age : 6, + gender : Male, + name : Sam, + { age : 8, + gender : Male, + name : Kit + } + ] +</code></pre></div> +<h2 id="all-text-mode-option">All text mode option</h2> + +<p>All text mode is a system option for controlling how Drill implicitly casts JSON data. When reading numerical values from a JSON file, Drill implicitly casts a number to the DOUBLE or BIGINT type depending on the presence or absence a decimal point. If some numbers in a JSON map or array appear with and without a decimal point, such as 0 and 0.0, Drill throws a schema change error. To prevent Drill from attempting to read such data, <a href="/docs/json-data-model#handling-type-differences">set all_text_mode</a> to true. In all text mode, Drill implicitly casts JSON data to VARCHAR, which you can subsequently cast to desired types.</p> + +<p>Drill reads numbers without decimal point as BIGINT values by default. The range of BIGINT is -9223372036854775808 to 9223372036854775807. A BIGINT result outside this range produces an error. Use <code>all_text_mode</code> to select data as VARCHAR and then cast the data to a numerical type.</p> + +<h2 id="guidelines-for-using-float-and-double">Guidelines for Using Float and Double</h2> + +<p>FLOAT and DOUBLE yield approximate results. These are variable-precision numeric types. Drill does not cast/convert all values precisely to the internal format, but instead stores approximations. Slight differences can occur in the value stored and retrieved. The following guidelines are recommended:</p> + +<ul> +<li>For conversions involving monetary calculations, for example, that require precise results use the decimal type instead of float or double.</li> +<li>For complex calculations or mission-critical applications, especially those involving infinity and underflow situations, carefully consider the limitations of type casting that involves FLOAT or DOUBLE.</li> +<li>Equality comparisons between floating-point values can produce unexpected results.</li> +</ul> + +<p>Values of FLOAT and DOUBLE that are less than the lowest value in the range (more negative) cause an error. Rounding can occur if the precision of an input number is too high. </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 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/> +</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> Modified: drill/site/trunk/content/drill/docs/hbase-storage-plugin/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/hbase-storage-plugin/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/hbase-storage-plugin/index.html (original) +++ drill/site/trunk/content/drill/docs/hbase-storage-plugin/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><p>Register a storage plugin instance and specify a zookeeper quorum to connect +<div class="int_text" align="left"><p><a href="/docs/file-system-storage-plugin">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/hive-storage-plugin">Next</a></p> + +<p>Register a storage plugin instance and specify a zookeeper quorum to connect Drill to an HBase data source. When you register a storage plugin instance for an HBase data source, provide a unique name for the instance, and identify the type as âhbaseâ in the Drill Web UI.</p> Modified: drill/site/trunk/content/drill/docs/hive-storage-plugin/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/hive-storage-plugin/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/hive-storage-plugin/index.html (original) +++ drill/site/trunk/content/drill/docs/hive-storage-plugin/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><p>You can register a storage plugin instance that connects Drill to a Hive data +<div class="int_text" align="left"><p><a href="/docs/hbase-storage-plugin">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/drill-default-input-format">Next</a></p> + +<p>You can register a storage plugin instance that connects Drill to a Hive data source that has a remote or embedded metastore service. When you register a storage plugin instance for a Hive data source, provide a unique name for the instance, and identify the type as â<code>hive</code>â. You must also provide the Modified: drill/site/trunk/content/drill/docs/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/index.html (original) +++ drill/site/trunk/content/drill/docs/index.html Wed Mar 18 20:35:57 2015 @@ -405,6 +405,20 @@ + + + + + + + + + + + + + + </ul> @@ -639,6 +653,20 @@ + + + + + + + + + + + + + + </ul> @@ -907,6 +935,20 @@ + + + + + + + + + + + + + + <li><a href="/docs/installing-the-apache-drill-sandbox/">Installing the Apache Drill Sandbox</a></li> @@ -1182,6 +1224,20 @@ + + + + + + + + + + + + + + <li><a href="/docs/installing-the-mapr-sandbox-with-apache-drill-on-vmware-player-vmware-fusion/">Installing the MapR Sandbox with Apache Drill on VMware Player/VMware Fusion</a></li> @@ -1661,6 +1717,20 @@ + + + + + + + + + + + + + + </ul> @@ -1824,6 +1894,20 @@ + + + + + + + + + + + + + + </ul> @@ -2181,6 +2265,20 @@ + + + + + + + + + + + + + + </ul> @@ -2413,6 +2511,20 @@ + + + + + + + + + + + + + + </ul> @@ -2551,7 +2663,14 @@ - <li><a href="/docs/using-the-mapr-odbc-driver-on-windows/">Using the MapR ODBC Driver on Windows</a></li> + <li><a href="/docs/using-the-jdbc-driver/">Using the JDBC Driver</a></li> + + + + + + + <li><a href="/docs/using-the-mapr-odbc-driver-on-linux-and-mac-os-x/">Using the MapR ODBC Driver on Linux and Mac OS X</a></li> @@ -2690,37 +2809,55 @@ + <li><a href="/docs/installing-the-mapr-drill-odbc-driver-on-linux/">Installing the MapR Drill ODBC Driver on Linux</a></li> + + <li><a href="/docs/installing-the-mapr-drill-odbc-driver-on-mac-os-x/">Installing the MapR Drill ODBC Driver on Mac OS X</a></li> + + <li><a href="/docs/configuring-odbc-connections-for-linux-and-mac-os-x/">Configuring ODBC Connections for Linux and Mac OS X</a></li> + + + + <li><a href="/docs/driver-configuration-options/">Driver Configuration Options</a></li> + + + + <li><a href="/docs/configuring-odbc-connections-for-linux-and-mac-os-x/">Configuring ODBC Connections for Linux and Mac OS X</a></li> + + <li><a href="/docs/advanced-properties/">Advanced Properties</a></li> + + <li><a href="/docs/testing-the-odbc-connection-on-linux-and-mac-os-x/">Testing the ODBC Connection on Linux and Mac OS X</a></li> + - <li><a href="/docs/step-1-install-the-mapr-drill-odbc-driver-on-windows/">Step 1. Install the MapR Drill ODBC Driver on Windows</a></li> + - <li><a href="/docs/step-2-configure-odbc-connections-to-drill-data-sources/">Step 2. Configure ODBC Connections to Drill Data Sources</a></li> + - <li><a href="/docs/step-3-connect-to-drill-data-sources-from-a-bi-tool/">Step 3. Connect to Drill Data Sources from a BI Tool</a></li> + - <li><a href="/docs/tableau-examples/">Tableau Examples</a></li> + - <li><a href="/docs/using-drill-explorer-to-browse-data-and-create-views/">Using Drill Explorer to Browse Data and Create Views</a></li> + @@ -2844,7 +2981,7 @@ - <li><a href="/docs/using-the-mapr-odbc-driver-on-linux-and-mac-os-x/">Using the MapR ODBC Driver on Linux and Mac OS X</a></li> + <li><a href="/docs/using-the-mapr-odbc-driver-on-windows/">Using the MapR ODBC Driver on Windows</a></li> @@ -2983,31 +3120,41 @@ - <li><a href="/docs/installing-the-mapr-drill-odbc-driver-on-linux/">Installing the MapR Drill ODBC Driver on Linux</a></li> + - <li><a href="/docs/installing-the-mapr-drill-odbc-driver-on-mac-os-x/">Installing the MapR Drill ODBC Driver on Mac OS X</a></li> + - <li><a href="/docs/configuring-odbc-connections-for-linux-and-mac-os-x/">Configuring ODBC Connections for Linux and Mac OS X</a></li> + - <li><a href="/docs/driver-configuration-options/">Driver Configuration Options</a></li> + + + <li><a href="/docs/step-1-install-the-mapr-drill-odbc-driver-on-windows/">Step 1. Install the MapR Drill ODBC Driver on Windows</a></li> - <li><a href="/docs/configuring-odbc-connections-for-linux-and-mac-os-x/">Configuring ODBC Connections for Linux and Mac OS X</a></li> + <li><a href="/docs/step-2-configure-odbc-connections-to-drill-data-sources/">Step 2. Configure ODBC Connections to Drill Data Sources</a></li> - <li><a href="/docs/advanced-properties/">Advanced Properties</a></li> + <li><a href="/docs/step-3-connect-to-drill-data-sources-from-a-bi-tool/">Step 3. Connect to Drill Data Sources from a BI Tool</a></li> - <li><a href="/docs/testing-the-odbc-connection-on-linux-and-mac-os-x/">Testing the ODBC Connection on Linux and Mac OS X</a></li> + <li><a href="/docs/tableau-examples/">Tableau Examples</a></li> + + + + <li><a href="/docs/using-drill-explorer-to-browse-data-and-create-views/">Using Drill Explorer to Browse Data and Create Views</a></li> + + + + @@ -3141,10 +3288,17 @@ - <li><a href="/docs/using-the-jdbc-driver/">Using the JDBC Driver</a></li> - - - + + + + + + + + + + + @@ -3759,6 +3913,20 @@ + + + + + + + + + + + + + + </ul> @@ -4050,6 +4218,20 @@ + + + + + + + + + + + + + + </ul> @@ -4350,6 +4532,20 @@ + + + + + + + + + + + + + + </ul> @@ -4457,6 +4653,20 @@ + + + + + + + + + + + + + + </ul> @@ -4693,7 +4903,7 @@ - <li><a href="/docs/data-type-casting/">Data Type Casting</a></li> + <li><a href="/docs/data-types/">Data Types</a></li> @@ -4946,11 +5156,25 @@ - <li><a href="/docs/date-time-formats/">Date/Time Formats</a></li> + + + + + + + + + + + + + + + <li><a href="/docs/date-time-and-timestamp/">Date, Time, and Timestamp</a></li> - <li><a href="/docs/handling-disparate-data-types/">Handling Disparate Data Types</a></li> + <li><a href="/docs/handling-different-data-types/">Handling Different Data Types</a></li> @@ -5258,6 +5482,20 @@ + + + + + + + + + + + + + + <li><a href="/docs/flatten-function/">FLATTEN Function</a></li> @@ -5535,10 +5773,26 @@ + <li><a href="/docs/alter-session-command/">ALTER SESSION Command</a></li> + + + + <li><a href="/docs/alter-system-command/">ALTER SYSTEM Command</a></li> + + + <li><a href="/docs/create-table-as-ctas-command/">CREATE TABLE AS (CTAS) command</a></li> + <li><a href="/docs/create-view-command/">CREATE VIEW command</a></li> + + + + <li><a href="/docs/describe-command/">DESCRIBE Command</a></li> + + + <li><a href="/docs/explain-commands/">EXPLAIN commands</a></li> @@ -5547,10 +5801,22 @@ + <li><a href="/docs/show-databases-and-show-schemas-command/">SHOW DATABASES AND SHOW SCHEMAS Command</a></li> + + + <li><a href="/docs/show-files-command/">SHOW FILES Command</a></li> + <li><a href="/docs/show-tables-command/">SHOW TABLES Command</a></li> + + + + <li><a href="/docs/use-command/">USE Command</a></li> + + + @@ -5621,6 +5887,20 @@ + + + + + + + + + + + + + + </ul> @@ -5924,6 +6204,20 @@ + + + + + + + + + + + + + + </ul> @@ -6232,6 +6526,20 @@ + + + + + + + + + + + + + + </ul> @@ -6686,6 +6994,20 @@ + + + + + + + + + + + + + + </ul> @@ -6824,6 +7146,20 @@ + + + + + + + + + + + + + + </ul> @@ -7122,6 +7458,20 @@ + + + + + + + + + + + + + + </ul> @@ -7430,6 +7780,20 @@ + + + + + + + + + + + + + + </ul> @@ -7723,6 +8087,20 @@ + + + + + + + + + + + + + + </ul> @@ -8021,6 +8399,20 @@ + + + + + + + + + + + + + + </ul> @@ -8329,6 +8721,20 @@ + + + + + + + + + + + + + + </ul> @@ -8622,6 +9028,20 @@ + + + + + + + + + + + + + + </ul> @@ -8910,6 +9330,20 @@ + + + + + + + + + + + + + + </ul> @@ -8922,6 +9356,20 @@ + + + + + + + + + + + + + + Modified: drill/site/trunk/content/drill/docs/install-drill/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/install-drill/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/install-drill/index.html (original) +++ drill/site/trunk/content/drill/docs/install-drill/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><p>You can install Drill in embedded mode or in distributed mode. Installing +<div class="int_text" align="left"><p><a href="/docs/analyzing-yelp-json-data-with-apache-drill">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/apache-drill-in-10-minutes">Next</a></p> + +<p>You can install Drill in embedded mode or in distributed mode. Installing Drill in embedded mode does not require any configuration, which means that you can quickly get started with Drill. If you want to use Drill in a clustered Hadoop environment, you can install Drill in distributed mode. Modified: drill/site/trunk/content/drill/docs/installing-drill-in-distributed-mode/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/installing-drill-in-distributed-mode/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/installing-drill-in-distributed-mode/index.html (original) +++ drill/site/trunk/content/drill/docs/installing-drill-in-distributed-mode/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><p>You can install Apache Drill in distributed mode on one or multiple nodes to +<div class="int_text" align="left"><p><a href="/docs/installing-drill-on-windows">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/connect-to-a-data-source">Next</a></p> + +<p>You can install Apache Drill in distributed mode on one or multiple nodes to run it in a clustered environment.</p> <p>To install Apache Drill in distributed mode, complete the following steps:</p> Modified: drill/site/trunk/content/drill/docs/installing-drill-in-embedded-mode/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/installing-drill-in-embedded-mode/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/installing-drill-in-embedded-mode/index.html (original) +++ drill/site/trunk/content/drill/docs/installing-drill-in-embedded-mode/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><p>Installing Drill in embedded mode installs Drill locally on your machine. +<div class="int_text" align="left"><p><a href="/docs/deploying-apache-drill-in-a-clustered-environment">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/installing-drill-on-linux">Next</a></p> + +<p>Installing Drill in embedded mode installs Drill locally on your machine. Embedded mode is a quick, easy way to install and try Drill without having to perform any configuration tasks. When you install Drill in embedded mode, the Drillbit service is installed locally and starts automatically when you invoke Modified: drill/site/trunk/content/drill/docs/installing-drill-on-linux/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/installing-drill-on-linux/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/installing-drill-on-linux/index.html (original) +++ drill/site/trunk/content/drill/docs/installing-drill-on-linux/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><p>Complete the following steps to install Apache Drill on a machine running +<div class="int_text" align="left"><p><a href="/docs/installing-drill-in-embedded-mode">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/installing-drill-on-mac-os-x">Next</a></p> + +<p>Complete the following steps to install Apache Drill on a machine running Linux:</p> <ol> Modified: drill/site/trunk/content/drill/docs/installing-drill-on-mac-os-x/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/installing-drill-on-mac-os-x/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/installing-drill-on-mac-os-x/index.html (original) +++ drill/site/trunk/content/drill/docs/installing-drill-on-mac-os-x/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><p>Complete the following steps to install Apache Drill on a machine running Mac +<div class="int_text" align="left"><p><a href="/docs/installing-drill-on-linux">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/installing-drill-on-windows">Next</a></p> + +<p>Complete the following steps to install Apache Drill on a machine running Mac OS X:</p> <ol> Modified: drill/site/trunk/content/drill/docs/installing-drill-on-windows/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/installing-drill-on-windows/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/installing-drill-on-windows/index.html (original) +++ drill/site/trunk/content/drill/docs/installing-drill-on-windows/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><p>You can install Drill on Windows 7 or 8. To install Drill on Windows, you must +<div class="int_text" align="left"><p><a href="/docs/installing-drill-on-mac-os-x">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/installing-drill-in-distributed-mode">Next</a></p> + +<p>You can install Drill on Windows 7 or 8. To install Drill on Windows, you must have JDK 7, and you must set the <code>JAVA_HOME</code> path in the Windows Environment Variables. You must also have a utility, such as <a href="http://www.7-zip.org/">7-zip</a>, installed on your machine. These instructions Modified: drill/site/trunk/content/drill/docs/installing-the-apache-drill-sandbox/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/installing-the-apache-drill-sandbox/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/installing-the-apache-drill-sandbox/index.html (original) +++ drill/site/trunk/content/drill/docs/installing-the-apache-drill-sandbox/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><h2 id="prerequisites">Prerequisites</h2> +<div class="int_text" align="left"><p><a href="/docs/apache-drill-tutorial">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/installing-the-mapr-sandbox-with-apache-drill-on-vmware-player-vmware-fusion">Next</a></p> + +<h2 id="prerequisites">Prerequisites</h2> <p>The MapR Sandbox with Apache Drill runs on VMware Player and VirtualBox, free desktop applications that you can use to run a virtual machine on a Windows, Modified: drill/site/trunk/content/drill/docs/installing-the-mapr-drill-odbc-driver-on-linux/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/installing-the-mapr-drill-odbc-driver-on-linux/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/installing-the-mapr-drill-odbc-driver-on-linux/index.html (original) +++ drill/site/trunk/content/drill/docs/installing-the-mapr-drill-odbc-driver-on-linux/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><p>Install the MapR Drill ODBC Driver on the machine from which you connect to +<div class="int_text" align="left"><p><a href="/docs/using-the-mapr-odbc-driver-on-linux-and-mac-os-x">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/installing-the-mapr-drill-odbc-driver-on-mac-os-x">Next</a></p> + +<p>Install the MapR Drill ODBC Driver on the machine from which you connect to the Drill service. You can install the 32- or 64-bit driver on Linux. Install the version of the driver that matches the architecture of the client application that you use to access Drill. The 64-bit editions of Linux support Modified: drill/site/trunk/content/drill/docs/installing-the-mapr-drill-odbc-driver-on-mac-os-x/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/installing-the-mapr-drill-odbc-driver-on-mac-os-x/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/installing-the-mapr-drill-odbc-driver-on-mac-os-x/index.html (original) +++ drill/site/trunk/content/drill/docs/installing-the-mapr-drill-odbc-driver-on-mac-os-x/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><p>Install the MapR Drill ODBC Driver on the machine from which you connect to +<div class="int_text" align="left"><p><a href="/docs/installing-the-mapr-drill-odbc-driver-on-linux">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/configuring-odbc-connections-for-linux-and-mac-os-x">Next</a></p> + +<p>Install the MapR Drill ODBC Driver on the machine from which you connect to the Drill service.</p> <p>To install the MapR Drill ODBC Driver, complete the following steps:</p> Modified: drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-virtualbox/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-virtualbox/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-virtualbox/index.html (original) +++ drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-virtualbox/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><p>The MapR Sandbox for Apache Drill on VirtualBox comes with NAT port forwarding +<div class="int_text" align="left"><p><a href="/docs/installing-the-mapr-sandbox-with-apache-drill-on-vmware-player-vmware-fusion">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/getting-to-know-the-drill-sandbox">Next</a></p> + +<p>The MapR Sandbox for Apache Drill on VirtualBox comes with NAT port forwarding enabled, which allows you to access the sandbox using localhost as hostname.</p> <p>Complete the following steps to install the MapR Sandbox with Apache Drill on Modified: drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-vmware-player-vmware-fusion/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-vmware-player-vmware-fusion/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-vmware-player-vmware-fusion/index.html (original) +++ drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-vmware-player-vmware-fusion/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><p>Complete the following steps to install the MapR Sandbox with Apache Drill on +<div class="int_text" align="left"><p><a href="/docs/installing-the-apache-drill-sandbox">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/installing-the-mapr-sandbox-with-apache-drill-on-virtualbox">Next</a></p> + +<p>Complete the following steps to install the MapR Sandbox with Apache Drill on VMware Player or VMware Fusion:</p> <ol> Modified: drill/site/trunk/content/drill/docs/lession-1-learn-about-the-data-set/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/lession-1-learn-about-the-data-set/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/lession-1-learn-about-the-data-set/index.html (original) +++ drill/site/trunk/content/drill/docs/lession-1-learn-about-the-data-set/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><h2 id="goal">Goal</h2> +<div class="int_text" align="left"><p><a href="/docs/getting-to-know-the-drill-sandbox">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/lession-2-run-queries-with-ansi-sql">Next</a></p> + +<h2 id="goal">Goal</h2> <p>This lesson is simply about discovering what data is available, in what format, using simple SQL SELECT statements. Drill is capable of analyzing data Modified: drill/site/trunk/content/drill/docs/lession-2-run-queries-with-ansi-sql/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/lession-2-run-queries-with-ansi-sql/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/lession-2-run-queries-with-ansi-sql/index.html (original) +++ drill/site/trunk/content/drill/docs/lession-2-run-queries-with-ansi-sql/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><h2 id="goal">Goal</h2> +<div class="int_text" align="left"><p><a href="/docs/lession-1-learn-about-the-data-set">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/lession-3-run-queries-on-complex-data-types">Next</a></p> + +<h2 id="goal">Goal</h2> <p>This lesson shows how to do some standard SQL analysis in Apache Drill: for example, summarizing data by using simple aggregate functions and connecting Modified: drill/site/trunk/content/drill/docs/lession-3-run-queries-on-complex-data-types/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/lession-3-run-queries-on-complex-data-types/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/lession-3-run-queries-on-complex-data-types/index.html (original) +++ drill/site/trunk/content/drill/docs/lession-3-run-queries-on-complex-data-types/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><h2 id="goal">Goal</h2> +<div class="int_text" align="left"><p><a href="/docs/lession-2-run-queries-with-ansi-sql">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/summary">Next</a></p> + +<h2 id="goal">Goal</h2> <p>This lesson focuses on queries that exercise functions and operators on self- describing data and complex data types. Drill offers intuitive SQL extensions Modified: drill/site/trunk/content/drill/docs/mapr-db-format/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/mapr-db-format/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/mapr-db-format/index.html (original) +++ drill/site/trunk/content/drill/docs/mapr-db-format/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><p>Drill includes a <code>maprdb</code> format for reading MapR-DB data. The <code>dfs</code> storage plugin defines the format when you install Drill from the <code>mapr-drill</code> package on a MapR node. The <code>maprdb</code> format plugin improves the +<div class="int_text" align="left"><p><a href="/docs/mongodb-plugin-for-apache-drill">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/odbc-jdbc-interfaces">Next</a></p> + +<p>Drill includes a <code>maprdb</code> format for reading MapR-DB data. The <code>dfs</code> storage plugin defines the format when you install Drill from the <code>mapr-drill</code> package on a MapR node. The <code>maprdb</code> format plugin improves the estimated number of rows that Drill uses to plan a query. It also enables you to query tables like you would query files in a file system because MapR-DB and MapR-FS share the same namespace.</p> Modified: drill/site/trunk/content/drill/docs/mongodb-plugin-for-apache-drill/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/mongodb-plugin-for-apache-drill/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/mongodb-plugin-for-apache-drill/index.html (original) +++ drill/site/trunk/content/drill/docs/mongodb-plugin-for-apache-drill/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><h2 id="overview">Overview</h2> +<div class="int_text" align="left"><p><a href="/docs/drill-default-input-format">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/mapr-db-format/">Next</a></p> + +<h2 id="overview">Overview</h2> <p>You can leverage the power of Apache Drill to query data without any upfront schema definitions. Drill enables you to create an architecture that works Modified: drill/site/trunk/content/drill/docs/odbc-jdbc-interfaces/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/odbc-jdbc-interfaces/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/odbc-jdbc-interfaces/index.html (original) +++ drill/site/trunk/content/drill/docs/odbc-jdbc-interfaces/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><p>You can connect to Apache Drill through the following interfaces:</p> +<div class="int_text" align="left"><p><a href="/docs/mapr-db-format/">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/using-the-mapr-odbc-driver-on-windows">Next</a></p> + +<p>You can connect to Apache Drill through the following interfaces:</p> <ul> <li>Drill shell (SQLLine)</li> Modified: drill/site/trunk/content/drill/docs/performance/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/performance/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/performance/index.html (original) +++ drill/site/trunk/content/drill/docs/performance/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><p>Drill is designed from the ground up for high performance on large datasets. +<div class="int_text" align="left"><p><a href="/docs/flexibility">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/apache-drill-tutorial">Next</a></p> + +<p>Drill is designed from the ground up for high performance on large datasets. The following core elements of Drill processing are responsible for Drill's performance:</p> Modified: drill/site/trunk/content/drill/docs/query-data/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/query-data/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/query-data/index.html (original) +++ drill/site/trunk/content/drill/docs/query-data/index.html Wed Mar 18 20:35:57 2015 @@ -67,7 +67,9 @@ </div> -<div class="int_text" align="left"><p>You can query local and distributed file systems, Hive, and HBase data sources +<div class="int_text" align="left"><p><a href="/docs/using-drill-explorer-to-browse-data-and-create-views">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/getting-started-tutorial">Next</a></p> + +<p>You can query local and distributed file systems, Hive, and HBase data sources registered with Drill. If you connected directly to a particular schema when you invoked SQLLine, you can issue SQL queries against that schema. If you did not indicate a schema when you invoked SQLLine, you can issue the <code>USE Modified: drill/site/trunk/content/drill/docs/select-statements/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/select-statements/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff ============================================================================== --- drill/site/trunk/content/drill/docs/select-statements/index.html (original) +++ drill/site/trunk/content/drill/docs/select-statements/index.html Wed Mar 18 20:35:57 2015 @@ -173,7 +173,98 @@ all return Boolean results.</p> <p>In general, correlated subqueries are supported. EXISTS and NOT EXISTS subqueries that do not contain a correlation join are not yet supported.</p> -</div> + +<h2 id="with-clause">WITH Clause</h2> + +<p>The WITH clause is an optional clause used to contain one or more common table +expressions (CTE) where each CTE defines a temporary table that exists for the +duration of the query. Each subquery in the WITH clause specifies a table +name, an optional list of column names, and a SELECT statement.</p> + +<h2 id="syntax">Syntax</h2> + +<p>The WITH clause supports the following syntax:</p> +<div class="highlight"><pre><code class="language-text" data-lang="text">[ WITH with_subquery [, ...] ] +where with_subquery is: +with_subquery_table_name [ ( column_name [, ...] ) ] AS ( query ) +</code></pre></div> +<h2 id="parameters">Parameters</h2> + +<p><em>with_subquery</em>table_name_</p> + +<p>A unique name for a temporary table that defines the results of a WITH clause +subquery. You cannot use duplicate names within a single WITH clause. You must +give each subquery a table name that can be referenced in the FROM clause.</p> + +<p><em>column</em>name_</p> + +<p>An optional list of output column names for the WITH clause subquery, +separated by commas. The number of column names specified must be equal to or +less than the number of columns defined by the subquery.</p> + +<p><em>query</em></p> + +<p>Any SELECT query that Drill supports. See +<a href="/docs/SELECT+Statements">SELECT</a>.</p> + +<h2 id="usage-notes">Usage Notes</h2> + +<p>Use the WITH clause to efficiently define temporary tables that Drill can +access throughout the execution of a single query. The WITH clause is +typically a simpler alternative to using subqueries in the main body of the +SELECT statement. In some cases, Drill can evaluate a WITH subquery once and +reuse the results for query optimization.</p> + +<p>You can use a WITH clause in the following SQL statements:</p> + +<ul> +<li><p>SELECT (including subqueries within SELECT statements)</p></li> +<li><p>CREATE TABLE AS</p></li> +<li><p>CREATE VIEW</p></li> +<li><p>EXPLAIN</p></li> +</ul> + +<p>You can reference the temporary tables in the FROM clause of the query. If the +FROM clause does not reference any tables defined by the WITH clause, Drill +ignores the WITH clause and executes the query as normal.</p> + +<p>Drill can only reference a table defined by a WITH clause subquery in the +scope of the SELECT query that the WITH clause begins. For example, you can +reference such a table in the FROM clause of a subquery in the SELECT list, +WHERE clause, or HAVING clause. You cannot use a WITH clause in a subquery and +reference its table in the FROM clause of the main query or another subquery.</p> + +<p>You cannot specify another WITH clause inside a WITH clause subquery.</p> + +<p>For example, the following query includes a forward reference to table t2 in +the definition of table t1:</p> + +<h2 id="example">Example</h2> + +<p>The following example shows the WITH clause used to create a WITH query named +<code>emp_data</code> that selects all of the rows from the <code>employee.json</code> file. The +main query selects the <code>full_name, position_title, salary</code>, and <code>hire_date</code> +rows from the <code>emp_data</code> temporary table (created from the WITH subquery) and +orders the results by the hire date. The <code>emp_data</code> table only exists for the +duration of the query.</p> + +<p><strong>Note:</strong> The <code>employee.json</code> file is included with the Drill installation. It is located in the <code>cp.default</code> workspace which is configured by default. </p> +<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> with emp_data as (select * from cp.`employee.json`) select full_name, position_title, salary, hire_date from emp_data order by hire_date limit 10; ++------------------+-------------------------+------------+-----------------------+ +| full_name | position_title | salary | hire_date | ++------------------+-------------------------+------------+-----------------------+ +| Bunny McCown | Store Assistant Manager | 8000.0 | 1993-05-01 00:00:00.0 | +| Danielle Johnson | Store Assistant Manager | 8000.0 | 1993-05-01 00:00:00.0 | +| Dick Brummer | Store Assistant Manager | 7900.0 | 1993-05-01 00:00:00.0 | +| Gregory Whiting | Store Assistant Manager | 10000.0 | 1993-05-01 00:00:00.0 | +| Juanita Sharp | HQ Human Resources | 6700.0 | 1994-01-01 00:00:00.0 | +| Sheri Nowmer | President | 80000.0 | 1994-12-01 00:00:00.0 | +| Rebecca Kanagaki | VP Human Resources | 15000.0 | 1994-12-01 00:00:00.0 | +| Shauna Wyro | Store Manager | 15000.0 | 1994-12-01 00:00:00.0 | +| Roberta Damstra | VP Information Systems | 25000.0 | 1994-12-01 00:00:00.0 | +| Pedro Castillo | VP Country Manager | 35000.0 | 1994-12-01 00:00:00.0 | ++------------+----------------+--------------+------------------------------------+ +</code></pre></div></div> <div id="footer" class="mw"> Added: drill/site/trunk/content/drill/docs/show-databases-and-show-schemas-command/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/show-databases-and-show-schemas-command/index.html?rev=1667611&view=auto ============================================================================== --- drill/site/trunk/content/drill/docs/show-databases-and-show-schemas-command/index.html (added) +++ drill/site/trunk/content/drill/docs/show-databases-and-show-schemas-command/index.html Wed Mar 18 20:35:57 2015 @@ -0,0 +1,144 @@ +<!DOCTYPE html> +<html> + +<head> + +<meta charset="UTF-8"> + + +<title>SHOW DATABASES AND SHOW SCHEMAS Command - Apache Drill</title> + +<link href="/css/syntax.css" rel="stylesheet" type="text/css"> +<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"> + +<link rel="shortcut icon" href="/favicon.ico" type="image/x-icon"> +<link rel="icon" href="/favicon.ico" type="image/x-icon"> + +<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="/"></a></li> + <li> + <a href="/overview/">Documentation</a> + <ul> + <li><a href="/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="/why/">Why Drill? </a></li> + <li><a href="/architecture/">Architecture</a></li> + </ul> + </li> + <li> + <a href="/community/">Community</a> + <ul> + <li><a href="/team/">Team</a></li> + <li><a href="/community/#events">Events and Meetups</a></li> + <li><a href="/community/#mailinglists">Mailing Lists</a></li> + <li><a href="/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/drill" target="_blank">GitHub</a></li> + </ul> + </li> + <li><a href="/faq/">FAQ</a></li> + <li><a href="/blog/">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/">Download</a></li> +</ul> +</div> + +<div class="int_title"> +<h1>SHOW DATABASES AND SHOW SCHEMAS Command</h1> + +</div> + +<div class="int_text" align="left"><p>The SHOW DATABASES and SHOW SCHEMAS commands generate a list of available Drill schemas that you can query.</p> + +<h2 id="syntax">Syntax</h2> + +<p>The SHOW DATABASES and SHOW SCHEMAS commands support the following syntax:</p> +<div class="highlight"><pre><code class="language-text" data-lang="text">SHOW DATABASES; +SHOW SCHEMAS; +</code></pre></div> +<p><strong>Note:</strong> These commands generate the same results.</p> + +<h2 id="usage-notes">Usage Notes</h2> + +<p>You may want to run the SHOW DATABASES or SHOW SCHEMAS command to see a list of the configured storage plugins and workspaces in Drill before you issue the USE command to switch to a particular schema for your queries.</p> + +<p>In Drill, a database or schema is a configured storage plugin instance or a configured storage plugin instance with a configured workspace. For example, dfs.donuts where dfs is the file system configured as a storage plugin instance, and donuts is a configured workspace.</p> + +<p>You can configure and use multiple storage plugins and workspaces in Drill. See <a href="/docs/storage-plugin-registration">Storage Plugin Registration</a> and <a href="/docs/workspaces">Workspaces</a>.</p> + +<h2 id="example">Example</h2> + +<p>The following example uses the SHOW DATABASES and SHOW SCHEMAS commands to generate a list of the available schemas in Drill. Some of the results that display are specific to all Drill installations, such as <code>cp.default</code> and <code>dfs.default</code>, while others vary based on your specific storage plugin and workspace configurations.</p> +<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> show databases; ++-------------+ +| SCHEMA_NAME | ++-------------+ +| dfs.default | +| dfs.root | +| dfs.donuts | +| dfs.tmp | +| dfs.customers | +| dfs.yelp | +| cp.default | +| sys | +| INFORMATION_SCHEMA | ++-------------+ +9 rows selected (0.07 seconds) + + +0: jdbc:drill:zk=local> show schemas; ++-------------+ +| SCHEMA_NAME | ++-------------+ +| dfs.default | +| dfs.root | +| dfs.donuts | +| dfs.tmp | +| dfs.customers | +| dfs.yelp | +| cp.default | +| sys | +| INFORMATION_SCHEMA | ++-------------+ +9 rows selected (0.058 seconds) +</code></pre></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 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/> +</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: drill/site/trunk/content/drill/docs/show-tables-command/index.html URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/show-tables-command/index.html?rev=1667611&view=auto ============================================================================== --- drill/site/trunk/content/drill/docs/show-tables-command/index.html (added) +++ drill/site/trunk/content/drill/docs/show-tables-command/index.html Wed Mar 18 20:35:57 2015 @@ -0,0 +1,214 @@ +<!DOCTYPE html> +<html> + +<head> + +<meta charset="UTF-8"> + + +<title>SHOW TABLES Command - Apache Drill</title> + +<link href="/css/syntax.css" rel="stylesheet" type="text/css"> +<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"> + +<link rel="shortcut icon" href="/favicon.ico" type="image/x-icon"> +<link rel="icon" href="/favicon.ico" type="image/x-icon"> + +<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="/"></a></li> + <li> + <a href="/overview/">Documentation</a> + <ul> + <li><a href="/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="/why/">Why Drill? </a></li> + <li><a href="/architecture/">Architecture</a></li> + </ul> + </li> + <li> + <a href="/community/">Community</a> + <ul> + <li><a href="/team/">Team</a></li> + <li><a href="/community/#events">Events and Meetups</a></li> + <li><a href="/community/#mailinglists">Mailing Lists</a></li> + <li><a href="/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/drill" target="_blank">GitHub</a></li> + </ul> + </li> + <li><a href="/faq/">FAQ</a></li> + <li><a href="/blog/">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/">Download</a></li> +</ul> +</div> + +<div class="int_title"> +<h1>SHOW TABLES Command</h1> + +</div> + +<div class="int_text" align="left"><p>The SHOW TABLES command returns a list of views created within a schema. It +also returns the tables that exist in Hive, HBase, and MapR-DB when you have +these data sources configured as storage plugin instances. See<a href="/docs/storage-plugin-registration"> Storage Plugin +Registration</a>.</p> + +<h2 id="syntax">Syntax</h2> + +<p>The SHOW TABLES command supports the following syntax:</p> +<div class="highlight"><pre><code class="language-text" data-lang="text">SHOW TABLES; +</code></pre></div> +<h2 id="usage-notes">Usage Notes</h2> + +<p>First issue the USE command to identify the schema for which you want to view +tables or views. For example, the following USE statement tells Drill that you +only want information from the <code>dfs.myviews</code> schema:</p> +<div class="highlight"><pre><code class="language-text" data-lang="text">USE dfs.myviews; +</code></pre></div> +<p>In this example, â<code>myviews</code>â is a workspace created withing an instance of the +<code>dfs</code> storage plugin.</p> + +<p>When you use a particular schema and then issue the SHOW TABLES command, Drill +returns the tables and views within that schema.</p> + +<h4 id="limitations">Limitations</h4> + +<ul> +<li><p>You can create and query tables within the file system, however Drill does not return these tables when you issue the SHOW TABLES command. You can issue the <a href="/docs/show-files-command">SHOW FILES </a>command to see a list of all files, tables, and views, including those created in Drill. </p></li> +<li><p>You cannot create Hive, HBase, or MapR-DB tables in Drill. </p></li> +</ul> + +<h2 id="examples">Examples</h2> + +<p>The following examples demonstrate the steps that you can follow when you want +to issue the SHOW TABLES command on the file system, Hive, and HBase. </p> + +<p>Complete the following steps to see views that exist in a file system and +tables that exist in Hive and HBase data sources:</p> + +<ol> +<li><p>Issue the SHOW SCHEMAS command to see a list of available schemas.</p> +<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=drilldemo:5181> show schemas; ++-------------+ +| SCHEMA_NAME | ++-------------+ +| hive.default | +| dfs.reviews | +| dfs.flatten | +| dfs.default | +| dfs.root | +| dfs.logs | +| dfs.myviews | +| dfs.clicks | +| dfs.tmp | +| sys | +| hbase | +| INFORMATION_SCHEMA | +| s3.twitter | +| s3.reviews | +| s3.default | ++-------------+ +15 rows selected (0.072 seconds) +</code></pre></div></li> +<li><p>Issue the USE command to switch to a particular schema. When you use a particular schema, Drill searches or queries within that schema only. </p> +<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=drilldemo:5181> use dfs.myviews; ++------------+------------+ +| ok | summary | ++------------+------------+ +| true | Default schema changed to 'dfs.myviews' | ++------------+------------+ +1 row selected (0.025 seconds) +</code></pre></div></li> +<li><p>Issue the SHOW TABLES command to see the views or tables that exist within workspace.</p> +<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=drilldemo:5181> show tables; ++--------------+------------+ +| TABLE_SCHEMA | TABLE_NAME | ++--------------+------------+ +| dfs.myviews | logs_vw | +| dfs.myviews | customers_vw | +| dfs.myviews | s3_review_vw | +| dfs.myviews | clicks_vw | +| dfs.myviews | nestedclickview | +| dfs.myviews | s3_user_vw | +| dfs.myviews | s3_bus_vw | ++--------------+------------+ +7 rows selected (0.499 seconds) +0: jdbc:drill:zk=drilldemo:5181> +</code></pre></div></li> +<li><p>Switch to the Hive schema and issue the SHOW TABLES command to see the Hive tables that exist.</p> +<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=drilldemo:5181> use hive; ++------------+------------+ +| ok | summary | ++------------+------------+ +| true | Default schema changed to 'hive' | ++------------+------------+ +1 row selected (0.043 seconds) + +0: jdbc:drill:zk=drilldemo:5181> show tables; ++--------------+------------+ +| TABLE_SCHEMA | TABLE_NAME | ++--------------+------------+ +| hive.default | orders | +| hive.default | products | ++--------------+------------+ +2 rows selected (0.552 seconds) +</code></pre></div></li> +<li><p>Switch to the HBase schema and issue the SHOW TABLES command to see the HBase tables that exist within the schema.</p> +<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=drilldemo:5181> use hbase; ++------------+------------+ +| ok | summary | ++------------+------------+ +| true | Default schema changed to 'hbase' | ++------------+------------+ +1 row selected (0.043 seconds) + +0: jdbc:drill:zk=drilldemo:5181> show tables; ++--------------+------------+ +| TABLE_SCHEMA | TABLE_NAME | ++--------------+------------+ +| hbase | customers | ++--------------+------------+ +1 row selected (0.412 seconds) +</code></pre></div></li> +</ol> +</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 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/> +</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>