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 2017/11/14 18:16:32 UTC
drill-site git commit: doc updates for 1.12 - allow dots in column
names
Repository: drill-site
Updated Branches:
refs/heads/asf-site 5297ad832 -> f61edcbe7
doc updates for 1.12 - allow dots in column names
Project: http://git-wip-us.apache.org/repos/asf/drill-site/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill-site/commit/f61edcbe
Tree: http://git-wip-us.apache.org/repos/asf/drill-site/tree/f61edcbe
Diff: http://git-wip-us.apache.org/repos/asf/drill-site/diff/f61edcbe
Branch: refs/heads/asf-site
Commit: f61edcbe754e35634f6abd8c66df7c1016967d40
Parents: 5297ad8
Author: Bridget Bevens <bb...@maprtech.com>
Authored: Tue Nov 14 10:15:57 2017 -0800
Committer: Bridget Bevens <bb...@maprtech.com>
Committed: Tue Nov 14 10:15:57 2017 -0800
----------------------------------------------------------------------
docs/lexical-structure/index.html | 28 +++++++++++++++++++++++-----
feed.xml | 4 ++--
2 files changed, 25 insertions(+), 7 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f61edcbe/docs/lexical-structure/index.html
----------------------------------------------------------------------
diff --git a/docs/lexical-structure/index.html b/docs/lexical-structure/index.html
index 9057235..c6309d5 100644
--- a/docs/lexical-structure/index.html
+++ b/docs/lexical-structure/index.html
@@ -1126,7 +1126,7 @@
</div>
- Aug 8, 2017
+ Nov 14, 2017
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1212,7 +1212,7 @@
<ul>
<li>Keywords</li>
-<li>Identifiers that SQL cannot parse</li>
+<li>Identifiers that SQL cannot parse<br></li>
</ul>
<p>For example, enclose the SQL keywords date and time in identifier quotes when referring to column names, but not when referring to data types:</p>
@@ -1226,7 +1226,7 @@ FROM dfs.`/Users/drilluser/sample.json`);
</code></pre></div>
<p>Table and column names are case-insensitive. Use identifier quotes to enclose names that contain special characters. Special characters are those other than the 52 Latin alphabet characters. For example, space and @ are special characters. </p>
-<p>The following example shows the keyword Year enclosed in identifier quotes. Because the column alias contains the special space character, also enclose the alias in back ticks, as shown in the following example:</p>
+<p>The following example shows the keyword Year enclosed in identifier quotes. Because the column alias contains the special space character, also enclose the alias in backticks, as shown in the following example:</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT extract(year from transdate) AS `Year`, t.user_info.cust_id AS `Customer Number` FROM dfs.tmp.`sampleparquet` t;
+------------+-----------------+
| Year | Customer Number |
@@ -1241,7 +1241,7 @@ FROM dfs.`/Users/drilluser/sample.json`);
</code></pre></div>
<h3 id="identifier-quotes">Identifier Quotes</h3>
-<p>Prior to Drill 1.11, the SQL parser in Drill only supported back ticks as identifier quotes. As of Drill 1.11, the SQL parser can also use double quotes and square brackets. The default setting for identifier quotes is back ticks. You can configure the type of identifier quotes used with the <code>planner.parser.quoting_identifiers</code> configuration option, at the system or session level, as shown: </p>
+<p>Prior to Drill 1.11, the SQL parser in Drill only supported backticks as identifier quotes. As of Drill 1.11, the SQL parser can also use double quotes and square brackets. The default setting for identifier quotes is backticks. You can configure the type of identifier quotes used with the <code>planner.parser.quoting_identifiers</code> configuration option, at the system or session level, as shown: </p>
<div class="highlight"><pre><code class="language-text" data-lang="text"> ALTER SYSTEM|SESSION SET planner.parser.quoting_identifiers = '"';
ALTER SYSTEM|SESSION SET planner.parser.quoting_identifiers = '[';
ALTER SYSTEM|SESSION SET planner.parser.quoting_identifiers = '`';
@@ -1255,7 +1255,7 @@ FROM dfs.`/Users/drilluser/sample.json`);
</tr>
</thead><tbody>
<tr>
-<td>Back ticks</td>
+<td>Backticks</td>
<td>'GRAVE ACCENT' (U+0060)</td>
</tr>
<tr>
@@ -1298,6 +1298,24 @@ FROM dfs.`/Users/drilluser/sample.json`);
+--------------+---------------+
1 row selected (0.14 seconds)
</code></pre></div>
+<h3 id="dots-in-column-names">Dots in Column Names</h3>
+
+<p>As of Drill 1.12, Drill supports dots in column names if the data source itself allows dots in column names, such as JSON and Parquet , as shown in the following example: </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text"> SELECT * FROM `test.json`;
+
+ +--------------------------------------------------------+----------------------------------------------------------+
+ | 0.0.1 | 0.1.2 |
+ +--------------------------------------------------------+----------------------------------------------------------+
+ | {"version":"0.0.1","date_created":"2014-03-15"} | {"version":"0.1.2","date_created":"2014-05-21"} |
+ +--------------------------------------------------------+----------------------------------------------------------+
+</code></pre></div>
+<p>When referencing column names with dots in queries, you must escape the dots with <a href="/docs/lexical-structure/#identifier-quotes">identifier quotes</a>, as shown in the following query: </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text"> SELECT t.`0.1.2`.version FROM dfs.tmp.`test.json` t WHERE t.`0.1.2`.date_created='2014-05-21'
+</code></pre></div>
+<p>Drill also supports associative array indexing, for example <code>SELECT a, b.c, b['d.e']...</code>. </p>
+
+<p>Note that in this example, the <code>“d.e”</code> field is selected, not a map <code>“d”</code> with field <code>“e”</code> inside of it. </p>
+
<h3 id="integer">Integer</h3>
<p>An integer value consists of an optional minus sign, -, followed by one or more digits.</p>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/f61edcbe/feed.xml
----------------------------------------------------------------------
diff --git a/feed.xml b/feed.xml
index 1b9fb5d..ba74a4a 100644
--- a/feed.xml
+++ b/feed.xml
@@ -6,8 +6,8 @@
</description>
<link>/</link>
<atom:link href="/feed.xml" rel="self" type="application/rss+xml"/>
- <pubDate>Thu, 07 Sep 2017 11:01:14 -0700</pubDate>
- <lastBuildDate>Thu, 07 Sep 2017 11:01:14 -0700</lastBuildDate>
+ <pubDate>Tue, 14 Nov 2017 10:10:03 -0800</pubDate>
+ <lastBuildDate>Tue, 14 Nov 2017 10:10:03 -0800</lastBuildDate>
<generator>Jekyll v2.5.2</generator>
<item>