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/12/27 23:22:28 UTC
[drill] branch gh-pages updated: updates for Drill 1.15
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 <bb...@maprtech.com>
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).