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 38351fe updates for Drill 1.15
38351fe is described below
commit 38351fe9620cbd25c0f5bcaa97b08938f31f694b
Author: Bridget Bevens <[email protected]>
AuthorDate: Thu Dec 27 15:21:24 2018 -0800
updates for Drill 1.15
---
.../030-planning-and-exececution-options.md | 95 +++++++++++++++++++--
_docs/img/web_ui_reset_default.PNG | Bin 0 -> 46472 bytes
_docs/install/060-starting-the-web-ui.md | 6 +-
3 files changed, 93 insertions(+), 8 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 e52fee6..e2294a0 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
@@ -1,6 +1,6 @@
---
title: "Planning and Execution Options"
-date: 2018-11-02
+date: 2018-12-27
parent: "Configuration Options"
---
You can set Drill query planning and execution options per cluster, at the
@@ -9,10 +9,95 @@ 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.
-## Configuring Planning and Execution Options
+# 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.
-Use the [ALTER SYSTEM]({{site.baseurl}}/docs/alter-system/) or
[SET]({{site.baseurl}}/docs/set/) commands to set planning and execution
options. Typically,
+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
+
+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
-persist across all sessions.
+persist across all sessions.
+
+You can run the following query to see a list of options:
+
+ SELECT * FROM sys.options;
+
+The query returns a table that lists options with descriptions and other
details. As of Drill 1.15, there are 179 options:
+
+ SELECT COUNT() AS num_of_sysopts FROM sys.options;
+ +-----------------+
+ | num_of_sysopts |
+ +-----------------+
+ | 179 |
+ +-----------------+
+
+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
+
+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
+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
+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
+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
+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`
+- `web.display_format.time`
+- `web.display_format.timestamp`
+
+**Example: Setting Web Display Options**
+
+The following examples demonstrate how the web display options change the
format for date, time, and timestamp values:
+
+**Date**
+Issuing `select date '2008-2-23' from (values(1))` returns the following
results, by default, in the Web UI:
+
+ 2008-02-23
+
+Issuing the query after setting the `web.display_format.date` option to the
format `EEE, MMM d, yyyy` returns the following results in the Web UI:
+
+ Sat, Feb 23, 2008
+
+**Time**
+Issuing `select time '12:23:34' from (values(1))` returns the following
results, by default, in the Web UI:
+
+ 12:23:34
+
+Issuing the query after setting the `web.display_format.time` option to the
format `HH:mm:ss.SS` returns the following results in the Web UI:
+
+ 12:23:34.00
+
+**Timestamp**
+Issuing ` select timestamp '2008-2-23 12:23:34' from (values(1))` returns the
following results, by default, in the Web UI:
+
+ 2008-02-23T12:23:34
+
+Issuing the query after setting the `web.display_format.timestamp` option to
the format `yyyy-MM-dd HH:mm:ss.SS` returns the following results in the Web
UI:
+
+ 2008-02-23 12:23:34.00
+
+
+
+
+
+
+
+
+
+
-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:
diff --git a/_docs/img/web_ui_reset_default.PNG
b/_docs/img/web_ui_reset_default.PNG
new file mode 100644
index 0000000..9774733
Binary files /dev/null and b/_docs/img/web_ui_reset_default.PNG differ
diff --git a/_docs/install/060-starting-the-web-ui.md
b/_docs/install/060-starting-the-web-ui.md
index 2059333..4c9f710 100644
--- a/_docs/install/060-starting-the-web-ui.md
+++ b/_docs/install/060-starting-the-web-ui.md
@@ -1,12 +1,12 @@
---
title: "Starting the Web UI"
-date: 2018-12-08
+date: 2018-12-27
parent: Install Drill
---
-The Drill Web UI is one of several [client
interfaces](/docs/architecture-introduction/#drill-clients) you can use to
access Drill.
+The Drill Web UI is one of several [client
interfaces](/docs/architecture-introduction/#drill-clients) that you can use to
access Drill.
-To open the Drill Web UI, launch a web browser, and go to one of the following
URLs depending on the configuration of HTTPS support:
+To open the Drill Web UI, launch a web browser, and go to one of the following
URLs depending on the configuration:
* `http://<IP address or host name>:8047`
Use this URL when [HTTPS
support]({{site.baseurl}}/docs/configuring-web-console-and-rest-api-security/#https-support)
is disabled (the default).
