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 fa3fdb4 edits
fa3fdb4 is described below
commit fa3fdb4ff33c67f8c3fc10b3eda818b0e4fb29ee
Author: Bridget Bevens <[email protected]>
AuthorDate: Thu Apr 18 12:38:12 2019 -0700
edits
---
docs/limit-clause/index.html | 8 +++++---
docs/planning-and-execution-options/index.html | 6 +++---
feed.xml | 4 ++--
3 files changed, 10 insertions(+), 8 deletions(-)
diff --git a/docs/limit-clause/index.html b/docs/limit-clause/index.html
index fc54b0f..7e38058 100644
--- a/docs/limit-clause/index.html
+++ b/docs/limit-clause/index.html
@@ -1310,13 +1310,15 @@
</div>
- Aug 5, 2018
+ Apr 18, 2019
<link href="/css/docpage.css" rel="stylesheet" type="text/css">
<div class="int_text" align="left">
- <p>The LIMIT clause limits the result set to the specified number of
rows. You can use LIMIT with or without an ORDER BY clause.</p>
+ <p>The LIMIT clause limits the result set to the specified number of
rows. You can use LIMIT with or without an ORDER BY clause. </p>
+
+<p>Starting in Drill 1.16, you can configure an automatic limit on the number
of rows returned from a result set. See <a
href="/docs/planning-and-execution-options/#setting-an-auto-limit-on-the-number-of-rows-returned-for-result-sets">Setting
an Auto Limit on the Number of Rows Returned for Result Sets</a>.</p>
<h2 id="syntax">Syntax</h2>
@@ -1396,7 +1398,7 @@ LIMIT 0 optimizations do not work for queries with the
UNION [ALL] set operator
<li>CONVERT_TOJSON<br></li>
<li>CONVERT_TOSIMPLEJSON<br></li>
<li>CONVERT_TOEXTENDEDJSON<br></li>
-<li>AVG (window function)</li>
+<li>AVG (window function)<br></li>
</ul>
<h2 id="examples">Examples</h2>
diff --git a/docs/planning-and-execution-options/index.html
b/docs/planning-and-execution-options/index.html
index bb0b479..8f39068 100644
--- a/docs/planning-and-execution-options/index.html
+++ b/docs/planning-and-execution-options/index.html
@@ -1349,9 +1349,9 @@ persist across all sessions. </p>
<h3 id="setting-options-from-the-drill-web-ui">Setting Options from the Drill
Web UI</h3>
-<p>When Drill is running, you can access the Drill Web UI at
<code>http://<drill-hostname>:8047/</code>. 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. </p>
+<p>When Drill is running, you can access the Drill Web UI at
<code>http://<drill-hostname>:8047/</code>. The Drill Web UI has an
Options button located in the upper right corner that you can click to display
an Options page. </p>
-<p><img src="https://i.imgur.com/WMij8gQ.png"; alt=""> </p>
+<p>The Options page lists all the Drill options that you can set 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. </p>
<p>Starting in Drill 1.15, the Options page includes the following
enhancements: </p>
@@ -1398,7 +1398,7 @@ Issuing <code>select timestamp '2008-2-23
12:23:34' from (values(1))</co
<p>Issuing the query after setting the
<code>web.display_format.timestamp</code> option to the format <code>yyyy-MM-dd
HH:mm:ss.SS</code> returns the following results in the Web UI: </p>
<div class="highlight"><pre><code class="language-text"
data-lang="text">2008-02-23 12:23:34.00
</code></pre></div>
-<h2 id="limiting-the-number-of-rows-returned-for-result-sets">Limiting the
Number of Rows Returned for Result Sets</h2>
+<h2
id="setting-an-auto-limit-on-the-number-of-rows-returned-for-result-sets">Setting
an Auto Limit on the Number of Rows Returned for Result Sets</h2>
<p>The <code>exec.query.max_rows</code> option, introduced in Drill 1.16,
automatically limits the number of rows that Drill returns from a result set.
When you configure a limit, the limit is automatically applied by Drill when
you run a query. You do not need to include the LIMIT clause. Configuring a
limit on results reduces the amount of processing and streaming work for the
web server when using the Drill WEb UI. </p>
diff --git a/feed.xml b/feed.xml
index a8cabe0..5760102 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>Thu, 18 Apr 2019 12:19:09 -0700</pubDate>
- <lastBuildDate>Thu, 18 Apr 2019 12:19:09 -0700</lastBuildDate>
+ <pubDate>Thu, 18 Apr 2019 12:35:49 -0700</pubDate>
+ <lastBuildDate>Thu, 18 Apr 2019 12:35:49 -0700</lastBuildDate>
<generator>Jekyll v2.5.2</generator>
<item>
![https://i.imgur.com/WMij8gQ.png"](https://i.imgur.com/WMij8gQ.png"){kind=link}