drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject svn commit: r1671986 - in /drill/site/trunk/content/drill: ./ docs/analyzing-yelp-json-data-with-apache-drill/ docs/apache-drill-tutorial/ docs/data-type-conversion/ docs/date-time-and-timestamp/ docs/date-time-functions-and-arithmetic/ docs/mapr-db-fo...
Date Wed, 08 Apr 2015 00:46:37 GMT
Author: bridgetb
Date: Wed Apr  8 00:46:36 2015
New Revision: 1671986

URL: http://svn.apache.org/r1671986
Log:
DRILL-2706: sql functions doc review feedback

Modified:
    drill/site/trunk/content/drill/docs/analyzing-yelp-json-data-with-apache-drill/index.html
    drill/site/trunk/content/drill/docs/apache-drill-tutorial/index.html
    drill/site/trunk/content/drill/docs/data-type-conversion/index.html
    drill/site/trunk/content/drill/docs/date-time-and-timestamp/index.html
    drill/site/trunk/content/drill/docs/date-time-functions-and-arithmetic/index.html
    drill/site/trunk/content/drill/docs/mapr-db-format/index.html
    drill/site/trunk/content/drill/docs/math-and-trig/index.html
    drill/site/trunk/content/drill/docs/sql-functions/index.html
    drill/site/trunk/content/drill/docs/string-manipulation/index.html
    drill/site/trunk/content/drill/feed.xml

Modified: drill/site/trunk/content/drill/docs/analyzing-yelp-json-data-with-apache-drill/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/analyzing-yelp-json-data-with-apache-drill/index.html?rev=1671986&r1=1671985&r2=1671986&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/analyzing-yelp-json-data-with-apache-drill/index.html (original)
+++ drill/site/trunk/content/drill/docs/analyzing-yelp-json-data-with-apache-drill/index.html Wed Apr  8 00:46:36 2015
@@ -88,7 +88,7 @@ example is downloadable from <a href="ht
 
 <h3 id="step-1:-download-apache-drill-onto-your-local-machine">Step 1: Download Apache Drill onto your local machine</h3>
 
-<p><a href="http://incubator.apache.org/drill/download/">http://incubator.apache.org/drill/download/</a></p>
+<p><a href="http://drill.apache.org/download/">http://drill.apache.org/download/</a></p>
 
 <p>You can also <a href="/docs/deploying-apache-drill-in-a-clustered-environment">deploy Drill in clustered mode</a> if you
 want to scale your environment.</p>

Modified: drill/site/trunk/content/drill/docs/apache-drill-tutorial/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/apache-drill-tutorial/index.html?rev=1671986&r1=1671985&r2=1671986&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/apache-drill-tutorial/index.html (original)
+++ drill/site/trunk/content/drill/docs/apache-drill-tutorial/index.html Wed Apr  8 00:46:36 2015
@@ -109,7 +109,7 @@ be used to get an overview on Apache Dri
 and technical analysts, product managers, and developers can use the sandbox
 environment to get a feel for the power and capabilities of Apache Drill by
 performing various types of queries. Once you get a flavor for the technology,
-refer to the <a href="http://incubator.apache.org/drill/">Apache Drill web site</a> and
+refer to the <a href="http://drill.apache.org">Apache Drill web site</a> and
 <a href="/docs">Apache Drill documentation
 </a>for more
 details.</p>

Modified: drill/site/trunk/content/drill/docs/data-type-conversion/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/data-type-conversion/index.html?rev=1671986&r1=1671985&r2=1671986&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/data-type-conversion/index.html (original)
+++ drill/site/trunk/content/drill/docs/data-type-conversion/index.html Wed Apr  8 00:46:36 2015
@@ -72,6 +72,7 @@
 <ul>
 <li><a href="/docs/data-type-conversion#cast">CAST</a></li>
 <li><a href="/docs/data-type-conversion#convert_to-and-convert_from">CONVERT_TO and CONVERT_FROM</a></li>
+<li><a href="/docs/data-type-conversion#other-data-type-conversions">Other Data Type Conversions</a></li>
 </ul>
 
 <h2 id="cast">CAST</h2>
@@ -112,7 +113,7 @@
 <p>You cannot cast a character string that includes a decimal point to an INT or BIGINT. For example, if you have &quot;1200.50&quot; in a JSON file, attempting to select and cast the string to an INT fails. As a workaround, cast to a FLOAT or DECIMAL type, and then to an INT. </p>
 
 <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.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CAST(&#39;1&#39; as DECIMAL(28, 2)) FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -122,7 +123,7 @@
 <h4 id="casting-a-number-to-a-character-string">Casting a number to a character string</h4>
 
 <p>The first example shows that Drill uses a default limit of 1 character if you omit the VARCHAR limit: The result is truncated to 1 character.  The second example casts the same number to a VARCHAR having a limit of 3 characters: The result is a 3-character string, 456. The third example shows that you can use CHAR as an alias for VARCHAR. You can also use CHARACTER or CHARACTER VARYING.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CAST(456 as VARCHAR) FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CAST(456 as VARCHAR) FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -130,7 +131,7 @@
 +------------+
 1 row selected (0.063 seconds)
 
-SELECT CAST(456 as VARCHAR(3)) FROM sys.drillbits;
+SELECT CAST(456 as VARCHAR(3)) FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -138,7 +139,7 @@ SELECT CAST(456 as VARCHAR(3)) FROM sys.
 +------------+
 1 row selected (0.08 seconds)
 
-SELECT CAST(456 as CHAR(3)) FROM sys.drillbits;
+SELECT CAST(456 as CHAR(3)) FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -149,7 +150,7 @@ SELECT CAST(456 as CHAR(3)) FROM sys.dri
 <h4 id="casting-from-one-numerical-type-to-another">Casting from one numerical type to another</h4>
 
 <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.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CAST(-2147483648 AS DECIMAL(28,8)) FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -519,7 +520,7 @@ FROM tmp.`json2parquet2`;
 
 <ol>
 <li><p>Take a look at the Drill time zone configuration by running the TIMEOFDAY function. This 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.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TIMEOFDAY() FROM sys.version;
 
 +------------+
 |   EXPR$0   |
@@ -528,12 +529,16 @@ FROM tmp.`json2parquet2`;
 +------------+
 1 row selected (1.199 seconds)
 </code></pre></div></li>
-<li><p>Configure the default time zone format in <drill installation directory>/conf/drill-env.sh by adding <code>-Duser.timezone=UTC</code> to DRILL_JAVA_OPTS. For example:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">export DRILL_JAVA_OPTS=&quot;-Xms1G -Xmx$DRILL_MAX_HEAP -XX:MaxDirectMemorySize=$DRILL_MAX_DIRECT_MEMORY -XX:MaxPermSize=512M -XX:ReservedCodeCacheSize=1G -ea -Duser.timezone=UTC&quot;
+<li><p>Configure the default time zone format in the drill-override.conf. For example:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">drill.exec: {
+  cluster-id: “xyz&quot;,
+  zk.connect: “abc:5181&quot;,
+  user.timezone: &quot;UTC&quot;
+}
 </code></pre></div></li>
 <li><p>Restart sqlline.</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.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TIMEOFDAY() FROM sys.version;
 
 +------------+
 |   EXPR$0   |
@@ -587,10 +592,18 @@ use in your Drill queries as described i
 </tr>
 </tbody></table>
 
-<!-- A character string to a timestamp with time zone
-
-A decimal type to a timestamp with time zone -->
+<p>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;
 
++------------+------------+
+|  Original  |  TimeZone  |
++------------+------------+
+| 2015-03-30 20:49:00.0 | UTC        |
++------------+------------+
+1 row selected (0.299 seconds)
+</code></pre></div>
 <h3 id="format-specifiers-for-numerical-conversions">Format Specifiers for Numerical Conversions</h3>
 
 <p>Use the following format specifiers for numerical conversions:
@@ -820,7 +833,7 @@ A decimal type to a timestamp with time
 <h3 id="examples">Examples</h3>
 
 <p>Convert a FLOAT to a character string.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_CHAR(125.789383, &#39;#,###.###&#39;) FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_CHAR(125.789383, &#39;#,###.###&#39;) FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -828,7 +841,7 @@ A decimal type to a timestamp with time
 +------------+
 </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(125, &#39;#,###.###&#39;) FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_CHAR(125, &#39;#,###.###&#39;) FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -837,7 +850,7 @@ A decimal type to a timestamp with time
 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.drillbits;
+<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;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -845,7 +858,7 @@ A decimal type to a timestamp with time
 +------------+
 </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.drillbits;
+<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;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -854,7 +867,7 @@ A decimal type to a timestamp with time
 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.drillbits;
+<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;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -873,19 +886,42 @@ A decimal type to a timestamp with time
 
 <p><em>&#39;format&#39;</em> is a format specifier enclosed in single quotation marks that sets a pattern for the output formatting. Use this option only when the expression is a character string, not a UNIX epoch timestamp. </p>
 
-<h3 id="usage">Usage</h3>
+<h3 id="usage-notes">Usage Notes</h3>
 
 <p>Specify a format using patterns defined in <a href="http://joda-time.sourceforge.net/apidocs/org/joda/time/format/DateTimeFormat.html">Java DateTimeFormat class</a>. The TO_TIMESTAMP function takes a Unix epoch timestamp. The TO_DATE function takes a UNIX epoch timestamp in milliseconds.</p>
 
 <p>To compare dates in the WHERE clause, use TO_DATE on the value in the date column and in the comparison value. For example:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT &lt;fields&gt; FROM &lt;plugin&gt; WHERE TO_DATE(&lt;column&gt;, &lt;format&gt;) &lt;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT &lt;fields&gt; FROM &lt;plugin&gt; WHERE TO_DATE(&lt;field&gt;, &lt;format&gt;) &lt; TO_DATE (&lt;value&gt;, &lt;format&gt;);
 </code></pre></div>
-<p>TO_DATE(<value>, <format>);</p>
+<p>For example:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_DATE(`date`, &#39;yyyy-MM-dd&#39;) FROM `sample.json`;
+
++------------+
+|   EXPR$0   |
++------------+
+| 2013-07-26 |
+| 2013-05-16 |
+| 2013-06-09 |
+| 2013-07-19 |
+| 2013-07-21 |
++------------+
+5 rows selected (0.134 seconds)
+
+SELECT TO_DATE(`date`, &#39;yyyy-MM-dd&#39;) FROM `sample.json` WHERE TO_DATE(`date`, &#39;yyyy-MM-dd&#39;) &lt; TO_DATE(&#39;2013-07-20&#39;, &#39;yyyy-MM-dd&#39;);
 
++------------+
+|   EXPR$0   |
++------------+
+| 2013-05-16 |
+| 2013-06-09 |
+| 2013-07-19 |
++------------+
+3 rows selected (0.177 seconds)
+</code></pre></div>
 <h3 id="examples">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.drillbits;
+<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;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -893,7 +929,7 @@ A decimal type to a timestamp with time
 +------------+
 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.drillbits);
+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);
 
 +------------+
 |   myyear   |
@@ -903,7 +939,7 @@ SELECT EXTRACT(year from mydate) `extrac
 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.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_DATE(1427849046000) FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -939,14 +975,14 @@ Exponent. Separates mantissa and exponen
 </ul>
 
 <h3 id="examples">Examples</h3>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_NUMBER(&#39;987,966&#39;, &#39;######&#39;) FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_NUMBER(&#39;987,966&#39;, &#39;######&#39;) FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
 | 987.0      |
 +------------+
 
-SELECT TO_NUMBER(&#39;987.966&#39;, &#39;###.###&#39;) FROM sys.drillbits;
+SELECT TO_NUMBER(&#39;987.966&#39;, &#39;###.###&#39;) FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -954,7 +990,7 @@ SELECT TO_NUMBER(&#39;987.966&#39;, &#39
 +------------+
 1 row selected (0.063 seconds)
 
-SELECT TO_NUMBER(&#39;12345&#39;, &#39;##0.##E0&#39;) FROM sys.drillbits;
+SELECT TO_NUMBER(&#39;12345&#39;, &#39;##0.##E0&#39;) FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -978,7 +1014,7 @@ SELECT TO_NUMBER(&#39;12345&#39;, &#39;#
 <p>Specify a format using patterns defined in <a href="http://joda-time.sourceforge.net/apidocs/org/joda/time/format/DateTimeFormat.html">Java DateTimeFormat class</a>.</p>
 
 <h3 id="examples">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.drillbits;
+<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;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -987,7 +1023,7 @@ SELECT TO_NUMBER(&#39;12345&#39;, &#39;#
 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.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT to_time(82855000) FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1011,7 +1047,7 @@ SELECT TO_NUMBER(&#39;12345&#39;, &#39;#
 <h3 id="examples">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.drillbits;
+<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;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1019,7 +1055,7 @@ SELECT TO_NUMBER(&#39;12345&#39;, &#39;#
 +------------+
 </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.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TO_TIMESTAMP(1427936330) FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -1030,7 +1066,7 @@ SELECT TO_NUMBER(&#39;12345&#39;, &#39;#
 <p>Connvert 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.drillbits;
+FROM sys.version;
 
 +------------+------------+
 |  Original  |   New_TZ   |

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=1671986&r1=1671985&r2=1671986&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 Wed Apr  8 00:46:36 2015
@@ -77,7 +77,7 @@
 <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.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT date &#39;2010-2-15&#39; FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -85,7 +85,7 @@
 +------------+
 1 row selected (0.083 seconds)
 
-SELECT time &#39;15:20:30&#39; from sys.drillbits;
+SELECT time &#39;15:20:30&#39; from sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -93,7 +93,7 @@ SELECT time &#39;15:20:30&#39; from sys.
 +------------+
 1 row selected (0.067 seconds)
 
-SELECT timestamp &#39;2015-03-11 6:50:08&#39; FROM sys.drillbits;
+SELECT timestamp &#39;2015-03-11 6:50:08&#39; FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -129,7 +129,7 @@ P [qty] Y [qty] M
 <p>The format of INTERVAL data in the data source differs from the query format. </p>
 
 <p>You can run the query described earlier to check the formatting of the fields. The input to the following SELECT statements show how to format INTERVAL data in the query. The output shows how to format the data in the data source.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT INTERVAL &#39;1 10:20:30.123&#39; day to second FROM sys.drillbits;
+<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;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -137,7 +137,7 @@ P [qty] Y [qty] M
 +------------+
 1 row selected (0.054 seconds)
 
-SELECT INTERVAL &#39;1-2&#39; year to month FROM sys.drillbits;
+SELECT INTERVAL &#39;1-2&#39; year to month FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -145,7 +145,7 @@ SELECT INTERVAL &#39;1-2&#39; year to mo
 +------------+
 1 row selected (0.927 seconds)
 
-SELECT INTERVAL &#39;1&#39; year FROM sys.drillbits;
+SELECT INTERVAL &#39;1&#39; year FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -153,7 +153,7 @@ SELECT INTERVAL &#39;1&#39; year FROM sy
 +------------+
 1 row selected (0.088 seconds)
 
-SELECT INTERVAL &#39;13&#39; month FROM sys.drillbits;
+SELECT INTERVAL &#39;13&#39; month FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+

Modified: drill/site/trunk/content/drill/docs/date-time-functions-and-arithmetic/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/date-time-functions-and-arithmetic/index.html?rev=1671986&r1=1671985&r2=1671986&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/date-time-functions-and-arithmetic/index.html (original)
+++ drill/site/trunk/content/drill/docs/date-time-functions-and-arithmetic/index.html Wed Apr  8 00:46:36 2015
@@ -165,7 +165,7 @@
 <h4 id="examples">Examples</h4>
 
 <p>Find the interval between midnight 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.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT AGE(&#39;1957-06-13&#39;) FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -174,7 +174,7 @@
 1 row selected (0.064 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.drillbits;
+<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;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -199,7 +199,7 @@
 <h4 id="examples">Examples</h4>
 
 <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.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT EXTRACT(day FROM NOW()), EXTRACT(day FROM CURRENT_DATE) FROM sys.version;
 
 +------------+------------+
 |   EXPR$0   |   EXPR$1   |
@@ -209,7 +209,7 @@
 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.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT EXTRACT(hour FROM CURRENT_DATE) FROM sys.version;
 
 +------------+
 |   EXPR$0   |
@@ -218,7 +218,7 @@
 +------------+
 </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.drillbits;
+<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;
 
 +------------+
 |   EXPR$0   |
@@ -228,7 +228,7 @@
 1 row selected (0.056 seconds)
 </code></pre></div>
 <p>What is the second 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.drillbits;
+<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;
 
 +------------+
 |   EXPR$0   |
@@ -245,7 +245,7 @@
 <div class="highlight"><pre><code class="language-text" data-lang="text">DATE_ADD(date, interval);
 </code></pre></div>
 <h4 id="example">Example</h4>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CAST(DATE_ADD(datetype(2008, 2, 27), intervaltype(0, 1, 0, 0, 0, 0, 0)) as VARCHAR(100)) FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CAST(DATE_ADD(datetype(2008, 2, 27), intervaltype(0, 1, 0, 0, 0, 0, 0)) as VARCHAR(100)) FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -269,7 +269,7 @@
 <p>Use Unix Epoch timestamp in milliseconds as the expression to get the field of a timestamp.</p>
 
 <h4 id="examples">Examples</h4>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_PART(&#39;day&#39;, &#39;2015-04-02&#39;) FROM sys.drillbits;
+<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;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -277,7 +277,7 @@
 +------------+
 1 row selected (0.098 seconds)
 
-SELECT DATE_PART(&#39;hour&#39;, &#39;23:14:30.076&#39;) FROM sys.drillbits;
+SELECT DATE_PART(&#39;hour&#39;, &#39;23:14:30.076&#39;) FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -286,7 +286,7 @@ SELECT DATE_PART(&#39;hour&#39;, &#39;23
 1 row selected (0.088 seconds)
 </code></pre></div>
 <p>Find the hour part of the timestamp for April 2, 2015 23:25:43. Use Unix Epoch timestamp in milliseconds, which is 1428017143000 in UTC.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_PART(&#39;hour&#39;, 1428017143000) FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT DATE_PART(&#39;hour&#39;, 1428017143000) FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -295,7 +295,7 @@ SELECT DATE_PART(&#39;hour&#39;, &#39;23
 1 row selected (0.07 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.drillbits;
+<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;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -311,7 +311,7 @@ SELECT DATE_PART(&#39;hour&#39;, &#39;23
 <div class="highlight"><pre><code class="language-text" data-lang="text">DATE_SUB(date, interval);
 </code></pre></div>
 <h4 id="example">Example</h4>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CAST(DATE_SUB(datetype(2008, 2, 27), intervaltype(0, 1, 0, 0, 0, 0, 0)) as VARCHAR(100)) FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CAST(DATE_SUB(datetype(2008, 2, 27), intervaltype(0, 1, 0, 0, 0, 0, 0)) as VARCHAR(100)) FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -334,7 +334,7 @@ SELECT DATE_PART(&#39;hour&#39;, &#39;23
 </ul>
 
 <p>The following examples show how to use the utilities:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CURRENT_DATE FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CURRENT_DATE FROM sys.version;
 +--------------+
 | current_date |
 +--------------+
@@ -342,7 +342,7 @@ SELECT DATE_PART(&#39;hour&#39;, &#39;23
 +--------------+
 1 row selected (0.077 seconds)
 
-SELECT CURRENT_TIME FROM sys.drillbits;
+SELECT CURRENT_TIME FROM sys.version;
 +--------------+
 | current_time |
 +--------------+
@@ -350,7 +350,7 @@ SELECT CURRENT_TIME FROM sys.drillbits;
 +--------------+
 1 row selected (0.073 seconds)
 
-SELECT CURRENT_TIMESTAMP FROM sys.drillbits;
+SELECT CURRENT_TIMESTAMP FROM sys.version;
 +-------------------+
 | current_timestamp |
 +-------------------+
@@ -358,7 +358,7 @@ SELECT CURRENT_TIMESTAMP FROM sys.drillb
 +-------------------+
 1 row selected (0.061 seconds)
 
-SELECT LOCALTIME FROM sys.drillbits;
+SELECT LOCALTIME FROM sys.version;
 
 +------------+
 | localtime  |
@@ -367,7 +367,7 @@ SELECT LOCALTIME FROM sys.drillbits;
 +------------+
 1 row selected (0.051 seconds)
 
-SELECT LOCALTIMESTAMP FROM sys.drillbits;
+SELECT LOCALTIMESTAMP FROM sys.version;
 
 +----------------+
 | LOCALTIMESTAMP |
@@ -376,7 +376,7 @@ SELECT LOCALTIMESTAMP FROM sys.drillbits
 +----------------+
 1 row selected (0.105 seconds)
 
-SELECT NOW() FROM sys.drillbits;
+SELECT NOW() FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -385,7 +385,7 @@ SELECT NOW() FROM sys.drillbits;
 1 row selected (0.05 seconds)
 </code></pre></div>
 <p>If you set up Drill for <a href="/docs/casting-converting-data-types/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.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TIMEOFDAY() FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -394,7 +394,7 @@ SELECT NOW() FROM sys.drillbits;
 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.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TIMEOFDAY() FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -408,7 +408,7 @@ SELECT NOW() FROM sys.drillbits;
 date + interval  -->
 
 <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.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT EXTRACT(day FROM NOW()) = EXTRACT(day FROM CURRENT_DATE) FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -417,7 +417,7 @@ date + interval  -->
 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.drillbits;
+<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;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -426,7 +426,7 @@ date + interval  -->
 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.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT EXTRACT(hour FROM CURRENT_DATE) = 2 FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+

Modified: drill/site/trunk/content/drill/docs/mapr-db-format/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/mapr-db-format/index.html?rev=1671986&r1=1671985&r2=1671986&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/mapr-db-format/index.html (original)
+++ drill/site/trunk/content/drill/docs/mapr-db-format/index.html Wed Apr  8 00:46:36 2015
@@ -67,7 +67,7 @@
 
 </div>
 
-<div class="int_text" align="left"><p>Drill includes a <code>maprdb</code> format plugin for handling MapR-DB and HBase data. The Drill Sandbox also includes the following <code>maprdb</code> storage plugin on a MapR node:</p>
+<div class="int_text" align="left"><p>Drill includes a <code>maprdb</code> format plugin for handling MapR-DB and HBase data. The Drill Sandbox also includes the following <code>maprdb</code> format plugin on a MapR node:</p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">{
   &quot;type&quot;: &quot;hbase&quot;,
   &quot;config&quot;: {
@@ -77,7 +77,7 @@
   &quot;enabled&quot;: true
 }
 </code></pre></div>
-<p>Using the Sandbox and this <code>maprdb</code> storage plugin, you can query HBase tables located in the <code>/tables</code> directory, as shown in the <a href="/docs/querying-hbase">&quot;Query HBase&quot;</a> examples.</p>
+<p>Using the Sandbox and this <code>maprdb</code> format plugin, you can query HBase tables located in the <code>/tables</code> directory, as shown in the <a href="/docs/querying-hbase">&quot;Query HBase&quot;</a> examples.</p>
 
 <p>The <code>dfs</code> storage plugin includes the maprdb format when you install Drill from the <code>mapr-drill</code> package on a MapR node. Click <strong>Update</strong> next to the <code>dfs</code> instance
 in the Web UI of the Drill Sandbox to view the configuration for the <code>dfs</code> instance:</p>

Modified: drill/site/trunk/content/drill/docs/math-and-trig/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/math-and-trig/index.html?rev=1671986&r1=1671985&r2=1671986&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/math-and-trig/index.html (original)
+++ drill/site/trunk/content/drill/docs/math-and-trig/index.html Wed Apr  8 00:46:36 2015
@@ -342,7 +342,7 @@ SELECT ROUND(`float`, 4) FROM dfs.`/User
 <h2 id="log-examples">Log Examples</h2>
 
 <p>Get the base 2 log of 64.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT log(2, 64) FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT log(2, 64) FROM sys.version;
 
 +------------+
 |   EXPR$0   |
@@ -352,7 +352,7 @@ SELECT ROUND(`float`, 4) FROM dfs.`/User
 1 row selected (0.069 seconds)
 </code></pre></div>
 <p>Get the common log of 100.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT log10(100) FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT log10(100) FROM sys.version;
 
 +------------+
 |   EXPR$0   |
@@ -362,7 +362,7 @@ SELECT ROUND(`float`, 4) FROM dfs.`/User
 1 row selected (0.203 seconds)
 </code></pre></div>
 <p>Get the natural log of 7.5.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT log(7.5) FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT log(7.5) FROM sys.version;
 
 +------------+
 |   EXPR$0   |
@@ -399,7 +399,7 @@ Hyperbolic tangent of hyperbolic angle x
 <p><strong>Examples</strong></p>
 
 <p>Find the sine and tangent of a 45 degree angle. First convert degrees to radians for use in the SIN() function.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT RADIANS(30) AS Degrees FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT RADIANS(30) AS Degrees FROM sys.version;
 
 +------------+
 |  Degrees   |
@@ -408,7 +408,7 @@ Hyperbolic tangent of hyperbolic angle x
 +------------+
 1 row selected (0.045 seconds)
 
-SELECT SIN(0.7853981633974483) AS `Sine of 30 degrees` FROM sys.drillbits;
+SELECT SIN(0.7853981633974483) AS `Sine of 30 degrees` FROM sys.version;
 
 +-----------------------+
 |  Sine of 45 degrees   |
@@ -417,7 +417,7 @@ SELECT SIN(0.7853981633974483) AS `Sine
 +-----------------------+
 1 row selected (0.059 seconds)
 
-SELECT TAN(0.7853981633974483) AS `Tangent of 30 degrees` from sys.drillbits;
+SELECT TAN(0.7853981633974483) AS `Tangent of 30 degrees` from sys.version;
 
 +-----------------------+
 | Tangent of 45 degrees |

Modified: drill/site/trunk/content/drill/docs/sql-functions/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/sql-functions/index.html?rev=1671986&r1=1671985&r2=1671986&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/sql-functions/index.html (original)
+++ drill/site/trunk/content/drill/docs/sql-functions/index.html Wed Apr  8 00:46:36 2015
@@ -74,9 +74,9 @@
 <li><a href="/docs/casting-converting-data-types/">Casting and Converting Data Types</a></li>
 <li><a href="/docs/date-time-functions-and-arithmetic/">Date/Time and Arithmetic</a></li>
 <li><a href="/docs/string-manipulation">String Manipulation</a></li>
-<li><a href="">Aggregate and Aggregate Statistics</a></li>
+<li><a href="/docs/aggregate-and-aggregate-statistical">Aggregate and Aggregate Statistical</a></li>
 <li><a href="/docs/nested-data-functions/">Nested Data</a></li>
-<li><a href="">Other functions</a></li>
+<li><a href="/docs/functions-for-handling-nulls">Functions for Handling Nulls</a></li>
 </ul>
 </div>
 

Modified: drill/site/trunk/content/drill/docs/string-manipulation/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/string-manipulation/index.html?rev=1671986&r1=1671985&r2=1671986&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/string-manipulation/index.html (original)
+++ drill/site/trunk/content/drill/docs/string-manipulation/index.html Wed Apr  8 00:46:36 2015
@@ -185,7 +185,7 @@ SELECT CONVERT_FROM(BYTE_SUBSTR(row_key,
 <div class="highlight"><pre><code class="language-text" data-lang="text">( CHAR_LENGTH | CHARACTER_LENGTH ) (string);
 </code></pre></div>
 <h3 id="example">Example</h3>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CHAR_LENGTH(&#39;Drill rocks&#39;) FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CHAR_LENGTH(&#39;Drill rocks&#39;) FROM sys.version;
 
 +------------+
 |   EXPR$0   |
@@ -202,7 +202,7 @@ SELECT CONVERT_FROM(BYTE_SUBSTR(row_key,
 <div class="highlight"><pre><code class="language-text" data-lang="text">CONCAT(string [, string [, ...] );
 </code></pre></div>
 <h3 id="example">Example</h3>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CONCAT(&#39;Drill&#39;, &#39; &#39;, 1.0, &#39; &#39;, &#39;release&#39;) FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT CONCAT(&#39;Drill&#39;, &#39; &#39;, 1.0, &#39; &#39;, &#39;release&#39;) FROM sys.version;
 
 +------------+
 |   EXPR$0   |
@@ -221,7 +221,7 @@ SELECT CONVERT_FROM(BYTE_SUBSTR(row_key,
 <div class="highlight"><pre><code class="language-text" data-lang="text">INITCAP(string);
 </code></pre></div>
 <h3 id="examples">Examples</h3>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT INITCAP(&#39;apache drill release 1.0&#39;) FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT INITCAP(&#39;apache drill release 1.0&#39;) FROM sys.version;
 
 +------------+
 |   EXPR$0   |
@@ -238,7 +238,7 @@ SELECT CONVERT_FROM(BYTE_SUBSTR(row_key,
 <div class="highlight"><pre><code class="language-text" data-lang="text">LENGTH( string [, encoding] );
 </code></pre></div>
 <h3 id="example">Example</h3>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT LENGTH(&#39;apache drill release 1.0&#39;) FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT LENGTH(&#39;apache drill release 1.0&#39;) FROM sys.version;
 
 +------------+
 |   EXPR$0   |
@@ -267,7 +267,7 @@ SELECT LENGTH(row_key, &#39;UTF8&#39;) F
 <div class="highlight"><pre><code class="language-text" data-lang="text">LOWER (string);
 </code></pre></div>
 <h3 id="example">Example</h3>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT LOWER(&#39;Apache Drill&#39;) FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT LOWER(&#39;Apache Drill&#39;) FROM sys.version;
 
 +------------+
 |   EXPR$0   |
@@ -285,7 +285,7 @@ SELECT LENGTH(row_key, &#39;UTF8&#39;) F
 <div class="highlight"><pre><code class="language-text" data-lang="text">LPAD (string, length [, fill text]);
 </code></pre></div>
 <h3 id="example">Example</h3>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT LPAD(&#39;Release 1.0&#39;, 27, &#39;of Apache Drill 1.0&#39;) FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT LPAD(&#39;Release 1.0&#39;, 27, &#39;of Apache Drill 1.0&#39;) FROM sys.version;
 
 +------------+
 |   EXPR$0   |
@@ -302,7 +302,7 @@ SELECT LENGTH(row_key, &#39;UTF8&#39;) F
 <div class="highlight"><pre><code class="language-text" data-lang="text">LTRIM(string, string);
 </code></pre></div>
 <h3 id="example">Example</h3>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT LTRIM(&#39;Apache Drill&#39;, &#39;Apache &#39;) FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT LTRIM(&#39;Apache Drill&#39;, &#39;Apache &#39;) FROM sys.version;
 
 +------------+
 |   EXPR$0   |
@@ -319,7 +319,7 @@ SELECT LENGTH(row_key, &#39;UTF8&#39;) F
 <div class="highlight"><pre><code class="language-text" data-lang="text">POSITION(&#39;substring&#39; in &#39;string&#39;)
 </code></pre></div>
 <h3 id="example">Example</h3>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT POSITION(&#39;c&#39; in &#39;Apache Drill&#39;) FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT POSITION(&#39;c&#39; in &#39;Apache Drill&#39;) FROM sys.version;
 
 +------------+
 |   EXPR$0   |
@@ -380,7 +380,7 @@ SELECT id, REGEXP_REPLACE(FLATTEN(strs),
 <div class="highlight"><pre><code class="language-text" data-lang="text">RPAD (string, length [, fill text]);
 </code></pre></div>
 <h3 id="example">Example</h3>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT RPAD(&#39;Apache Drill &#39;, 22, &#39;Release 1.0&#39;) FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT RPAD(&#39;Apache Drill &#39;, 22, &#39;Release 1.0&#39;) FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -396,7 +396,7 @@ SELECT id, REGEXP_REPLACE(FLATTEN(strs),
 <div class="highlight"><pre><code class="language-text" data-lang="text">RTRIM(string, string);
 </code></pre></div>
 <h3 id="example">Example</h3>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT RTRIM(&#39;Apache Drill&#39;, &#39;Drill &#39;) FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT RTRIM(&#39;Apache Drill&#39;, &#39;Drill &#39;) FROM sys.version;
 
 +------------+
 |   EXPR$0   |
@@ -414,7 +414,7 @@ SELECT id, REGEXP_REPLACE(FLATTEN(strs),
 <p>STRPOS(string, substring)</p>
 
 <h3 id="example">Example</h3>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT STRPOS(&#39;Apache Drill&#39;, &#39;Drill&#39;) FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT STRPOS(&#39;Apache Drill&#39;, &#39;Drill&#39;) FROM sys.version;
 
 +------------+
 |   EXPR$0   |
@@ -432,7 +432,7 @@ SELECT id, REGEXP_REPLACE(FLATTEN(strs),
 <p>(SUBSTR | SUBSTRING)(string, x, y)</p>
 
 <h3 id="example">Example</h3>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT SUBSTR(&#39;Apache Drill&#39;, 8) FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT SUBSTR(&#39;Apache Drill&#39;, 8) FROM sys.version;
 
 +------------+
 |   EXPR$0   |
@@ -441,7 +441,7 @@ SELECT id, REGEXP_REPLACE(FLATTEN(strs),
 +------------+
 1 row selected (0.134 seconds)
 
-SELECT SUBSTR(&#39;Apache Drill&#39;, 3, 2) FROM sys.drillbits;
+SELECT SUBSTR(&#39;Apache Drill&#39;, 3, 2) FROM sys.version;
 
 +------------+
 |   EXPR$0   |
@@ -458,7 +458,7 @@ SELECT SUBSTR(&#39;Apache Drill&#39;, 3,
 <div class="highlight"><pre><code class="language-text" data-lang="text">TRIM ([leading | trailing | both] [characters] from string)
 </code></pre></div>
 <h3 id="example">Example</h3>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TRIM(trailing &#39;l&#39; from &#39;Drill&#39;) FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT TRIM(trailing &#39;l&#39; from &#39;Drill&#39;) FROM sys.version;
 +------------+
 |   EXPR$0   |
 +------------+
@@ -474,7 +474,7 @@ SELECT SUBSTR(&#39;Apache Drill&#39;, 3,
 <div class="highlight"><pre><code class="language-text" data-lang="text">UPPER (string);
 </code></pre></div>
 <h3 id="example">Example</h3>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT UPPER(&#39;Apache Drill&#39;) FROM sys.drillbits;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT UPPER(&#39;Apache Drill&#39;) FROM sys.version;
 
 +------------+
 |   EXPR$0   |

Modified: drill/site/trunk/content/drill/feed.xml
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/feed.xml?rev=1671986&r1=1671985&r2=1671986&view=diff
==============================================================================
--- drill/site/trunk/content/drill/feed.xml (original)
+++ drill/site/trunk/content/drill/feed.xml Wed Apr  8 00:46:36 2015
@@ -6,8 +6,8 @@
 </description>
     <link>/</link>
     <atom:link href="/feed.xml" rel="self" type="application/rss+xml"/>
-    <pubDate>Mon, 06 Apr 2015 18:32:48 -0700</pubDate>
-    <lastBuildDate>Mon, 06 Apr 2015 18:32:48 -0700</lastBuildDate>
+    <pubDate>Tue, 07 Apr 2015 17:45:05 -0700</pubDate>
+    <lastBuildDate>Tue, 07 Apr 2015 17:45:05 -0700</lastBuildDate>
     <generator>Jekyll v2.5.2</generator>
     
       <item>



Mime
View raw message