You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by br...@apache.org on 2015/04/08 03:47:41 UTC
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/
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 "/mapr/demo.mapr.com/tables". 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">{
"type": "file",
@@ -828,8 +828,6 @@ use in your Drill queries as described i
<p><em>'format'</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 '0' appears in the format string, that digit appears in the output; otherwise, a '0' appears in that position in the output.</p></li>
+Digit placeholder. If a value has a digit in the position where the zero '0' appears in the format string, that digit appears in the output; otherwise, a '0' appears in that position in the output.</p></li>
<li><p>.<br>
Decimal point. Make the first '.' character in the format string the location of the decimal separator in the value; ignore any additional '.' characters.</p></li>
<li><p>,<br>
@@ -1063,7 +1061,7 @@ SELECT TO_NUMBER('12345', '#
+------------+
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('2015-03-30 20:49:59.0 UTC', 'YYYY-MM-dd HH:mm:ss.s z') AS Original,
TO_CHAR(TO_TIMESTAMP('2015-03-30 20:49:59.0 UTC', 'YYYY-MM-dd HH:mm:ss.s z'), 'z') 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 'clicks','click9',&#
<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 'clicks','click9',&#
<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, 'Glaze?') AS `Glazed?` FROM dfs.`/Users/drill/testRepeatedWrite.json` WHERE type='donut';
+------------+------------+
@@ -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, 'P*r') AS `Powdered Sugar?` FROM dfs.`/Users/khahn/Documents/test_files_source/testRepeatedWrite.json` WHERE type='donut';
+------------+-----------------+
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, 'UTF8') 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('Apache Drill', 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>