You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by ad...@apache.org on 2015/02/26 02:16:45 UTC
svn commit: r1662344 [7/8] - in /drill/site/trunk/content/drill: ./
blog/2014/12/11/apache-drill-qa-panelist-spotlight/ docs/
docs/2014-q1-drill-report/ docs/advanced-properties/
docs/analyzing-yelp-json-data-with-apache-drill/ docs/apache-drill-0-6-0-...
Modified: drill/site/trunk/content/drill/docs/release-notes/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/release-notes/index.html?rev=1662344&r1=1662343&r2=1662344&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/release-notes/index.html (original)
+++ drill/site/trunk/content/drill/docs/release-notes/index.html Thu Feb 26 01:16:43 2015
@@ -80,7 +80,7 @@ Drill has been tested against MapR, Clou
distributions. There are associated build profiles and JIRAs that can help you
run Drill against your preferred distribution</p>
-<p>Apache Drill 0.7.0 Key Features</p>
+<h3 id="apache-drill-0.7.0-key-features">Apache Drill 0.7.0 Key Features</h3>
<ul>
<li><p>No more dependency on UDP/Multicast - Making it possible for Drill to work well in the following scenarios:</p>
@@ -104,7 +104,7 @@ run Drill against your preferred distrib
<li><p>Stability improvements in ODBC and JDBC drivers</p></li>
</ul>
-<p>Apache Drill 0.7.0 Key Notes and Limitations</p>
+<h3 id="apache-drill-0.7.0-key-notes-and-limitations">Apache Drill 0.7.0 Key Notes and Limitations</h3>
<ul>
<li>The current release supports in-memory and beyond-memory execution. However, you must disable memory-intensive hash aggregate and hash join operations to leverage this functionality.</li>
@@ -123,18 +123,18 @@ against Apache Hadoop. Drill has been te
Hortonworks Hadoop distributions. There are associated build profiles and
JIRAs that can help you run Drill against your preferred distribution.</p>
-<p>Apache Drill 0.6.0 Key Features</p>
+<h3 id="apache-drill-0.6.0-key-features">Apache Drill 0.6.0 Key Features</h3>
<p>This release is primarily a bug fix release, with <a href="https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12313820&vers%0Aion=12327472">more than 30 JIRAs closed</a>, but there are some notable features:</p>
<ul>
-<li>Direct ANSI SQL access to MongoDB, using the latest <a href="/confluence/display/DRILL/MongoDB+Plugin+for+Apache+Drill">MongoDB Plugin for Apache Drill</a></li>
+<li>Direct ANSI SQL access to MongoDB, using the latest <a href="/drill/docs/mongodb-plugin-for-apache-drill">MongoDB Plugin for Apache Drill</a></li>
<li>Filesystem query performance improvements with partition pruning</li>
<li>Ability to use the file system as a persistent store for query profiles and diagnostic information</li>
<li>Window function support (alpha)</li>
</ul>
-<p>Apache Drill 0.6.0 Key Notes and Limitations</p>
+<h3 id="apache-drill-0.6.0-key-notes-and-limitations">Apache Drill 0.6.0 Key Notes and Limitations</h3>
<ul>
<li>The current release supports in-memory and beyond-memory execution. However, you must disable memory-intensive hash aggregate and hash join operations to leverage this functionality.</li>
@@ -157,7 +157,7 @@ against Apache Hadoop. Drill has been te
Hortonworks Hadoop distributions. There are associated build profiles and
JIRAs that can help you run Drill against your preferred distribution.</p>
-<p>Apache Drill 0.5.0 Key Notes and Limitations</p>
+<h3 id="apache-drill-0.5.0-key-notes-and-limitations">Apache Drill 0.5.0 Key Notes and Limitations</h3>
<ul>
<li>The current release supports in memory and beyond memory execution. However, you must disable memory-intensive hash aggregate and hash join operations to leverage this functionality.</li>
@@ -191,7 +191,7 @@ MapR, Cloudera and Hortonworks Hadoop di
build profiles or JIRAs that can help you run against your preferred
distribution.</p>
-<p>Some Key Notes & Limitations</p>
+<h3 id="some-key-notes-&-limitations">Some Key Notes & Limitations</h3>
<ul>
<li>The current release supports in memory and beyond memory execution. However, users must disable memory-intensive hash aggregate and hash join operations to leverage this functionality.</li>
@@ -241,7 +241,7 @@ will be correct in a future milestone re
<li>Drill Alpha does not include, there are currently a couple of differences for how to write a query in In order to query against</li>
</ul>
-<p>UDFs</p>
+<h3 id="udfs">UDFs</h3>
<ul>
<li>Drill currently supports simple and aggregate functions using scalar, repeated and</li>
Modified: drill/site/trunk/content/drill/docs/repeated-count-function/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/repeated-count-function/index.html?rev=1662344&r1=1662343&r2=1662344&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/repeated-count-function/index.html (original)
+++ drill/site/trunk/content/drill/docs/repeated-count-function/index.html Thu Feb 26 01:16:43 2015
@@ -94,7 +94,7 @@ the count to be grouped by other columns
this example).</p>
<p>For another example of this function, see the following lesson in the Apache
-Drill Tutorial for Hadoop: <a href="/conf%0Aluence/display/DRILL/Lesson+3%3A+Run+Queries+on+Complex+Data+Types">Lesson 3: Run Queries on Complex Data Types</a>.</p>
+Drill Tutorial for Hadoop: <a href="/drill/docs/lession-3-run-queries-on-complex-data-types/">Lesson 3: Run Queries on Complex Data Types</a>.</p>
</div>
Added: drill/site/trunk/content/drill/docs/reserved-keywords/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/reserved-keywords/index.html?rev=1662344&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/reserved-keywords/index.html (added)
+++ drill/site/trunk/content/drill/docs/reserved-keywords/index.html Thu Feb 26 01:16:43 2015
@@ -0,0 +1,102 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Reserved Keywords - 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>Reserved Keywords</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>When you use a reserved keyword in a Drill query, enclose the word in
+backticks. For example, if you issue the following query to Drill,<br>
+you must include backticks around the word TABLES because TABLES is a reserved
+keyword:</p>
+
+<p><code>SELECT * FROM INFORMATION_SCHEMA.`TABLES`;</code></p>
+
+<p>The following table provides the Drill reserved keywords that require back
+ticks:</p>
+
+<table ><tbody><tr><td valign="top" ><h1 id="ReservedKeywords-A">A</h1><p>ABS<br />ALL<br />ALLOCATE<br />ALLOW<br />ALTER<br />AND<br />ANY<br />ARE<br />ARRAY<br />AS<br />ASENSITIVE<br />ASYMMETRIC<br />AT<br />ATOMIC<br />AUTHORIZATION<br />AVG</p><h1 id="ReservedKeywords-B">B</h1><p>BEGIN<br />BETWEEN<br />BIGINT<br />BINARY<br />BIT<br />BLOB<br />BOOLEAN<br />BOTH<br />BY</p><h1 id="ReservedKeywords-C">C</h1><p>CALL<br />CALLED<br />CARDINALITY<br />CASCADED<br />CASE<br />CAST<br />CEIL<br />CEILING<br />CHAR<br />CHARACTER<br />CHARACTER_LENGTH<br />CHAR_LENGTH<br />CHECK<br />CLOB<br />CLOSE<br />COALESCE<br />COLLATE<br />COLLECT<br />COLUMN<br />COMMIT<br />CONDITION<br />CONNECT<br />CONSTRAINT<br />CONVERT<br />CORR<br />CORRESPONDING<br />COUNT<br />COVAR_POP<br />COVAR_SAMP<br />CREATE<br />CROSS<br />CUBE<br />CUME_DIST<br />CURRENT<br />CURRENT_CATALOG<br />CURRENT_DATE<br />CURRENT_DEFAULT_TRANSFORM_GROUP<br />CURRENT_PATH<br />CURRENT_ROLE<br />CURRENT_SCHEMA<br
/>CURRENT_TIME<br />CURRENT_TIMESTAMP<br />CURRENT_TRANSFORM_GROUP_FOR_TYPE<br />CURRENT_USER<br />CURSOR<br />CYCLE</p></td><td valign="top" ><h1 id="ReservedKeywords-D">D</h1><p>DATABASES<br />DATE<br />DAY<br />DEALLOCATE<br />DEC<br />DECIMAL<br />DECLARE<br />DEFAULT<br />DEFAULT_KW<br />DELETE<br />DENSE_RANK<br />DEREF<br />DESCRIBE<br />DETERMINISTIC<br />DISALLOW<br />DISCONNECT<br />DISTINCT<br />DOUBLE<br />DROP<br />DYNAMIC</p><h1 id="ReservedKeywords-E">E</h1><p>EACH<br />ELEMENT<br />ELSE<br />END<br />END_EXEC<br />ESCAPE<br />EVERY<br />EXCEPT<br />EXEC<br />EXECUTE<br />EXISTS<br />EXP<br />EXPLAIN<br />EXTERNAL<br />EXTRACT</p><h1 id="ReservedKeywords-F">F</h1><p>FALSE<br />FETCH<br />FILES<br />FILTER<br />FIRST_VALUE<br />FLOAT<br />FLOOR<br />FOR<br />FOREIGN<br />FREE<br />FROM<br />FULL<br />FUNCTION<br />FUSION</p><h1 id="ReservedKeywords-G">G</h1><p>GET<br />GLOBAL<br />GRANT<br />GROUP<br />GROUPING</p><h1 id="ReservedKeywords-H">H</h1><p>HAVING<br />HOLD<b
r />HOUR</p></td><td valign="top" ><h1 id="ReservedKeywords-I">I</h1><p>IDENTITY<br />IMPORT<br />IN<br />INDICATOR<br />INNER<br />INOUT<br />INSENSITIVE<br />INSERT<br />INT<br />INTEGER<br />INTERSECT<br />INTERSECTION<br />INTERVAL<br />INTO<br />IS</p><h1 id="ReservedKeywords-J">J</h1><p>JOIN</p><h1 id="ReservedKeywords-L">L</h1><p>LANGUAGE<br />LARGE<br />LAST_VALUE<br />LATERAL<br />LEADING<br />LEFT<br />LIKE<br />LIMIT<br />LN<br />LOCAL<br />LOCALTIME<br />LOCALTIMESTAMP<br />LOWER</p><h1 id="ReservedKeywords-M">M</h1><p>MATCH<br />MAX<br />MEMBER<br />MERGE<br />METHOD<br />MIN<br />MINUTE<br />MOD<br />MODIFIES<br />MODULE<br />MONTH<br />MULTISET</p><h1 id="ReservedKeywords-N">N</h1><p>NATIONAL<br />NATURAL<br />NCHAR<br />NCLOB<br />NEW<br />NO<br />NONE<br />NORMALIZE<br />NOT<br />NULL<br />NULLIF<br />NUMERIC</p><h1 id="ReservedKeywords-O">O</h1><p>OCTET_LENGTH<br />OF<br />OFFSET<br />OLD<br />ON<br />ONLY<br />OPEN<br />OR<br />ORDER<br />OUT<br />OUTER<br />OVER<
br />OVERLAPS<br />OVERLAY</p></td><td valign="top" colspan="1" ><h1 id="ReservedKeywords-P">P</h1><p>PARAMETER<br />PARTITION<br />PERCENTILE_CONT<br />PERCENTILE_DISC<br />PERCENT_RANK<br />POSITION<br />POWER<br />PRECISION<br />PREPARE<br />PRIMARY<br />PROCEDURE</p><h1 id="ReservedKeywords-R">R</h1><p>RANGE<br />RANK<br />READS<br />REAL<br />RECURSIVE<br />REF<br />REFERENCES<br />REFERENCING<br />REGR_AVGX<br />REGR_AVGY<br />REGR_COUNT<br />REGR_INTERCEPT<br />REGR_R2<br />REGR_SLOPE<br />REGR_SXX<br />REGR_SXY<br />RELEASE<br />REPLACE<br />RESULT<br />RETURN<br />RETURNS<br />REVOKE<br />RIGHT<br />ROLLBACK<br />ROLLUP<br />ROW<br />ROWS<br />ROW_NUMBER</p><h1 id="ReservedKeywords-S">S</h1><p>SAVEPOINT<br />SCHEMAS<br />SCOPE<br />SCROLL<br />SEARCH<br />SECOND<br />SELECT<br />SENSITIVE<br />SESSION_USER<br />SET<br />SHOW<br />SIMILAR<br />SMALLINT<br />SOME<br />SPECIFIC<br />SPECIFICTYPE<br />SQL<br />SQLEXCEPTION<br />SQLSTATE<br />SQLWARNING<br />SQRT<br />START<br /
>STATIC<br />STDDEV_POP<br />STDDEV_SAMP<br />SUBMULTISET<br />SUBSTRING<br />SUM<br />SYMMETRIC<br />SYSTEM<br />SYSTEM_USER</p></td><td valign="top" colspan="1" ><h1 id="ReservedKeywords-T">T</h1><p>TABLE<br />TABLES<br />TABLESAMPLE<br />THEN<br />TIME<br />TIMESTAMP<br />TIMEZONE_HOUR<br />TIMEZONE_MINUTE<br />TINYINT<br />TO<br />TRAILING<br />TRANSLATE<br />TRANSLATION<br />TREAT<br />TRIGGER<br />TRIM<br />TRUE</p><h1 id="ReservedKeywords-U">U</h1><p>UESCAPE<br />UNION<br />UNIQUE<br />UNKNOWN<br />UNNEST<br />UPDATE<br />UPPER<br />USE<br />USER<br />USING</p><h1 id="ReservedKeywords-V">V</h1><p>VALUE<br />VALUES<br />VARBINARY<br />VARCHAR<br />VARYING<br />VAR_POP<br />VAR_SAMP</p><h1 id="ReservedKeywords-W">W</h1><p>WHEN<br />WHENEVER<br />WHERE<br />WIDTH_BUCKET<br />WINDOW<br />WITH<br />WITHIN<br />WITHOUT</p><h1 id="ReservedKeywords-Y">Y</h1><p>YEAR</p></td></tr></tbody></table>
+</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/sample-datasets/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/sample-datasets/index.html?rev=1662344&r1=1662343&r2=1662344&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/sample-datasets/index.html (original)
+++ drill/site/trunk/content/drill/docs/sample-datasets/index.html Thu Feb 26 01:16:43 2015
@@ -70,9 +70,9 @@
<div class="int_text" align="left"><p>Use any of the following sample datasets provided to test Drill:</p>
<ul>
-<li><a href="/confluence/display/DRILL/AOL+Search">AOL Search</a></li>
-<li><a href="/confluence/display/DRILL/Enron+Emails">Enron Emails</a></li>
-<li><a href="/confluence/display/DRILL/Wikipedia+Edit+History">Wikipedia Edit History</a></li>
+<li><a href="/drill/docs/aol-search">AOL Search</a></li>
+<li><a href="/drill/docs/enron-emails">Enron Emails</a></li>
+<li><a href="/drill/docs/wikipedia-edit-history">Wikipedia Edit History</a></li>
</ul>
</div>
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=1662344&r1=1662343&r2=1662344&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/select-statements/index.html (original)
+++ drill/site/trunk/content/drill/docs/select-statements/index.html Thu Feb 26 01:16:43 2015
@@ -88,7 +88,7 @@
<p>INSERT INTO SELECT is not yet supported.</p>
-<h1 id="column-aliases">Column Aliases</h1>
+<h2 id="column-aliases">Column Aliases</h2>
<p>You can use named column aliases in the SELECT list to provide meaningful
names for regular columns and computed columns, such as the results of
@@ -106,7 +106,7 @@ aggregate functions. See the section on
aliases (1, 2, etc.) to refer to SELECT list columns, except in the ORDER BY
clause.</p>
-<h1 id="union-all-set-operator">UNION ALL Set Operator</h1>
+<h2 id="union-all-set-operator">UNION ALL Set Operator</h2>
<p>Drill supports the UNION ALL set operator to combine two result sets. The
distinct UNION operator is not yet supported.</p>
@@ -114,7 +114,7 @@ distinct UNION operator is not yet suppo
<p>The EXCEPT, EXCEPT ALL, INTERSECT, and INTERSECT ALL operators are not yet
supported.</p>
-<h1 id="joins">Joins</h1>
+<h2 id="joins">Joins</h2>
<p>Drill supports ANSI standard joins in the FROM and WHERE clauses:</p>
@@ -158,7 +158,7 @@ the same two tables as part of a conjunc
</code></pre></div>
<p>This restriction applies to both inner and outer joins.</p>
-<h1 id="subqueries">Subqueries</h1>
+<h2 id="subqueries">Subqueries</h2>
<p>You can use the following subquery operators in Drill queries. These operators
all return Boolean results.</p>
Modified: drill/site/trunk/content/drill/docs/show-files-command/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/show-files-command/index.html?rev=1662344&r1=1662343&r2=1662344&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/show-files-command/index.html (original)
+++ drill/site/trunk/content/drill/docs/show-files-command/index.html Thu Feb 26 01:16:43 2015
@@ -70,7 +70,7 @@
<div class="int_text" align="left"><p>The SHOW FILES command provides a quick report of the file systems that are
visible to Drill for query purposes. This command is unique to Apache Drill.</p>
-<h1 id="syntax">Syntax</h1>
+<h2 id="syntax">Syntax</h2>
<p>The SHOW FILES command supports the following syntax.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SHOW FILES [ FROM filesystem.directory_name | IN filesystem.directory_name ];
@@ -85,7 +85,7 @@ word, you must use back ticks around the
directory, such as permissions, owner, and group values. This information is
not specific to Drill.</p>
-<h1 id="examples">Examples</h1>
+<h2 id="examples">Examples</h2>
<p>The following example returns information about directories and files in the
local (<code>dfs</code>) file system.</p>
Modified: drill/site/trunk/content/drill/docs/sql-commands-summary/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/sql-commands-summary/index.html?rev=1662344&r1=1662343&r2=1662344&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/sql-commands-summary/index.html (original)
+++ drill/site/trunk/content/drill/docs/sql-commands-summary/index.html Thu Feb 26 01:16:43 2015
@@ -70,18 +70,8 @@
<div class="int_text" align="left"><p>The following table provides a list of the SQL commands that Drill supports,
with their descriptions and example syntax:</p>
-<div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Command</th><th class="confluenceTh">Description</th><th class="confluenceTh">Syntax</th></tr><tr><td valign="top" class="confluenceTd">ALTER SESSION</td><td valign="top" class="confluenceTd">Changes a system setting for the duration of a session. A session ends when you quit the Drill shell. For a list of Drill options and their descriptions, refer to <a href="https://cwiki.apache.org/confluence/display/DRILL/Planning+and+Execution+Options" rel="nofollow">Planning and Execution Options</a>.</td><td valign="top" class="confluenceTd"><code>ALTER SESSION SET `option_name`='string';<br />ALTER SESSION SET `option_name`=TRUE | FALSE;</code></td></tr><tr><td valign="top" class="confluenceTd">ALTER SYSTEM</td><td valign="top" class="confluenceTd">Permanently changes a system setting. The new settings persist across all sessions. For a list of Drill options and their descriptions, refer to <a href="h
ttps://cwiki.apache.org/confluence/display/DRILL/Planning+and+Execution+Options" rel="nofollow">Planning and Execution Options</a>.</td><td valign="top" class="confluenceTd"><code>ALTER SYSTEM `option_name`='string'<br />ALTER SYSTEM `option_name`=TRUE | FALSE;</code></td></tr><tr><td valign="top" class="confluenceTd"><p><a href="/confluence/display/DRILL/CREATE+TABLE+AS+%28CTAS%29+Command">CREATE TABLE AS<br />(CTAS)</a></p></td><td valign="top" class="confluenceTd"><p>Creates a new table and populates the new table with rows returned from a SELECT query. Use the CREATE TABLE AS (CTAS) statement in place of INSERT INTO. When you issue the CTAS command, you create a directory that contains parquet or CSV files. Each workspace in a file system has a default file type.</p><p>You can specify which writer you want Drill to use when creating a table: parquet, CSV, or JSON (as specified with <span style="line-height: 1.4285715;">the </span><code>store.format</code><span style="line-height
: 1.4285715;"> option<span><span>).</span></span></span></p></td><td valign="top" class="confluenceTd"><code>CREATE TABLE new_table_name AS <query>;</code></td></tr><tr><td valign="top" colspan="1" class="confluenceTd">CREATE VIEW</td><td valign="top" colspan="1" class="confluenceTd"><p>Creates a new view based on the results of a SELECT query.</p></td><td valign="top" colspan="1" class="confluenceTd"><code>CREATE VIEW view_name [(column_list)] AS <query>;</code></td></tr><tr><td valign="top" colspan="1" class="confluenceTd">DROP VIEW</td><td valign="top" colspan="1" class="confluenceTd">Removes one or more views.</td><td valign="top" colspan="1" class="confluenceTd"><code>DROP VIEW view_name [, <em class="replaceable">view_name</em>] ...; </code></td></tr><tr><td valign="top" colspan="1" class="confluenceTd"><a href="https://cwiki.apache.org/confluence/display/DRILL/EXPLAIN+Commands" rel="nofollow">EXPLAIN PLAN FOR</a></td><td valign="top" colspan="1" class="conflue
nceTd">Returns the physical plan for a particular query.</td><td valign="top" colspan="1" class="confluenceTd"><code>EXPLAIN PLAN FOR <query>;</code></td></tr><tr><td valign="top" colspan="1" class="confluenceTd"><a href="https://cwiki.apache.org/confluence/display/DRILL/EXPLAIN+Commands" rel="nofollow">EXPLAIN PLAN WITHOUT IMPLEMENTATION FOR</a></td><td valign="top" colspan="1" class="confluenceTd">Returns the logical plan for a particular query.</td><td valign="top" colspan="1" class="confluenceTd"><code>EXPLAIN PLAN WITHOUT IMPLEMENTATION FOR <query>;</code></td></tr><tr><td valign="top" colspan="1" class="confluenceTd"><a href="https://cwiki.apache.org/confluence/display/DRILL/SELECT+Statements" rel="nofollow">SELECT</a></td><td valign="top" colspan="1" class="confluenceTd">Retrieves data from tables and files.</td><td valign="top" colspan="1" class="confluenceTd"><code>[WITH subquery]<br />SELECT column_list FROM table_name <br />[WHERE clause]<br />[GROUP BY clause
]<br />[HAVING clause]<br />[ORDER BY clause];</code></td></tr><tr><td valign="top" colspan="1" class="confluenceTd">SHOW DATABASES</td><td valign="top" colspan="1" class="confluenceTd">Returns a list of available schemas. Equivalent to SHOW SCHEMAS.</td><td valign="top" colspan="1" class="confluenceTd"><code>SHOW DATABASES;</code></td></tr><tr><td valign="top" colspan="1" class="confluenceTd"><a href="https://cwiki.apache.org/confluence/display/DRILL/SHOW+FILES+Command" rel="nofollow">SHOW FILES</a></td><td valign="top" colspan="1" class="confluenceTd">Returns a list of files in a file system schema.</td><td valign="top" colspan="1" class="confluenceTd"><code>SHOW FILES IN filesystem.`schema_name`;<br />SHOW FILES FROM filesystem.`schema_name`;</code></td></tr><tr><td valign="top" colspan="1" class="confluenceTd">SHOW SCHEMAS</td><td valign="top" colspan="1" class="confluenceTd">Returns a list of available schemas. Equivalent to SHOW DATABASES.</td><td valign="top" colspan="1" clas
s="confluenceTd"><code>SHOW SCHEMAS;</code></td></tr><tr><td valign="top" colspan="1" class="confluenceTd">SHOW TABLES</td><td valign="top" colspan="1" class="confluenceTd">Returns a list of tables for all schemas. Optionally, you can first issue the <code>USE </code>command to identify the schema for which you want to view tables.<br />For example, the following <code>USE</code> statement tells Drill that you only want information from the <code>hive.default</code> schema:<br /><code>USE hive.`default`;</code></td><td valign="top" colspan="1" class="confluenceTd"><code>SHOW TABLES;</code></td></tr><tr><td valign="top" colspan="1" class="confluenceTd">USE</td><td valign="top" colspan="1" class="confluenceTd">Change to a particular schema. When you opt to use a particular schema, Drill issues queries on that schema only.</td><td valign="top" colspan="1" class="confluenceTd"><code>USE schema_name;</code></td></tr></tbody></table></div>
+<table ><tbody><tr><th >Command</th><th >Description</th><th >Syntax</th></tr><tr><td valign="top" >ALTER SESSION</td><td valign="top" >Changes a system setting for the duration of a session. A session ends when you quit the Drill shell. For a list of Drill options and their descriptions, refer to <a href="/drill/docs/planning-and-execution-options" rel="nofollow">Planning and Execution Options</a>.</td><td valign="top" ><code>ALTER SESSION SET `option_name`='string';<br />ALTER SESSION SET `option_name`=TRUE | FALSE;</code></td></tr><tr><td valign="top" >ALTER SYSTEM</td><td valign="top" >Permanently changes a system setting. The new settings persist across all sessions. For a list of Drill options and their descriptions, refer to <a href="/drill/docs/planning-and-execution-options/" rel="nofollow">Planning and Execution Options</a>.</td><td valign="top" ><code>ALTER SYSTEM `option_name`='string'<br />ALTER SYSTEM `option_name`=TRUE | FALSE;</code></td></tr><tr><td valign="top" ><a
href="/drill/docs/create-table-as-ctas-command">CREATE TABLE AS<br />(CTAS)</a></p></td><td valign="top" >Creates a new table and populates the new table with rows returned from a SELECT query. Use the CREATE TABLE AS (CTAS) statement in place of INSERT INTO. When you issue the CTAS command, you create a directory that contains parquet or CSV files. Each workspace in a file system has a default file type.<p>You can specify which writer you want Drill to use when creating a table: parquet, CSV, or JSON (as specified with <span style="line-height: 1.4285715;">the </span><code>store.format</code><span style="line-height: 1.4285715;"> option<span><span>).</span></span></span></p></td><td valign="top" ><code>CREATE TABLE new_table_name AS <query>;</code></td></tr><tr><td valign="top" colspan="1" >CREATE VIEW</td><td valign="top" colspan="1" >Creates a new view based on the results of a SELECT query.</td><td valign="top" colspan="1" ><code>CREATE VIEW view_name [(column_list)] AS &
lt;query>;</code></td></tr><tr><td valign="top" colspan="1" >DROP VIEW</td><td valign="top" colspan="1" >Removes one or more views.</td><td valign="top" colspan="1" ><code>DROP VIEW view_name [, <em class="replaceable">view_name</em>] ...; </code></td></tr><tr><td valign="top" colspan="1" ><a href="/drill/docs/explain-commands" rel="nofollow">EXPLAIN PLAN FOR</a></td><td valign="top" colspan="1" >Returns the physical plan for a particular query.</td><td valign="top" colspan="1" ><code>EXPLAIN PLAN FOR <query>;</code></td></tr><tr><td valign="top" colspan="1" ><a href="/drill/docs/explain-commands/" rel="nofollow">EXPLAIN PLAN WITHOUT IMPLEMENTATION FOR</a></td><td valign="top" colspan="1" >Returns the logical plan for a particular query.</td><td valign="top" colspan="1" ><code>EXPLAIN PLAN WITHOUT IMPLEMENTATION FOR <query>;</code></td></tr><tr><td valign="top" colspan="1" ><a href="/drill/docs/select-statements" rel="nofollow">SELECT</a></td><td valign="top" cols
pan="1" >Retrieves data from tables and files.</td><td valign="top" colspan="1" ><code>[WITH subquery]<br />SELECT column_list FROM table_name <br />[WHERE clause]<br />[GROUP BY clause]<br />[HAVING clause]<br />[ORDER BY clause];</code></td></tr><tr><td valign="top" colspan="1" >SHOW DATABASES</td><td valign="top" colspan="1" >Returns a list of available schemas. Equivalent to SHOW SCHEMAS.</td><td valign="top" colspan="1" ><code>SHOW DATABASES;</code></td></tr><tr><td valign="top" colspan="1" ><a href="/drill/docs/show-files-command/" rel="nofollow">SHOW FILES</a></td><td valign="top" colspan="1" >Returns a list of files in a file system schema.</td><td valign="top" colspan="1" ><code>SHOW FILES IN filesystem.`schema_name`;<br />SHOW FILES FROM filesystem.`schema_name`;</code></td></tr><tr><td valign="top" colspan="1" >SHOW SCHEMAS</td><td valign="top" colspan="1" >Returns a list of available schemas. Equivalent to SHOW DATABASES.</td><td valign="top" colspan="1" ><code>SHOW SCHE
MAS;</code></td></tr><tr><td valign="top" colspan="1" >SHOW TABLES</td><td valign="top" colspan="1" >Returns a list of tables for all schemas. Optionally, you can first issue the <code>USE </code>command to identify the schema for which you want to view tables.<br />For example, the following <code>USE</code> statement tells Drill that you only want information from the <code>hive.default</code> schema:<br /><code>USE hive.`default`;</code></td><td valign="top" colspan="1" ><code>SHOW TABLES;</code></td></tr><tr><td valign="top" colspan="1" >USE</td><td valign="top" colspan="1" >Change to a particular schema. When you opt to use a particular schema, Drill issues queries on that schema only.</td><td valign="top" colspan="1" ><code>USE schema_name;</code></td></tr></tbody></table>
-
-<p>Click on any of the following links for more information about the various
-commands:</p>
-
-<ul>
-<li><a href="/confluence/display/DRILL/CREATE+TABLE+AS+%28CTAS%29+Command">CREATE TABLE AS (CTAS) Command</a></li>
-<li><a href="/confluence/display/DRILL/EXPLAIN+Commands">EXPLAIN Commands</a></li>
-<li><a href="/confluence/display/DRILL/SELECT+Statements">SELECT Statements</a></li>
-<li><a href="/confluence/display/DRILL/SHOW+FILES+Command">SHOW FILES Command</a></li>
-</ul>
</div>
Modified: drill/site/trunk/content/drill/docs/sql-functions/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/sql-functions/index.html?rev=1662344&r1=1662343&r2=1662344&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/sql-functions/index.html (original)
+++ drill/site/trunk/content/drill/docs/sql-functions/index.html Thu Feb 26 01:16:43 2015
@@ -536,9 +536,9 @@ FROM hbase.table1
analyze nested data:</p>
<ul>
-<li><a href="/confluence/display/DRILL/FLATTEN+Function">FLATTEN Function</a></li>
-<li><a href="/confluence/display/DRILL/KVGEN+Function">KVGEN Function</a></li>
-<li><a href="/confluence/display/DRILL/REPEATED_COUNT+Function">REPEATED_COUNT Function</a></li>
+<li><a href="/drill/docs/flatten-function">FLATTEN Function</a></li>
+<li><a href="/drill/docs/kvgen-function">KVGEN Function</a></li>
+<li><a href="/drill/docs/repeated-count-function">REPEATED_COUNT Function</a></li>
</ul>
</div>
Added: drill/site/trunk/content/drill/docs/sql-reference/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/sql-reference/index.html?rev=1662344&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/sql-reference/index.html (added)
+++ drill/site/trunk/content/drill/docs/sql-reference/index.html Thu Feb 26 01:16:43 2015
@@ -0,0 +1,102 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>SQL Reference - 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>SQL Reference</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>Drill supports the ANSI standard for SQL. You can use SQL to query your Hive,
+HBase, and distributed file system data sources. Drill can discover the form
+of the data when you submit a query. You can query text files and nested data
+formats, such as JSON and Parquet. Drill provides special operators and
+functions that you can use to _drill down _into nested data formats.</p>
+
+<p>Drill queries do not require information about the data that you are trying to
+access, regardless of its source system or its schema and data types. The
+sweet spot for Apache Drill is a SQL query workload against "complex data":
+data made up of various types of records and fields, rather than data in a
+recognizable relational form (discrete rows and columns).</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/start-up-options/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/start-up-options/index.html?rev=1662344&r1=1662343&r2=1662344&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/start-up-options/index.html (original)
+++ drill/site/trunk/content/drill/docs/start-up-options/index.html Thu Feb 26 01:16:43 2015
@@ -96,12 +96,12 @@ can override as necessary.</p>
in the root directory of the JAR file that you add. The <code>drill-module.conf</code>
file tells Drill to scan that JAR file or associated object and include it.</p>
-<h4 id="viewing-startup-options">Viewing Startup Options</h4>
+<h2 id="viewing-startup-options">Viewing Startup Options</h2>
<p>You can run the following query to see a list of Drillâs startup options:</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM sys.options WHERE type='BOOT'
</code></pre></div>
-<h4 id="configuring-start-up-options">Configuring Start-Up Options</h4>
+<h2 id="configuring-start-up-options">Configuring Start-Up Options</h2>
<p>You can configure start-up options for each Drillbit in the <code>drill-
override.conf</code> file located in Drillâs<code>/conf</code> directory.</p>
@@ -109,7 +109,7 @@ override.conf</code> file located in Dri
<p>You may want to configure the following start-up options that control certain
behaviors in Drill:</p>
-<div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Option</th><th class="confluenceTh">Default Value</th><th class="confluenceTh">Description</th></tr><tr><td valign="top" class="confluenceTd"><p>drill.exec.sys.store.provider</p></td><td valign="top" class="confluenceTd"><p>ZooKeeper</p></td><td valign="top" class="confluenceTd"><p>Defines the persistent storage (PStore) provider. The PStore holds configuration and profile data. For more information about PStores, see <a href="https://cwiki.apache.org/confluence/display/DRILL/Persistent+Configuration+Storage" rel="nofollow">Persistent Configuration Storage</a>.</p></td></tr><tr><td valign="top" class="confluenceTd"><p>drill.exec.buffer.size</p></td><td valign="top" class="confluenceTd"><p> </p></td><td valign="top" class="confluenceTd"><p>Defines the amount of memory available, in terms of record batches, to hold data on the downstream side of an operation. Drill pushes data downstream as quic
kly as possible to make data immediately available. This requires Drill to use memory to hold the data pending operations. When data on a downstream operation is required, that data is immediately available so Drill does not have to go over the network to process it. Providing more memory to this option increases the speed at which Drill completes a query.</p></td></tr><tr><td valign="top" class="confluenceTd"><p>drill.exec.sort.external.directories</p><p>drill.exec.sort.external.fs</p></td><td valign="top" class="confluenceTd"><p> </p></td><td valign="top" class="confluenceTd"><p>These options control spooling. The drill.exec.sort.external.directories option tells Drill which directory to use when spooling. The drill.exec.sort.external.fs option tells Drill which file system to use when spooling beyond memory files. <span style="line-height: 1.4285715;background-color: transparent;"> </span></p><p>Drill uses a spool and sort operation for beyond memory operations. The sorting opera
tion is designed to spool to a Hadoop file system. The default Hadoop file system is a local file system in the /tmp directory. Spooling performance (both writing and reading back from it) is constrained by the file system. <span style="line-height: 1.4285715;background-color: transparent;"> </span></p><p>For MapR clusters, use MapReduce volumes or set up local volumes to use for spooling purposes. Volumes improve performance and stripe data across as many disks as possible.</p></td></tr><tr><td valign="top" colspan="1" class="confluenceTd"><p>drill.exec.debug.error_on_leak</p></td><td valign="top" colspan="1" class="confluenceTd"><p>True</p></td><td valign="top" colspan="1" class="confluenceTd"><p>Determines how Drill behaves when memory leaks occur during a query. By default, this option is enabled so that queries fail when memory leaks occur. If you disable the option, Drill issues a warning when a memory leak occurs and completes the query.</p></td></tr><tr><td valign="top" cols
pan="1" class="confluenceTd"><p>drill.exec.zk.connect</p></td><td valign="top" colspan="1" class="confluenceTd"><p>localhost:2181</p></td><td valign="top" colspan="1" class="confluenceTd"><p>Provides Drill with the ZooKeeper quorum to use to connect to data sources. Change this setting to point to the ZooKeeper quorum that you want Drill to use. You must configure this option on each Drillbit node.</p></td></tr><tr><td valign="top" colspan="1" class="confluenceTd"><p>drill.exec.cluster-id</p></td><td valign="top" colspan="1" class="confluenceTd"><p>my_drillbit_cluster</p></td><td valign="top" colspan="1" class="confluenceTd"><p>Identifies the cluster that corresponds with the ZooKeeper quorum indicated. It also provides Drill with the name of the cluster used during UDP multicast. You must change the default cluster-id if there are multiple clusters on the same subnet. If you do not change the ID, the clusters will try to connect to each other to create one cluster.</p></td></tr></t
body></table></div>
+<table ><tbody><tr><th >Option</th><th >Default Value</th><th >Description</th></tr><tr><td valign="top" >drill.exec.sys.store.provider</td><td valign="top" >ZooKeeper</td><td valign="top" >Defines the persistent storage (PStore) provider. The PStore holds configuration and profile data. For more information about PStores, see <a href="/drill/docs/persistent-configuration-storage" rel="nofollow">Persistent Configuration Storage</a>.</td></tr><tr><td valign="top" >drill.exec.buffer.size</td><td valign="top" > </td><td valign="top" >Defines the amount of memory available, in terms of record batches, to hold data on the downstream side of an operation. Drill pushes data downstream as quickly as possible to make data immediately available. This requires Drill to use memory to hold the data pending operations. When data on a downstream operation is required, that data is immediately available so Drill does not have to go over the network to process it. Providing more memory to this optio
n increases the speed at which Drill completes a query.</td></tr><tr><td valign="top" >drill.exec.sort.external.directoriesdrill.exec.sort.external.fs</td><td valign="top" > </td><td valign="top" >These options control spooling. The drill.exec.sort.external.directories option tells Drill which directory to use when spooling. The drill.exec.sort.external.fs option tells Drill which file system to use when spooling beyond memory files. <span style="line-height: 1.4285715;background-color: transparent;"> </span>Drill uses a spool and sort operation for beyond memory operations. The sorting operation is designed to spool to a Hadoop file system. The default Hadoop file system is a local file system in the /tmp directory. Spooling performance (both writing and reading back from it) is constrained by the file system. <span style="line-height: 1.4285715;background-color: transparent;"> </span>For MapR clusters, use MapReduce volumes or set up local volumes to use for spooling purposes. Vol
umes improve performance and stripe data across as many disks as possible.</td></tr><tr><td valign="top" colspan="1" >drill.exec.debug.error_on_leak</td><td valign="top" colspan="1" >True</td><td valign="top" colspan="1" >Determines how Drill behaves when memory leaks occur during a query. By default, this option is enabled so that queries fail when memory leaks occur. If you disable the option, Drill issues a warning when a memory leak occurs and completes the query.</td></tr><tr><td valign="top" colspan="1" >drill.exec.zk.connect</td><td valign="top" colspan="1" >localhost:2181</td><td valign="top" colspan="1" >Provides Drill with the ZooKeeper quorum to use to connect to data sources. Change this setting to point to the ZooKeeper quorum that you want Drill to use. You must configure this option on each Drillbit node.</td></tr><tr><td valign="top" colspan="1" >drill.exec.cluster-id</td><td valign="top" colspan="1" >my_drillbit_cluster</td><td valign="top" colspan="1" >Identifies t
he cluster that corresponds with the ZooKeeper quorum indicated. It also provides Drill with the name of the cluster used during UDP multicast. You must change the default cluster-id if there are multiple clusters on the same subnet. If you do not change the ID, the clusters will try to connect to each other to create one cluster.</td></tr></tbody></table>
</div>
Modified: drill/site/trunk/content/drill/docs/starting-stopping-drill/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/starting-stopping-drill/index.html?rev=1662344&r1=1662343&r2=1662344&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/starting-stopping-drill/index.html (original)
+++ drill/site/trunk/content/drill/docs/starting-stopping-drill/index.html Thu Feb 26 01:16:43 2015
@@ -73,7 +73,7 @@ Drillbit locally. If you installed Drill
multiple nodes in a cluster, you must start the Drillbit service and then
invoke SQLLine. Once SQLLine starts, you can issue queries to Drill.</p>
-<h3 id="starting-a-drillbit">Starting a Drillbit</h3>
+<h2 id="starting-a-drillbit">Starting a Drillbit</h2>
<p>If you installed Drill in embedded mode, you do not need to start the
Drillbit.</p>
@@ -83,7 +83,7 @@ the following command:</p>
<p><code>bin/drillbit.sh restart</code></p>
-<h3 id="invoking-sqlline/connecting-to-a-schema">Invoking SQLLine/Connecting to a Schema</h3>
+<h2 id="invoking-sqlline/connecting-to-a-schema">Invoking SQLLine/Connecting to a Schema</h2>
<p>SQLLine is used as the Drill shell. SQLLine connects to relational databases
and executes SQL commands. You invoke SQLLine for Drill in embedded or
@@ -93,17 +93,17 @@ can indicate the schema name when you in
<p>To start SQLLine, issue the appropriate command for your Drill installation
type:</p>
-<div class="table-wrap"><table class="confluenceTable"><tbody><tr><td class="confluenceTd"><p><strong>Drill Install Type</strong></p></td><td class="confluenceTd"><p><strong>Example</strong></p></td><td class="confluenceTd"><p><strong>Command</strong></p></td></tr><tr><td class="confluenceTd"><p>Embedded</p></td><td class="confluenceTd"><p>Drill installed locally (embedded mode);</p><p>Hive with embedded metastore</p></td><td class="confluenceTd"><p>To connect without specifying a schema, navigate to the Drill installation directory and issue the following command:</p><p><code>$ bin/sqlline -u jdbc:drill:zk=local -n admin -p admin </code><span> </span></p><p>Once you are in the prompt, you can issue<code> USE <schema> </code>or you can use absolute notation: <code>schema.table.column.</code></p><p>To connect to a schema directly, issue the command with the schema name:</p><p><code>$ bin/sqlline -u jdbc:drill:schema=<database>;zk=local -n admin -p admin</code></p></td></t
r><tr><td class="confluenceTd"><p>Distributed</p></td><td class="confluenceTd"><p>Drill installed in distributed mode;</p><p>Hive with remote metastore;</p><p>HBase</p></td><td class="confluenceTd"><p>To connect without specifying a schema, navigate to the Drill installation directory and issue the following command:</p><p><code>$ bin/sqlline -u jdbc:drill:zk=<zk1host>:<port>,<zk2host>:<port>,<zk3host>:<port> -n admin -p admin</code></p><p>Once you are in the prompt, you can issue<code> USE <schema> </code>or you can use absolute notation: <code>schema.table.column.</code></p><p>To connect to a schema directly, issue the command with the schema name:</p><p><code>$ bin/sqlline -u jdbc:drill:schema=<database>;zk=<zk1host>:<port>,<zk2host>:<port>,<zk3host>:<port> -n admin -p admin</code></p></td></tr></tbody></table></div>
+<table ><tbody><tr><td valign="top"><strong>Drill Install Type</strong></td><td valign="top"><strong>Example</strong></td><td valign="top"><strong>Command</strong></td></tr><tr><td valign="top">Embedded</td><td valign="top">Drill installed locally (embedded mode);Hive with embedded metastore</td><td valign="top">To connect without specifying a schema, navigate to the Drill installation directory and issue the following command:<code>$ bin/sqlline -u jdbc:drill:zk=local -n admin -p admin </code><span> </span>Once you are in the prompt, you can issue<code> USE <schema> </code>or you can use absolute notation: <code>schema.table.column.</code>To connect to a schema directly, issue the command with the schema name:<code>$ bin/sqlline -u jdbc:drill:schema=<database>;zk=local -n admin -p admin</code></td></tr><tr><td valign="top">Distributed</td><td valign="top">Drill installed in distributed mode;Hive with remote metastore;HBase</td><td valign="top">To connect without specify
ing a schema, navigate to the Drill installation directory and issue the following command:<code>$ bin/sqlline -u jdbc:drill:zk=<zk1host>:<port>,<zk2host>:<port>,<zk3host>:<port> -n admin -p admin</code>Once you are in the prompt, you can issue<code> USE <schema> </code>or you can use absolute notation: <code>schema.table.column.</code>To connect to a schema directly, issue the command with the schema name:<code>$ bin/sqlline -u jdbc:drill:schema=<database>;zk=<zk1host>:<port>,<zk2host>:<port>,<zk3host>:<port> -n admin -p admin</code></td></tr></tbody></table>
<p>When SQLLine starts, the system displays the following prompt:</p>
-<p><code>0: [jdbc:drill](http://jdbcdrill):schema=<database>;zk=<zkhost>:<port>></code></p>
+<p><code>0: jdbc:drill]:schema=<database>;zk=<zkhost>:<port></code></p>
<p>At this point, you can use Drill to query your data source or you can discover
metadata.</p>
-<h3 id="exiting-sqlline">Exiting SQLLine</h3>
+<h2 id="exiting-sqlline">Exiting SQLLine</h2>
<p>To exit SQLLine, issue the following command:</p>
Added: drill/site/trunk/content/drill/docs/step-1-install-the-mapr-drill-odbc-driver-on-windows/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/step-1-install-the-mapr-drill-odbc-driver-on-windows/index.html?rev=1662344&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/step-1-install-the-mapr-drill-odbc-driver-on-windows/index.html (added)
+++ drill/site/trunk/content/drill/docs/step-1-install-the-mapr-drill-odbc-driver-on-windows/index.html Thu Feb 26 01:16:43 2015
@@ -0,0 +1,156 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Step 1. Install the MapR Drill ODBC Driver on Windows - 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>Step 1. Install the MapR Drill ODBC Driver on Windows</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>The MapR Drill ODBC Driver installer is available for 32-bit and 64-bit
+applications. Both versions of the driver can be installed on a 64-bit
+machine.</p>
+
+<h2 id="system-requirements">System Requirements</h2>
+
+<p>Each computer where you install the driver must meet the following system
+requirements:</p>
+
+<ul>
+<li>One of the following operating systems (32- and 64-bit editions are supported):
+
+<ul>
+<li>Windows® Vista</li>
+<li>Windows® 7 Professional</li>
+<li>Windows® Server 2008 R2</li>
+</ul></li>
+<li>.NET Framework 2.0 is required to run the Drill Explorer application.</li>
+<li>60 MB of available disk space</li>
+<li><p>The client must be able to resolve the actual hostname of the Drill node(s) with the IP(s). Verify that a DNS entry was created on the client machine for the Drill node(s). If not, create the following entry for the Drill node(s) in the <code>%WINDIR%\system32\drivers\etc\hosts</code> file:</p>
+
+<p><code><drill-machine-IP> <drill-machine-hostname></code><br>
+Example: <code>127.0.1.1 apachedemo</code></p></li>
+</ul>
+
+<p>To install the driver, you need Administrator privileges on the computer.</p>
+
+<h2 id="installing-the-driver">Installing the Driver</h2>
+
+<ol>
+<li>Download the installer that corresponds to the bitness of the client application from which you want to create an ODBC connection:
+
+<ul>
+<li><a href="http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc/MapRDrillODBC32.msi">MapRDrillODBC32.msi</a> (32-bit)</li>
+<li><a href="http://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc/MapRDrillODBC64.msi">MapRDrillODBC64.msi</a> (64-bit)</li>
+</ul></li>
+<li>Double-click the installer from the location where you downloaded it.</li>
+<li>Click <strong>Next.</strong></li>
+<li>Select the check box to accept the terms of the License Agreement and click <strong>Next</strong>.</li>
+<li>Verify or change the install location. Then, click <strong>Next</strong>.</li>
+<li>Click <strong>Install</strong>.</li>
+<li>When the installation completes, click <strong>Finish</strong>.</li>
+<li>To verify the installation, click <strong>Start > All Programs > MapR Drill ODBC Driver 1.0 (32|64-bit) > (32|64-bit) ODBC Administrator</strong>. Then, click the <strong>Drivers</strong> tab and verify that the MapR Drill ODBC Driver appears in the list of drivers that are installed on the computer.</li>
+</ol>
+
+<h2 id="the-tableau-data-connection-customization-(tdc)-file">The Tableau Data-connection Customization (TDC) File</h2>
+
+<p>The MapR Drill ODBC Driver includes a file named <code>MapRDrillODBC.TDC</code>. The TDC
+file includes customizations that improve ODBC configuration and performance
+when using Tableau.</p>
+
+<p>If you install Tableau after you install the MapR Drill ODBC driver, you must
+install the Tableau TDC FIle. When Tableau is already installed on the
+machine, the TDC file is installed automatically with the MapR Drill ODBC
+driver.</p>
+
+<p><strong>To install the MapRDrillODBC.TDC file manually:</strong></p>
+
+<ol>
+<li>Click <strong>Start > All Programs > MapR Drill ODBC Driver <version> (32|64-bit) > Install Tableau TDC File</strong>. </li>
+<li>When the installation completes, press any key to continue.<br>
+For example, you can press the SPACEBAR key.</li>
+</ol>
+
+<h4 id="what's-next?-go-to-step-2.-configure-odbc-connections-to-drill-data-sources.">What's Next? Go to <a href="/drill/docs/step-2-configure-odbc-connections-to-drill-data-sources">Step 2. Configure ODBC Connections to Drill Data Sources</a>.</h4>
+</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/step-2-configure-odbc-connections-to-drill-data-sources/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/step-2-configure-odbc-connections-to-drill-data-sources/index.html?rev=1662344&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/step-2-configure-odbc-connections-to-drill-data-sources/index.html (added)
+++ drill/site/trunk/content/drill/docs/step-2-configure-odbc-connections-to-drill-data-sources/index.html Thu Feb 26 01:16:43 2015
@@ -0,0 +1,232 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Step 2. Configure ODBC Connections to Drill Data Sources - 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>Step 2. Configure ODBC Connections to Drill Data Sources</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>Complete one of the following steps to create an ODBC connection to Drill data
+sources:</p>
+
+<ul>
+<li>Create a Data Source Name</li>
+<li>Create an ODBC Connection String</li>
+</ul>
+
+<p><strong>Prerequisite:</strong> An Apache Drill installation must be available that is configured to access the data sources that you want to connect to. For information about how to install Apache Drill, see <a href="/drill/docs/install-drill">Install Drill</a>. For information about configuring data sources, see the <a href="/drill/docs">Apache Drill documentation</a>.</p>
+
+<h2 id="create-a-data-source-name-(dsn)">Create a Data Source Name (DSN)</h2>
+
+<p>Create a DSN that an application can use to connect to Drill data sources. If
+you want to create a DSN for a 32-bit application, you must use the 32-bit
+version of the ODBC Administrator to create the DSN.</p>
+
+<ol>
+<li><p>To launch the ODBC Administrator, click <strong>Start > All Programs > MapR Drill ODBC Driver 1.0 (32|64-bit) > (32|64-bit) ODBC Administrator</strong>.<br>
+The ODBC Data Source Administrator window appears.</p>
+
+<p>To launch the 32-bit version of the ODBC driver on a 64-bit machine, run:
+<code>C:\WINDOWS\SysWOW64\odbcad32.exe</code>.</p></li>
+<li><p>Click the <strong>System DSN</strong> tab to create a system DSN or click the <strong>User DSN</strong> tab to create a user DSN. A system DSN is available for all users who log in to the machine. A user DSN is available to the user who creates the DSN.</p></li>
+<li><p>Click <strong>Add</strong>.</p></li>
+<li><p>Select <strong>MapR Drill ODBC Driver</strong> and click <strong>Finish</strong>.<br>
+ The <em>MapR Drill ODBC Driver DSN Setup</em> window appears.</p></li>
+<li><p>In the <strong>Data Source Name</strong> field, enter a name for the DSN,</p></li>
+<li><p>Optionally, enter a description of the DSN in the Description field.</p></li>
+<li><p>In the Connection Type section, select a connection type and enter the associated connection details:</p>
+
+<p><table style='table-layout:fixed;width:100%'><tbody><tr><th>Connection Type</th><th >Properties</th><th >Descriptions</th></tr><tr><td rowspan="2" valign="top" width="10%">Zookeeper Quorum</td><td valign="top" style='width: 100px;'>Quorum</td><td valign="top" style='width: 400px;'>A comma-separated list of servers in a Zookeeper cluster.For example, <ip_zookeepernode1>:5181,<ip_zookeepernode21>:5181,â¦</td></tr><tr><td valign="top">ClusterID</td><td valign="top">Name of the drillbit cluster. The default is drillbits1. You may need to specify a different value if the cluster ID was changed in the drill-override.conf file.</td></tr><tr><td colspan="1" valign="top">Direct to Drillbit</td><td colspan="1" valign="top"> </td><td colspan="1" valign="top">Provide the IP address or host name of the Drill server and the port number that that the Drill server is listening on. The port number defaults to 31010. You may need to specify a different value if the port number was
changed in the drill-override.conf file.</td></tr></tbody></table>
+ For information on selecting the appropriate connection type, see <a href="/drill/docs/step-2-configure-odbc-connections-to-drill-data-sources#connection-type">Connection
+Types</a>.</p></li>
+<li><p>In the <strong>Default Schema</strong> field, select the default schema that you want to connect to.
+ For more information about the schemas that appear in this list, see Schemas.</p></li>
+<li><p>Optionally, perform one of the following operations:</p>
+
+<p><table ><tbody><tr><th >Option</th><th >Action</th></tr><tr><td valign="top">Update the configuration of the advanced properties.</td><td valign="top">Edit the default values in the <strong>Advanced Properties</strong> section. <br />For more information, see <a href="/drill/docs/advanced-properties/">Advanced Properties</a>.</td></tr><tr><td valign="top">Configure the types of events that you want the driver to log.</td><td valign="top">Click <strong>Logging Options</strong>. <br />For more information, see <a href="/drill/docs/step-2-configure-odbc-connections-to-drill-data-sources#logging-options">Logging Options</a>.</td></tr><tr><td valign="top">Create views or explore Drill sources.</td><td valign="top">Click <strong>Drill Explorer</strong>. <br />For more information, see <a href="/drill/docs/using-drill-explorer-to-browse-data-and-create-views">Using Drill Explorer to Browse Data and Create Views</a>.</td></tr></tbody></table></p></li>
+<li><p>Click <strong>OK</strong> to save the DSN.</p></li>
+</ol>
+
+<h2 id="configuration-options">Configuration Options</h2>
+
+<h3 id="connection-type">Connection Type</h3>
+
+<p>ODBC can connect directly to a Drillbit or to a ZooKeeper Quorum. Select your
+connection type based on your environment and Drillbit configuration.</p>
+
+<p>The following table lists the appropriate connection type for each scenario:</p>
+
+<table ><tbody><tr><th >Scenario</th><th >Connection Type</th></tr><tr><td valign="top">Drillbit is running in embedded mode.</td><td valign="top">Direct to Drillbit</td></tr><tr><td valign="top">Drillbit is registered with the ZooKeeper in a testing environment.</td><td valign="top">ZooKeeper Quorum or Direct to Drillbit</td></tr><tr><td valign="top">Drillbit is registered with the ZooKeeper in a production environment.</td><td valign="top">ZooKeeper Quorum</td></tr></tbody></table>
+
+<h4 id="connection-to-zookeeper-quorum">Connection to Zookeeper Quorum</h4>
+
+<p>When you choose to connect to a ZooKeeper Quorum, the ODBC driver connects to
+the ZooKeeper Quorum to get a list of available Drillbits in the specified
+cluster. Then, the ODBC driver submits a query after selecting a Drillbit. All
+Drillbits in the cluster process the query and the Drillbit that received the
+query returns the query results.</p>
+
+<p><img src="/docs/img/ODBC_to_Quorum.png" alt="ODBC to Quorum"></p>
+
+<p>In a production environment, you should connect to a ZooKeeper Quorum for a
+more reliable connection. If one Drillbit is not available, another Drillbit
+that is registered with the ZooKeeper quorum can accept the query.</p>
+
+<h4 id="direct-connection-to-drillbit">Direct Connection to Drillbit</h4>
+
+<p>When you choose to connect directly to a Drillbit, the ODBC driver connects to
+the Drillbit and submits a query. If you connect directly to Drillbit that is
+not part of a cluster, the Drillbit that you connect to processes the query.
+If you connect directly to a Drillbit that is part of a cluster, all Drillbits
+in the cluster process the query. In either case, the Drillbit that the ODBC
+driver connected to returns the query results.</p>
+
+<p><img src="/docs/img/ODBC_to_Drillbit.png" alt=""></p>
+
+<h3 id="catalog">Catalog</h3>
+
+<p>This value defaults to DRILL and cannot be changed.</p>
+
+<h3 id="schema">Schema</h3>
+
+<p>The Default Schema list contains the data sources that you have configured to
+use with Drill via the Drill Storage Plugin.</p>
+
+<p>Views that you create using the Drill Explorer do not appear under the schema
+associated with the data source type. Instead, the views can be accessed from
+the file-based schema that you selected when saving the view.</p>
+
+<h3 id="advanced-properties">Advanced Properties</h3>
+
+<p>The Advanced Properties field allows you to customize the DSN.<br>
+You can configure the values of the following advanced properties:</p>
+
+<table ><tbody><tr><th >Property Name</th><th >Default Value</th><th >Description</th></tr><tr><td valign="top">HandshakeTimeout</td><td valign="top">5</td><td valign="top">An integer value representing the number of seconds that the driver waits to establish a connection before aborting. When set to 0, the driver does not abort connection attempts.</td></tr><tr><td valign="top">QueryTimeout</td><td valign="top">180</td><td valign="top">An integer value representing the number of seconds for the driver to wait before automatically stopping a query. When set to 0, the driver does not stop queries automatically.</td></tr><tr><td valign="top">TimestampTZDisplayTimezone</td><td valign="top">local</td><td valign="top">A string value that defines how the timestamp with timezone is displayed:<ul><li class="Body"><strong>local</strong>âTimestamps appear in the time zone of the user.</li><li class="Body"><strong>utc</strong>âTimestamps appear in Coordinated Universal Time (UTC).</l
i></ul></td></tr><tr><td valign="top">ExcludedSchemas</td><td valign="top">sys, INFORMATION_SCHEMA</td><td valign="top">A list of schemas that should not appear in client applications such as Drill Explorer, Tableau, and Excel. Separate schemas in the list using a comma (,).</td></tr></tbody></table>
+
+<p>Separate each advanced property using a semicolon.</p>
+
+<p>For example, the following Advanced Properties string excludes the schemas
+named test and abc; sets the timeout to 30 seconds; and, sets the time zone to
+Coordinated Universal Time:<br>
+<code>HandshakeTimeout=30;QueryTimeout=30;TimestampTZDisplayTimezone=utc;ExcludedSchemas=test,abc</code></p>
+
+<h3 id="logging-options">Logging Options</h3>
+
+<p>Configure logging to troubleshoot issues. To configure logging, click the
+Logging Options button on the ODBC DSN Setup dialog and then set a log level
+and a log path.</p>
+
+<p>If logging is enabled, the MapR Drill ODBC driver logs events in following log
+files in the log path that you configure:</p>
+
+<table ><tbody><tr><th >Log File</th><th >Description</th></tr><tr><td valign="top">driver.log</td><td valign="top">A log of driver events.</td></tr><tr><td valign="top">drillclient.log</td><td valign="top">A log of the Drill client events.</td></tr></tbody></table>
+
+<h4 id="logging-levels">Logging Levels</h4>
+
+<p>Each logging level provides a different level of detail in the log files. The
+following log levels are available:</p>
+
+<table ><tbody><tr><th >Logging Level</th><th >Description</th></tr><tr><td valign="top">OFF</td><td valign="top">Disables all logging.</td></tr><tr><td valign="top">FATAL</td><td valign="top">Logs severe error events that may cause the driver to stop running.</td></tr><tr><td valign="top">ERROR</td><td valign="top">Logs error events that may allow the driver to continue running.</td></tr><tr><td valign="top">WARNING</td><td valign="top">Logs events about potentially harmful situations.</td></tr><tr><td valign="top">INFO</td><td valign="top">Logs high-level events about driver processes.</td></tr><tr><td valign="top">DEBUG</td><td valign="top">Logs detailed events that may help to debug issues.</td></tr><tr><td colspan="1" valign="top">TRACE</td><td colspan="1" valign="top">Logs finer-grained events than the DEBUG level.</td></tr></tbody></table>
+
+<h2 id="create-an-odbc-connection-string">Create an ODBC Connection String</h2>
+
+<p>If you want to connect to a Drill data source from an application that does
+not require a DSN, you can use an ODBC connection string.<br>
+The following table describes the properties that you can use in the
+connection string:</p>
+
+<table ><tbody><tr><th >Property</th><th >Description</th></tr><tr><td valign="top">AdvancedProperties</td><td valign="top">Separate advanced properties using a semicolon (;), and then surround all advanced properties in a connection string using braces { and }.For more information, see <a href="#Step2.ConfigureODBCConnectionstoDrillDataSources-AdvancedProperties">Advanced Properties</a>.</td></tr><tr><td valign="top">Catalog</td><td valign="top">The name of the catalog, under which all of the schemas are organized. The catalog name is DRILL.</td></tr><tr><td valign="top">ConnectionType</td><td valign="top">One of the following values:<br />⢠DirectâConnect to a Drill server using Host and Port properties in the connection string.<br />⢠ZooKeeperâConnect to a ZooKeeper cluster using ZKQuorum and ZKClusterID properties in the connection string.For more information, see<a href="#Step2.ConfigureODBCConnectionstoDrillDataSources-ConnectionType"> Connection Type</a>.
</td></tr><tr><td valign="top">DRIVER</td><td valign="top">The name of the installed driver: MapR Drill ODBC Driver<br />(Required)</td></tr><tr><td valign="top">Host</td><td valign="top">If the ConnectionType property is set to Direct, indicate the IP address or hostname of the Drillbit server.</td></tr><tr><td valign="top">Port</td><td valign="top">If the ConnectionType property is set to Direct, indicate the port on which the Drillbit server is listening.</td></tr><tr><td valign="top">Schema</td><td valign="top">The name of the database schema to use when a schema is not explicitly specified in a query.<br />Note: Queries on other schemas can still be issued by explicitly specifying the schema in the query.</td></tr><tr><td valign="top">ZKClusterID</td><td valign="top">If the ConnectionType property is set to ZooKeeper, then use ZKClusterID to indicate the name of the Drillbit cluster to use.</td></tr><tr><td valign="top">ZKQuorum</td><td valign="top">If the ConnectionType proper
ty is set to ZooKeeper, then use ZKQuorum to indicate the server(s) in your ZooKeeper cluster. Separate multiple servers using a comma (,).</td></tr></tbody></table>
+
+<h4 id="connection-string-examples">Connection String Examples</h4>
+
+<p>The following is an example connection string for the Direct connection type: </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text"> DRIVER=MapR Drill ODBC Driver;AdvancedProperties={HandshakeTimeout=0;QueryTimeout=0;TimestampTZDisplayTimezone=utc;ExcludedSchemas=sys,INFORMATION_SCHEMA;};Catalog=DRILL;Schema=hivestg;ConnectionType=Direct;Host=192.168.202.147;Port=31010
+</code></pre></div>
+<p>The following is an example connection string for the Zookeeper connection
+type: </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text"> DRIVER=MapR Drill ODBC Driver;AdvancedProperties={HandshakeTimeout=0;QueryTimeout=0;TimestampTZDisplayTimezone=utc;ExcludedSchemas=sys, INFORMATION_SCHEMA;};Catalog=DRILL;Schema=;ConnectionType=ZooKeeper;ZKQuorum=192.168.39.43:5181;ZKClusterID=drillbits1
+</code></pre></div>
+<h4 id="what's-next?-go-to-step-3.-connect-to-drill-data-sources-from-a-bi-tool.">What's Next? Go to <a href="/drill/docs/step-3-connect-to-drill-data-sources-from-a-bi-tool">Step 3. Connect to Drill Data Sources from a BI Tool</a>.</h4>
+</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/step-3-connect-to-drill-data-sources-from-a-bi-tool/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/step-3-connect-to-drill-data-sources-from-a-bi-tool/index.html?rev=1662344&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/step-3-connect-to-drill-data-sources-from-a-bi-tool/index.html (added)
+++ drill/site/trunk/content/drill/docs/step-3-connect-to-drill-data-sources-from-a-bi-tool/index.html Thu Feb 26 01:16:43 2015
@@ -0,0 +1,110 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Step 3. Connect to Drill Data Sources from a BI Tool - 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>Step 3. Connect to Drill Data Sources from a BI Tool</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>After you create the ODBC DSN, you can use ODBC to directly connect to data
+that is defined by a schema, such as Hive, and data that is self-describing.
+Examples of self-describing data include HBase, Parquet, JSON, CSV,and TSV.</p>
+
+<p>In some cases, you may want to use Drill Explorer to explore that data or to
+create a view before you connect to the data from a BI tool. For more
+information about Drill Explorer, see <a href="/drill/docs/using-drill-explorer-to-browse-data-and-create-views">Using Drill Explorer to Browse Data and
+Create Views</a>.</p>
+
+<p>In an ODBC-compliant BI tool, use the ODBC DSN to create an ODBC connection
+with one of the methods applicable to the data source type:</p>
+
+<table ><tbody><tr><th >Data Source Type</th><th>ODBC Connection Method</th></tr><tr><td valign="top">Hive</td><td valign="top">Connect to a table.<br />Connect to the table using custom SQL.<br />Use Drill Explorer to create a view. Then use ODBC to connect to the view as if it were a table.</td></tr><tr><td valign="top">HBase<br /><span style="line-height: 1.4285715;background-color: transparent;">Parquet<br /></span><span style="line-height: 1.4285715;background-color: transparent;">JSON<br /></span><span style="line-height: 1.4285715;background-color: transparent;">CSV<br /></span><span style="line-height: 1.4285715;background-color: transparent;">TSV</span></td><td valign="top">Use Drill Explorer to create a view. Then use ODBC to connect to the view as if it were a table.<br />Connect to the data using custom SQL.</td></tr></tbody></table>
+
+
+<p>For examples of how to connect to Drill data sources from a BI tool, see the
+<a href="/drill/docs/step-3-connect-to-drill-data-sources-from-a-bi-tool">Step 3. Connect to Drill Data Sources from a BI Tool</a>.</p>
+
+<p><strong>Note:</strong> The default schema that you configure in the DSN may or may not carry over to an applicationâs data source connections. You may need to re-select the schema.</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/storage-plugin-registration/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/storage-plugin-registration/index.html?rev=1662344&r1=1662343&r2=1662344&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/storage-plugin-registration/index.html (original)
+++ drill/site/trunk/content/drill/docs/storage-plugin-registration/index.html Thu Feb 26 01:16:43 2015
@@ -97,13 +97,7 @@ other instance <code>hdfsproduction</cod
<p>The following example shows an HDFS data source registered in the Drill Web UI
as a storage plugin instance of plugin type "<code>file"</code>:</p>
-<p><img src="../../img/StoragePluginConfig.png" alt=""></p>
-
-<p>Click the following link to learn about workspaces:</p>
-
-<ul>
-<li><a href="/confluence/display/DRILL/Workspaces">Workspaces</a></li>
-</ul>
+<p><img src="/docs/img/StoragePluginConfig.png" alt="drill query flow"></p>
</div>
Modified: drill/site/trunk/content/drill/docs/summary/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/summary/index.html?rev=1662344&r1=1662343&r2=1662344&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/summary/index.html (original)
+++ drill/site/trunk/content/drill/docs/summary/index.html Thu Feb 26 01:16:43 2015
@@ -75,7 +75,7 @@ systems.</p>
<p>Now that you are familiar with different ways to access the sample data with
Drill, you can try writing your own queries against your own data sources.
-Refer to the <a href="https://cwiki.apache.org/confluence/%0Adisplay/DRILL/Apache+Drill+Wiki">Apache Drill documentation</a> for more information.</p>
+Refer to the <a href="/drill/docs">Apache Drill documentation</a> for more information.</p>
</div>