drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject [4/5] drill-site git commit: Updates
Date Sat, 15 Aug 2015 01:50:12 GMT
http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/data-type-conversion/index.html
----------------------------------------------------------------------
diff --git a/docs/data-type-conversion/index.html b/docs/data-type-conversion/index.html
index cf18601..d0e2574 100644
--- a/docs/data-type-conversion/index.html
+++ b/docs/data-type-conversion/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           
@@ -1056,7 +1054,7 @@
 </div>
 
 <p>The following example shows how to cast a character to a DECIMAL having two decimal places.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CAST(&#39;1&#39; as DECIMAL(28, 2)) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CAST(&#39;1&#39; as DECIMAL(28, 2)) FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1066,7 +1064,7 @@
 <h3 id="casting-a-number-to-a-character-string">Casting a Number to a Character String</h3>
 
 <p>The first example shows Drill casting a number to a VARCHAR having a length of 3 bytes: The result is a 3-character string, 456. Drill supports the CHAR and CHARACTER VARYING alias.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CAST(456 as VARCHAR(3)) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CAST(456 as VARCHAR(3)) FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1074,7 +1072,7 @@
 +------------+
 1 row selected (0.08 seconds)
 
-SELECT CAST(456 as CHAR(3)) FROM sys.version;
+SELECT CAST(456 as CHAR(3)) FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1085,7 +1083,7 @@ SELECT CAST(456 as CHAR(3)) FROM sys.version;
 <h3 id="casting-from-one-type-of-number-to-another">Casting from One Type of Number to Another</h3>
 
 <p>Cast an integer to a decimal.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CAST(-2147483648 AS DECIMAL(28,8)) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CAST(-2147483648 AS DECIMAL(28,8)) FROM (VALUES(1));
 +-----------------+
 |     EXPR$0      |
 +-----------------+
@@ -1165,7 +1163,7 @@ data as encoded VARBINARY data. To read HBase data in Drill, convert every colum
 
 <p>CONVERT_TO also converts an SQL data type to complex types, including HBase byte arrays, JSON and Parquet arrays, and maps. CONVERT_FROM converts from complex types, including HBase arrays, JSON and Parquet arrays and maps to an SQL data type. </p>
 
-<p>Use the BINARY_STRING and STRING_BINARY custom Drill functions with CONVERT_TO and CONVERT_FROM to see readable results of your conversions.</p>
+<p>Use the BINARY_STRING and STRING_BINARY custom Drill functions with CONVERT_TO and CONVERT_FROM to get meaningful results.</p>
 
 <h3 id="conversion-of-data-types-examples">Conversion of Data Types Examples</h3>
 
@@ -1202,7 +1200,7 @@ SELECT * FROM students;
 4 rows selected (0.504 seconds)
 </code></pre></div>
 <p>This example converts from VARCHAR to a JSON map:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CONVERT_FROM(&#39;{x:100, y:215.6}&#39; ,&#39;JSON&#39;) AS MYCOL FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CONVERT_FROM(&#39;{x:100, y:215.6}&#39; ,&#39;JSON&#39;) AS MYCOL FROM (VALUES(1));
 +----------------------+
 |        MYCOL         |
 +----------------------+
@@ -1211,7 +1209,7 @@ SELECT * FROM students;
 1 row selected (0.163 seconds)
 </code></pre></div>
 <p>This example uses a list of BIGINT as input and returns a repeated list of vectors:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CONVERT_FROM(&#39;[ [1, 2], [3, 4], [5]]&#39; ,&#39;JSON&#39;) AS MYCOL1 FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CONVERT_FROM(&#39;[ [1, 2], [3, 4], [5]]&#39; ,&#39;JSON&#39;) AS MYCOL1 FROM (VALUES(1));
 +------------+
 |   mycol1   |
 +------------+
@@ -1220,7 +1218,7 @@ SELECT * FROM students;
 1 row selected (0.054 seconds)
 </code></pre></div>
 <p>This example uses a map as input to return a repeated list vector (JSON).</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CONVERT_FROM(&#39;[{a : 100, b: 200}, {a:300, b: 400}]&#39; ,&#39;JSON&#39;) AS MYCOL1  FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CONVERT_FROM(&#39;[{a : 100, b: 200}, {a:300, b: 400}]&#39; ,&#39;JSON&#39;) AS MYCOL1  FROM (VALUES(1));
 +--------------------+
 |       MYCOL1       |
 +--------------------+
@@ -1230,7 +1228,7 @@ SELECT * FROM students;
 </code></pre></div>
 <h3 id="set-up-a-storage-plugin-for-working-with-hbase">Set Up a Storage Plugin for Working with HBase</h3>
 
-<p>This example assumes you are working in the Drill Sandbox. The <code>maprdb</code> storage plugin definition is limited, so you modify the <code>dfs</code> storage plugin slightly and use that plugin for this example.</p>
+<p>This example assumes you are working in the Drill Sandbox. You modify the <code>dfs</code> storage plugin slightly and use that plugin for this example.</p>
 
 <ol>
 <li><p>Copy/paste the <code>dfs</code> storage plugin definition to a newly created plugin called myplugin.</p></li>
@@ -1349,7 +1347,7 @@ FROM tmp.`to_json`;
 +------------+---------------------------+
 1 row selected (0.414 seconds)
 </code></pre></div></li>
-<li><p>Take a look at the binary Parquet output:</p>
+<li><p>Take a look at the meaningless output from sqlline:</p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM tmp.`json2parquet`;
 +-------------+-------------+-------------+-------------+-------------+
 |      id     |    name     |    state    |   street    |     zip     |
@@ -1383,7 +1381,7 @@ FROM tmp.`json2parquet2`;
 
 <h2 id="string_binary-function">STRING_BINARY function</h2>
 
-<p>Converts a VARBINARY type into a hexadecimal-encoded string.</p>
+<p>Converts a VARBINARY value into a string that is its hexadecimal encoding.</p>
 
 <h3 id="string_binary-syntax">STRING_BINARY Syntax</h3>
 <div class="highlight"><pre><code class="language-text" data-lang="text">STRING_BINARY(expression)
@@ -1423,7 +1421,7 @@ FROM (VALUES (1));
 </code></pre></div>
 <h2 id="binary_string-function">BINARY_STRING function</h2>
 
-<p>Converts a hexadecimal-encoded string into a VARBINARY type. </p>
+<p>Converts a string that is the hexadecimal encoding of a sequence of bytes into a VARBINARY value. </p>
 
 <h3 id="binary_string-syntax">BINARY_STRING Syntax</h3>
 <div class="highlight"><pre><code class="language-text" data-lang="text">BINARY_STRING(expression)
@@ -1441,11 +1439,11 @@ FROM (VALUES (1));
 </code></pre></div>
 <p><em>expression</em> is a byte array, such as {(byte)0xca, (byte)0xfe, (byte)0xba, (byte)0xbe}.</p>
 
-<p>This function returns a hexadecimal-encoded string, such as <code>&quot;\xca\xfe\xba\xbe&quot;</code>. You can use this function with CONVERT_TO for readable results.</p>
+<p>This function returns a hexadecimal-encoded string, such as <code>&quot;\xca\xfe\xba\xbe&quot;</code>. You can use this function with CONVERT_TO for meaningful results.</p>
 
 <h3 id="binary_string-examples">BINARY_STRING Examples</h3>
 
-<p>Decode the hexadecimal string 000000C8 expressed in four octets <code>\x00\x00\x00\xC8</code> into its big endian four-byte integer equivalent. </p>
+<p>Decode the hexadecimal string 000000C8 expressed in four octets <code>\x00\x00\x00\xC8</code> into an integer equivalent using big endian encoding. </p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CONVERT_FROM(BINARY_STRING(&#39;\x00\x00\x00\xC8&#39;), &#39;INT_BE&#39;) AS cnvrt
 FROM (VALUES (1));
 </code></pre></div>
@@ -1457,7 +1455,7 @@ FROM (VALUES (1));
 +--------+
 1 row selected (0.133 seconds)
 </code></pre></div>
-<p>Decode the same hexadecimal string into its little endian four-byte signed integer equivalent.</p>
+<p>Decode the same hexadecimal string into an integer using little endian encoding.</p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CONVERT_FROM(BINARY_STRING(&#39;\x00\x00\x00\xC8&#39;), &#39;INT&#39;) AS cnvrt FROM (VALUES (1));
 </code></pre></div>
 <p>Output is:</p>
@@ -1778,7 +1776,7 @@ use in your Drill queries as described in this section:</p>
 <h3 id="to_char-examples">TO_CHAR Examples</h3>
 
 <p>Convert a FLOAT to a character string. The format specifications use a comma to separate thousands and round-off to three decimal places.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_CHAR(1256.789383, &#39;#,###.###&#39;) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_CHAR(1256.789383, &#39;#,###.###&#39;) FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1787,7 +1785,7 @@ use in your Drill queries as described in this section:</p>
 1 row selected (1.767 seconds)
 </code></pre></div>
 <p>Convert an integer to a character string.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_CHAR(125677.4567, &#39;#,###.###&#39;) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_CHAR(125677.4567, &#39;#,###.###&#39;) FROM (VALUES(1));
 +--------------+
 |    EXPR$0    |
 +--------------+
@@ -1796,7 +1794,7 @@ use in your Drill queries as described in this section:</p>
 1 row selected (0.083 seconds)
 </code></pre></div>
 <p>Convert a date to a character string.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_CHAR((CAST(&#39;2008-2-23&#39; AS DATE)), &#39;yyyy-MMM-dd&#39;) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_CHAR((CAST(&#39;2008-2-23&#39; AS DATE)), &#39;yyyy-MMM-dd&#39;) FROM (VALUES(1));
 +--------------+
 |    EXPR$0    |
 +--------------+
@@ -1805,7 +1803,7 @@ use in your Drill queries as described in this section:</p>
 1 row selected (0.166 seconds)
 </code></pre></div>
 <p>Convert a time to a string.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_CHAR(CAST(&#39;12:20:30&#39; AS TIME), &#39;HH mm ss&#39;) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_CHAR(CAST(&#39;12:20:30&#39; AS TIME), &#39;HH mm ss&#39;) FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1814,7 +1812,7 @@ use in your Drill queries as described in this section:</p>
 1 row selected (0.07 seconds)
 </code></pre></div>
 <p>Convert a timestamp to a string.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_CHAR(CAST(&#39;2015-2-23 12:00:00&#39; AS TIMESTAMP), &#39;yyyy MMM dd HH:mm:ss&#39;) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_CHAR(CAST(&#39;2015-2-23 12:00:00&#39; AS TIMESTAMP), &#39;yyyy MMM dd HH:mm:ss&#39;) FROM (VALUES(1));
 +-----------------------+
 |        EXPR$0         |
 +-----------------------+
@@ -1868,7 +1866,7 @@ SELECT TO_DATE(`date`, &#39;yyyy-MM-dd&#39;) FROM `sample.json` WHERE TO_DATE(`d
 <h3 id="to_date-examples">TO_DATE Examples</h3>
 
 <p>The first example converts a character string to a date. The second example extracts the year to verify that Drill recognizes the date as a date type. </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_DATE(&#39;2015-FEB-23&#39;, &#39;yyyy-MMM-dd&#39;) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_DATE(&#39;2015-FEB-23&#39;, &#39;yyyy-MMM-dd&#39;) FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1876,7 +1874,7 @@ SELECT TO_DATE(`date`, &#39;yyyy-MM-dd&#39;) FROM `sample.json` WHERE TO_DATE(`d
 +------------+
 1 row selected (0.077 seconds)
 
-SELECT EXTRACT(year from mydate) `extracted year` FROM (SELECT TO_DATE(&#39;2015-FEB-23&#39;, &#39;yyyy-MMM-dd&#39;) AS mydate FROM sys.version);
+SELECT EXTRACT(year from mydate) `extracted year` FROM (SELECT TO_DATE(&#39;2015-FEB-23&#39;, &#39;yyyy-MMM-dd&#39;) AS mydate FROM (VALUES(1)));
 
 +------------+
 |   myyear   |
@@ -1886,7 +1884,7 @@ SELECT EXTRACT(year from mydate) `extracted year` FROM (SELECT TO_DATE(&#39;2015
 1 row selected (0.128 seconds)
 </code></pre></div>
 <p>The following example converts a UNIX epoch timestamp to a date.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_DATE(1427849046000) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_DATE(1427849046000) FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1922,14 +1920,14 @@ Exponent. Separates mantissa and exponent in scientific notation. </p></li>
 </ul>
 
 <h3 id="to_number-examples">TO_NUMBER Examples</h3>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_NUMBER(&#39;987,966&#39;, &#39;######&#39;) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_NUMBER(&#39;987,966&#39;, &#39;######&#39;) FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
 | 987.0      |
 +------------+
 
-SELECT TO_NUMBER(&#39;987.966&#39;, &#39;###.###&#39;) FROM sys.version;
+SELECT TO_NUMBER(&#39;987.966&#39;, &#39;###.###&#39;) FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1937,7 +1935,7 @@ SELECT TO_NUMBER(&#39;987.966&#39;, &#39;###.###&#39;) FROM sys.version;
 +------------+
 1 row selected (0.063 seconds)
 
-SELECT TO_NUMBER(&#39;12345&#39;, &#39;##0.##E0&#39;) FROM sys.version;
+SELECT TO_NUMBER(&#39;12345&#39;, &#39;##0.##E0&#39;) FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1961,7 +1959,7 @@ SELECT TO_NUMBER(&#39;12345&#39;, &#39;##0.##E0&#39;) FROM sys.version;
 <p>Specify a format using patterns defined in <a href="http://joda-time.sourceforge.net/apidocs/org/joda/time/format/DateTimeFormat.html">Joda DateTimeFormat class</a>.</p>
 
 <h3 id="to_time-examples">TO_TIME Examples</h3>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_TIME(&#39;12:20:30&#39;, &#39;HH:mm:ss&#39;) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_TIME(&#39;12:20:30&#39;, &#39;HH:mm:ss&#39;) FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1970,7 +1968,7 @@ SELECT TO_NUMBER(&#39;12345&#39;, &#39;##0.##E0&#39;) FROM sys.version;
 1 row selected (0.067 seconds)
 </code></pre></div>
 <p>Convert 828550000 milliseconds (23 hours 55 seconds) to the time.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT to_time(82855000) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT to_time(82855000) FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1994,7 +1992,7 @@ SELECT TO_NUMBER(&#39;12345&#39;, &#39;##0.##E0&#39;) FROM sys.version;
 <h3 id="to_timestamp-examples">TO_TIMESTAMP Examples</h3>
 
 <p>Convert a date to a timestamp. </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_TIMESTAMP(&#39;2008-2-23 12:00:00&#39;, &#39;yyyy-MM-dd HH:mm:ss&#39;) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_TIMESTAMP(&#39;2008-2-23 12:00:00&#39;, &#39;yyyy-MM-dd HH:mm:ss&#39;) FROM (VALUES(1));
 +------------------------+
 |         EXPR$0         |
 +------------------------+
@@ -2003,7 +2001,7 @@ SELECT TO_NUMBER(&#39;12345&#39;, &#39;##0.##E0&#39;) FROM sys.version;
 1 row selected (0.126 seconds)
 </code></pre></div>
 <p>Convert Unix Epoch time to a timestamp.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_TIMESTAMP(1427936330) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_TIMESTAMP(1427936330) FROM (VALUES(1));
 +------------------------+
 |         EXPR$0         |
 +------------------------+
@@ -2014,7 +2012,7 @@ SELECT TO_NUMBER(&#39;12345&#39;, &#39;##0.##E0&#39;) FROM sys.version;
 <p>Convert a UTC date to a timestamp offset from the UTC time zone code.</p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_TIMESTAMP(&#39;2015-03-30 20:49:59.0 UTC&#39;, &#39;YYYY-MM-dd HH:mm:ss.s z&#39;) AS Original, 
        TO_CHAR(TO_TIMESTAMP(&#39;2015-03-30 20:49:59.0 UTC&#39;, &#39;YYYY-MM-dd HH:mm:ss.s z&#39;), &#39;z&#39;) AS New_TZ 
-FROM sys.version;
+FROM (VALUES(1));
 
 +------------------------+---------+
 |        Original        | New_TZ  |
@@ -2029,7 +2027,7 @@ FROM sys.version;
 
 <ol>
 <li><p>Take a look at the Drill time zone configuration by running the TIMEOFDAY function or by querying the system.options table. This TIMEOFDAY function returns the local date and time with time zone information. </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TIMEOFDAY() FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TIMEOFDAY() FROM (VALUES(1));
 
 +----------------------------------------------+
 |                    EXPR$0                    |
@@ -2043,7 +2041,7 @@ FROM sys.version;
 </code></pre></div></li>
 <li><p>Restart the Drill shell.</p></li>
 <li><p>Confirm that Drill is now set to UTC:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TIMEOFDAY() FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TIMEOFDAY() FROM (VALUES(1));
 
 +----------------------------------------------+
 |                    EXPR$0                    |
@@ -2057,7 +2055,7 @@ FROM sys.version;
 <p>You can use the ā€˜zā€™ option to identify the time zone in TO_TIMESTAMP to make sure the timestamp has the timezone in it. Also, use the ā€˜zā€™ option to identify the time zone in a timestamp using the TO_CHAR function. For example:</p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_TIMESTAMP(&#39;2015-03-30 20:49:59.0 UTC&#39;, &#39;YYYY-MM-dd HH:mm:ss.s z&#39;) AS Original, 
        TO_CHAR(TO_TIMESTAMP(&#39;2015-03-30 20:49:59.0 UTC&#39;, &#39;YYYY-MM-dd HH:mm:ss.s z&#39;), &#39;z&#39;) AS TimeZone 
-       FROM sys.version;
+       FROM (VALUES(1));
 
 +------------------------+-----------+
 |        Original        | TimeZone  |

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/data-types/index.html
----------------------------------------------------------------------
diff --git a/docs/data-types/index.html b/docs/data-types/index.html
index dddbc04..9b89a51 100644
--- a/docs/data-types/index.html
+++ b/docs/data-types/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/date-time-and-timestamp/index.html
----------------------------------------------------------------------
diff --git a/docs/date-time-and-timestamp/index.html b/docs/date-time-and-timestamp/index.html
index 28dd22e..9d1e5fc 100644
--- a/docs/date-time-and-timestamp/index.html
+++ b/docs/date-time-and-timestamp/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           
@@ -1012,18 +1010,18 @@
        TIME &#39;12:23:34&#39;, 
        TIMESTAMP &#39;2008-2-23 12:23:34.456&#39;, 
        INTERVAL &#39;1&#39; YEAR, INTERVAL &#39;2&#39; DAY, 
-       DATE_ADD(DATE &#39;2008-2-23&#39;, INTERVAL &#39;1 10:20:30&#39; DAY TO SECOND) 
+       DATE_ADD(DATE &#39;2008-2-23&#39;, INTERVAL &#39;1 10:20:30&#39; DAY TO SECOND), 
        DATE_ADD(DATE &#39;2010-2-23&#39;, 1)
-FROM sys.version LIMIT 1;
+FROM (VALUES (1));
 +-------------+-----------+--------------------------+---------+---------+------------------------+-------------+
 |   EXPR$0    |  EXPR$1   |          EXPR$2          | EXPR$3  | EXPR$4  |         EXPR$5         |   EXPR$6    |
 +-------------+-----------+--------------------------+---------+---------+------------------------+-------------+
 | 2008-02-23  | 12:23:34  | 2008-02-23 12:23:34.456  | P1Y     | P2D     | 2008-02-24 10:20:30.0  | 2010-02-24  |
 +-------------+-----------+--------------------------+---------+---------+------------------------+-------------+
 </code></pre></div>
-<h2 id="intervalyear-and-intervalday">INTERVALYEAR and INTERVALDAY</h2>
+<h2 id="interval">INTERVAL</h2>
 
-<p>The INTERVALYEAR and INTERVALDAY types represent a period of time. The INTERVALYEAR type specifies values from a year to a month. The INTERVALDAY type specifies values from a day to seconds.</p>
+<p>The INTERVALYEAR and INTERVALDAY internal types represent a period of time. The INTERVALYEAR type specifies values from a year to a month. The INTERVALDAY type specifies values from a day to seconds.</p>
 
 <h3 id="interval-in-data-source">Interval in Data Source</h3>
 
@@ -1073,13 +1071,13 @@ P [qty] Y [qty] M
 <h3 id="literal-interval-examples">Literal Interval Examples</h3>
 
 <p>In the following example, the INTERVAL keyword followed by 200 adds 200 years to the timestamp. The 3 in parentheses in <code>YEAR(3)</code> specifies the precision of the year interval, 3 digits in this case to support the hundreds interval.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CURRENT_TIMESTAMP + INTERVAL &#39;200&#39; YEAR(3) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CURRENT_TIMESTAMP + INTERVAL &#39;200&#39; YEAR(3) FROM (VALUES(1));
 +--------------------------+
 |          EXPR$0          |
 +--------------------------+
-| 2215-05-20 14:04:25.129  |
+| 2215-08-14 15:18:00.094  |
 +--------------------------+
-1 row selected (0.148 seconds)
+1 row selected (0.096 seconds)
 </code></pre></div>
 <p>The following examples show the input and output format of INTERVALYEAR (Year, Month) and INTERVALDAY (Day, Hours, Minutes, Seconds, Milliseconds). The following SELECT statements show how to format the query input. 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 &#39;1 10:20:30.123&#39; day to second FROM sys.version;
@@ -1090,7 +1088,7 @@ P [qty] Y [qty] M
 +------------+
 1 row selected (0.054 seconds)
 
-SELECT INTERVAL &#39;1-2&#39; year to month FROM sys.version;
+SELECT INTERVAL &#39;1-2&#39; year to month FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1098,7 +1096,7 @@ SELECT INTERVAL &#39;1-2&#39; year to month FROM sys.version;
 +------------+
 1 row selected (0.927 seconds)
 
-SELECT INTERVAL &#39;1&#39; year FROM sys.version;
+SELECT INTERVAL &#39;1&#39; year FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1106,7 +1104,7 @@ SELECT INTERVAL &#39;1&#39; year FROM sys.version;
 +------------+
 1 row selected (0.088 seconds)
 
-SELECT INTERVAL &#39;13&#39; month FROM sys.version;
+SELECT INTERVAL &#39;13&#39; month FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1126,7 +1124,7 @@ SELECT INTERVAL &#39;13&#39; month FROM sys.version;
 <li><code>date</code></li>
 <li><code>time</code></li>
 <li><p><code>timestamp</code></p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT date &#39;2010-2-15&#39; FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT date &#39;2010-2-15&#39; FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1134,7 +1132,7 @@ SELECT INTERVAL &#39;13&#39; month FROM sys.version;
 +------------+
 1 row selected (0.083 seconds)
 
-SELECT time &#39;15:20:30&#39; from sys.version;
+SELECT time &#39;15:20:30&#39; from (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1142,7 +1140,7 @@ SELECT time &#39;15:20:30&#39; from sys.version;
 +------------+
 1 row selected (0.067 seconds)
 
-SELECT timestamp &#39;2015-03-11 6:50:08&#39; FROM sys.version;
+SELECT timestamp &#39;2015-03-11 6:50:08&#39; FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/date-time-functions-and-arithmetic/index.html
----------------------------------------------------------------------
diff --git a/docs/date-time-functions-and-arithmetic/index.html b/docs/date-time-functions-and-arithmetic/index.html
index 838a228..292e2c2 100644
--- a/docs/date-time-functions-and-arithmetic/index.html
+++ b/docs/date-time-functions-and-arithmetic/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           
@@ -1087,7 +1085,7 @@
 <h3 id="age-examples">AGE Examples</h3>
 
 <p>Find the interval between midnight today, April 3, 2015, and June 13, 1957.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT AGE(&#39;1957-06-13&#39;) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT AGE(&#39;1957-06-13&#39;) FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1106,7 +1104,7 @@
 2 rows selected (0.121 seconds)
 </code></pre></div>
 <p>Find the interval between 11:10:10 PM on January 1, 2001 and 10:10:10 PM on January 1, 2001.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT AGE(CAST(&#39;2010-01-01 10:10:10&#39; AS TIMESTAMP), CAST(&#39;2001-01-01 11:10:10&#39; AS TIMESTAMP)) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT AGE(CAST(&#39;2010-01-01 10:10:10&#39; AS TIMESTAMP), CAST(&#39;2001-01-01 11:10:10&#39; AS TIMESTAMP)) FROM (VALUES(1));
 +------------------+
 |      EXPR$0      |
 +------------------+
@@ -1143,7 +1141,7 @@ DATE_ADD(column, interval expr)
 <p><strong><code>DATE_ADD(keyword literal, integer)</code> Syntax Example</strong></p>
 
 <p>Add two days to today&#39;s date May 15, 2015.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_ADD(date &#39;2015-05-15&#39;, 2) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_ADD(date &#39;2015-05-15&#39;, 2) FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1216,7 +1214,7 @@ DATE_ADD(column, interval expr)
 <p><strong><code>DATE_ADD(keyword literal, integer)</code> Syntax Example</strong></p>
 
 <p>Add 1 year and 1 month to the timestamp 2015-04-15 22:55:55.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_ADD(timestamp &#39;2015-04-15 22:55:55&#39;, interval &#39;1-2&#39; year to month) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_ADD(timestamp &#39;2015-04-15 22:55:55&#39;, interval &#39;1-2&#39; year to month) FROM (VALUES(1));
 +------------------------+
 |         EXPR$0         |
 +------------------------+
@@ -1225,7 +1223,7 @@ DATE_ADD(column, interval expr)
 1 row selected (0.106 seconds)
 </code></pre></div>
 <p>Add 1 day 2 and 1/2 hours and 45.100 seconds to the time 22:55:55.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_ADD(time &#39;22:55:55&#39;, interval &#39;1 2:30:45.100&#39; day to second) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_ADD(time &#39;22:55:55&#39;, interval &#39;1 2:30:45.100&#39; day to second) FROM (VALUES(1));
 +---------------+
 |    EXPR$0     |
 +---------------+
@@ -1248,7 +1246,7 @@ DATE_ADD(column, interval expr)
 <p>Use Unix Epoch timestamp in milliseconds as the expression to get the field of a timestamp.</p>
 
 <h3 id="date_part-examples">DATE_PART Examples</h3>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_PART(&#39;day&#39;, &#39;2015-04-02&#39;) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_PART(&#39;day&#39;, &#39;2015-04-02&#39;) FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1256,7 +1254,7 @@ DATE_ADD(column, interval expr)
 +------------+
 1 row selected (0.098 seconds)
 
-SELECT DATE_PART(&#39;hour&#39;, &#39;23:14:30.076&#39;) FROM sys.version;
+SELECT DATE_PART(&#39;hour&#39;, &#39;23:14:30.076&#39;) FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1265,7 +1263,7 @@ SELECT DATE_PART(&#39;hour&#39;, &#39;23:14:30.076&#39;) FROM sys.version;
 1 row selected (0.088 seconds)
 </code></pre></div>
 <p>Return the day part of the one year, 2 months, 10 days interval.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_PART(&#39;day&#39;, &#39;1:2:10&#39;) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_PART(&#39;day&#39;, &#39;1:2:10&#39;) FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1300,7 +1298,7 @@ DATE_SUB(column, interval expr)
 <p><strong><code>DATE_SUB(keyword literal, integer)</code> Syntax Example</strong></p>
 
 <p>Subtract two days from today&#39;s date May 15, 2015.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_SUB(date &#39;2015-05-15&#39;, 2) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_SUB(date &#39;2015-05-15&#39;, 2) FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1309,7 +1307,7 @@ DATE_SUB(column, interval expr)
 1 row selected (0.088 seconds)
 </code></pre></div>
 <p>Subtact two months from April 15, 2015.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_SUB(date &#39;2015-04-15&#39;, interval &#39;2&#39; month) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_SUB(date &#39;2015-04-15&#39;, interval &#39;2&#39; month) FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1320,7 +1318,7 @@ DATE_SUB(column, interval expr)
 <p><strong><code>DATE_SUB(keyword literal, interval expr)</code> Syntax Example</strong></p>
 
 <p>Subtract 10 hours from the timestamp 2015-04-15 22:55:55.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_SUB(timestamp &#39;2015-04-15 22:55:55&#39;, interval &#39;10&#39; hour) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_SUB(timestamp &#39;2015-04-15 22:55:55&#39;, interval &#39;10&#39; hour) FROM (VALUES(1));
 +------------------------+
 |         EXPR$0         |
 +------------------------+
@@ -1329,7 +1327,7 @@ DATE_SUB(column, interval expr)
 1 row selected (0.108 seconds)
 </code></pre></div>
 <p>Subtract 10 hours from the time 22 hours, 55 minutes, 55 seconds.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_SUB(time &#39;22:55:55&#39;, interval &#39;10&#39; hour) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_SUB(time &#39;22:55:55&#39;, interval &#39;10&#39; hour) FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1338,7 +1336,7 @@ DATE_SUB(column, interval expr)
 1 row selected (0.079 seconds)
 </code></pre></div>
 <p>Subtract 1 year and 1 month from the timestamp 2015-04-15 22:55:55.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_SUB(timestamp &#39;2015-04-15 22:55:55&#39;, interval &#39;1-2&#39; year to month) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_SUB(timestamp &#39;2015-04-15 22:55:55&#39;, interval &#39;1-2&#39; year to month) FROM (VALUES(1));
 +------------------------+
 |         EXPR$0         |
 +------------------------+
@@ -1347,7 +1345,7 @@ DATE_SUB(column, interval expr)
 1 row selected (0.108 seconds)
 </code></pre></div>
 <p>Subtract 1 day, 2 and 1/2 hours, and 45.100 seconds from the time 22:55:55.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_ADD(time &#39;22:55:55&#39;, interval &#39;1 2:30:45.100&#39; day to second) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_ADD(time &#39;22:55:55&#39;, interval &#39;1 2:30:45.100&#39; day to second) FROM (VALUES(1));
 +---------------+
 |    EXPR$0     |
 +---------------+
@@ -1388,7 +1386,7 @@ DATE_SUB(column, interval expr)
 <li>LOCALTIMESTAMP</li>
 <li>NOW</li>
 <li><p>TIMEOFDAY</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CURRENT_DATE FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CURRENT_DATE FROM (VALUES(1));
 +--------------+
 | current_date |
 +--------------+
@@ -1396,7 +1394,7 @@ DATE_SUB(column, interval expr)
 +--------------+
 1 row selected (0.077 seconds)
 
-SELECT CURRENT_TIME FROM sys.version;
+SELECT CURRENT_TIME FROM (VALUES(1));
 +--------------+
 | current_time |
 +--------------+
@@ -1404,7 +1402,7 @@ SELECT CURRENT_TIME FROM sys.version;
 +--------------+
 1 row selected (0.073 seconds)
 
-SELECT CURRENT_TIMESTAMP FROM sys.version;
+SELECT CURRENT_TIMESTAMP FROM (VALUES(1));
 +--------------------------+
 |    CURRENT_TIMESTAMP     |
 +--------------------------+
@@ -1412,7 +1410,7 @@ SELECT CURRENT_TIMESTAMP FROM sys.version;
 +--------------------------+
 1 row selected (0.109 seconds)
 
-SELECT LOCALTIME FROM sys.version;
+SELECT LOCALTIME FROM (VALUES(1));
 
 +---------------+
 |   LOCALTIME   |
@@ -1421,7 +1419,7 @@ SELECT LOCALTIME FROM sys.version;
 +---------------+
 1 row selected (0.105 seconds)
 
-SELECT LOCALTIMESTAMP FROM sys.version;
+SELECT LOCALTIMESTAMP FROM (VALUES(1));
 
 +--------------------------+
 |      LOCALTIMESTAMP      |
@@ -1430,7 +1428,7 @@ SELECT LOCALTIMESTAMP FROM sys.version;
 +--------------------------+
 1 row selected (0.08 seconds)
 
-SELECT NOW() FROM sys.version;
+SELECT NOW() FROM (VALUES(1));
 +--------------------------+
 |          EXPR$0          |
 +--------------------------+
@@ -1441,7 +1439,7 @@ SELECT NOW() FROM sys.version;
 </ul>
 
 <p>If you set up Drill for <a href="/docs/data-type-conversion/#time-zone-limitation">UTC time</a>, TIMEOFDAY returns the result for the UTC time zone.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TIMEOFDAY() FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TIMEOFDAY() FROM (VALUES(1));
 +-----------------------------+
 |           EXPR$0            |
 +-----------------------------+
@@ -1450,7 +1448,7 @@ SELECT NOW() FROM sys.version;
 1 row selected (1.191 seconds)
 </code></pre></div>
 <p>If you did not set up Drill for UTC time, TIMEOFDAY returns the local date and time with time zone information.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TIMEOFDAY() FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TIMEOFDAY() FROM (VALUES(1));
 +----------------------------------------------+
 |                    EXPR$0                    |
 +----------------------------------------------+
@@ -1477,7 +1475,7 @@ SELECT NOW() FROM sys.version;
 <h3 id="extract-examples">EXTRACT Examples</h3>
 
 <p>On the third day of the month, run the following function:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT EXTRACT(day FROM NOW()), EXTRACT(day FROM CURRENT_DATE) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT EXTRACT(day FROM NOW()), EXTRACT(day FROM CURRENT_DATE) FROM (VALUES(1));
 
 +------------+------------+
 |   EXPR$0   |   EXPR$1   |
@@ -1487,7 +1485,7 @@ SELECT NOW() FROM sys.version;
 1 row selected (0.208 seconds)
 </code></pre></div>
 <p>At 8:00 am, extract the hour from the value of CURRENT_DATE.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT EXTRACT(hour FROM CURRENT_DATE) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT EXTRACT(hour FROM CURRENT_DATE) FROM (VALUES(1));
 
 +------------+
 |   EXPR$0   |
@@ -1496,7 +1494,7 @@ SELECT NOW() FROM sys.version;
 +------------+
 </code></pre></div>
 <p>What is the hour component of this time: 17:12:28.5?</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT EXTRACT(hour FROM TIME &#39;17:12:28.5&#39;) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT EXTRACT(hour FROM TIME &#39;17:12:28.5&#39;) FROM (VALUES(1));
 
 +------------+
 |   EXPR$0   |
@@ -1506,7 +1504,7 @@ SELECT NOW() FROM sys.version;
 1 row selected (0.056 seconds)
 </code></pre></div>
 <p>What is the seconds component of this timestamp: 2001-02-16 20:38:40</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT EXTRACT(SECOND FROM TIMESTAMP &#39;2001-02-16 20:38:40&#39;) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT EXTRACT(SECOND FROM TIMESTAMP &#39;2001-02-16 20:38:40&#39;) FROM (VALUES(1));
 
 +------------+
 |   EXPR$0   |
@@ -1518,7 +1516,7 @@ SELECT NOW() FROM sys.version;
 <h2 id="date,-time,-and-interval-arithmetic-functions">Date, Time, and Interval Arithmetic Functions</h2>
 
 <p>Is the day returned from the NOW function the same as the day returned from the CURRENT_DATE function?</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT EXTRACT(day FROM NOW()) = EXTRACT(day FROM CURRENT_DATE) FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT EXTRACT(day FROM NOW()) = EXTRACT(day FROM CURRENT_DATE) FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1527,7 +1525,7 @@ SELECT NOW() FROM sys.version;
 1 row selected (0.092 seconds)
 </code></pre></div>
 <p>Every 23 hours, a 4 hour task started. What time does the task end? </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TIME &#39;04:00:00&#39; + interval &#39;23:00:00&#39; hour to second FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TIME &#39;04:00:00&#39; + interval &#39;23:00:00&#39; hour to second FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1536,7 +1534,7 @@ SELECT NOW() FROM sys.version;
 1 row selected (0.097 seconds)
 </code></pre></div>
 <p>Is the time 2:00 PM?</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT EXTRACT(hour FROM CURRENT_DATE) = 2 FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT EXTRACT(hour FROM CURRENT_DATE) = 2 FROM (VALUES(1));
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1560,7 +1558,7 @@ UNIX_TIMESTAMP(string date, string pattern)
 <li>Converts the time string in format yyyy-MM-dd HH:mm:ss to a Unix timestamp in seconds using the default timezone and locale.<br></li>
 <li>Converts the time string with the given pattern to a Unix time stamp in seconds.<br></li>
 </ul>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT UNIX_TIMESTAMP FROM sys.version;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT UNIX_TIMESTAMP() FROM (VALUES(1));
 +-------------+
 |   EXPR$0    |
 +-------------+
@@ -1568,7 +1566,7 @@ UNIX_TIMESTAMP(string date, string pattern)
 +-------------+
 1 row selected (0.749 seconds)
 
-SELECT UNIX_TIMESTAMP(&#39;2009-03-20 11:15:55&#39;) FROM sys.version;
+SELECT UNIX_TIMESTAMP(&#39;2009-03-20 11:15:55&#39;) FROM (VALUES(1));
 +-------------+
 |   EXPR$0    |
 +-------------+
@@ -1576,7 +1574,7 @@ SELECT UNIX_TIMESTAMP(&#39;2009-03-20 11:15:55&#39;) FROM sys.version;
 +-------------+
 1 row selected (1.848 seconds)
 
-SELECT UNIX_TIMESTAMP(&#39;2009-03-20&#39;, &#39;yyyy-MM-dd&#39;) FROM sys.version;
+SELECT UNIX_TIMESTAMP(&#39;2009-03-20&#39;, &#39;yyyy-MM-dd&#39;) FROM (VALUES(1));
 +-------------+
 |   EXPR$0    |
 +-------------+
@@ -1584,7 +1582,7 @@ SELECT UNIX_TIMESTAMP(&#39;2009-03-20&#39;, &#39;yyyy-MM-dd&#39;) FROM sys.versi
 +-------------+
 1 row selected (0.181 seconds)
 
-SELECT UNIX_TIMESTAMP(&#39;2015-05-29 08:18:53.0&#39;, &#39;yyyy-MM-dd HH:mm:ss.SSS&#39;) FROM sys.version;
+SELECT UNIX_TIMESTAMP(&#39;2015-05-29 08:18:53.0&#39;, &#39;yyyy-MM-dd HH:mm:ss.SSS&#39;) FROM (VALUES(1));
 +-------------+
 |   EXPR$0    |
 +-------------+

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/deploying-and-using-a-hive-udf/index.html
----------------------------------------------------------------------
diff --git a/docs/deploying-and-using-a-hive-udf/index.html b/docs/deploying-and-using-a-hive-udf/index.html
index 3ff9247..5cc06c6 100644
--- a/docs/deploying-and-using-a-hive-udf/index.html
+++ b/docs/deploying-and-using-a-hive-udf/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           
@@ -1009,18 +1007,34 @@
 
 <h2 id="creating-the-udf">Creating the UDF</h2>
 
-<p>You create the JAR for a UDF to use in Drill in a conventional manner with a few caveats, using a unique name and creating a Drill resource, covered in this section.</p>
+<p>You create the JAR for a UDF to use in Drill in a conventional manner with a few caveats, using a unique name and creating a Drill resource, covered in this section. Sample code for this function is in <a href="https://github.com/viadea/HiveUDF">Github</a>.</p>
 
 <ol>
-<li>Use a unique name for the Hive UDF to avoid conflicts with Drill custom functions of the same name.</li>
-<li>Create a custom Hive UDF using either of these APIs:<br>
+<li><p>Use a unique name for the Hive UDF to avoid conflicts with Drill custom functions of the same name.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">@Description(
+        name = &quot;my_upper&quot;,
+        value = &quot;_FUNC_(str) - Converts a string to uppercase&quot;,
+        extended = &quot;Example:\n&quot; +
+        &quot;  &gt; SELECT my_upper(a) FROM test;\n&quot; +
+        &quot;  ABC&quot;
+        )
+</code></pre></div></li>
+<li><p>Create a custom Hive UDF using either of these APIs:  </p>
 
 <ul>
 <li>Simple API: org.apache.hadoop.hive.ql.exec.UDF</li>
 <li>Complex API: org.apache.hadoop.hive.ql.udf.generic.GenericUDF</li>
 </ul></li>
-<li>Create an empty <code>drill-module.conf</code> in the resources directory in the Java project. </li>
-<li>Export the logic to a JAR, including the <code>drill-module.conf</code> file in resources.</li>
+<li><p>Create an empty <code>drill-module.conf</code> in the resources directory in the Java project.  </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text"># ls -altr src/main/resources/drill-module.conf
+-rw-r--r-- 1 root root 0 Aug 12 23:16 src/main/resources/drill-module.conf
+</code></pre></div></li>
+<li><p>Export the logic to a JAR, including the <code>drill-module.conf</code> file in resources.</p></li>
+<li><p>Make sure the drill-module.conf is in the JAR.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text"># jar tf target/MyUDF-1.0.0.jar  |grep -i drill
+drill-module.conf
+</code></pre></div></li>
+<li><p>Test the UDF in Hive as shown in the <a href="https://github.com/viadea/HiveUDF#c-test-udf">Github readme</a>.</p></li>
 </ol>
 
 <p>The <code>drill-module.conf</code> file defines <a href="/docs/start-up-options/">startup options</a> and makes the JAR functions available to use in queries throughout the Hadoop cluster. After exporting the UDF logic to a JAR file, set up the UDF in Drill. Drill users can access the custom UDF for use in Hive queries.</p>
@@ -1032,16 +1046,23 @@
 <p>To set up the UDF:</p>
 
 <ol>
-<li>Register Hive. <a href="/docs/hive-storage-plugin/">Register a Hive storage plugin</a> that connects Drill to a Hive data source.</li>
-<li>Add the JAR for the UDF to the Drill CLASSPATH. In earlier versions of Drill, place the JAR file in the <code>/jars/3rdparty</code> directory of the Drill installation on all nodes running a Drillbit.</li>
-<li>On each Drill node in the cluster, restart the Drillbit.
+<li>Enable the default <a href="/docs/hive-storage-plugin/">Hive storage plugin configuration</a> that connects Drill to a Hive data source.<br></li>
+<li>Add the JAR for the UDF in the <code>/jars/3rdparty</code> directory of the Drill installation on all nodes running a Drillbit.<br>
+<code>clush -a cp /xxx/target/MyUDF-1.0.0.jar /xxx/drill-1.1.0/jars/3rdparty/</code><br></li>
+<li>On each Drill node in the cluster, restart the Drillbit.<br>
 <code>&lt;drill installation directory&gt;/bin/drillbit.sh restart</code></li>
 </ol>
 
 <h2 id="using-a-udf">Using a UDF</h2>
 
 <p>Use a Hive UDF just as you would use a Drill custom function. For example, to query using a Hive UDF named upper-to-lower that takes a column.value argument, the SELECT statement looks something like this:  </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text"> SELECT upper-to-lower(my_column.myvalue) FROM mytable;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT MY_UPPER(&#39;abc&#39;) from (VALUES(1));
++---------+
+| EXPR$0  |
++---------+
+| ABC     |
++---------+
+1 row selected (1.516 seconds)
 </code></pre></div>
     
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/describe/index.html
----------------------------------------------------------------------
diff --git a/docs/describe/index.html b/docs/describe/index.html
index 64714aa..ce57687 100644
--- a/docs/describe/index.html
+++ b/docs/describe/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           
@@ -1017,7 +1015,7 @@
 <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
+tables created in Hive and HBase. 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

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/design-docs/index.html
----------------------------------------------------------------------
diff --git a/docs/design-docs/index.html b/docs/design-docs/index.html
index 04dca41..52a1f24 100644
--- a/docs/design-docs/index.html
+++ b/docs/design-docs/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/develop-custom-functions-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/develop-custom-functions-introduction/index.html b/docs/develop-custom-functions-introduction/index.html
index 16076c5..460a1d7 100644
--- a/docs/develop-custom-functions-introduction/index.html
+++ b/docs/develop-custom-functions-introduction/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/develop-custom-functions/index.html
----------------------------------------------------------------------
diff --git a/docs/develop-custom-functions/index.html b/docs/develop-custom-functions/index.html
index 7dc044a..1273def 100644
--- a/docs/develop-custom-functions/index.html
+++ b/docs/develop-custom-functions/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/develop-drill/index.html
----------------------------------------------------------------------
diff --git a/docs/develop-drill/index.html b/docs/develop-drill/index.html
index 0332719..6871540 100644
--- a/docs/develop-drill/index.html
+++ b/docs/develop-drill/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/developer-information/index.html
----------------------------------------------------------------------
diff --git a/docs/developer-information/index.html b/docs/developer-information/index.html
index 3655c60..9c5de7a 100644
--- a/docs/developer-information/index.html
+++ b/docs/developer-information/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/developing-a-simple-function/index.html
----------------------------------------------------------------------
diff --git a/docs/developing-a-simple-function/index.html b/docs/developing-a-simple-function/index.html
index 379f130..5e896d0 100644
--- a/docs/developing-a-simple-function/index.html
+++ b/docs/developing-a-simple-function/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/developing-an-aggregate-function/index.html
----------------------------------------------------------------------
diff --git a/docs/developing-an-aggregate-function/index.html b/docs/developing-an-aggregate-function/index.html
index 3fad883..5d6e794 100644
--- a/docs/developing-an-aggregate-function/index.html
+++ b/docs/developing-an-aggregate-function/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/distributed-mode-prerequisites/index.html
----------------------------------------------------------------------
diff --git a/docs/distributed-mode-prerequisites/index.html b/docs/distributed-mode-prerequisites/index.html
index a18631e..0c0cd96 100644
--- a/docs/distributed-mode-prerequisites/index.html
+++ b/docs/distributed-mode-prerequisites/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/drill-default-input-format/index.html
----------------------------------------------------------------------
diff --git a/docs/drill-default-input-format/index.html b/docs/drill-default-input-format/index.html
index 954ea36..8302b8c 100644
--- a/docs/drill-default-input-format/index.html
+++ b/docs/drill-default-input-format/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/drill-explorer-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/drill-explorer-introduction/index.html b/docs/drill-explorer-introduction/index.html
index 43ecf0c..cd8f13c 100644
--- a/docs/drill-explorer-introduction/index.html
+++ b/docs/drill-explorer-introduction/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/drill-in-10-minutes/index.html
----------------------------------------------------------------------
diff --git a/docs/drill-in-10-minutes/index.html b/docs/drill-in-10-minutes/index.html
index 0775d45..269c765 100644
--- a/docs/drill-in-10-minutes/index.html
+++ b/docs/drill-in-10-minutes/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           
@@ -1126,8 +1124,7 @@ Java HotSpot(TM) 64-Bit Server VM (build 24.79-b02, mixed mode)
 <h2 id="query-sample-data">Query Sample Data</h2>
 
 <p>Your Drill installation includes a <code>sample-data</code> directory with JSON and
-Parquet files that you can query. The local file system on your machine is
-configured as the <code>dfs</code> storage plugin instance by default when you install
+Parquet files that you can query. The default <code>dfs</code> storage plugin configuration represents the local file system on your machine when you install
 Drill in embedded mode. For more information about storage plugin
 configuration, refer to <a href="/docs/connect-a-data-source-introduction">Storage Plugin Registration</a>.</p>
 

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/drill-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/drill-introduction/index.html b/docs/drill-introduction/index.html
index 08ec0d8..1216d47 100644
--- a/docs/drill-introduction/index.html
+++ b/docs/drill-introduction/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           
@@ -1044,7 +1042,7 @@ with existing Apache Hive and Apache HBase deployments. </p>
 
 <ul>
 <li>Low-latency SQL queries</li>
-<li>Dynamic queries on self-describing data in files (such as JSON, Parquet, text) and MapR-DB/HBase tables, without requiring metadata definitions in the Hive metastore.</li>
+<li>Dynamic queries on self-describing data in files (such as JSON, Parquet, text) and HBase tables, without requiring metadata definitions in the Hive metastore.</li>
 <li>ANSI SQL</li>
 <li>Nested data support</li>
 <li>Integration with Apache Hive (queries on Hive tables and views, support for all Hive file formats and Hive UDFs)</li>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/drill-patch-review-tool/index.html
----------------------------------------------------------------------
diff --git a/docs/drill-patch-review-tool/index.html b/docs/drill-patch-review-tool/index.html
index e00394b..6b05dab 100644
--- a/docs/drill-patch-review-tool/index.html
+++ b/docs/drill-patch-review-tool/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/drill-plan-syntax/index.html
----------------------------------------------------------------------
diff --git a/docs/drill-plan-syntax/index.html b/docs/drill-plan-syntax/index.html
index 5726306..b08e38e 100644
--- a/docs/drill-plan-syntax/index.html
+++ b/docs/drill-plan-syntax/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/drill-query-execution/index.html
----------------------------------------------------------------------
diff --git a/docs/drill-query-execution/index.html b/docs/drill-query-execution/index.html
index b5d565a..0e37dae 100644
--- a/docs/drill-query-execution/index.html
+++ b/docs/drill-query-execution/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/drop-view/index.html
----------------------------------------------------------------------
diff --git a/docs/drop-view/index.html b/docs/drop-view/index.html
index 26486ed..7150ab1 100644
--- a/docs/drop-view/index.html
+++ b/docs/drop-view/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/embedded-mode-prerequisites/index.html
----------------------------------------------------------------------
diff --git a/docs/embedded-mode-prerequisites/index.html b/docs/embedded-mode-prerequisites/index.html
index bae5c5e..8169b87 100644
--- a/docs/embedded-mode-prerequisites/index.html
+++ b/docs/embedded-mode-prerequisites/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/enabling-query-queuing/index.html
----------------------------------------------------------------------
diff --git a/docs/enabling-query-queuing/index.html b/docs/enabling-query-queuing/index.html
index a05955c..70411ca 100644
--- a/docs/enabling-query-queuing/index.html
+++ b/docs/enabling-query-queuing/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/enron-emails/index.html
----------------------------------------------------------------------
diff --git a/docs/enron-emails/index.html b/docs/enron-emails/index.html
index eb7854f..849ca17 100644
--- a/docs/enron-emails/index.html
+++ b/docs/enron-emails/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/error-messages/index.html
----------------------------------------------------------------------
diff --git a/docs/error-messages/index.html b/docs/error-messages/index.html
index 8b535e6..c2fa994 100644
--- a/docs/error-messages/index.html
+++ b/docs/error-messages/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/explain/index.html
----------------------------------------------------------------------
diff --git a/docs/explain/index.html b/docs/explain/index.html
index 19b63f6..0fac45e 100644
--- a/docs/explain/index.html
+++ b/docs/explain/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/file-system-storage-plugin/index.html
----------------------------------------------------------------------
diff --git a/docs/file-system-storage-plugin/index.html b/docs/file-system-storage-plugin/index.html
index 4bf53e7..7d5634d 100644
--- a/docs/file-system-storage-plugin/index.html
+++ b/docs/file-system-storage-plugin/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           
@@ -1089,8 +1087,8 @@ workspace named <code>json_files</code>. The configuration points Drill to the
 <p>The <code>connection</code> parameter in this configuration is &quot;<code>file:///</code>&quot;, connecting Drill to the local file system.</p>
 
 <p>To query a file in the example <code>json_files</code> workspace, you can issue the <code>USE</code>
-command to tell Drill to use the <code>json_files</code> workspace configured in the <code>dfs</code>
-instance for each query that you issue:</p>
+command to tell Drill to use the <code>json_files</code> workspace, which is included in the <code>dfs</code>
+configuration for each query that you issue:</p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">USE dfs.json_files;
 SELECT * FROM `donuts.json` WHERE type=&#39;frosted&#39;
 </code></pre></div>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/flatten/index.html
----------------------------------------------------------------------
diff --git a/docs/flatten/index.html b/docs/flatten/index.html
index 9963693..48ec997 100644
--- a/docs/flatten/index.html
+++ b/docs/flatten/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/from-clause/index.html
----------------------------------------------------------------------
diff --git a/docs/from-clause/index.html b/docs/from-clause/index.html
index f558459..09ffa9f 100644
--- a/docs/from-clause/index.html
+++ b/docs/from-clause/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/functions-for-handling-nulls/index.html
----------------------------------------------------------------------
diff --git a/docs/functions-for-handling-nulls/index.html b/docs/functions-for-handling-nulls/index.html
index f8bc9af..ce2f7ba 100644
--- a/docs/functions-for-handling-nulls/index.html
+++ b/docs/functions-for-handling-nulls/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/getting-started/index.html
----------------------------------------------------------------------
diff --git a/docs/getting-started/index.html b/docs/getting-started/index.html
index 18f93e7..9623005 100644
--- a/docs/getting-started/index.html
+++ b/docs/getting-started/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/getting-to-know-the-drill-sandbox/index.html
----------------------------------------------------------------------
diff --git a/docs/getting-to-know-the-drill-sandbox/index.html b/docs/getting-to-know-the-drill-sandbox/index.html
index bed40ba..f4a7971 100644
--- a/docs/getting-to-know-the-drill-sandbox/index.html
+++ b/docs/getting-to-know-the-drill-sandbox/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           
@@ -1032,7 +1030,7 @@ apache drill 1.1.0
 
 <p><img src="/docs/img/get2kno_plugin.png" alt="sandbox plugin"></p>
 
-<p>You see the following storage plugin controls:</p>
+<p>You see the following storage plugin configurations:</p>
 
 <ul>
 <li>cp</li>
@@ -1045,7 +1043,7 @@ apache drill 1.1.0
 
 <p>Click Update to examine a configuration. </p>
 
-<p>If you&#39;ve used an installation of Drill before using the sandbox, you might notice that a few storage plugins in the sandbox differ from the same storage plugin in a Drill installation. The sandbox version of dfs, hive, maprdb, and hbase storage plugins definitions play a role in simulating the cluster environment for running the tutorial. </p>
+<p>If you&#39;ve used an installation of Drill before using the sandbox, you might notice that a few storage plugin configurations in the sandbox differ from the same storage plugin configurations in a Drill installation. The sandbox configurations of dfs, hive, maprdb, and hbase storage plugins definitions play a role in simulating the cluster environment for running the tutorial. </p>
 
 <h3 id="dfs">dfs</h3>
 
@@ -1061,7 +1059,7 @@ location in MapR-FS:</p>
 <li>views: a workspace for creating views</li>
 </ul>
 
-<p>The <code>dfs</code> definition includes format definitions.</p>
+<p>The <code>dfs</code> configuration includes format definitions.</p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">{
   &quot;type&quot;: &quot;file&quot;,
   &quot;enabled&quot;: true,
@@ -1098,11 +1096,11 @@ location in MapR-FS:</p>
 </code></pre></div>
 <h3 id="maprdb">maprdb</h3>
 
-<p>The maprdb format is a configuration for MapR-DB in the sandbox. You use this format in the sandbox to query MapR-DB/HBase tables. </p>
+<p>The maprdb is a configuration for MapR-DB in the sandbox. You use this format in the sandbox to query MapR-DB/HBase tables. </p>
 
 <h3 id="hive">hive</h3>
 
-<p>The hive storage plugin is a configuration for a Hive data warehouse within the sandbox.
+<p>The hive configuration for a Hive data warehouse within the sandbox.
 Drill connects to the Hive metastore by using the configured metastore thrift
 URI. Metadata for Hive tables is automatically available for users to query.</p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">{
@@ -1114,22 +1112,7 @@ URI. Metadata for Hive tables is automatically available for users to query.</p>
   }
 }
 </code></pre></div>
-<h2 id="use-case-overview">Use Case Overview</h2>
-
-<p>This section describes the use case that serves as the basis for the tutorial. Imagine being an analyst with basic SQL skills who works for an
-emerging online retail business. The business accepts purchases from its customers
-through both an established web-based interface and a new mobile application.</p>
-
-<p>Your job is data-driven and independent with little or no interaction with the IT department. Recently the central IT team
-has implemented a Hadoop-based infrastructure to reduce the cost of the legacy
-database system, and most of the DWH/ETL workload is now handled by
-Hadoop/Hive. MapR-DB manages the master customer profile information and product catalog. MapR-DB is a NoSQL database. The IT team has also started
-acquiring clickstream data that comes from web and mobile applications. This
-data is stored in Hadoop as JSON files.</p>
-
-<p>You have a number of data sources to explore.  For example, analyzing customer records in the clickstream data and tying them to the master customer data in MapR-DB might yield some potentially interesting analytical connections. You decide to explore various data sources by using Apache Drill. You need Apache Drill to provide flexibility and analytic capability.</p>
-
-<h1 id="what&#39;s-next">What&#39;s Next</h1>
+<h2 id="what&#39;s-next">What&#39;s Next</h2>
 
 <p>Start running queries by going to <a href="/docs/lesson-1-learn-about-the-data-set">Lesson 1: Learn About the Data
 Set</a>.</p>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/group-by-clause/index.html
----------------------------------------------------------------------
diff --git a/docs/group-by-clause/index.html b/docs/group-by-clause/index.html
index 74c53e2..085a5ad 100644
--- a/docs/group-by-clause/index.html
+++ b/docs/group-by-clause/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/guidelines-for-optimizing-aggregation/index.html
----------------------------------------------------------------------
diff --git a/docs/guidelines-for-optimizing-aggregation/index.html b/docs/guidelines-for-optimizing-aggregation/index.html
index fff41de..49c0bed 100644
--- a/docs/guidelines-for-optimizing-aggregation/index.html
+++ b/docs/guidelines-for-optimizing-aggregation/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/handling-different-data-types/index.html
----------------------------------------------------------------------
diff --git a/docs/handling-different-data-types/index.html b/docs/handling-different-data-types/index.html
index c7b7dbb..afd3d73 100644
--- a/docs/handling-different-data-types/index.html
+++ b/docs/handling-different-data-types/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/having-clause/index.html
----------------------------------------------------------------------
diff --git a/docs/having-clause/index.html b/docs/having-clause/index.html
index 2323700..ad78407 100644
--- a/docs/having-clause/index.html
+++ b/docs/having-clause/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/hbase-storage-plugin/index.html
----------------------------------------------------------------------
diff --git a/docs/hbase-storage-plugin/index.html b/docs/hbase-storage-plugin/index.html
index c16d872..b928427 100644
--- a/docs/hbase-storage-plugin/index.html
+++ b/docs/hbase-storage-plugin/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/hive-storage-plugin/index.html
----------------------------------------------------------------------
diff --git a/docs/hive-storage-plugin/index.html b/docs/hive-storage-plugin/index.html
index 499348c..5e7faa8 100644
--- a/docs/hive-storage-plugin/index.html
+++ b/docs/hive-storage-plugin/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           
@@ -1031,7 +1029,7 @@ in a Hive storage plugin configuration to configure a connection to Drill.</p>
 <li>Issue the following command to start the Hive metastore service on the system specified in the <code>hive.metastore.uris</code>:
 <code>hive --service metastore</code></li>
 <li>In the <a href="/docs/plugin-configuration-basics/#using-the-drill-web-ui">Drill Web UI</a>, select the <strong>Storage</strong> tab.</li>
-<li><p>In the list of disabled storage plugins in the Drill Web UI, click <strong>Update</strong> next to the <code>hive</code> instance. For example:</p>
+<li><p>In the list of disabled storage plugins in the Drill Web UI, click <strong>Update</strong> next to <code>hive</code>. The Hive storage plugin configuration appears:</p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">{
   &quot;type&quot;: &quot;hive&quot;,
   &quot;enabled&quot;: false,
@@ -1056,11 +1054,7 @@ in a Hive storage plugin configuration to configure a connection to Drill.</p>
 <li><code>hdfs://</code></li>
 <li><code>hdfs://&lt;hostname&gt;:&lt;port&gt;</code></li>
 </ul></li>
-<li><p>If you are running Drill and Hive in a secure MapR cluster, remove the following line from the configuration:<br>
-<code>&quot;hive.metastore.sasl.enabled&quot; : &quot;false&quot;</code></p></li>
 <li><p>Click <strong>Enable</strong>.  </p></li>
-<li><p>If you are running Drill and Hive in a secure MapR cluster, add the following line to <code>&lt;DRILL_HOME&gt;/conf/drill-env.sh</code> on each Drill node and then <a href="/docs/starting-drill-in-distributed-mode/">restart the Drillbit service</a>:<br>
-<code>export DRILL_JAVA_OPTS=&quot;$DRILL_JAVA_OPTS -Dmapr_sec_enabled=true -Dhadoop.login=maprsasl -Dzookeeper.saslprovider=com.mapr.security.maprsasl.MaprSaslProvider -Dmapr.library.flatclass&quot;</code></p></li>
 </ol>
 
 <p>After configuring a Hive storage plugin, you can <a href="/docs/querying-hive/">query Hive tables</a>.</p>
@@ -1077,7 +1071,7 @@ steps:</p>
 
 <ol>
 <li>In the <a href="/docs/plugin-configuration-basics/#using-the-drill-web-ui">Drill Web UI</a>, and select the <strong>Storage</strong> tab.</li>
-<li>In the disabled storage plugins section, click <strong>Update</strong> next to <code>hive</code> instance.</li>
+<li>In the disabled storage plugin configurations section, click <strong>Update</strong> next to <code>hive</code>.</li>
 <li><p>In the configuration window, add the database configuration settings.</p>
 
 <p><strong>Example</strong></p>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/hive-to-drill-data-type-mapping/index.html
----------------------------------------------------------------------
diff --git a/docs/hive-to-drill-data-type-mapping/index.html b/docs/hive-to-drill-data-type-mapping/index.html
index 3c8edff..69262d5 100644
--- a/docs/hive-to-drill-data-type-mapping/index.html
+++ b/docs/hive-to-drill-data-type-mapping/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           
@@ -1057,14 +1055,9 @@
 <td>1-, 2-, or 4-byte signed integer</td>
 </tr>
 <tr>
-<td>INTERVALDAY</td>
-<td>N/A</td>
-<td>Integer fields representing a day</td>
-</tr>
-<tr>
-<td>INTERVALYEAR</td>
+<td>INTERVAL</td>
 <td>N/A</td>
-<td>Integer fields representing a year</td>
+<td>A day-time or year-month interval</td>
 </tr>
 <tr>
 <td>TIME</td>
@@ -1112,7 +1105,13 @@
 <li>UNION</li>
 </ul>
 
-<p>The Hive version used in MapR supports the Hive timestamp in Unix Epoch format. Currently, the Apache Hive version used by Drill does not support this timestamp format. The workaround is to use the JDBC format for the timestamp, which Hive accepts and Drill uses, as shown in the following type mapping example. The timestamp value appears in the example CSV file in JDBC format: 2015-03-25 01:23:15. The Hive table defines column i in the CREATE EXTERNAL TABLE command as a timestamp column. The Drill extract function verifies that Drill interprets the timestamp correctly.</p>
+<p>Currently, the Apache Hive version used by Drill does not support the Hive timestamp in Unix Epoch format. The workaround is to use the JDBC format for the timestamp, which Hive accepts and Drill uses. The type mapping example shows how to use the workaround as follows. </p>
+
+<ul>
+<li>The timestamp value appears in the example CSV file in JDBC format: 2015-03-25 01:23:15.<br></li>
+<li>Workaround: The Hive table defines column i in the CREATE EXTERNAL TABLE command as a timestamp column.<br></li>
+<li>The Drill extract function verifies that Drill interprets the timestamp correctly.</li>
+</ul>
 
 <h2 id="type-mapping-example">Type Mapping Example</h2>
 
@@ -1124,7 +1123,7 @@
 <p>The example makes the following assumptions:</p>
 
 <ul>
-<li>The CSV resides on the MapR file system (MapRFS) in the Drill sandbox: <code>/mapr/demo.mapr.com/data/</code><br></li>
+<li>The CSV resides in the following location in the Drill sandbox: <code>/mapr/demo.mapr.com/data/</code><br></li>
 <li>You <a href="/docs/supported-data-types#enabling-the-decimal-type">enabled the DECIMAL data type</a> in Drill.<br></li>
 </ul>
 

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/how-to-run-the-drill-demo/index.html
----------------------------------------------------------------------
diff --git a/docs/how-to-run-the-drill-demo/index.html b/docs/how-to-run-the-drill-demo/index.html
index 8250e82..36c435e 100644
--- a/docs/how-to-run-the-drill-demo/index.html
+++ b/docs/how-to-run-the-drill-demo/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/1ad8cc8c/docs/identifying-performance-issues/index.html
----------------------------------------------------------------------
diff --git a/docs/identifying-performance-issues/index.html b/docs/identifying-performance-issues/index.html
index f3872b6..8a8abcd 100644
--- a/docs/identifying-performance-issues/index.html
+++ b/docs/identifying-performance-issues/index.html
@@ -436,8 +436,6 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li>
-              
             </ul>
             
           


Mime
View raw message