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 2018/09/28 21:39:54 UTC
[drill-site] branch asf-site updated: edit sp basics to update
case-sensitivity and fix broken link to explain command
This is an automated email from the ASF dual-hosted git repository.
bridgetb pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/drill-site.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 96dd054 edit sp basics to update case-sensitivity and fix broken link to explain command
96dd054 is described below
commit 96dd054820bbe7419e5def282ede32cebd521f77
Author: Bridget Bevens <bb...@maprtech.com>
AuthorDate: Fri Sep 28 14:39:39 2018 -0700
edit sp basics to update case-sensitivity and fix broken link to explain command
---
docs/parquet-filter-pushdown/index.html | 4 ++--
docs/plugin-configuration-basics/index.html | 12 +++++++-----
feed.xml | 4 ++--
3 files changed, 11 insertions(+), 9 deletions(-)
diff --git a/docs/parquet-filter-pushdown/index.html b/docs/parquet-filter-pushdown/index.html
index ca8bdd7..da5079f 100644
--- a/docs/parquet-filter-pushdown/index.html
+++ b/docs/parquet-filter-pushdown/index.html
@@ -1272,7 +1272,7 @@
</div>
- Jun 15, 2018
+ Sep 28, 2018
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1280,7 +1280,7 @@
<p>Drill 1.9 introduces the Parquet filter pushdown option. Parquet filter pushdown is a performance optimization that prunes extraneous data from a Parquet file to reduce the amount of data that Drill scans and reads when a query on a Parquet file contains a filter expression. Pruning data reduces the I/O, CPU, and network overhead to optimize Drill’s performance.</p>
-<p>Parquet filter pushdown is enabled by default. When a query contains a filter expression, you can run the <a href="/docs/explain-commands/">EXPLAIN PLAN command</a> to see if Drill applies Parquet filter pushdown to the query. You can enable and disable this feature using the <a href="/docs/alter-system/">ALTER SYSTEM|SESSION SET</a> command with the <code>planner.store.parquet.rowgroup.filter.pushdown</code> option. </p>
+<p>Parquet filter pushdown is enabled by default. When a query contains a filter expression, you can run the <a href="/docs/explain/">EXPLAIN PLAN command</a> to see if Drill applies Parquet filter pushdown to the query. You can enable and disable this feature using the <a href="/docs/alter-system/">ALTER SYSTEM|SESSION SET</a> command with the <code>planner.store.parquet.rowgroup.filter.pushdown</code> option. </p>
<p>As of Drill 1.13, the query planner in Drill can apply project push down, filter push down, and partition pruning to star queries in common table expressions (CTEs), views, and subqueries, for example: </p>
<div class="highlight"><pre><code class="language-text" data-lang="text"> select col1 from (select * from t)
diff --git a/docs/plugin-configuration-basics/index.html b/docs/plugin-configuration-basics/index.html
index 900b1c8..5ab9dbd 100644
--- a/docs/plugin-configuration-basics/index.html
+++ b/docs/plugin-configuration-basics/index.html
@@ -1274,7 +1274,7 @@
</div>
- Aug 2, 2018
+ Sep 28, 2018
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
@@ -1429,12 +1429,14 @@ fieldDelimiter => ',', extractHeader => true))</code></p>
<p>The configuration of other attributes, such as <code>size.calculator.enabled</code> in the <code>hbase</code> plugin and <code>configProps</code> in the <code>hive</code> plugin, are implementation-dependent and beyond the scope of this document.</p>
-<h2 id="case-sensitive-names">Case-sensitive Names</h2>
+<h2 id="case-sensitivity">Case-Sensitivity</h2>
-<p>As previously mentioned, workspace and storage plugin names are case-sensitive. For example, the following query uses a storage plugin name <code>dfs</code> and a workspace name <code>clicks</code>. When you refer to <code>dfs.clicks</code> in an SQL statement, use the defined case:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:> USE dfs.clicks;
+<p>Starting in Drill 1.15, storage plugin names and workspaces (schemas) are case-insensitive. For example, the following query uses a storage plugin named <code>dfs</code> and a workspace named <code>clicks</code>. You can reference <code>dfs.clicks</code> in an SQL statement in uppercase or lowercase, as shown:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text"> USE dfs.clicks;
+ USE DFS.CLICKs;
+ USE dfs.CLICKS;
</code></pre></div>
-<p>For example, using uppercase letters in the query after defining the storage plugin and workspace names using lowercase letters does not work. </p>
+<p>Refer to <a href="/docs/lexical-structure/#case-sensitivity">Case-Sensitivity</a> for more information about case-sensitivity in Drill.</p>
diff --git a/feed.xml b/feed.xml
index 24ef44b..9ed058a 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>Fri, 28 Sep 2018 14:11:22 -0700</pubDate>
- <lastBuildDate>Fri, 28 Sep 2018 14:11:22 -0700</lastBuildDate>
+ <pubDate>Fri, 28 Sep 2018 14:37:12 -0700</pubDate>
+ <lastBuildDate>Fri, 28 Sep 2018 14:37:12 -0700</lastBuildDate>
<generator>Jekyll v2.5.2</generator>
<item>