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/11 00:39:11 UTC
[drill-site] branch asf-site updated: edits per DRILL-6790
This is an automated email from the ASF dual-hosted git repository.
bridgetb pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/drill-site.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 969f0f8 edits per DRILL-6790
969f0f8 is described below
commit 969f0f8520d703fb8e5945cb26e613bdc2b66470
Author: Bridget Bevens <bb...@maprtech.com>
AuthorDate: Mon Dec 10 16:38:54 2018 -0800
edits per DRILL-6790
---
docs/set/index.html | 81 +++++++++++++++++++++++++++--------------------------
feed.xml | 4 +--
2 files changed, 44 insertions(+), 41 deletions(-)
diff --git a/docs/set/index.html b/docs/set/index.html
index 01124a7..f96c22d 100644
--- a/docs/set/index.html
+++ b/docs/set/index.html
@@ -1274,13 +1274,13 @@
</div>
- Nov 2, 2018
+ Dec 11, 2018
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
<div class="int_text" align="left">
- <p>The SET command replaces the ALTER SESSION SET command in Drill version 1.3 and later. The SET command changes a system setting for the duration of a session. Session level settings override system level settings.</p>
+ <p>Starting in Drill 1.3, the SET command replaces the ALTER SESSION SET command. The SET command changes a system setting for the duration of a session. Session level settings override system level settings.</p>
<h2 id="syntax">Syntax</h2>
@@ -1290,58 +1290,61 @@
<h2 id="parameters">Parameters</h2>
<p><em>option_name</em><br>
-This is the option name as it appears in the systems table.</p>
+This is the option name as it appears in the options table that is stored in the sys database (schema).</p>
<p><em>value</em><br>
-A value of the type listed in the sys.options table: number, string, boolean,
+A value of the type listed in the val column of the sys.options table: number, string, boolean,
or float. Use the appropriate value type for each option that you set.</p>
<h2 id="usage-notes">Usage Notes</h2>
-<p>You can still use the ALTER SESSION SET command, however ALTER SESSION is now just an alias for the SET command. Use the SET command to change Drill query planning and execution
-options per session in a cluster. The options that you set only apply to queries that run during the current Drill connection. A session ends when you quit the Drill shell. You can set any of the system level options at the session level. You can use the <a href="/docs/reset">RESET</a> command to change the value of an option back to the default system setting.</p>
+<ul>
+<li>You can still use the ALTER SESSION SET command; however, ALTER SESSION is now just an alias for the SET command.</li>
+<li>Use the SET command to change Drill query planning and execution options per session in a cluster. </li>
+<li>The options that you set only apply to queries that run during the current Drill connection. </li>
+<li>A session ends when you quit the Drill shell. </li>
+<li>You can set any of the system level options at the session level. </li>
+<li>Use the <a href="/docs/reset">RESET</a> command to change the value of an option back to the default system setting.</li>
+</ul>
-<p>You can run the following query to see a complete list of planning and
-execution options that are currently set at the system or session level:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> SELECT name, type FROM sys.options WHERE type in ('SYSTEM','SESSION') order by name;
-+------------+------------------------------------------------+
-| name | type |
-+----------------------------------------------+--------------+
-| drill.exec.functions.cast_empty_string_to_null | SYSTEM |
-| drill.exec.storage.file.partition.column.label | SYSTEM |
-| exec.errors.verbose | SYSTEM |
-| exec.java_compiler | SYSTEM |
-| exec.java_compiler_debug | SYSTEM |
-…
-+------------+------------------------------------------------+
+<p>The following query returns the planning and execution options that are currently set at the system level:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM sys.options WHERE optionScope IN ('SYSTEM') ORDER BY name;
++-------------------------------------------+---------+-------------------+-------------+----------+--------------+----------------------------------------------------------------------------------+
+| name | kind | accessibleScopes | val | status | optionScope | description |
++-------------------------------------------+---------+-------------------+-------------+----------+--------------+----------------------------------------------------------------------------------+
+| debug.validate_iterators | BIT | ALL | true | CHANGED | SYSTEM | |
+| exec.query.progress.update | BIT | ALL | false | CHANGED | SYSTEM | |
+| planner.memory.max_query_memory_per_node | BIGINT | ALL | 2147483750 | CHANGED | SYSTEM | Sets the maximum amount of direct memory allocated to the Sort and Hash Aggregate operators during each que... |
++-------------------------------------------+---------+-------------------+-------------+----------+--------------+----------------------------------------------------------------------------------+
</code></pre></div>
-<div class="admonition note">
- <p class="first admonition-title">Note</p>
- <p class="last">This is a truncated version of the list. </p>
-</div>
-
-<h2 id="example">Example</h2>
+<h2 id="examples">Examples</h2>
-<p>This example demonstrates how to use the SET command to set the
-<code>store.json.all_text_mode</code> option to “true” for the current Drill session.
-Setting this option to “true” enables text mode so that Drill reads everything
-in JSON as a text object instead of trying to interpret data types. This
-allows complicated JSON to be read using CASE and CAST.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text"> 0: jdbc:drill:zk=local> SET `store.json.all_text_mode`= true;
+<p>This example demonstrates how to use the SET command to set the <code>store.json.all_text_mode</code> option to “true” for the current Drill session.
+Setting this option to “true” enables text mode so that Drill reads everything in JSON as a text object instead of trying to interpret data types. </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text"> SET `store.json.all_text_mode`= true;
+-------+------------------------------------+
| ok | summary |
+-------+------------------------------------+
| true | store.json.all_text_mode updated. |
+-------+------------------------------------+
</code></pre></div>
-<p>You can issue a query to see options set at the session level. Note that the
-option type is case-sensitive.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text"> 0: jdbc:drill:zk=local> SELECT name, type, bool_val FROM sys.options WHERE type = 'SESSION' order by name;
- +---------------------------+----------+-----------+
- | name | type | bool_val |
- +---------------------------+----------+-----------+
- | store.json.all_text_mode | SESSION | true |
- +---------------------------+----------+-----------+
+<p><strong>Note:</strong> Drill reads complicated JSON using CASE and CAST. </p>
+
+<p>The following query returns the planning and execution options currently set at the session level after changing the value of the <code>debug.validate_iterators</code> option to "false": </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">SET `debug.validate_iterators` = false;
++-------+------------------------------------+
+| ok | summary |
++-------+------------------------------------+
+| true | debug.validate_iterators updated. |
++-------+------------------------------------+
+
+
+SELECT * FROM sys.options WHERE optionScope IN ('SESSION') ORDER BY name;
++---------------------------+-------+-------------------+--------+----------+--------------+--------------+
+| name | kind | accessibleScopes | val | status | optionScope | description |
++---------------------------+-------+-------------------+--------+----------+--------------+--------------+
+| debug.validate_iterators | BIT | ALL | false | DEFAULT | SESSION | |
++---------------------------+-------+-------------------+--------+----------+--------------+--------------+
</code></pre></div>
diff --git a/feed.xml b/feed.xml
index e123538..8aad132 100644
--- a/feed.xml
+++ b/feed.xml
@@ -6,8 +6,8 @@
</description>
<link>/</link>
<atom:link href="/feed.xml" rel="self" type="application/rss+xml"/>
- <pubDate>Mon, 10 Dec 2018 14:58:23 -0800</pubDate>
- <lastBuildDate>Mon, 10 Dec 2018 14:58:23 -0800</lastBuildDate>
+ <pubDate>Mon, 10 Dec 2018 16:34:32 -0800</pubDate>
+ <lastBuildDate>Mon, 10 Dec 2018 16:34:32 -0800</lastBuildDate>
<generator>Jekyll v2.5.2</generator>
<item>