This is an automated email from the ASF dual-hosted git repository.
bridgetb pushed a commit to branch gh-pages
in repository https://gitbox.apache.org/repos/asf/drill.git
The following commit(s) were added to refs/heads/gh-pages by this push:
new fa7c40e edit SP config basics to update case sensitivity info, fix
link to explain command
fa7c40e is described below
commit fa7c40e667103262f874a2b36dcb603b01780fab
Author: Bridget Bevens <[email protected]>
AuthorDate: Fri Sep 28 14:35:20 2018 -0700
edit SP config basics to update case sensitivity info, fix link to explain
command
---
.../035-plugin-configuration-basics.md | 22 +++++++++++++++++-----
.../026-parquet-filter-pushdown.md | 4 ++--
2 files changed, 19 insertions(+), 7 deletions(-)
diff --git a/_docs/connect-a-data-source/035-plugin-configuration-basics.md
b/_docs/connect-a-data-source/035-plugin-configuration-basics.md
index ec2d3d4..b8d8ce2 100644
--- a/_docs/connect-a-data-source/035-plugin-configuration-basics.md
+++ b/_docs/connect-a-data-source/035-plugin-configuration-basics.md
@@ -1,6 +1,6 @@
---
title: "Plugin Configuration Basics"
-date: 2018-08-02 22:29:53 UTC
+date: 2018-09-28 21:35:20 UTC
parent: "Storage Plugin Configuration"
---
There are several ways you can configure storage plugins. For example, you can
configure storage plugins in the Drill Web UI, using REST API, or through
configuration files. See [Configuring Storage
Plugins]({{site.baseurl}}/docs/configuring-storage-plugins/) for more
information.
@@ -151,9 +151,21 @@ For more information about format plugin configuration see
["Text Files: CSV, TS
The configuration of other attributes, such as `size.calculator.enabled` in
the `hbase` plugin and `configProps` in the `hive` plugin, are
implementation-dependent and beyond the scope of this document.
-## Case-sensitive Names
-As previously mentioned, workspace and storage plugin names are
case-sensitive. For example, the following query uses a storage plugin name
`dfs` and a workspace name `clicks`. When you refer to `dfs.clicks` in an SQL
statement, use the defined case:
+## Case-Sensitivity
- 0: jdbc:drill:> USE dfs.clicks;
+Starting in Drill 1.15, storage plugin names and workspaces (schemas) are
case-insensitive. For example, the following query uses a storage plugin named
`dfs` and a workspace named `clicks`. You can reference `dfs.clicks` in an SQL
statement in uppercase or lowercase, as shown:
-For example, using uppercase letters in the query after defining the storage
plugin and workspace names using lowercase letters does not work.
\ No newline at end of file
+ USE dfs.clicks;
+ USE DFS.CLICKs;
+ USE dfs.CLICKS;
+
+Refer to
[Case-Sensitivity]({{site.baseurl}}/docs/lexical-structure/#case-sensitivity)
for more information about case-sensitivity in Drill.
+
+
+
+
+
+
+
+
+
\ No newline at end of file
diff --git a/_docs/performance-tuning/026-parquet-filter-pushdown.md
b/_docs/performance-tuning/026-parquet-filter-pushdown.md
index 0afdcee..beebe78 100644
--- a/_docs/performance-tuning/026-parquet-filter-pushdown.md
+++ b/_docs/performance-tuning/026-parquet-filter-pushdown.md
@@ -1,12 +1,12 @@
---
title: "Parquet Filter Pushdown"
-date: 2018-06-15 18:30:17 UTC
+date: 2018-09-28 21:35:21 UTC
parent: "Performance Tuning"
---
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.
-Parquet filter pushdown is enabled by default. When a query contains a filter
expression, you can run the [EXPLAIN PLAN
command]({{site.baseurl}}/docs/explain-commands/) to see if Drill applies
Parquet filter pushdown to the query. You can enable and disable this feature
using the [ALTER SYSTEM|SESSION SET]({{site.baseurl}}/docs/alter-system/)
command with the `planner.store.parquet.rowgroup.filter.pushdown` option.
+Parquet filter pushdown is enabled by default. When a query contains a filter
expression, you can run the [EXPLAIN PLAN
command]({{site.baseurl}}/docs/explain/) to see if Drill applies Parquet filter
pushdown to the query. You can enable and disable this feature using the [ALTER
SYSTEM|SESSION SET]({{site.baseurl}}/docs/alter-system/) command with the
`planner.store.parquet.rowgroup.filter.pushdown` option.
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:
