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 <[email protected]> Authored: Tue Nov 14 10:15:57 2017 -0800 Committer: Bridget Bevens <[email protected]> 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>
