drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject svn commit: r1671988 - in /drill/site/trunk/content/drill: ./ docs/data-type-conversion/ docs/math-and-trig/ docs/querying-hbase/ docs/repeated-contains/ docs/sql-functions/ docs/string-manipulation/
Date Wed, 08 Apr 2015 01:47:41 GMT
Author: bridgetb
Date: Wed Apr  8 01:47:40 2015
New Revision: 1671988

URL: http://svn.apache.org/r1671988
Log:
DRILL-2713: doc configuration options

Modified:
    drill/site/trunk/content/drill/docs/data-type-conversion/index.html
    drill/site/trunk/content/drill/docs/math-and-trig/index.html
    drill/site/trunk/content/drill/docs/querying-hbase/index.html
    drill/site/trunk/content/drill/docs/repeated-contains/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/data-type-conversion/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/data-type-conversion/index.html?rev=1671988&r1=1671987&r2=1671988&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 01:47:40
2015
@@ -358,7 +358,7 @@ SELECT * FROM students;
 <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>
 
 <ol>
-<li><p>Copy/paste the <code>dfs</code> storage plugin defintion to
a newly created plugin called myplugin.</p></li>
+<li><p>Copy/paste the <code>dfs</code> storage plugin definition
to a newly created plugin called myplugin.</p></li>
 <li><p>Change the root location to &quot;/mapr/demo.mapr.com/tables&quot;.
This change allows you to query tables for reading in the tables directory by workspace.table
name. This change allows you to read a table in the <code>tables</code> directory.
You can write a converted version of the table in the <code>tmp</code> directory
because the writable property is true.</p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">{
   &quot;type&quot;: &quot;file&quot;,
@@ -828,8 +828,6 @@ use in your Drill queries as described i
 
 <p><em>&#39;format&#39;</em> is a format specifier enclosed in
single quotation marks that sets a pattern for the output formatting. </p>
 
-<h3 id="usage-notes">Usage Notes</h3>
-
 <h3 id="examples">Examples</h3>
 
 <p>Convert a FLOAT to a character string.</p>
@@ -963,9 +961,9 @@ SELECT EXTRACT(year from mydate) `extrac
 <p>The data type of the output of TO_NUMBER is a numeric. You can use the following
<a href="http://docs.oracle.com/javase/7/docs/api/java/text/DecimalFormat.html">Java
DecimalFormat class</a> specifiers to set the output formatting. </p>
 
 <ul>
-<li><p>Digit place holder. </p></li>
+<li><p>Digit placeholder. </p></li>
 <li><p>0<br>
-Digit place holder. If a value has a digit in the position where the zero &#39;0&#39;
appears in the format string, that digit appears in the output; otherwise, a &#39;0&#39;
appears in that position in the output.</p></li>
+Digit placeholder. If a value has a digit in the position where the zero &#39;0&#39;
appears in the format string, that digit appears in the output; otherwise, a &#39;0&#39;
appears in that position in the output.</p></li>
 <li><p>.<br>
 Decimal point. Make the first &#39;.&#39; character in the format string the location
of the decimal separator in the value; ignore any additional &#39;.&#39; characters.</p></li>
 <li><p>,<br>
@@ -1063,7 +1061,7 @@ SELECT TO_NUMBER(&#39;12345&#39;, &#39;#
 +------------+
 1 row selected (0.094 seconds)
 </code></pre></div>
-<p>Connvert a UTC date to a timestamp offset from the UTC time zone code.</p>
+<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;

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=1671988&r1=1671987&r2=1671988&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 01:47:40 2015
@@ -88,7 +88,7 @@
 <li>DECIMAL18</li>
 </ul>
 
-<p><strong>Math Functions</strong></p>
+<h1 id="math-functions">Math Functions</h1>
 
 <table>
   <tr>
@@ -225,9 +225,9 @@
 
 <h2 id="math-function-examples">Math Function Examples</h2>
 
-<p>Examples in this section use the <code>input2.json</code> file</p>
+<p>Examples in this section use the <code>input2.json</code> file. Download
the <code>input2.json</code> file from the <a href="https://github.com/apache/drill/tree/master/exec/java-exec/src/test/resources/jsoninput">Drill
source code</a> page. </p>
 
-<p>Download the <code>input2.json</code> file from the <a href="https://github.com/apache/drill/tree/master/exec/java-exec/src/test/resources/jsoninput">Drill
source code</a> page. On the Mac, for example, right-click input2.json and choose Save
Link As, and then click Save.</p>
+<p>You need to use a FROM clause in Drill queries. This document often uses the sys.version
table in the FROM clause of the query for example purposes.</p>
 
 <h4 id="abs-example">ABS Example</h4>
 
@@ -245,8 +245,9 @@
 . . .
 
 SELECT `integer` FROM dfs.`/Users/drill/input2.json`;
-
-+------------+
+</code></pre></div>
+<p>The output shows values not shown in the snippet. You can take a look at all the
values in the input2.json file.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">+------------+
 |  integer   |
 +------------+
 | 2010       |
@@ -268,7 +269,7 @@ SELECT ABS(`integer`) FROM dfs.`/Users/d
 +------------+
 4 rows selected (0.357 seconds)
 </code></pre></div>
-<h2 id="ceil-example">CEIL Example</h2>
+<h3 id="ceil-example">CEIL Example</h3>
 
 <p>Get the ceiling of float key values in input2.json. The input2.json file contains
these float key values:</p>
 
@@ -371,7 +372,7 @@ SELECT ROUND(`float`, 4) FROM dfs.`/User
 +------------+
 1 row selected (0.063 seconds)
 </code></pre></div>
-<p><strong>Trig Functions</strong></p>
+<h1 id="trig-functions">Trig Functions</h1>
 
 <p>Drill supports the following trig functions, which return a FLOAT8 result.</p>
 
@@ -396,7 +397,7 @@ Hyperbolic cosine of hyperbolic angle x
 Hyperbolic tangent of hyperbolic angle x in radians</p></li>
 </ul>
 
-<p><strong>Examples</strong></p>
+<h2 id="examples">Examples</h2>
 
 <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.version;

Modified: drill/site/trunk/content/drill/docs/querying-hbase/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/querying-hbase/index.html?rev=1671988&r1=1671987&r2=1671988&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/querying-hbase/index.html (original)
+++ drill/site/trunk/content/drill/docs/querying-hbase/index.html Wed Apr  8 01:47:40 2015
@@ -156,7 +156,7 @@ put &#39;clicks&#39;,&#39;click9&#39;,&#
 <div class="highlight"><pre><code class="language-text" data-lang="text">cat
testdata.txt | hbase shell
 </code></pre></div></li>
 <li><p>Start Drill. Type <code>sqlline</code> on the terminal command
line if you are using the Drill Sandbox; otherwise, see <a href="/docs/starting-stopping-drill">Starting/Stopping
Drill</a>.</p></li>
-<li><p>Use the <code>maprdb</code> storage plugin, which includes
the <a href="/docs/mapr-db-format">MapR-DB format</a>, if you are using the Drill
Sandbox; otherwise, enable and use the hbase storage plugin on a system having HBase services.
</p>
+<li><p>Use the <a href="/docs/mapr-db-format">MapR-DB format plugin</a>,
if you are using the Drill Sandbox; otherwise, enable and use the hbase storage plugin on
a system having HBase services. </p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">
USE hbase; /* If you have installed HBase services. */ 
 </code></pre></div></li>
 </ol>
@@ -164,7 +164,7 @@ put &#39;clicks&#39;,&#39;click9&#39;,&#
 <p>Or:</p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">
    USE maprdb; /* If you are using the Drill Sandbox */
 </code></pre></div>
-<p>The <code>maprdb</code> storage plugin provides access to the <code>/tables</code>
directory. Use Drill to query the students and clicks tables on the Drill Sandbox.  </p>
+<p>The <code>maprdb</code> format plugin provides access to the <code>/tables</code>
directory. Use Drill to query the students and clicks tables on the Drill Sandbox.  </p>
 
 <h2 id="query-hbase-tables">Query HBase Tables</h2>
 

Modified: drill/site/trunk/content/drill/docs/repeated-contains/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/repeated-contains/index.html?rev=1671988&r1=1671987&r2=1671988&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/repeated-contains/index.html (original)
+++ drill/site/trunk/content/drill/docs/repeated-contains/index.html Wed Apr  8 01:47:40 2015
@@ -93,13 +93,24 @@
 
 <h2 id="usage-notes">Usage Notes</h2>
 
-<p>REPEATED_CONTAINS returns true if Drill finds a match; otherwise, the function returns
false. The function supports regular expression wildcards, such as *, ., and ?, but not at
the beginning of the keyword. Enclose keyword string values in single quotation marks. Do
not enclose numerical keyword values in single quotation marks.</p>
+<p>REPEATED_CONTAINS returns true if Drill finds a match; otherwise, the function returns
false. The function supports regular expression wildcards, but not at the beginning of the
keyword:</p>
+
+<ul>
+<li>Asterisk (*)</li>
+<li>Period (.)</li>
+<li>Question mark (?)</li>
+<li>Square bracketed ranges [a-z]</li>
+<li>Square bracketed characters [ch]</li>
+<li>Negated square bracketed ranges or characters [!ch].</li>
+</ul>
+
+<p>Enclose keyword string values in single quotation marks. Do not enclose numerical
keyword values in single quotation marks.</p>
 
 <h2 id="examples">Examples</h2>
 
-<p>The examples in this section <code>testRepeatedWrite.json</code>. To
download this file, go to <a href="https://github.com/apache/drill/tree/master/exec/java-exec/src/test/resources">Drill
test resources</a> page, locate testRepeatedWrite.json.json in the list of files, and
download it. For example, on the Mac right-click the five, select Save Link As, and then click
Save.</p>
+<p>The examples in this section use <code>testRepeatedWrite.json</code>.
To download this file, go to <a href="https://github.com/apache/drill/tree/master/exec/java-exec/src/test/resources">Drill
test resources</a> page, locate testRepeatedWrite.json in the list of files, and download
it.</p>
 
-<p>Which donuts having glazed or glaze toppings?</p>
+<p>Which donuts have glazed or glaze toppings?</p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">
   SELECT name, REPEATED_CONTAINS(topping, &#39;Glaze?&#39;) AS `Glazed?` FROM  dfs.`/Users/drill/testRepeatedWrite.json`
WHERE type=&#39;donut&#39;;
 
     +------------+------------+
@@ -113,7 +124,7 @@
     +------------+------------+
     5 rows selected (0.072 seconds)
 </code></pre></div>
-<p>Which objects have powered sugar toppings? Use the asterisk wildcard instead of
typing the entire keyword pair.</p>
+<p>Which objects have powdered sugar toppings? Use the asterisk wildcard instead of
typing the entire keyword pair.</p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">SELECT
name, REPEATED_CONTAINS(topping, &#39;P*r&#39;) AS `Powdered Sugar?` FROM  dfs.`/Users/khahn/Documents/test_files_source/testRepeatedWrite.json`
WHERE type=&#39;donut&#39;;
 
 +------------+-----------------+

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=1671988&r1=1671987&r2=1671988&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 01:47:40 2015
@@ -71,7 +71,7 @@
 
 <ul>
 <li><a href="/docs/math-and-trig/">Math and Trig</a></li>
-<li><a href="/docs/casting-converting-data-types/">Casting and Converting Data
Types</a></li>
+<li><a href="/docs/data-type-conversion/">Data Type Conversion</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="/docs/aggregate-and-aggregate-statistical">Aggregate and Aggregate
Statistical</a></li>

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=1671988&r1=1671987&r2=1671988&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 01:47:40
2015
@@ -261,7 +261,7 @@ SELECT LENGTH(row_key, &#39;UTF8&#39;) F
 </code></pre></div>
 <h2 id="lower">LOWER</h2>
 
-<p>Converts characters in the string to lower case.</p>
+<p>Converts characters in the string to lowercase.</p>
 
 <h3 id="syntax">Syntax</h3>
 <div class="highlight"><pre><code class="language-text" data-lang="text">LOWER
(string);
@@ -468,7 +468,7 @@ SELECT SUBSTR(&#39;Apache Drill&#39;, 3,
 </code></pre></div>
 <h2 id="upper">UPPER</h2>
 
-<p>Converts characters in the string to lower case.</p>
+<p>Converts characters in the string to uppercase.</p>
 
 <h3 id="syntax">Syntax</h3>
 <div class="highlight"><pre><code class="language-text" data-lang="text">UPPER
(string);

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



Mime
View raw message