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 d225767 edits
d225767 is described below
commit d2257678c993f1076397a3209df1285a0c58aa33
Author: Bridget Bevens <[email protected]>
AuthorDate: Thu Dec 27 15:45:22 2018 -0800
edits
---
.../030-planning-and-exececution-options.md | 23 +++++++++++-----------
1 file changed, 11 insertions(+), 12 deletions(-)
diff --git
a/_docs/configure-drill/configuration-options/030-planning-and-exececution-options.md
b/_docs/configure-drill/configuration-options/030-planning-and-exececution-options.md
index e2294a0..3393f8e 100644
---
a/_docs/configure-drill/configuration-options/030-planning-and-exececution-options.md
+++
b/_docs/configure-drill/configuration-options/030-planning-and-exececution-options.md
@@ -7,14 +7,15 @@ You can set Drill query planning and execution options per
cluster, at the
system or session level. Options set at the session level only apply to
queries that you run during the current Drill connection. Options set at the
system level affect the entire system and persist between restarts. Session
-level settings override system level settings.
+level settings override system level settings.
-# Setting Planning and Execution Options
-You can set planning and execution options for Drill from the command line
using the Drill shell (SQLLine) or the Drill Web UI.
+Planning options are prepended by planner, for example
`planner.enable_hashjoin`. Execution options are prepended by drill.exe, for
example `drill.exec.functions.cast_empty_string_to_null`.
+
-Options set in the Drill Web UI are set at the system level. You can override
system level options set in the Drill Web UI by setting the options at the
session level from the Drill shell. Session level options override
system-level options for the duration of the session.
+## Setting Planning and Execution Options
+You can set planning and execution options for Drill from the Drill shell
(SQLLine) or the Drill Web UI. Options set in the Drill Web UI are set at the
system level. You can override system level options set in the Drill Web UI by
setting the options at the session level from the Drill shell. Session level
options override system-level options for the duration of the session.
-## Setting Options from the Drill Shell
+### Setting Options from the Drill Shell
Use the [ALTER SYSTEM]({{site.baseurl}}/docs/alter-system/) or
[SET]({{site.baseurl}}/docs/set/) commands to set planning and execution
options at the system or session level. Typically,
you set the options at the session level unless you want the setting to
@@ -36,24 +37,22 @@ The query returns a table that lists options with
descriptions and other details
See [Querying the Options
Table]({{site.baseurl}}/docs/querying-system-tables/#querying-the-options-table).
-The [summary of system
options]({{site.baseurl}}/docs/configuration-options-introduction) lists
default values and a short description of the planning and execution options.
The planning option names have a planning preface. Execution options have an
exe preface. For more information, see the section, "Performance Turning".The
following descriptions provide more detail on some of these options:
-
-## Setting Options from the Drill Web UI
+### Setting Options from the Drill Web UI
When Drill is running, you can access the Drill Web UI at
`http://<drill-hostname>:8047/`. The Drill Web UI has an Options button located
in the upper right corner that you can click to display an Options page. The
Options page lists all the Drill options that you can set. When you set options
from this page, you are setting the options at the system level. To override an
option for the duration of a session, set the option from the Drill shell using
the SET command.
Starting in Drill 1.15, the Options page includes the following enhancements:
-### Search Field
+**Search Field**
The search field enables you to quickly search across all available Drill
configuration options to quickly find options you are interested in. For
example, you can search on the keyword "memory" for a list of all options
related to configuring Drill memory.
-### Quick Filter Buttons
+**Quick Filter Buttons**
Next to the search field are quick filter buttons that filter options by
important keywords in one click. For example, the Planner quick filter button
quickly lists all options related to the query planner. The query planning
options are prepended by the keyword "planner." Quick filters return options
that include the keyword in the option name and/or description.
-### Default Button
+**Default Button**
Each option has a Default button that indicates whether the default value for
the option was changed. If the Default button is not active, the option is
currently set to the default value. If the default button is active, the value
of the option was changed from the default. Clicking an active Default button
resets the value of the option back to the original (default) value.
-### Web Display Options
+**Web Display Options**
Prior to Drill 1.15, timestamp, date, and time values did not display
correctly in query results when running queries from the Query page in the
Drill Web UI; however, you can set the output format for these values through
the following three options:
- `web.display_format.date`
