drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject svn commit: r1670235 [2/4] - in /drill/site/trunk/content/drill: ./ blog/2014/12/11/apache-drill-qa-panelist-spotlight/ docs/ docs/advanced-properties/ docs/analyzing-yelp-json-data-with-apache-drill/ docs/apache-drill-in-10-minutes/ docs/apache-drill-...
Date Tue, 31 Mar 2015 01:20:44 GMT
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=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/data-types/index.html (original)
+++ drill/site/trunk/content/drill/docs/data-types/index.html Tue Mar 31 01:20:42 2015
@@ -75,11 +75,11 @@
 
 <ul>
 <li>HBase<br>
-No implicit casting to SQL types. Convert data to appropriate types as shown in <a href="/docs/querying-hbase/">&quot;Querying HBase.&quot;</a></li>
+Does not implicitly cast input to SQL types. Convert data to appropriate types as shown in <a href="/docs/querying-hbase/">&quot;Querying HBase.&quot;</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>
+Implicitly casts JSON data to its <a href="/docs/json-data-model#data-type-mapping">corresponding SQL types</a> or to VARCHAR if Drill is 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>
@@ -90,11 +90,13 @@ Implicitly casts all textual data to VAR
 
 <h2 id="implicit-casting">Implicit Casting</h2>
 
-<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>
+<p>Generally, Drill performs implicit casting based on the order of precedence shown in the implicit casting preference table. 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. Drill might deviate from these precedence rules for performance reasons.</p>
 
-<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>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>
+<p>The following table lists data types top to bottom, in descending order of precedence. Drill implicitly casts to more data types than are currently supported for explicit casting.</p>
+
+<h3 id="implicit-casting-precedence">Implicit Casting Precedence</h3>
 
 <table>
   <tr>
@@ -107,104 +109,144 @@ Implicitly casts all textual data to VAR
     <td>1</td>
     <td>INTERVAL</td>
     <td>13</td>
-    <td>BIGINT</td>
+    <td>UINT4</td>
   </tr>
   <tr>
     <td>2</td>
     <td>INTERVALYEAR</td>
     <td>14</td>
-    <td>UINT4</td>
+    <td>INT</td>
   </tr>
   <tr>
     <td>3</td>
     <td>INTERVLADAY</td>
     <td>15</td>
-    <td>INT</td>
+    <td>UINT2</td>
   </tr>
   <tr>
     <td>4</td>
     <td>TIMESTAMPTZ</td>
     <td>16</td>
-    <td>UINT2</td>
+    <td>SMALLINT</td>
   </tr>
   <tr>
     <td>5</td>
     <td>TIMETZ</td>
     <td>17</td>
-    <td>SMALLINT</td>
+    <td>UINT1</td>
   </tr>
   <tr>
     <td>6</td>
     <td>TIMESTAMP</td>
     <td>18</td>
-    <td>UINT1</td>
+    <td>VAR16CHAR</td>
   </tr>
   <tr>
     <td>7</td>
     <td>DATE</td>
     <td>19</td>
-    <td>VAR16CHAR</td>
+    <td>FIXED16CHAR</td>
   </tr>
   <tr>
     <td>8</td>
     <td>TIME</td>
     <td>20</td>
-    <td>FIXED16CHAR</td>
+    <td>VARCHAR</td>
   </tr>
   <tr>
     <td>9</td>
-    <td>FLOAT8</td>
+    <td>DOUBLE</td>
     <td>21</td>
-    <td>VARCHAR</td>
+    <td>CHAR</td>
   </tr>
   <tr>
     <td>10</td>
     <td>DECIMAL</td>
     <td>22</td>
-    <td>FIXEDCHAR</td>
+    <td>VARBINARY*</td>
   </tr>
   <tr>
     <td>11</td>
-    <td>MONEY</td>
+    <td>UINT8</td>
     <td>23</td>
-    <td>VARBINARY</td>
+    <td>FIXEDBINARY*</td>
   </tr>
   <tr>
     <td>12</td>
-    <td>UINT8</td>
+    <td>BIGINT</td>
     <td>24</td>
-    <td>FIXEDBINARY</td>
-  </tr>
-  <tr>
-    <td></td>
-    <td></td>
-    <td>25</td>
     <td>NULL</td>
   </tr>
 </table>
 
+<p>* The Drill Parquet reader supports these types.</p>
+
 <h2 id="explicit-casting">Explicit Casting</h2>
 
-<p>Drill supports a number of functions to cast and convert compatible data types:</p>
+<p>In a textual file, such as CSV, Drill interprets every field as a VARCHAR, as previously mentioned. To handle textual data, you can use the following functions to cast and convert compatible data types:</p>
 
 <ul>
-<li>CAST<br>
+<li><a href="/docs/data-type-fmt#cast">CAST</a><br>
 Casts data from one data type to another.</li>
-<li>CONVERT_TO and CONVERT_FROM<br>
+<li><a href="/docs/data-type-fmt#convert-to-and-convert-from">CONVERT_TO and CONVERT_FROM</a><br>
 Converts data, including binary data, from one data type to another.</li>
-<li>TO_CHAR
+<li><a href="">TO_CHAR</a><br>
 Converts a TIMESTAMP, INTERVAL, INTEGER, DOUBLE, or DECIMAL to a string.</li>
-<li>TO_DATE
+<li><a href="">TO_DATE</a><br>
 Converts a string to DATE.</li>
-<li>TO_NUMBER
+<li><a href="">TO_NUMBER</a><br>
 Converts a string to a DECIMAL.</li>
-<li>TO_TIMESTAMP
+<li><a href="">TO_TIMESTAMP</a><br>
 Converts a string to TIMESTAMP.</li>
 </ul>
 
+<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.</p>
+
+<h2 id="supported-data-types-for-casting">Supported Data Types for Casting</h2>
+
+<p>You use the following data types in queries that involve casting/converting data types:</p>
+
+<ul>
+<li><p>BIGINT<br>
+8-byte signed integer. the range is -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.</p></li>
+<li><p>BOOLEAN<br>
+True or false  </p></li>
+<li><p>DATE<br>
+Years, months, and days in YYYY-MM-DD format</p></li>
+<li><p>DECIMAL(p,s), or DEC(p,s), NUMERIC(p,s) 
+38-digit precision number, precision is p, and scale is s. Example: DECIMAL(6,2) has 4 digits before the decimal point and 2 digits after the decimal point. </p></li>
+<li><p>FLOAT<br>
+4-byte single precision floating point number</p></li>
+<li><p>DOUBLE, DOUBLE PRECISION<br>
+8-byte double precision floating point number. </p></li>
+<li><p>INTEGER or INT<br>
+4-byte signed integer. The range is -2,147,483,648 to 2,147,483,647.</p></li>
+<li><p>INTERVAL<br>
+Integer fields representing a period of time in years, months, days hours, minutes, seconds and optional milliseconds using ISO 8601 format.</p></li>
+<li><p>INTERVALDAY<br>
+A simple version of the interval type expressing a period of time in days, hours, minutes, and seconds only.</p></li>
+<li><p>INTERVALYEAR<br>
+A simple version of interval representing a period of time in years and months only.</p></li>
+<li><p>SMALLINT<br>
+2-byte signed integer. The range is -32,768 to 32,767. Supported in Drill 0.9 and later. See DRILL-2135.</p></li>
+<li><p>TIME<br>
+Hours, minutes, seconds in the form HH:mm:ss, 24-hour based</p></li>
+<li><p>TIMESTAMP<br>
+JDBC timestamp in year, month, date hour, minute, second, and optional milliseconds: yyyy-MM-dd HH:mm:ss.SSS</p></li>
+<li><p>CHARACTER VARYING, CHARACTER, CHAR, or VARCHAR<br>
+Character string optionally declared with a length that indicates the maximum number of characters to use. For example, CHAR(30) casts data to a 30-character string maximum. The default limit is 1 character. The maximum character limit is 255.</p></li>
+</ul>
+
+<p>You specify a DECIMAL using a precision and scale. The precision (p) is the total number of digits required to represent the number.
+. The scale (s) is the number of decimal digits to the right of the decimal point. Subtract s from p to determine the maximum number of digits to the left of the decimal point. Scale is a value from 0 through p. Scale is specified only if precision is specified. The default scale is 0.</p>
+
+<p>For more information about and examples of casting, see <a href="">CAST</a>.</p>
+
+<h3 id="explicit-type-casting-maps">Explicit Type Casting Maps</h3>
+
 <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>
+<h4 id="numerical-and-character-data-types">Numerical and Character Data Types</h4>
 
 <table>
   <tr>
@@ -218,17 +260,15 @@ Converts a string to TIMESTAMP.</li>
     <th></th>
     <th></th>
     <th></th>
-    <th></th>
   </tr>
   <tr>
     <td>From:</td>
     <td>SMALLINT</td>
     <td>INT</td>
-    <td>BIGINT/UINT</td>
+    <td>BIGINT</td>
     <td>DECIMAL</td>
-    <td>FLOAT4</td>
-    <td>FLOAT8</td>
-    <td>FIXEDCHAR</td>
+    <td>FLOAT</td>
+    <td>CHAR</td>
     <td>FIXEDBINARY</td>
     <td>VARCHAR</td>
     <td>VARBINARY</td>
@@ -244,7 +284,6 @@ Converts a string to TIMESTAMP.</li>
     <td>yes</td>
     <td>yes</td>
     <td>yes</td>
-    <td>yes</td>
   </tr>
   <tr>
     <td>INT</td>
@@ -257,11 +296,9 @@ Converts a string to TIMESTAMP.</li>
     <td>yes</td>
     <td>yes</td>
     <td>yes</td>
-    <td>yes</td>
   </tr>
   <tr>
-    <td>BIGINT/UINT</td>
-    <td>yes</td>
+    <td>BIGINT</td>
     <td>yes</td>
     <td>yes</td>
     <td>yes</td>
@@ -283,37 +320,33 @@ Converts a string to TIMESTAMP.</li>
     <td>yes</td>
     <td>yes</td>
     <td>yes</td>
-    <td>yes</td>
   </tr>
   <tr>
-    <td>FLOAT8</td>
+    <td>DOUBLE</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>FLOAT</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>CHAR</td>
     <td>yes</td>
     <td>yes</td>
     <td>yes</td>
@@ -325,8 +358,7 @@ Converts a string to TIMESTAMP.</li>
     <td>yes</td>
   </tr>
   <tr>
-    <td>FIXEDBINARY</td>
-    <td>yes</td>
+    <td>FIXEDBINARY*</td>
     <td>yes</td>
     <td>yes</td>
     <td>yes</td>
@@ -338,8 +370,7 @@ Converts a string to TIMESTAMP.</li>
     <td>yes</td>
   </tr>
   <tr>
-    <td>VARCHAR</td>
-    <td>yes</td>
+    <td>VARCHAR**</td>
     <td>yes</td>
     <td>yes</td>
     <td>yes</td>
@@ -351,8 +382,7 @@ Converts a string to TIMESTAMP.</li>
     <td>yes</td>
   </tr>
   <tr>
-    <td>VARBINARY</td>
-    <td>yes</td>
+    <td>VARBINARY*</td>
     <td>yes</td>
     <td>yes</td>
     <td>yes</td>
@@ -365,7 +395,11 @@ Converts a string to TIMESTAMP.</li>
   </tr>
 </table>
 
-<h3 id="explicit-type-casting:-date/time-types">Explicit Type Casting: Date/Time types</h3>
+<p>* For use with CONVERT_TO/FROM to cast binary data coming to/from sources such as MapR-DB/HBase.</p>
+
+<p>** You cannot convert a character string having a decimal point to an INT or BIGINT.</p>
+
+<h4 id="date-and-time-data-types">Date and Time Data Types</h4>
 
 <table>
   <tr>
@@ -389,7 +423,7 @@ Converts a string to TIMESTAMP.</li>
     <td>INTERVALDAY</td>
   </tr>
   <tr>
-    <td>FIXEDCHAR</td>
+    <td>CHAR</td>
     <td>Yes</td>
     <td>Yes</td>
     <td>Yes</td>
@@ -499,48 +533,6 @@ Converts a string to TIMESTAMP.</li>
     <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 &lt;expression&gt; AS &lt;data type&gt; 
-</code></pre></div>
-<ul>
-<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>
-
-<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)) &gt; -3.0
-</code></pre></div>
-<p>Do not use CAST to handle binary data conversions. Use CONVERT_TO and CONVERT_FROM for these conversions.</p>
-
-<h3 id="using-convert_to-and-convert_from">Using CONVERT_TO and CONVERT_FROM</h3>
-
-<p>CONVERT_TO converts an SQL data type to complex types, including Hbase byte arrays, JSON and Parquet arrays and mapsTo 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">&quot;Convert and Cast Functions&quot;.</a></p>
-
-<p>CONVERT_FROM converts from complex types, including Hbase byte arrays, JSON and Parquet arrays and maps to an SQL data type.</p>
-
-<h2 id="handling-textual-data">Handling Textual Data</h2>
-
-<p>In a textual file, such as CSV, Drill interprets every field as a VARCHAR, as previously mentioned. In addition to using the CAST function, you can also use <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>
 
 

Modified: 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=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/date-time-and-timestamp/index.html (original)
+++ drill/site/trunk/content/drill/docs/date-time-and-timestamp/index.html Tue Mar 31 01:20:42 2015
@@ -71,9 +71,9 @@
 
 <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. 
-    {&quot;dummy&quot; : &quot;data&quot;}. </p>
-
+<p>Before running a query, you can check the formatting of your dates and times as shown in the following examples. The examples refer to a dummy JSON file in the FROM clause. The dummy JSON file has following contents.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">{&quot;dummy&quot; : &quot;data&quot;}
+</code></pre></div>
 <p>Next, use the following literals in a SELECT statement. </p>
 
 <ul>
@@ -164,26 +164,7 @@ SELECT INTERVAL &#39;13&#39; month FROM
 +------------+
 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">{ &quot;INTERVALYEAR_col&quot;:&quot;P1Y&quot;, &quot;INTERVALDAY_col&quot;:&quot;P1D&quot;, &quot;INTERVAL_col&quot;:&quot;P1Y1M1DT1H1M&quot; }
-{ &quot;INTERVALYEAR_col&quot;:&quot;P2Y&quot;, &quot;INTERVALDAY_col&quot;:&quot;P2D&quot;, &quot;INTERVAL_col&quot;:&quot;P2Y2M2DT2H2M&quot; }
-{ &quot;INTERVALYEAR_col&quot;:&quot;P3Y&quot;, &quot;INTERVALDAY_col&quot;:&quot;P3D&quot;, &quot;INTERVAL_col&quot;:&quot;P3Y3M3DT3H3M&quot; }
-</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>
-<!-- Text and include output -->
+<p>For information about casting interval data, see the <a href="/docs/data-type-fmt#cast">&quot;CAST&quot;</a> function.</p>
 </div>
 
 

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=1670235&r1=1670234&r2=1670235&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 Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
 
 </div>
 
-<div class="int_text" align="left"><p><a href="/docs/apache-drill-in-10-minutes">Previous</a><code>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code><a href="/docs">Back to Table of Contents</a><code>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code><a href="/docs/installing-drill-in-embedded-mode">Next</a></p>
-
-<h2 id="overview">Overview</h2>
+<div class="int_text" align="left"><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/developer-information/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/developer-information/index.html?rev=1670235&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/developer-information/index.html (added)
+++ drill/site/trunk/content/drill/docs/developer-information/index.html Tue Mar 31 01:20:42 2015
@@ -0,0 +1,98 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Developer Information - 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&nbsp;&nbsp;&nbsp;&nbsp;</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? &nbsp;&nbsp;&nbsp;&nbsp;</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>&nbsp;</span></li>
+  <li class="d"><a href="/download/">Download</a></li>
+</ul>
+</div>
+
+<div class="int_title">
+<h1>Developer Information</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>The following quick links take you to key developer information:</p>
+
+<ul>
+<li>TBD</li>
+<li>TBD</li>
+<li>TBD</li>
+</ul>
+</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=1670235&r1=1670234&r2=1670235&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 Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
 
 </div>
 
-<div class="int_text" align="left"><p><a href="/docs/hive-storage-plugin">Previous</a><code>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code><a href="/docs">Back to Table of Contents</a><code>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</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
+<div class="int_text" align="left"><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=1670235&r1=1670234&r2=1670235&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 Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
 
 </div>
 
-<div class="int_text" align="left"><p><a href="/docs/configuring-odbc-connections-for-linux-and-mac-os-x">Previous</a><code>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code><a href="/docs">Back to Table of Contents</a><code>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</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
+<div class="int_text" align="left"><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>
 

Modified: drill/site/trunk/content/drill/docs/file-system-storage-plugin/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/file-system-storage-plugin/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/file-system-storage-plugin/index.html (original)
+++ drill/site/trunk/content/drill/docs/file-system-storage-plugin/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
 
 </div>
 
-<div class="int_text" align="left"><p><a href="/docs/workspaces">Previous</a><code>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code><a href="/docs">Back to Table of Contents</a><code>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code><a href="/docs/hbase-storage-plugin">Next</a></p>
-
-<p>You can register a storage plugin instance that connects Drill to a local file
+<div class="int_text" align="left"><p>You can register a storage plugin instance that connects Drill to a local file
 system or a distributed file system registered in <code>core-site.xml</code>, such as S3
 or HDFS. When you register a storage plugin instance for a file system,
 provide a unique name for the instance, and identify the type as “<code>file</code>”. By

Added: drill/site/trunk/content/drill/docs/flatten/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/flatten/index.html?rev=1670235&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/flatten/index.html (added)
+++ drill/site/trunk/content/drill/docs/flatten/index.html Tue Mar 31 01:20:42 2015
@@ -0,0 +1,182 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>FLATTEN - 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&nbsp;&nbsp;&nbsp;&nbsp;</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? &nbsp;&nbsp;&nbsp;&nbsp;</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>&nbsp;</span></li>
+  <li class="d"><a href="/download/">Download</a></li>
+</ul>
+</div>
+
+<div class="int_title">
+<h1>FLATTEN</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>FLATTEN separates the elements in a repeated field into individual records.</p>
+
+<h2 id="syntax">Syntax</h2>
+<div class="highlight"><pre><code class="language-text" data-lang="text">FLATTEN(z)
+</code></pre></div>
+<p><em>z</em> is a JSON array.</p>
+
+<h2 id="usage-notes">Usage Notes</h2>
+
+<p>The FLATTEN function is useful for flexible exploration of repeated data.</p>
+
+<p>To maintain the association between each flattened value and the other fields in
+the record, the FLATTEN function copies all of the other columns into each new record. </p>
+
+<p>A very simple example would turn this data (one record):</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">{
+  &quot;x&quot; : 5,
+  &quot;y&quot; : &quot;a string&quot;,
+  &quot;z&quot; : [ 1,2,3]
+}
+</code></pre></div>
+<p>into three distinct records:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT FLATTEN(z) FROM table;
+| x           | y              | z         |
++-------------+----------------+-----------+
+| 5           | &quot;a string&quot;     | 1         |
+| 5           | &quot;a string&quot;     | 2         |
+| 5           | &quot;a string&quot;     | 3         |
+</code></pre></div>
+<p>The function takes a single argument, which must be an array (the <code>z</code> column
+in this example).</p>
+
+<p>Using the all (*) wildcard as the argument to flatten is not supported and returns an error.</p>
+
+<h2 id="examples">Examples</h2>
+
+<p>For a more interesting example, consider the JSON data in the publicly
+available <a href="https://www.yelp.com/dataset_challenge/dataset">Yelp</a> data set. The
+first query below returns three columns from the
+<code>yelp_academic_dataset_business.json</code> file: <code>name</code>, <code>hours</code>, and <code>categories</code>.
+The query is restricted to distinct rows where the name is <code>z</code><code>pizza</code>. The
+query returns only one row that meets those criteria; however, note that this
+row contains an array of four categories:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local&gt; select distinct name, hours, categories 
+from dfs.yelp.`yelp_academic_dataset_business.json` 
+where name =&#39;zpizza&#39;;
++------------+------------+------------+
+|    name    |   hours    | categories |
++------------+------------+------------+
+| zpizza     | {&quot;Tuesday&quot;:{&quot;close&quot;:&quot;22:00&quot;,&quot;open&quot;:&quot;10:00&quot;},&quot;Friday&quot;:{&quot;close&quot;:&quot;23:00&quot;,&quot;open&quot;:&quot;10:00&quot;},&quot;Monday&quot;:{&quot;close&quot;:&quot;22:00&quot;,&quot;open&quot;:&quot;10:00&quot;},&quot;Wednesday&quot;:{&quot;close&quot;:&quot;22:00&quot;,&quot;open&quot;:&quot;10:00&quot;},&quot;Thursday&quot;:{&quot;close&quot;:&quot;22:00&quot;,&quot;open&quot;:&quot;10:00&quot;},&quot;Sunday&quot;:{&quot;close&quot;:&quot;22:00&quot;,&quot;open&quot;:&quot;10:00&quot;},&quot;Saturday&quot;:{&quot;close&quot;:&quot;23:00&quot;,&quot;open&quot;:&quot;10:00&quot;}} | [&quot;Gluten-Free&quot;,&quot;Pizza&quot;,&quot;Vegan&quot;,&quot;Restaurants&quot;] |
+</code></pre></div>
+<p>The FLATTEN function can operate on this single row and return multiple rows,
+one for each category:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local&gt; select distinct name, flatten(categories) as categories 
+from dfs.yelp.`yelp_academic_dataset_business.json` 
+where name =&#39;zpizza&#39; order by 2;
++------------+-------------+
+|    name    | categories  |
++------------+-------------+
+| zpizza     | Gluten-Free |
+| zpizza     | Pizza       |
+| zpizza     | Restaurants |
+| zpizza     | Vegan       |
++------------+-------------+
+4 rows selected (2.797 seconds)
+</code></pre></div>
+<p>Having used the FLATTEN function to break down arrays into distinct rows, you
+can run queries that do deeper analysis on the flattened result set. For
+example, you can use FLATTEN in a subquery, then apply WHERE clause
+constraints or aggregate functions to the results in the outer query.</p>
+
+<p>The following query uses the same data file as the previous query to flatten
+the categories array, then run a COUNT function on the flattened result:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">select celltbl.catl, count(celltbl.catl) catcount 
+from (select flatten(categories) catl 
+from dfs.yelp.`yelp_academic_dataset_business.json`) celltbl 
+group by celltbl.catl 
+order by count(celltbl.catl) desc limit 5;
+
++---------------+------------+
+|    catl       |  catcount  |
++---------------+------------+
+| Restaurants   | 14303      |
+| Shopping      | 6428       |
+| Food          | 5209       |
+| Beauty &amp; Spas | 3421       |
+| Nightlife     | 2870       |
++---------------|------------+
+</code></pre></div>
+<p>A common use case for FLATTEN is its use in conjunction with the
+<a href="/docs/flatten-function">KVGEN</a> function as shown in the section, <a href="/docs/json-data-model/">&quot;JSON Data Model&quot;</a>.</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/flexibility/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/flexibility/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/flexibility/index.html (original)
+++ drill/site/trunk/content/drill/docs/flexibility/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
 
 </div>
 
-<div class="int_text" align="left"><p><a href="/docs/architectural-highlights">Previous</a><code>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code><a href="/docs">Back to Table of Contents</a><code>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code><a href="/docs/performance">Next</a></p>
-
-<p>The following features contribute to Drill&#39;s flexible architecture:</p>
+<div class="int_text" align="left"><p>The following features contribute to Drill&#39;s flexible architecture:</p>
 
 <p><strong><em>Dynamic schema discovery</em></strong></p>
 

Modified: drill/site/trunk/content/drill/docs/getting-started-tutorial/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/getting-started-tutorial/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/getting-started-tutorial/index.html (original)
+++ drill/site/trunk/content/drill/docs/getting-started-tutorial/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
 
 </div>
 
-<div class="int_text" align="left"><p><a href="/docs/query-data">Previous</a><code>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code><a href="/docs">Back to Table of Contents</a><code>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code><a href="/docs/lesson-1-connect-to-data-sources">Next</a></p>
-
-<h2 id="goal">Goal</h2>
+<div class="int_text" align="left"><h2 id="goal">Goal</h2>
 
 <p>This tutorial covers how to query a file and a directory on your local file
 system. Files and directories are like standard SQL tables to Drill. If you

Modified: drill/site/trunk/content/drill/docs/getting-to-know-the-drill-sandbox/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/getting-to-know-the-drill-sandbox/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/getting-to-know-the-drill-sandbox/index.html (original)
+++ drill/site/trunk/content/drill/docs/getting-to-know-the-drill-sandbox/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
 
 </div>
 
-<div class="int_text" align="left"><p><a href="/docs/installing-the-mapr-sandbox-with-apache-drill-on-virtualbox">Previous</a><code>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code><a href="/docs">Back to Table of Contents</a><code>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code><a href="/docs/lession-1-learn-about-the-data-set">Next</a></p>
-
-<p>This section covers key information about the Apache Drill tutorial. After <a href="/docs/installing-the-apache-drill-sandbox">installing the Drill sandbox</a> and starting the sandbox, you can open another terminal window (Linux) or Command Prompt (Windows) and use the secure shell (ssh) to connect to the VM, assuming ssh is installed. Use the following login name and password: mapr/mapr. For
+<div class="int_text" align="left"><p>This section covers key information about the Apache Drill tutorial. After <a href="/docs/installing-the-apache-drill-sandbox">installing the Drill sandbox</a> and starting the sandbox, you can open another terminal window (Linux) or Command Prompt (Windows) and use the secure shell (ssh) to connect to the VM, assuming ssh is installed. Use the following login name and password: mapr/mapr. For
 example:</p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">$ ssh mapr@localhost -p 2222
 Password:

Modified: drill/site/trunk/content/drill/docs/hbase-storage-plugin/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/hbase-storage-plugin/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/hbase-storage-plugin/index.html (original)
+++ drill/site/trunk/content/drill/docs/hbase-storage-plugin/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
 
 </div>
 
-<div class="int_text" align="left"><p><a href="/docs/file-system-storage-plugin">Previous</a><code>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code><a href="/docs">Back to Table of Contents</a><code>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code><a href="/docs/hive-storage-plugin">Next</a></p>
-
-<p>Register a storage plugin instance and specify a zookeeper quorum to connect
+<div class="int_text" align="left"><p>Register a storage plugin instance and specify a zookeeper quorum to connect
 Drill to an HBase data source. When you register a storage plugin instance for
 an HBase data source, provide a unique name for the instance, and identify the
 type as “hbase” in the Drill Web UI.</p>

Modified: drill/site/trunk/content/drill/docs/hive-storage-plugin/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/hive-storage-plugin/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/hive-storage-plugin/index.html (original)
+++ drill/site/trunk/content/drill/docs/hive-storage-plugin/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
 
 </div>
 
-<div class="int_text" align="left"><p><a href="/docs/hbase-storage-plugin">Previous</a><code>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code><a href="/docs">Back to Table of Contents</a><code>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</code><a href="/docs/drill-default-input-format">Next</a></p>
-
-<p>You can register a storage plugin instance that connects Drill to a Hive data
+<div class="int_text" align="left"><p>You can register a storage plugin instance that connects Drill to a Hive data
 source that has a remote or embedded metastore service. When you register a
 storage plugin instance for a Hive data source, provide a unique name for the
 instance, and identify the type as “<code>hive</code>”. You must also provide the

Modified: drill/site/trunk/content/drill/docs/hive-to-drill-data-type-mapping/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/hive-to-drill-data-type-mapping/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/hive-to-drill-data-type-mapping/index.html (original)
+++ drill/site/trunk/content/drill/docs/hive-to-drill-data-type-mapping/index.html Tue Mar 31 01:20:42 2015
@@ -67,7 +67,10 @@
 
 </div>
 
-<div class="int_text" align="left"><p>Using Drill you can read tables created in Hive that use data types compatible with Drill. Drill currently does not support writing Hive tables. The following table shows Drill support for Hive primitive types:
+<div class="int_text" align="left"><p>Using Drill you can read tables created in Hive that use data types compatible with Drill. Drill currently does not support writing Hive tables. Drill supports the following Hive types for querying:</p>
+
+<!-- See DRILL-1570 -->
+
 <table>
   <tr>
     <th>Supported SQL Type</th>
@@ -75,67 +78,67 @@
     <th>Description</th>
   </tr>
   <tr>
-    <td>bigint</td>
+    <td>BIGINT</td>
     <td>BIGINT</td>
     <td>8-byte signed integer</td>
   </tr>
   <tr>
-    <td>boolean</td>
+    <td>BOOLEAN</td>
     <td>BOOLEAN</td>
     <td>TRUE (1) or FALSE (0)</td>
   </tr>
   <tr>
-    <td>N/A</td>
     <td>CHAR</td>
-    <td>Same as Varchar but having a fixed-length max 255</td>
+    <td>CHAR</td>
+    <td>Character string, fixed-length max 255</td>
   </tr>
   <tr>
-    <td>date</td>
+    <td>DATE</td>
     <td>DATE</td>
     <td>Years months and days in the form in the form YYYY-­MM-­DD</td>
   </tr>
   <tr>
-    <td>decimal</td>
+    <td>DECIMAL</td>
     <td>DECIMAL</td>
     <td>38-digit precision</td>
   </tr>
   <tr>
-    <td>float</td>
+    <td>FLOAT</td>
     <td>FLOAT</td>
     <td>4-byte single precision floating point number</td>
   </tr>
   <tr>
-    <td>double</td>
+    <td>DOUBLE</td>
     <td>DOUBLE</td>
     <td>8-byte double precision floating point number</td>
   </tr>
   <tr>
-    <td>integer</td>
+    <td>INT or INTEGER</td>
     <td>INT</td>
     <td>4-byte signed integer</td>
   </tr>
   <tr>
-    <td>interval</td>
+    <td>INTERVAL</td>
     <td>N/A</td>
     <td>Integer fields representing a period of time depending on the type of interval</td>
   </tr>
   <tr>
-    <td>intervalday</td>
+    <td>INTERVALDAY</td>
     <td>N/A</td>
     <td>Integer fields representing a day</td>
   </tr>
   <tr>
-    <td>intervalyear</td>
+    <td>INTERVALYEAR</td>
     <td>N/A</td>
     <td>Integer fields representing a year</td>
   </tr>
   <tr>
-    <td>smallint</td>
+    <td>SMALLINT</td>
     <td>SMALLINT</td>
     <td>2-byte signed integer</td>
   </tr>
   <tr>
-    <td>time</td>
+    <td>TIME</td>
     <td>N/A</td>
     <td>Hours minutes seconds 24-hour basis</td>
   </tr>
@@ -145,7 +148,7 @@
     <td>Conventional UNIX Epoch timestamp.</td>
   </tr>
   <tr>
-    <td>timestamp</td>
+    <td>TIMESTAMP</td>
     <td>TIMESTAMP</td>
     <td>JDBC timestamp in yyyy-mm-dd hh:mm:ss format</td>
   </tr>
@@ -153,14 +156,14 @@
     <td>None</td>
     <td>STRING</td>
     <td>Binary string (16)</td>
-  </tr></p>
-
-<p><tr>
-    <td>varchar</td>
+  </tr>
+  
+  <tr>
+    <td>VARCHAR</td>
     <td>VARCHAR</td>
     <td>Character string variable length</td>
   </tr>
-</table></p>
+</table>
 
 <h2 id="unsupported-types">Unsupported Types</h2>
 

Added: drill/site/trunk/content/drill/docs/img/image_1.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/image_1.png?rev=1670235&view=auto
==============================================================================
Binary file - no diff available.

Propchange: drill/site/trunk/content/drill/docs/img/image_1.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: drill/site/trunk/content/drill/docs/img/image_10.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/image_10.png?rev=1670235&view=auto
==============================================================================
Binary file - no diff available.

Propchange: drill/site/trunk/content/drill/docs/img/image_10.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: drill/site/trunk/content/drill/docs/img/image_11.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/image_11.png?rev=1670235&view=auto
==============================================================================
Binary file - no diff available.

Propchange: drill/site/trunk/content/drill/docs/img/image_11.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: drill/site/trunk/content/drill/docs/img/image_12.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/image_12.png?rev=1670235&view=auto
==============================================================================
Binary file - no diff available.

Propchange: drill/site/trunk/content/drill/docs/img/image_12.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: drill/site/trunk/content/drill/docs/img/image_13.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/image_13.png?rev=1670235&view=auto
==============================================================================
Binary file - no diff available.

Propchange: drill/site/trunk/content/drill/docs/img/image_13.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: drill/site/trunk/content/drill/docs/img/image_14.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/image_14.png?rev=1670235&view=auto
==============================================================================
Binary file - no diff available.

Propchange: drill/site/trunk/content/drill/docs/img/image_14.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: drill/site/trunk/content/drill/docs/img/image_15.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/image_15.png?rev=1670235&view=auto
==============================================================================
Binary file - no diff available.

Propchange: drill/site/trunk/content/drill/docs/img/image_15.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: drill/site/trunk/content/drill/docs/img/image_16.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/image_16.png?rev=1670235&view=auto
==============================================================================
Binary file - no diff available.

Propchange: drill/site/trunk/content/drill/docs/img/image_16.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: drill/site/trunk/content/drill/docs/img/image_17.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/image_17.png?rev=1670235&view=auto
==============================================================================
Binary file - no diff available.

Propchange: drill/site/trunk/content/drill/docs/img/image_17.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: drill/site/trunk/content/drill/docs/img/image_2.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/image_2.png?rev=1670235&view=auto
==============================================================================
Binary file - no diff available.

Propchange: drill/site/trunk/content/drill/docs/img/image_2.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: drill/site/trunk/content/drill/docs/img/image_3.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/image_3.png?rev=1670235&view=auto
==============================================================================
Binary file - no diff available.

Propchange: drill/site/trunk/content/drill/docs/img/image_3.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: drill/site/trunk/content/drill/docs/img/image_4.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/image_4.png?rev=1670235&view=auto
==============================================================================
Binary file - no diff available.

Propchange: drill/site/trunk/content/drill/docs/img/image_4.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: drill/site/trunk/content/drill/docs/img/image_5.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/image_5.png?rev=1670235&view=auto
==============================================================================
Binary file - no diff available.

Propchange: drill/site/trunk/content/drill/docs/img/image_5.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: drill/site/trunk/content/drill/docs/img/image_6.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/image_6.png?rev=1670235&view=auto
==============================================================================
Binary file - no diff available.

Propchange: drill/site/trunk/content/drill/docs/img/image_6.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: drill/site/trunk/content/drill/docs/img/image_7.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/image_7.png?rev=1670235&view=auto
==============================================================================
Binary file - no diff available.

Propchange: drill/site/trunk/content/drill/docs/img/image_7.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: drill/site/trunk/content/drill/docs/img/image_8.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/image_8.png?rev=1670235&view=auto
==============================================================================
Binary file - no diff available.

Propchange: drill/site/trunk/content/drill/docs/img/image_8.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: drill/site/trunk/content/drill/docs/img/image_9.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/img/image_9.png?rev=1670235&view=auto
==============================================================================
Binary file - no diff available.

Propchange: drill/site/trunk/content/drill/docs/img/image_9.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream



Mime
View raw message