You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by br...@apache.org on 2015/03/18 21:35:58 UTC
svn commit: r1667611 [1/3] - in /drill/site/trunk/content/drill: ./ docs/
docs/advanced-properties/ docs/alter-session-command/
docs/alter-system-command/ docs/analyzing-yelp-json-data-with-apache-drill/
docs/apache-drill-in-10-minutes/ docs/apache-dri...
Author: bridgetb
Date: Wed Mar 18 20:35:57 2015
New Revision: 1667611
URL: http://svn.apache.org/r1667611
Log:
DRILL-2490: convert confluence sql commands pages
Added:
drill/site/trunk/content/drill/docs/alter-session-command/
drill/site/trunk/content/drill/docs/alter-session-command/index.html
drill/site/trunk/content/drill/docs/alter-system-command/
drill/site/trunk/content/drill/docs/alter-system-command/index.html
drill/site/trunk/content/drill/docs/create-view-command/
drill/site/trunk/content/drill/docs/create-view-command/index.html
drill/site/trunk/content/drill/docs/date-time-and-timestamp/
drill/site/trunk/content/drill/docs/date-time-and-timestamp/index.html
drill/site/trunk/content/drill/docs/describe-command/
drill/site/trunk/content/drill/docs/describe-command/index.html
drill/site/trunk/content/drill/docs/handling-different-data-types/
drill/site/trunk/content/drill/docs/handling-different-data-types/index.html
drill/site/trunk/content/drill/docs/show-databases-and-show-schemas-command/
drill/site/trunk/content/drill/docs/show-databases-and-show-schemas-command/index.html
drill/site/trunk/content/drill/docs/show-tables-command/
drill/site/trunk/content/drill/docs/show-tables-command/index.html
drill/site/trunk/content/drill/docs/use-command/
drill/site/trunk/content/drill/docs/use-command/index.html
Modified:
drill/site/trunk/content/drill/docs/advanced-properties/index.html
drill/site/trunk/content/drill/docs/analyzing-yelp-json-data-with-apache-drill/index.html
drill/site/trunk/content/drill/docs/apache-drill-in-10-minutes/index.html
drill/site/trunk/content/drill/docs/apache-drill-tutorial/index.html
drill/site/trunk/content/drill/docs/architectural-highlights/index.html
drill/site/trunk/content/drill/docs/architectural-overview/index.html
drill/site/trunk/content/drill/docs/configuring-odbc-connections-for-linux-and-mac-os-x/index.html
drill/site/trunk/content/drill/docs/connect-to-a-data-source/index.html
drill/site/trunk/content/drill/docs/core-modules-within-a-drillbit/index.html
drill/site/trunk/content/drill/docs/data-types/index.html
drill/site/trunk/content/drill/docs/deploying-apache-drill-in-a-clustered-environment/index.html
drill/site/trunk/content/drill/docs/drill-default-input-format/index.html
drill/site/trunk/content/drill/docs/driver-configuration-options/index.html
drill/site/trunk/content/drill/docs/explain-commands/index.html
drill/site/trunk/content/drill/docs/file-system-storage-plugin/index.html
drill/site/trunk/content/drill/docs/flexibility/index.html
drill/site/trunk/content/drill/docs/getting-started-tutorial/index.html
drill/site/trunk/content/drill/docs/getting-to-know-the-drill-sandbox/index.html
drill/site/trunk/content/drill/docs/hbase-storage-plugin/index.html
drill/site/trunk/content/drill/docs/hive-storage-plugin/index.html
drill/site/trunk/content/drill/docs/index.html
drill/site/trunk/content/drill/docs/install-drill/index.html
drill/site/trunk/content/drill/docs/installing-drill-in-distributed-mode/index.html
drill/site/trunk/content/drill/docs/installing-drill-in-embedded-mode/index.html
drill/site/trunk/content/drill/docs/installing-drill-on-linux/index.html
drill/site/trunk/content/drill/docs/installing-drill-on-mac-os-x/index.html
drill/site/trunk/content/drill/docs/installing-drill-on-windows/index.html
drill/site/trunk/content/drill/docs/installing-the-apache-drill-sandbox/index.html
drill/site/trunk/content/drill/docs/installing-the-mapr-drill-odbc-driver-on-linux/index.html
drill/site/trunk/content/drill/docs/installing-the-mapr-drill-odbc-driver-on-mac-os-x/index.html
drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-virtualbox/index.html
drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-vmware-player-vmware-fusion/index.html
drill/site/trunk/content/drill/docs/lession-1-learn-about-the-data-set/index.html
drill/site/trunk/content/drill/docs/lession-2-run-queries-with-ansi-sql/index.html
drill/site/trunk/content/drill/docs/lession-3-run-queries-on-complex-data-types/index.html
drill/site/trunk/content/drill/docs/mapr-db-format/index.html
drill/site/trunk/content/drill/docs/mongodb-plugin-for-apache-drill/index.html
drill/site/trunk/content/drill/docs/odbc-jdbc-interfaces/index.html
drill/site/trunk/content/drill/docs/performance/index.html
drill/site/trunk/content/drill/docs/query-data/index.html
drill/site/trunk/content/drill/docs/select-statements/index.html
drill/site/trunk/content/drill/docs/sql-commands-summary/index.html
drill/site/trunk/content/drill/docs/step-1-install-the-mapr-drill-odbc-driver-on-windows/index.html
drill/site/trunk/content/drill/docs/step-2-configure-odbc-connections-to-drill-data-sources/index.html
drill/site/trunk/content/drill/docs/step-3-connect-to-drill-data-sources-from-a-bi-tool/index.html
drill/site/trunk/content/drill/docs/storage-plugin-configuration/index.html
drill/site/trunk/content/drill/docs/storage-plugin-registration/index.html
drill/site/trunk/content/drill/docs/summary/index.html
drill/site/trunk/content/drill/docs/tableau-examples/index.html
drill/site/trunk/content/drill/docs/testing-the-odbc-connection-on-linux-and-mac-os-x/index.html
drill/site/trunk/content/drill/docs/using-drill-explorer-to-browse-data-and-create-views/index.html
drill/site/trunk/content/drill/docs/using-the-jdbc-driver/index.html
drill/site/trunk/content/drill/docs/using-the-mapr-odbc-driver-on-linux-and-mac-os-x/index.html
drill/site/trunk/content/drill/docs/using-the-mapr-odbc-driver-on-windows/index.html
drill/site/trunk/content/drill/docs/workspaces/index.html
drill/site/trunk/content/drill/feed.xml
Modified: drill/site/trunk/content/drill/docs/advanced-properties/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/advanced-properties/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/advanced-properties/index.html (original)
+++ drill/site/trunk/content/drill/docs/advanced-properties/index.html Wed Mar 18 20:35:57 2015
@@ -67,7 +67,9 @@
</div>
-<div class="int_text" align="left"><p>When you use advanced properties, you must separate them using a semi-colon
+<div class="int_text" align="left"><p><a href="/docs/configuring-odbc-connections-for-linux-and-mac-os-x">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/testing-the-odbc-connection-on-linux-and-mac-os-x">Next</a></p>
+
+<p>When you use advanced properties, you must separate them using a semi-colon
(;).</p>
<p>For example, the following Advanced Properties string excludes the schemas
Added: drill/site/trunk/content/drill/docs/alter-session-command/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/alter-session-command/index.html?rev=1667611&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/alter-session-command/index.html (added)
+++ drill/site/trunk/content/drill/docs/alter-session-command/index.html Wed Mar 18 20:35:57 2015
@@ -0,0 +1,156 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>ALTER SESSION 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>ALTER SESSION Command</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>The ALTER SESSION command changes a system setting for the duration of a
+session. Session level settings override system level settings.</p>
+
+<h2 id="syntax">Syntax</h2>
+
+<p>The ALTER SESSION command supports the following syntax:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">ALTER SESSION SET `<option_name>`=<value>;
+</code></pre></div>
+<h2 id="parameters">Parameters</h2>
+
+<p><em>option_name</em><br>
+This is the option name as it appears in the systems table.</p>
+
+<p><em>value</em><br>
+A value of the type listed in the sys.options table: number, string, boolean,
+or float. Use the appropriate value type for each option that you set.</p>
+
+<h2 id="usage-notes">Usage Notes</h2>
+
+<p>Use the ALTER SESSION command to set Drill query planning and execution
+options per session in a cluster. The options that you set using the ALTER
+SESSION command only apply to queries that run during the current Drill
+connection. A session ends when you quit the Drill shell. You can set any of
+the system level options at the session level.</p>
+
+<p>You can run the following query to see a complete list of planning and
+execution options that are currently set at the system or session level:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> SELECT name, type FROM sys.options WHERE type in ('SYSTEM','SESSION') order by name;
++------------+----------------------------------------------+
+| name | type |
++----------------------------------------------+------------+
+| drill.exec.functions.cast_empty_string_to_null | SYSTEM |
+| drill.exec.storage.file.partition.column.label | SYSTEM |
+| exec.errors.verbose | SYSTEM |
+| exec.java_compiler | SYSTEM |
+| exec.java_compiler_debug | SYSTEM |
+â¦
++------------+----------------------------------------------+
+</code></pre></div>
+<p><strong>Note:</strong> This is a truncated version of the list.</p>
+
+<h2 id="example">Example</h2>
+
+<p>This example demonstrates how to use the ALTER SESSION command to set the
+<code>store.json.all_text_mode</code> option to âtrueâ for the current Drill session.
+Setting this option to âtrueâ enables text mode so that Drill reads everything
+in JSON as a text object instead of trying to interpret data types. This
+allows complicated JSON to be read using CASE and CAST.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> alter session set `store.json.all_text_mode`= true;
++------------+------------+
+| ok | summary |
++------------+------------+
+| true | store.json.all_text_mode updated. |
++------------+------------+
+1 row selected (0.046 seconds)
+</code></pre></div>
+<p>You can issue a query to see all of the session level settings. Note that the
+option type is case-sensitive.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> SELECT name, type, bool_val FROM sys.options WHERE type = 'SESSION' order by name;
++------------+------------+------------+
+| name | type | bool_val |
++------------+------------+------------+
+| store.json.all_text_mode | SESSION | true |
++------------+------------+------------+
+1 row selected (0.176 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/alter-system-command/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/alter-system-command/index.html?rev=1667611&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/alter-system-command/index.html (added)
+++ drill/site/trunk/content/drill/docs/alter-system-command/index.html Wed Mar 18 20:35:57 2015
@@ -0,0 +1,182 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>ALTER SYSTEM 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>ALTER SYSTEM Command</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>The ALTER SYSTEM command permanently changes a system setting. The new setting
+persists across all sessions. Session level settings override system level
+settings.</p>
+
+<h2 id="syntax">Syntax</h2>
+
+<p>The ALTER SYSTEM command supports the following syntax:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">ALTER SYSTEM SET `<option_name>`=<value>;
+</code></pre></div>
+<h2 id="parameters">Parameters</h2>
+
+<p><em>option_name</em></p>
+
+<p>This is the option name as it appears in the systems table.</p>
+
+<p><em>value</em></p>
+
+<p>A value of the type listed in the sys.options table: number, string, boolean,
+or float. Use the appropriate value type for each option that you set.</p>
+
+<h2 id="usage-notes">Usage Notes</h2>
+
+<p>Use the ALTER SYSTEM command to permanently set Drill query planning and
+execution options per cluster. Options set at the system level affect the
+entire system and persist between restarts.</p>
+
+<p>You can run the following query to see a complete list of planning and
+execution options that you can set at the system level:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> select name, type, num_val, string_val, bool_val, float_val from sys.options where type like 'SYSTEM' order by name;
++------------+------------+------------+------------+------------+------------+
+| name | type | num_val | string_val | bool_val | float_val |
++------------+------------+------------+------------+------------+------------+
+| drill.exec.functions.cast_empty_string_to_null | SYSTEM | null | null | false | null |
+| drill.exec.storage.file.partition.column.label | SYSTEM | null | dir | null | null |
+| exec.errors.verbose | SYSTEM | null | null | false | null |
+| exec.java_compiler | SYSTEM | null | DEFAULT | null | null |
+| exec.java_compiler_debug | SYSTEM | null | null | true | null |
+| exec.java_compiler_janino_maxsize | SYSTEM | 262144 | null | null | null |
+| exec.queue.timeout_millis | SYSTEM | 400000 | null | null | null |
+| planner.add_producer_consumer | SYSTEM | null | null | true | null |
+| planner.affinity_factor | SYSTEM | null | null | null | 1.2 |
+| planner.broadcast_threshold | SYSTEM | 1000000 | null | null | null |
+| planner.disable_exchanges | SYSTEM | null | null | false | null |
+| planner.enable_broadcast_join | SYSTEM | null | null | true | null |
+| planner.enable_hash_single_key | SYSTEM | null | null | true | null |
+| planner.enable_hashagg | SYSTEM | null | null | true | null |
+| planner.enable_hashjoin | SYSTEM | null | null | true | null |
+| planner.slice_target | SYSTEM | 100000 | null | null | null |
+| planner.width.max_per_node | SYSTEM | 2 | null | null | null |
+| planner.width.max_per_query | SYSTEM | 1000 | null | null | null |
+| store.format | SYSTEM | null | parquet | null | null |
+| store.json.all_text_mode | SYSTEM | null | null | false | null |
+| store.mongo.all_text_mode | SYSTEM | null | null | false | null |
+| store.parquet.block-size | SYSTEM | 536870912 | null | null | null |
+| store.parquet.use_new_reader | SYSTEM | null | null | false | null |
+| store.parquet.vector_fill_check_threshold | SYSTEM | 10 | null | null | null |
+| store.parquet.vector_fill_threshold | SYSTEM | 85 | null | null | null |
++------------+------------+------------+------------+------------+------------+
+</code></pre></div>
+<p><strong>Note:</strong> This is a truncated version of the list.</p>
+
+<h2 id="example">Example</h2>
+
+<p>This example demonstrates how to use the ALTER SYSTEM command to set the
+<code>planner.add_producer_consumer</code> option to âtrue.â This option enables a
+secondary reading thread to prefetch data from disk.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> alter system set `planner.add_producer_consumer` = true;
++------------+------------+
+| ok | summary |
++------------+------------+
+| true | planner.add_producer_consumer updated. |
++------------+------------+
+1 row selected (0.046 seconds)
+</code></pre></div>
+<p>You can issue a query to see all of the system level settings set to âtrue.â
+Note that the option type is case-sensitive.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> SELECT name, type, bool_val FROM sys.options WHERE type = 'SYSTEM' and bool_val=true;
++------------+------------+------------+
+| name | type | bool_val |
++------------+------------+------------+
+| exec.java_compiler_debug | SYSTEM | true |
+| planner.enable_mergejoin | SYSTEM | true |
+| planner.enable_broadcast_join | SYSTEM | true |
+| planner.enable_hashagg | SYSTEM | true |
+| planner.add_producer_consumer | SYSTEM | true |
+| planner.enable_hash_single_key | SYSTEM | true |
+| planner.enable_multiphase_agg | SYSTEM | true |
+| planner.enable_streamagg | SYSTEM | true |
+| planner.enable_hashjoin | SYSTEM | true |
++------------+------------+------------+
+9 rows selected (0.159 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>
Modified: drill/site/trunk/content/drill/docs/analyzing-yelp-json-data-with-apache-drill/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/analyzing-yelp-json-data-with-apache-drill/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/analyzing-yelp-json-data-with-apache-drill/index.html (original)
+++ drill/site/trunk/content/drill/docs/analyzing-yelp-json-data-with-apache-drill/index.html Wed Mar 18 20:35:57 2015
@@ -67,7 +67,9 @@
</div>
-<div class="int_text" align="left"><p><a href="https://www.mapr.com/products/apache-drill">Apache Drill</a> is one of the
+<div class="int_text" align="left"><p><a href="/docs/summary">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/install-drill">Next</a></p>
+
+<p><a href="https://www.mapr.com/products/apache-drill">Apache Drill</a> is one of the
fastest growing open source projects, with the community making rapid progress
with monthly releases. The key difference is Drillâs agility and flexibility.
Along with meeting the table stakes for SQL-on-Hadoop, which is to achieve low
Modified: drill/site/trunk/content/drill/docs/apache-drill-in-10-minutes/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/apache-drill-in-10-minutes/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/apache-drill-in-10-minutes/index.html (original)
+++ drill/site/trunk/content/drill/docs/apache-drill-in-10-minutes/index.html Wed Mar 18 20:35:57 2015
@@ -67,7 +67,9 @@
</div>
-<div class="int_text" align="left"><ul>
+<div class="int_text" align="left"><p><a href="/docs/install-drill">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/deploying-apache-drill-in-a-clustered-environment">Next</a></p>
+
+<ul>
<li>Objective</li>
<li>A Few Bits About Apache Drill</li>
<li>Process Overview</li>
Modified: drill/site/trunk/content/drill/docs/apache-drill-tutorial/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/apache-drill-tutorial/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/apache-drill-tutorial/index.html (original)
+++ drill/site/trunk/content/drill/docs/apache-drill-tutorial/index.html Wed Mar 18 20:35:57 2015
@@ -67,7 +67,9 @@
</div>
-<div class="int_text" align="left"><p>This tutorial uses the MapR Sandbox, which is a Hadoop environment pre-
+<div class="int_text" align="left"><p><a href="/docs/performance">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/installing-the-apache-drill-sandbox">Next</a></p>
+
+<p>This tutorial uses the MapR Sandbox, which is a Hadoop environment pre-
configured with Apache Drill.</p>
<p>To complete the tutorial on the MapR Sandbox with Apache Drill, work through
Modified: drill/site/trunk/content/drill/docs/architectural-highlights/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/architectural-highlights/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/architectural-highlights/index.html (original)
+++ drill/site/trunk/content/drill/docs/architectural-highlights/index.html Wed Mar 18 20:35:57 2015
@@ -67,7 +67,9 @@
</div>
-<div class="int_text" align="left"><p>The goal for Drill is to bring the <strong>SQL Ecosystem</strong> and <strong>Performance</strong> of
+<div class="int_text" align="left"><p><a href="/docs/core-modules-within-a-drillbit">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/flexibility">Next</a></p>
+
+<p>The goal for Drill is to bring the <strong>SQL Ecosystem</strong> and <strong>Performance</strong> of
the relational systems to <strong>Hadoop scale</strong> data <strong>WITHOUT</strong> compromising on
the <strong>Flexibility</strong> of Hadoop/NoSQL systems. There are several core
architectural elements in Apache Drill that make it a highly flexible and
Modified: drill/site/trunk/content/drill/docs/architectural-overview/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/architectural-overview/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/architectural-overview/index.html (original)
+++ drill/site/trunk/content/drill/docs/architectural-overview/index.html Wed Mar 18 20:35:57 2015
@@ -67,7 +67,9 @@
</div>
-<div class="int_text" align="left"><p>Apache Drill is a low latency distributed query engine for large-scale
+<div class="int_text" align="left"><p><a href="/docs">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/core-modules-within-a-drillbit">Next</a></p>
+
+<p>Apache Drill is a low latency distributed query engine for large-scale
datasets, including structured and semi-structured/nested data. Inspired by
Googleâs Dremel, Drill is designed to scale to several thousands of nodes and
query petabytes of data at interactive speeds that BI/Analytics environments
Modified: drill/site/trunk/content/drill/docs/configuring-odbc-connections-for-linux-and-mac-os-x/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/configuring-odbc-connections-for-linux-and-mac-os-x/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/configuring-odbc-connections-for-linux-and-mac-os-x/index.html (original)
+++ drill/site/trunk/content/drill/docs/configuring-odbc-connections-for-linux-and-mac-os-x/index.html Wed Mar 18 20:35:57 2015
@@ -67,7 +67,9 @@
</div>
-<div class="int_text" align="left"><p>You can use a connection string to connect to your data source. For a list of
+<div class="int_text" align="left"><p><a href="/docs/driver-configuration-options">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/advanced-properties">Next</a></p>
+
+<p>You can use a connection string to connect to your data source. For a list of
all the properties that you can use in connection strings, see <a href="/docs/driver-configuration-options">Driver
Configuration
Options</a>.</p>
Modified: drill/site/trunk/content/drill/docs/connect-to-a-data-source/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/connect-to-a-data-source/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/connect-to-a-data-source/index.html (original)
+++ drill/site/trunk/content/drill/docs/connect-to-a-data-source/index.html Wed Mar 18 20:35:57 2015
@@ -67,7 +67,9 @@
</div>
-<div class="int_text" align="left"><p>A storage plugin is an interface for connecting to a data source to read and write data. Apache Drill connects to a data source, such as a file on the file system or a Hive metastore, through a storage plugin. When you execute a query, Drill gets the plugin name you provide in FROM clause of your query or from the default you specify in the USE.<plugin name> command that precedes the query.
+<div class="int_text" align="left"><p><a href="/docs/installing-drill-in-distributed-mode">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/storage-plugin-registration">Next</a></p>
+
+<p>A storage plugin is an interface for connecting to a data source to read and write data. Apache Drill connects to a data source, such as a file on the file system or a Hive metastore, through a storage plugin. When you execute a query, Drill gets the plugin name you provide in FROM clause of your query or from the default you specify in the USE.<plugin name> command that precedes the query.
. </p>
<p>In addition to the connection string, the storage plugin configures the workspace and file formats for reading data, as described in subsequent sections. </p>
Modified: drill/site/trunk/content/drill/docs/core-modules-within-a-drillbit/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/core-modules-within-a-drillbit/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/core-modules-within-a-drillbit/index.html (original)
+++ drill/site/trunk/content/drill/docs/core-modules-within-a-drillbit/index.html Wed Mar 18 20:35:57 2015
@@ -67,7 +67,9 @@
</div>
-<div class="int_text" align="left"><p>The following image represents components within each Drillbit:</p>
+<div class="int_text" align="left"><p><a href="/docs/architectural-overview">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/architectural-highlights">Next</a></p>
+
+<p>The following image represents components within each Drillbit:</p>
<p><img src="/docs/img/DrillbitModules.png" alt="drill query flow"></p>
Added: drill/site/trunk/content/drill/docs/create-view-command/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/create-view-command/index.html?rev=1667611&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/create-view-command/index.html (added)
+++ drill/site/trunk/content/drill/docs/create-view-command/index.html Wed Mar 18 20:35:57 2015
@@ -0,0 +1,280 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>CREATE VIEW 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>CREATE VIEW command</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>The CREATE VIEW command creates a virtual structure for the result set of a
+stored query. A view can combine data from multiple underlying data sources
+and provide the illusion that all of the data is from one source. You can use
+views to protect sensitive data, for data aggregation, and to hide data
+complexity from users. You can create Drill views from files in your local and
+distributed file systems, Hive, HBase, and MapR-DB tables, as well as from
+existing views or any other available storage plugin data sources.</p>
+
+<h2 id="syntax">Syntax</h2>
+
+<p>The CREATE VIEW command supports the following syntax:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">CREATE [OR REPLACE] VIEW [workspace.]view_name [ (column_name [, ...]) ] AS <query>;
+</code></pre></div>
+<p>Use CREATE VIEW to create a new view. Use CREATE OR REPLACE VIEW to replace an
+existing view with the same name. When you replace a view, the query must
+generate the same set of columns with the same column names and data types.</p>
+
+<p><strong>Note:</strong> Follow Drillâs rules for identifiers when you name the view. See coming soon...</p>
+
+<h2 id="parameters">Parameters</h2>
+
+<p><em>workspace</em><br>
+The location where you want the view to exist. By default, the view is created
+in the current workspace. See
+<a href="/docs/Workspaces">Workspaces</a>.</p>
+
+<p><em>view_name</em><br>
+The name that you give the view. The view must have a unique name. It cannot
+have the same name as any other view or table in the workspace.</p>
+
+<p><em>column_name</em><br>
+Optional list of column names in the view. If you do not supply column names,
+they are derived from the query.</p>
+
+<p><em>query</em><br>
+A SELECT statement that defines the columns and rows in the view.</p>
+
+<h2 id="usage-notes">Usage Notes</h2>
+
+<h3 id="storage">Storage</h3>
+
+<p>Drill stores views in the location specified by the workspace that you use
+when you run the CREATE VIEW command. If the workspace is not defined, Drill
+creates the view in the current workspace. You must use a writable workspace
+when you create a view. Currently, Drill only supports views created in the
+file system or distributed file system.</p>
+
+<p>The following example shows a writable workspace as defined within the storage
+plugin in the <code>/tmp</code> directory of the file system:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">"tmp": {
+ "location": "/tmp",
+ "writable": true,
+ }
+</code></pre></div>
+<p>Drill stores the view definition in JSON format with the name that you specify
+when you run the CREATE VIEW command, suffixed <code>by .view.drill</code>. For example,
+if you create a view named <code>myview</code>, Drill stores the view in the designated
+workspace as <code>myview.view.drill</code>.</p>
+
+<p>Data Sources</p>
+
+<p>Drill considers data sources to have either a strong schema or a weak schema. </p>
+
+<h5 id="strong-schema">Strong Schema</h5>
+
+<p>With the exception of text file data sources, Drill verifies that data sources
+associated with a strong schema contain data types compatible with those used
+in the query. Drill also verifies that the columns referenced in the query
+exist in the underlying data sources. If the columns do not exist, CREATE VIEW
+fails.</p>
+
+<h4 id="weak-schema">Weak Schema</h4>
+
+<p>Drill does not verify that data sources associated with a weak schema contain
+data types compatible with those used in the query. Drill does not verify if
+columns referenced in a query on a Parquet data source exist, therefore CREATE
+VIEW always succeeds. In the case of JSON files, Drill does not verify if the
+files contain the maps specified in the view.</p>
+
+<p>The following table lists the current categories of schema and the data
+sources associated with each:</p>
+
+<table>
+ <tr>
+ <th></th>
+ <th>Strong Schema</th>
+ <th>Weak Schema</th>
+ </tr>
+ <tr>
+ <td valign="top">Data Sources</td>
+ <td>views<br>hive tables<br>hbase column families<br>text</td>
+ <td>json<br>mongodb<br>hbase column qualifiers<br>parquet</td>
+ </tr>
+</table>
+
+
+<h2 id="related-commands">Related Commands</h2>
+
+<p>After you create a view using the CREATE VIEW command, you can issue the
+following commands against the view:</p>
+
+<ul>
+<li>SELECT </li>
+<li>DESCRIBE </li>
+<li>DROP </li>
+</ul>
+
+<p><strong>Note:</strong> You cannot update, insert into, or delete from a view.</p>
+
+<h2 id="example">Example</h2>
+
+<p>This example shows you some steps that you can follow when you want to create
+a view in Drill using the CREATE VIEW command. A workspace named âdonutsâ was
+created for the steps in this example.</p>
+
+<p>Complete the following steps to create a view in Drill:</p>
+
+<ol>
+<li><p>Decide which workspace you will use to create the view, and verify that the writable option is set to âtrue.â You can use an existing workspace, or you can create a new workspace. See <a href="https://cwiki.apache.org/confluence/display/DRILL/Workspaces">Workspaces</a> for more information. </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">"workspaces": {
+ "donuts": {
+ "location": "/home/donuts",
+ "writable": true,
+ "defaultInputFormat": null
+ }
+ },
+</code></pre></div></li>
+<li><p>Run SHOW DATABASES to verify that Drill recognizes the workspace. </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 |
+| cp.default |
+| sys |
+| INFORMATION_SCHEMA |
++-------------+
+</code></pre></div></li>
+<li><p>Use the writable workspace. </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> use dfs.donuts;
++------------+------------+
+| ok | summary |
++------------+------------+
+| true | Default schema changed to 'dfs.donuts' |
++------------+------------+
+</code></pre></div></li>
+<li><p>Test run the query that you plan to use with the CREATE VIEW command. </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> select id, type, name, ppu from `donuts.json`;
++------------+------------+------------+------------+
+| id | type | name | ppu |
++------------+------------+------------+------------+
+| 0001 | donut | Cake | 0.55 |
++------------+------------+------------+------------+
+</code></pre></div></li>
+<li><p>Run the CREATE VIEW command with the query. </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> create view mydonuts as select id, type, name, ppu from `donuts.json`;
++------------+------------+
+| ok | summary |
++------------+------------+
+| true | View 'mydonuts' created successfully in 'dfs.donuts' schema |
++------------+------------+
+</code></pre></div></li>
+<li><p>Create a new view in another workspace from the current workspace. </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> create view dfs.tmp.yourdonuts as select id, type, name from `donuts.json`;
++------------+------------+
+| ok | summary |
++------------+------------+
+| true | View 'yourdonuts' created successfully in 'dfs.tmp' schema |
++------------+------------+
+</code></pre></div></li>
+<li><p>Query the view created in both workspaces.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> select * from mydonuts;
++------------+------------+------------+------------+
+| id | type | name | ppu |
++------------+------------+------------+------------+
+| 0001 | donut | Cake | 0.55 |
++------------+------------+------------+------------+
+
+0: jdbc:drill:zk=local> select * from dfs.tmp.yourdonuts;
++------------+------------+------------+
+| id | type | name |
++------------+------------+------------+
+| 0001 | donut | Cake |
++------------+------------+------------+
+</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>
Modified: drill/site/trunk/content/drill/docs/data-types/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/data-types/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/data-types/index.html (original)
+++ drill/site/trunk/content/drill/docs/data-types/index.html Wed Mar 18 20:35:57 2015
@@ -67,88 +67,478 @@
</div>
-<div class="int_text" align="left"><p>You can use the following SQL data types in your Drill queries:</p>
+<div class="int_text" align="left"><p>Depending on the data format, you might need to cast or convert data types when Drill reads/writes data.</p>
-<h4 id="character">Character</h4>
+<p>After Drill reads schema-less data into SQL tables, you need to cast data types explicitly to query the data. In some cases, Drill converts schema-less data to typed data implicitly. In this case, you do not need to cast. The file format of the data and the nature of your query determines the requirement for casting or converting. </p>
+
+<p>Differences in casting depend on the data source. The following list describes how Drill treats data types from various data sources:</p>
<ul>
-<li>VARCHAR/CHAR </li>
+<li>HBase<br>
+No implicit casting to SQL types. Convert data to appropriate types as shown in <a href="/docs/querying-hbase/">"Querying HBase."</a></li>
+<li>Hive<br>
+Implicitly casts Hive types to SQL types as shown in the Hive <a href="/docs/hive-to-drill-data-type-mapping#type-mapping-example">type mapping example</a></li>
+<li>JSON<br>
+Implicitly casts JSON data to its <a href="/docs/json-data-model#data-type-mapping">corresponding SQL types</a> or to VARCHAR if Drillis in all text mode. </li>
+<li>MapR-DB<br>
+Implicitly casts MapR-DB data to SQL types when you use <a href="/docs/mapr-db-format">the maprdb format</a> for reading MapR-DB data. The dfs storage plugin defines the format when you install Drill from the mapr-drill package on a MapR node.</li>
+<li>Parquet<br>
+Implicitly casts Parquet data to the SQL types shown in <a href="/docs/parquet-format/sql-data-types-to-parquet">SQL Data Types to Parquet</a>. </li>
+<li>Text: CSV, TSV, and other text<br>
+Implicitly casts all textual data to VARCHAR.</li>
</ul>
-<h4 id="date/time">Date/Time</h4>
+<h2 id="implicit-casting">Implicit Casting</h2>
-<ul>
-<li>DATE</li>
-<li>INTERVAL
+<p>In general, Drill implicitly casts (promotes) one type to another type based on the order of precedence shown in the following table. Drill also considers the performance cost of implicit casting to one type versus another. Drill usually implicitly casts a type from a lower precedence to a type having higher precedence. For instance, NULL can be promoted to any other type; SMALLINT can be promoted into INT. INT is not promoted to SMALLINT due to possible precision loss.</p>
-<ul>
-<li>Interval Year (stores year and month)</li>
-<li>Interval Day (stores day, hour, minute, seconds, and milliseconds)</li>
-</ul></li>
-<li>TIME</li>
-<li>TIMESTAMP</li>
-</ul>
+<p>Under certain circumstances, such as queries involving substr and concat functions, Drill reverses the order of precedence and allows a cast to VARCHAR from a type of higher precedence than VARCHAR, such as BIGINT. </p>
+
+<p>The following table lists data types top to bottom, in descending precedence. Drill implicitly casts to more data types than are currently supported for explicit casting.</p>
+
+<table>
+ <tr>
+ <th>Precedence</th>
+ <th>Data Type</th>
+ <th>Precedence</th>
+ <th>Data Type</th>
+ </tr>
+ <tr>
+ <td>1</td>
+ <td>INTERVAL</td>
+ <td>13</td>
+ <td>BIGINT</td>
+ </tr>
+ <tr>
+ <td>2</td>
+ <td>INTERVALYEAR</td>
+ <td>14</td>
+ <td>UINT4</td>
+ </tr>
+ <tr>
+ <td>3</td>
+ <td>INTERVLADAY</td>
+ <td>15</td>
+ <td>INT</td>
+ </tr>
+ <tr>
+ <td>4</td>
+ <td>TIMESTAMPTZ</td>
+ <td>16</td>
+ <td>UINT2</td>
+ </tr>
+ <tr>
+ <td>5</td>
+ <td>TIMETZ</td>
+ <td>17</td>
+ <td>SMALLINT</td>
+ </tr>
+ <tr>
+ <td>6</td>
+ <td>TIMESTAMP</td>
+ <td>18</td>
+ <td>UINT1</td>
+ </tr>
+ <tr>
+ <td>7</td>
+ <td>DATE</td>
+ <td>19</td>
+ <td>VAR16CHAR</td>
+ </tr>
+ <tr>
+ <td>8</td>
+ <td>TIME</td>
+ <td>20</td>
+ <td>FIXED16CHAR</td>
+ </tr>
+ <tr>
+ <td>9</td>
+ <td>FLOAT8</td>
+ <td>21</td>
+ <td>VARCHAR</td>
+ </tr>
+ <tr>
+ <td>10</td>
+ <td>DECIMAL</td>
+ <td>22</td>
+ <td>FIXEDCHAR</td>
+ </tr>
+ <tr>
+ <td>11</td>
+ <td>MONEY</td>
+ <td>23</td>
+ <td>VARBINARY</td>
+ </tr>
+ <tr>
+ <td>12</td>
+ <td>UINT8</td>
+ <td>24</td>
+ <td>FIXEDBINARY</td>
+ </tr>
+ <tr>
+ <td></td>
+ <td></td>
+ <td>25</td>
+ <td>NULL</td>
+ </tr>
+</table>
-<p>Refer to <a href="/docs/supported-date-time-data-type-formats/">Supported Date/Time Data Type formats</a>.</p>
+<h2 id="explicit-casting">Explicit Casting</h2>
-<h4 id="integer">Integer</h4>
+<p>Drill supports a number of functions to cast and convert compatible data types:</p>
<ul>
-<li>BIGINT</li>
-<li>INT</li>
-<li>SMALLINT</li>
+<li>CAST<br>
+Casts textual data from one data type to another.</li>
+<li>CONVERT_TO and CONVERT_FROM<br>
+Converts data, including binary data, from one data type to another.</li>
+<li>TO_CHAR
+Converts a TIMESTAMP, INTERVAL, INTEGER, DOUBLE, or DECIMAL to a string.</li>
+<li>TO_DATE
+Converts a string to DATE.</li>
+<li>TO_NUMBER
+Converts a string to a DECIMAL.</li>
+<li>TO_TIMESTAMP
+Converts a string to TIMESTAMP.</li>
</ul>
-<h4 id="numeric">Numeric</h4>
+<p>The following tables show data types that Drill can cast to/from other data types. Not all types are available for explicit casting in the current release.</p>
+<h3 id="explicit-type-casting:-numeric-and-character-types">Explicit type Casting: Numeric and Character types</h3>
+
+<table>
+ <tr>
+ <th></th>
+ <th>To:</th>
+ <th></th>
+ <th></th>
+ <th></th>
+ <th></th>
+ <th></th>
+ <th></th>
+ <th></th>
+ <th></th>
+ <th></th>
+ </tr>
+ <tr>
+ <td>From:</td>
+ <td>SMALLINT</td>
+ <td>INT</td>
+ <td>BIGINT/UINT</td>
+ <td>DECIMAL</td>
+ <td>FLOAT4</td>
+ <td>FLOAT8</td>
+ <td>FIXEDCHAR</td>
+ <td>FIXEDBINARY</td>
+ <td>VARCHAR</td>
+ <td>VARBINARY</td>
+ </tr>
+ <tr>
+ <td>SMALLINT</td>
+ <td></td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ </tr>
+ <tr>
+ <td>INT</td>
+ <td>yes</td>
+ <td>no</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ </tr>
+ <tr>
+ <td>BIGINT/UINT</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ </tr>
+ <tr>
+ <td>DECIMAL</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ </tr>
+ <tr>
+ <td>FLOAT8</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>no</td>
+ <td>yes</td>
+ <td>no</td>
+ <td>yes</td>
+ <td>no</td>
+ </tr>
+ <tr>
+ <td>FLOAT4</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>no</td>
+ <td>no</td>
+ <td>yes</td>
+ <td>no</td>
+ <td>yes</td>
+ <td>no</td>
+ </tr>
+ <tr>
+ <td>FIXEDCHAR</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>no</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ </tr>
+ <tr>
+ <td>FIXEDBINARY</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>no</td>
+ <td>no</td>
+ <td>yes</td>
+ <td>yes</td>
+ </tr>
+ <tr>
+ <td>VARCHAR</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>no</td>
+ <td>yes</td>
+ </tr>
+ <tr>
+ <td>VARBINARY</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>no</td>
+ <td>yes</td>
+ <td>yes</td>
+ <td>no</td>
+ </tr>
+</table>
+
+<h3 id="explicit-type-casting:-date/time-types">Explicit Type Casting: Date/Time types</h3>
+
+<table>
+ <tr>
+ <th></th>
+ <th>To:</th>
+ <th></th>
+ <th></th>
+ <th></th>
+ <th></th>
+ <th></th>
+ <th></th>
+ </tr>
+ <tr>
+ <td>From:</td>
+ <td>DATE</td>
+ <td>TIME</td>
+ <td>TIMESTAMP</td>
+ <td>TIMESTAMPTZ</td>
+ <td>INTERVAL</td>
+ <td>INTERVALYEAR</td>
+ <td>INTERVALDAY</td>
+ </tr>
+ <tr>
+ <td>FIXEDCHAR</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ </tr>
+ <tr>
+ <td>FIXEDBINARY</td>
+ <td>No</td>
+ <td>No</td>
+ <td>No</td>
+ <td>Yes</td>
+ <td>No</td>
+ <td>No</td>
+ <td>No</td>
+ </tr>
+ <tr>
+ <td>VARCHAR</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ </tr>
+ <tr>
+ <td>VARBINARY</td>
+ <td>No</td>
+ <td>No</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>No</td>
+ <td>No</td>
+ <td>No</td>
+ </tr>
+ <tr>
+ <td>DATE</td>
+ <td>No</td>
+ <td>No</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>No</td>
+ <td>No</td>
+ <td>No</td>
+ </tr>
+ <tr>
+ <td>TIME</td>
+ <td>No</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>No</td>
+ <td>No</td>
+ <td>No</td>
+ </tr>
+ <tr>
+ <td>TIMESTAMP</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>No</td>
+ <td>No</td>
+ <td>No</td>
+ </tr>
+ <tr>
+ <td>TIMESTAMPTZ</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>No</td>
+ <td>No</td>
+ <td>No</td>
+ <td>No</td>
+ </tr>
+ <tr>
+ <td>INTERVAL</td>
+ <td>Yes</td>
+ <td>No</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>No</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ </tr>
+ <tr>
+ <td>INTERVALYEAR</td>
+ <td>Yes</td>
+ <td>No</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>No</td>
+ <td>Yes</td>
+ </tr>
+ <tr>
+ <td>INTERVALDAY</td>
+ <td>Yes</td>
+ <td>No</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>Yes</td>
+ <td>No</td>
+ </tr>
+</table>
+
+<h3 id="using-cast">Using CAST</h3>
+
+<p>Embed a CAST function in a query using this syntax:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">cast <expression> AS <data type>
+</code></pre></div>
<ul>
-<li>DECIMAL</li>
-<li>FLOAT </li>
-<li>DOUBLE PRECISION (FLOAT 8)</li>
-<li>REAL (FLOAT 4) </li>
+<li>expression<br>
+An entity that has single data value, such as a column name, of the data type you want to cast to a different type</li>
+<li>data type<br>
+The target data type, such as INTEGER or DATE</li>
</ul>
-<h4 id="boolean">Boolean</h4>
+<p>Example: Inspect INTEGER data and cast the data to the DECIMAL type</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT c_row, c_int FROM mydata WHERE c_row = 9;
+
+c_row | c_int
+------+------------
+ 9 | -2147483648
+(1 row)
+
+SELECT c_row, CAST(c_int AS DECIMAL(28,8)) FROM my_data WHERE c_row = 9;
+
+c_row | c_int
+------+---------------------
+9 | -2147483648.00000000
+(1 row)
+</code></pre></div>
+<p>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. For example:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT c_row, CAST(c_int AS DECIMAL(28,8)) FROM mydata WHERE CAST(c_int AS CECIMAL(28,8)) > -3.0
+</code></pre></div>
+<p>Although you can use CAST to handle binary data, CONVERT_TO and CONVERT_FROM are recommended for these conversions.</p>
+
+<h3 id="using-convert_to-and-convert_from">Using CONVERT_TO and CONVERT_FROM</h3>
-<p>Values are FALSE or TRUE.</p>
+<p>To query HBase data in Drill, convert every column of an HBase table to/from byte arrays from/to an <a href="/docs/data-types/">SQL data type</a> that Drill supports when writing/reading data. For examples of how to use these functions, see <a href="/docs/sql-functions#convert-and-cast-functions">"Convert and Cast Functions".</a></p>
-<h2 id="complex-data-types">Complex Data Types</h2>
+<h2 id="handling-textual-data">Handling Textual Data</h2>
-<p>Drill provides map and array data types to work with complex and nested data
-structures. For analysis of complex data, a more modern JSON-style approach to
-writing queries is more effective than using standard SQL functions.</p>
-
-<p>The following table provides descriptions and examples of the complex data
-types:</p>
-
-<table><tbody>
- <tr><th>Data Type</th>
- <th>Description</th>
- <th>Example</th></tr>
- <tr>
- <td valign="top">Map</td>
- <td valign="top">A map is a set of name/value pairs. </br>
- A value in an map can be a scalar type, </br>
- such as string or int, or a map can be a </br>
- complex type, such as an array or another map.</td>
- <td valign="top">Map with scalar type values:</br><code> "phoneNumber": { "areaCode": "622", "number": "1567845"}</code></br>Map with complex type value:<code></br> { "citiesLived" : [ { "place" : "Los Angeles",</br>
- "yearsLived" : [ "1989",</br>
- "1993",</br>
- "1998",</br>
- "2002"</br>
- ]</br>
-
- } ] }</code></td>
- </tr>
- <tr>
- <td valign="top">Array</td>
- <td valign="top">An array is a repeated list of values. </br>
- A value in an array can be a scalar type, </br>
- such as string or int, or an array can be a</br>
- complex type, such as a map or another array.</td>
- <td valign="top">Array with scalar values:</br><code> "yearsLived": ["1990", "1993", "1998", "2008"]</code></br>Array with complex type values:</br><code> "children":</br> [ { "age" : "10", </br> "gender" : "Male",</br> "name" : "Earl"</br> }, </br> { "age" : "6",</br> "gender" : "Male",</br> "name" : "Sam"</br> },</br> { "age" : "8",</br> "gender" : "Male", </br> "name" : "Kit" </br>  
;}</br> ]</code></td>
- </tr>
- </tbody></table>
+<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 <a href="link">to_char</a>, <a href="line">to_date</a>, <a href="link">to_number</a>, and <a href="link">to_timestamp</a>. 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>
</div>
Added: drill/site/trunk/content/drill/docs/date-time-and-timestamp/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/date-time-and-timestamp/index.html?rev=1667611&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/date-time-and-timestamp/index.html (added)
+++ drill/site/trunk/content/drill/docs/date-time-and-timestamp/index.html Wed Mar 18 20:35:57 2015
@@ -0,0 +1,210 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Date, Time, and Timestamp - 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>Date, Time, and Timestamp</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>Using familiar date and time formats, listed in the <a href="/docs/data-types">SQL data types table</a>, you can construct query date and time data. You need to cast textual data to date and time data types. The format of date, time, and timestamp text in a textual data source needs to match the SQL query format for successful casting. </p>
+
+<p>DATE, TIME, and TIMESTAMP store values in Coordinated Universal Time (UTC). Currently, Drill does not support casting a TIMESTAMP with time zone, but you can use the TO_TIMESTAMP function (link to example) in a query to use time stamp data having a time zone.</p>
+
+<p>Before running a query, you can check the formatting of your dates and times. First, create a dummy JSON file to use in the FROM clause for testing queries as shown in the following examples.
+ {"dummy" : "data"}. </p>
+
+<p>Next, use the following literals in a SELECT statement. </p>
+
+<ul>
+<li><code>date</code></li>
+<li><code>time</code></li>
+<li><p><code>timestamp</code></p>
+
+<p>SELECT date '2010-2-15' FROM dfs.<code>/Users/drilluser/apache-drill-0.8.0/dummy.json</code>;
++------------+
+| EXPR$0 |
++------------+
+| 2010-02-15 |
++------------+
+1 row selected (0.083 seconds)</p>
+
+<p>SELECT time '15:20:30' from dfs.<code>/Users/drilluser/apache-drill-0.8.0/dummy.json</code>;
++------------+
+| EXPR$0 |
++------------+
+| 15:20:30 |
++------------+
+1 row selected (0.067 seconds)</p>
+
+<p>SELECT timestamp '2015-03-11 6:50:08' FROM dfs.<code>/Users/drilluser/apache-drill-0.8.0/dummy.json</code>;
++------------+
+| EXPR$0 |
++------------+
+| 2015-03-11 06:50:08.0 |
++------------+
+1 row selected (0.071 seconds)</p></li>
+</ul>
+
+<h2 id="interval">INTERVAL</h2>
+
+<p>The INTERVAL type represents a period of time. Use ISO 8601 syntax to format a value of this type:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">P [qty] Y [qty] M [qty] D T [qty] H [qty] M [qty] S
+
+P [qty] D T [qty] H [qty] M [qty] S
+
+P [qty] Y [qty] M
+</code></pre></div>
+<p>where:</p>
+
+<ul>
+<li>P (Period) marks the beginning of a period of time.</li>
+<li>Y follows a number of years.</li>
+<li>M follows a number of months.</li>
+<li>D follows a number of days.</li>
+<li>H follows a number of hours 0-24.</li>
+<li>M follows a number of minutes.</li>
+<li>S follows a number of seconds and optional milliseconds to the right of a decimal point</li>
+</ul>
+
+<p>INTERVALYEAR (Year, Month) and INTERVALDAY (Day, Hours, Minutes, Seconds, Milliseconds) are a simpler version of INTERVAL with a subset of the fields. You do not need to specify all fields.</p>
+
+<p>The format of INTERVAL data in the data source differs from the query format. </p>
+
+<p>You can run the dummy query described earlier to check the formatting of the fields. The input to the following SELECT statements show how to format INTERVAL data in the query. The output shows how to format the data in the data source.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT INTERVAL '1 10:20:30.123' day to second FROM dfs.`/Users/drilluser/apache-drill-0.8.0/dummy.json`;
++------------+
+| EXPR$0 |
++------------+
+| P1DT37230.123S |
++------------+
+1 row selected (0.054 seconds)
+
+SELECT INTERVAL '1-2' year to month FROM dfs.`/Users/khahn/drill/apache-drill-0.8.0-SNAPSHOT/dummy.json`;
++------------+
+| EXPR$0 |
++------------+
+| P1Y2M |
++------------+
+1 row selected (0.927 seconds)
+
+SELECT INTERVAL '1' year FROM dfs.`/Users/khahn/drill/apache-drill-0.8.0-SNAPSHOT/dummy.json`;
++------------+
+| EXPR$0 |
++------------+
+| P1Y |
++------------+
+1 row selected (0.088 seconds)
+
+SELECT INTERVAL '13' month FROM dfs.`/Users/khahn/drill/apache-drill-0.8.0-SNAPSHOT/dummy.json`;
++------------+
+| EXPR$0 |
++------------+
+| P1Y1M |
++------------+
+1 row selected (0.076 seconds)
+</code></pre></div>
+<p>To cast INTERVAL data use the following syntax:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">CAST (column_name AS INTERVAL)
+CAST (column_name AS INTERVAL DAY)
+CAST (column_name AS INTERVAL YEAR)
+</code></pre></div>
+<h2 id="interval-example">Interval Example</h2>
+
+<p>A JSON file contains the following objects:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">{ "INTERVALYEAR_col":"P1Y", "INTERVALDAY_col":"P1D", "INTERVAL_col":"P1Y1M1DT1H1M" }
+{ "INTERVALYEAR_col":"P2Y", "INTERVALDAY_col":"P2D", "INTERVAL_col":"P2Y2M2DT2H2M" }
+{ "INTERVALYEAR_col":"P3Y", "INTERVALDAY_col":"P3D", "INTERVAL_col":"P3Y3M3DT3H3M" }
+</code></pre></div>
+<p>The following CTAS statement shows how to cast text from a JSON file to INTERVAL data types in a Parquet table:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">CREATE TABLE dfs.tmp.parquet_intervals AS
+(SELECT cast (INTERVAL_col as interval),
+ cast( INTERVALYEAR_col as interval year) INTERVALYEAR_col,
+ cast( INTERVALDAY_col as interval day) INTERVALDAY_col
+FROM `/user/root/intervals.json`);
+</code></pre></div>
+<p>Output is: </p>
+
+<p>TBD need to test in a future build.</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/deploying-apache-drill-in-a-clustered-environment/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/deploying-apache-drill-in-a-clustered-environment/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/deploying-apache-drill-in-a-clustered-environment/index.html (original)
+++ drill/site/trunk/content/drill/docs/deploying-apache-drill-in-a-clustered-environment/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/apache-drill-in-10-minutes">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/installing-drill-in-embedded-mode">Next</a></p>
+
+<h2 id="overview">Overview</h2>
<p>To run Drill in a clustered environment, complete the following steps:</p>
Added: drill/site/trunk/content/drill/docs/describe-command/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/describe-command/index.html?rev=1667611&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/describe-command/index.html (added)
+++ drill/site/trunk/content/drill/docs/describe-command/index.html Wed Mar 18 20:35:57 2015
@@ -0,0 +1,182 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>DESCRIBE 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>DESCRIBE Command</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>The DESCRIBE command returns information about columns in a table or view.</p>
+
+<h2 id="syntax">Syntax</h2>
+
+<p>The DESCRIBE command supports the following syntax:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">DESCRIBE [workspace.]table_name|view_name
+</code></pre></div>
+<h2 id="usage-notes">Usage Notes</h2>
+
+<p>You can issue the DESCRIBE command against views created in a workspace and
+tables created in Hive, HBase, and MapR-DB. You can issue the DESCRIBE command
+on a table or view from any schema. For example, if you are working in the
+<code>dfs.myworkspace</code> schema, you can issue the DESCRIBE command on a view or
+table in another schema. Currently, DESCRIBE does not support tables created
+in a file system.</p>
+
+<p>Drill only supports SQL data types. Verify that all data types in an external
+data source, such as Hive or HBase, map to supported data types in Drill. See
+Drill Data Type Mapping for more information.</p>
+
+<h2 id="example">Example</h2>
+
+<p>The following example demonstrates the steps that you can follow when you want
+to use the DESCRIBE command to see column information for a view and for Hive
+and HBase tables.</p>
+
+<p>Complete the following steps to use the DESCRIBE command:</p>
+
+<ol>
+<li><p>Issue the USE command to switch to a particular schema.</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.025 seconds)
+</code></pre></div></li>
+<li><p>Issue the SHOW TABLES command to see the existing tables in the schema.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=drilldemo:5181> show tables;
++--------------+------------+
+| TABLE_SCHEMA | TABLE_NAME |
++--------------+------------+
+| hive.default | orders |
+| hive.default | products |
++--------------+------------+
+2 rows selected (0.438 seconds)
+</code></pre></div></li>
+<li><p>Issue the DESCRIBE command on a table.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=drilldemo:5181> describe orders;
++-------------+------------+-------------+
+| COLUMN_NAME | DATA_TYPE | IS_NULLABLE |
++-------------+------------+-------------+
+| order_id | BIGINT | YES |
+| month | VARCHAR | YES |
+| purchdate | TIMESTAMP | YES |
+| cust_id | BIGINT | YES |
+| state | VARCHAR | YES |
+| prod_id | BIGINT | YES |
+| order_total | INTEGER | YES |
++-------------+------------+-------------+
+7 rows selected (0.64 seconds)
+</code></pre></div></li>
+<li><p>Issue the DESCRIBE command on a table in another schema from the current schema.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=drilldemo:5181> describe hbase.customers;
++-------------+------------+-------------+
+| COLUMN_NAME | DATA_TYPE | IS_NULLABLE |
++-------------+------------+-------------+
+| row_key | ANY | NO |
+| address | (VARCHAR(1), ANY) MAP | NO |
+| loyalty | (VARCHAR(1), ANY) MAP | NO |
+| personal | (VARCHAR(1), ANY) MAP | NO |
++-------------+------------+-------------+
+4 rows selected (0.671 seconds)
+</code></pre></div></li>
+<li><p>Issue the DESCRIBE command on a view in another schema from the current schema.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=drilldemo:5181> describe dfs.views.customers_vw;
++-------------+------------+-------------+
+| COLUMN_NAME | DATA_TYPE | IS_NULLABLE |
++-------------+------------+-------------+
+| cust_id | BIGINT | NO |
+| name | VARCHAR | NO |
+| address | VARCHAR | NO |
+| gender | VARCHAR | NO |
+| age | VARCHAR | NO |
+| agg_rev | VARCHAR | NO |
+| membership | VARCHAR | NO |
++-------------+------------+-------------+
+7 rows selected (0.403 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>
Modified: drill/site/trunk/content/drill/docs/drill-default-input-format/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/drill-default-input-format/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/drill-default-input-format/index.html (original)
+++ drill/site/trunk/content/drill/docs/drill-default-input-format/index.html Wed Mar 18 20:35:57 2015
@@ -67,7 +67,9 @@
</div>
-<div class="int_text" align="left"><p>You can define a default input format to tell Drill what file type exists in a
+<div class="int_text" align="left"><p><a href="/docs/hive-storage-plugin">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/mongodb-plugin-for-apache-drill">Next</a></p>
+
+<p>You can define a default input format to tell Drill what file type exists in a
workspace within a file system. Drill determines the file type based on file
extensions and magic numbers when searching a workspace.</p>
Modified: drill/site/trunk/content/drill/docs/driver-configuration-options/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/driver-configuration-options/index.html?rev=1667611&r1=1667610&r2=1667611&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/driver-configuration-options/index.html (original)
+++ drill/site/trunk/content/drill/docs/driver-configuration-options/index.html Wed Mar 18 20:35:57 2015
@@ -67,7 +67,9 @@
</div>
-<div class="int_text" align="left"><p>You can use various configuration options to control the behavior of the MapR
+<div class="int_text" align="left"><p><a href="/docs/configuring-odbc-connections-for-linux-and-mac-os-x">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>You can use various configuration options to control the behavior of the MapR
Drill ODBC Driver. You can use these options in a connection string or in the
<code>odbc.ini</code> configuration file for the Mac OS X version or the driver.</p>