You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by ts...@apache.org on 2015/05/19 18:30:04 UTC
[2/9] drill git commit: query-plan-tune hierarchy
query-plan-tune hierarchy
Project: http://git-wip-us.apache.org/repos/asf/drill/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill/commit/74f807d2
Tree: http://git-wip-us.apache.org/repos/asf/drill/tree/74f807d2
Diff: http://git-wip-us.apache.org/repos/asf/drill/diff/74f807d2
Branch: refs/heads/gh-pages
Commit: 74f807d2bcd1ba12c3b78a88193676acff78429c
Parents: bb0710b
Author: Kristine Hahn <kh...@maprtech.com>
Authored: Tue May 19 00:31:35 2015 -0700
Committer: Kristine Hahn <kh...@maprtech.com>
Committed: Tue May 19 00:31:35 2015 -0700
----------------------------------------------------------------------
.../query-plans-and-tuning/020-join-planning-guidelines.md | 2 +-
.../030-guidelines-for-optimizing-aggregation.md | 2 +-
.../query-plans-and-tuning/040-modifying-query-planning-options.md | 2 +-
.../050-sort-based-and-hash-based-memory-constrained-operators.md | 2 +-
.../query-plans-and-tuning/060-enabling-query-queuing.md | 2 +-
...ng-parallelization-to-balance-performance-with-multi-tenancy.md | 2 +-
6 files changed, 6 insertions(+), 6 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/drill/blob/74f807d2/_docs/performance-tuning/query-plans-and-tuning/020-join-planning-guidelines.md
----------------------------------------------------------------------
diff --git a/_docs/performance-tuning/query-plans-and-tuning/020-join-planning-guidelines.md b/_docs/performance-tuning/query-plans-and-tuning/020-join-planning-guidelines.md
index aa8a1ce..9ebc77a 100755
--- a/_docs/performance-tuning/query-plans-and-tuning/020-join-planning-guidelines.md
+++ b/_docs/performance-tuning/query-plans-and-tuning/020-join-planning-guidelines.md
@@ -1,6 +1,6 @@
---
title: "Join Planning Guidelines"
-parent: "Performance Tuning"
+parent: "Query Plans and Tuning Introduction"
---
Drill uses distributed and broadcast joins to join tables. You can modify configuration settings in Drill to control how Drill plans joins in a query.
http://git-wip-us.apache.org/repos/asf/drill/blob/74f807d2/_docs/performance-tuning/query-plans-and-tuning/030-guidelines-for-optimizing-aggregation.md
----------------------------------------------------------------------
diff --git a/_docs/performance-tuning/query-plans-and-tuning/030-guidelines-for-optimizing-aggregation.md b/_docs/performance-tuning/query-plans-and-tuning/030-guidelines-for-optimizing-aggregation.md
index 4b81b42..cbbb3e1 100755
--- a/_docs/performance-tuning/query-plans-and-tuning/030-guidelines-for-optimizing-aggregation.md
+++ b/_docs/performance-tuning/query-plans-and-tuning/030-guidelines-for-optimizing-aggregation.md
@@ -1,6 +1,6 @@
---
title: "Guidelines for Optimizing Aggregation"
-parent: "Performance Tuning"
+parent: "Query Plans and Tuning Introduction"
---
http://git-wip-us.apache.org/repos/asf/drill/blob/74f807d2/_docs/performance-tuning/query-plans-and-tuning/040-modifying-query-planning-options.md
----------------------------------------------------------------------
diff --git a/_docs/performance-tuning/query-plans-and-tuning/040-modifying-query-planning-options.md b/_docs/performance-tuning/query-plans-and-tuning/040-modifying-query-planning-options.md
index fea76e3..e142b02 100755
--- a/_docs/performance-tuning/query-plans-and-tuning/040-modifying-query-planning-options.md
+++ b/_docs/performance-tuning/query-plans-and-tuning/040-modifying-query-planning-options.md
@@ -1,6 +1,6 @@
---
title: "Modifying Query Planning Options"
-parent: "Performance Tuning"
+parent: "Query Plans and Tuning Introduction"
---
Planner options affect how Drill plans a query. You can use the ALTER SYSTEM|SESSION commands to modify certain planning options to optimize query plans and improve performance. Typically, you modify options at the session level. See [ALTER SESSION]({{ site.baseurl }}/docs/alter-session/) for details on how to run the command.
http://git-wip-us.apache.org/repos/asf/drill/blob/74f807d2/_docs/performance-tuning/query-plans-and-tuning/050-sort-based-and-hash-based-memory-constrained-operators.md
----------------------------------------------------------------------
diff --git a/_docs/performance-tuning/query-plans-and-tuning/050-sort-based-and-hash-based-memory-constrained-operators.md b/_docs/performance-tuning/query-plans-and-tuning/050-sort-based-and-hash-based-memory-constrained-operators.md
index 561aba9..45927bb 100755
--- a/_docs/performance-tuning/query-plans-and-tuning/050-sort-based-and-hash-based-memory-constrained-operators.md
+++ b/_docs/performance-tuning/query-plans-and-tuning/050-sort-based-and-hash-based-memory-constrained-operators.md
@@ -1,6 +1,6 @@
---
title: "Sort-Based and Hash-Based Memory-Constrained Operators"
-parent: "Performance Tuning"
+parent: "Query Plans and Tuning Introduction"
---
Drill uses hash-based and sort-based operators depending on the query characteristics. Hash aggregation and hash join are hash-based operations. Streaming aggregation and merge join are sort-based operations. Both hash-based and sort-based operations consume memory, however the hash aggregate and hash join operators are the fastest and most memory intensive operators.
http://git-wip-us.apache.org/repos/asf/drill/blob/74f807d2/_docs/performance-tuning/query-plans-and-tuning/060-enabling-query-queuing.md
----------------------------------------------------------------------
diff --git a/_docs/performance-tuning/query-plans-and-tuning/060-enabling-query-queuing.md b/_docs/performance-tuning/query-plans-and-tuning/060-enabling-query-queuing.md
index 671c1cd..bafa7eb 100755
--- a/_docs/performance-tuning/query-plans-and-tuning/060-enabling-query-queuing.md
+++ b/_docs/performance-tuning/query-plans-and-tuning/060-enabling-query-queuing.md
@@ -1,6 +1,6 @@
---
title: "Enabling Query Queuing"
-parent: "Performance Tuning"
+parent: "Query Plans and Tuning Introduction"
---
Drill runs all queries concurrently by default. However, Drill performance increases when a small number of queries run concurrently. You can enable query queues to limit the maximum number of queries that run concurrently. Splitting large queries into multiple small queries and enabling query queuing improves query performance.
http://git-wip-us.apache.org/repos/asf/drill/blob/74f807d2/_docs/performance-tuning/query-plans-and-tuning/070-controlling-parallelization-to-balance-performance-with-multi-tenancy.md
----------------------------------------------------------------------
diff --git a/_docs/performance-tuning/query-plans-and-tuning/070-controlling-parallelization-to-balance-performance-with-multi-tenancy.md b/_docs/performance-tuning/query-plans-and-tuning/070-controlling-parallelization-to-balance-performance-with-multi-tenancy.md
index 7fed3fd..fd162bc 100755
--- a/_docs/performance-tuning/query-plans-and-tuning/070-controlling-parallelization-to-balance-performance-with-multi-tenancy.md
+++ b/_docs/performance-tuning/query-plans-and-tuning/070-controlling-parallelization-to-balance-performance-with-multi-tenancy.md
@@ -1,6 +1,6 @@
---
title: "Controlling Parallelization to Balance Performance with Multi-Tenancy"
-parent: "Performance Tuning"
+parent: "Query Plans and Tuning Introduction"
---
When you run Drill in a multi-tenant environment, (in conjunction with other workloads in a cluster, such as MapReduce) you may need to modify Drill settings and options to maximize performance, or reduce the allocated resources to other applications. See [Configuring Multi-Tenant Resources]({{ site.baseurl }}/docs/configuring-multitenant-resources/).