This is an automated email from the ASF dual-hosted git repository.
git-site-role 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 192972b Automatic Site Publish by Buildbot
192972b is described below
commit 192972b1ce6cf780c86e4f1c88ec11badf97ba38
Author: buildbot <[email protected]>
AuthorDate: Wed Sep 15 09:07:04 2021 +0000
Automatic Site Publish by Buildbot
---
output/docs/limit-clause/index.html | 11 +++++++----
output/docs/offset-clause/index.html | 10 +++-------
output/feed.xml | 4 ++--
output/zh/docs/limit-clause/index.html | 11 +++++++----
output/zh/docs/offset-clause/index.html | 10 +++-------
output/zh/feed.xml | 4 ++--
6 files changed, 24 insertions(+), 26 deletions(-)
diff --git a/output/docs/limit-clause/index.html
b/output/docs/limit-clause/index.html
index 44baa88..359c76c 100644
--- a/output/docs/limit-clause/index.html
+++ b/output/docs/limit-clause/index.html
@@ -1426,14 +1426,17 @@
<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><strong>Introduced in release:</strong> 1.16</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>
+<p>The LIMIT clause limits the result set to the specified number of rows. You
can use LIMIT with or without ORDER BY and OFFSET clauses.</p>
+
+<p>You can also 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>
-<p>The LIMIT clause supports the following syntax:</p>
+<p>The LIMIT clause supports the following syntaxes:</p>
+<div class="language-sql highlighter-rouge"><div class="highlight"><pre
class="highlight"><code><span class="k">LIMIT</span> <span class="err">{</span>
<span class="k">count</span> <span class="o">|</span> <span
class="k">ALL</span> <span class="err">}</span>
-<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code> LIMIT { count | ALL }
+<span class="k">FETCH</span> <span class="k">NEXT</span> <span
class="k">count</span> <span class="err">{</span> <span class="k">ROW</span>
<span class="o">|</span> <span class="k">ROWS</span> <span class="err">}</span>
<span class="k">ONLY</span>
</code></pre></div></div>
<h2 id="parameters">Parameters</h2>
diff --git a/output/docs/offset-clause/index.html
b/output/docs/offset-clause/index.html
index 3eca48c..ca0aff2 100644
--- a/output/docs/offset-clause/index.html
+++ b/output/docs/offset-clause/index.html
@@ -1430,12 +1430,10 @@
<h2 id="syntax">Syntax</h2>
<p>The OFFSET clause supports the following syntax:</p>
-
-<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code> OFFSET start { ROW | ROWS }
+<div class="language-sql highlighter-rouge"><div class="highlight"><pre
class="highlight"><code><span class="k">OFFSET</span> <span
class="k">start</span> <span class="err">{</span> <span class="k">ROW</span>
<span class="o">|</span> <span class="k">ROWS</span> <span class="err">}</span>
</code></pre></div></div>
-
<h2 id="parameters">Parameters</h2>
-<p><em>rows</em><br />
+<p><em>rows</em>
Specifies the number of rows Drill should skip before returning the result
set.</p>
<h2 id="usage-notes">Usage Notes</h2>
@@ -1448,11 +1446,9 @@ Specifies the number of rows Drill should skip before
returning the result set.<
<h2 id="examples">Examples</h2>
<p>The following example query returns the result set from row 101 and on,
skipping the first 100 rows of the table:</p>
-
-<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code> SELECT * FROM dfs.logs OFFSET 100 ROWS;
+<div class="language-sql highlighter-rouge"><div class="highlight"><pre
class="highlight"><code><span class="k">SELECT</span> <span class="o">*</span>
<span class="k">FROM</span> <span class="n">dfs</span><span
class="p">.</span><span class="n">logs</span> <span class="k">OFFSET</span>
<span class="mi">100</span> <span class="k">ROWS</span><span class="p">;</span>
</code></pre></div></div>
-
<div class="doc-nav">
diff --git a/output/feed.xml b/output/feed.xml
index 4c4d04a..2f466e2 100644
--- a/output/feed.xml
+++ b/output/feed.xml
@@ -6,8 +6,8 @@
</description>
<link>/</link>
<atom:link href="/feed.xml" rel="self" type="application/rss+xml"/>
- <pubDate>Tue, 14 Sep 2021 13:25:41 +0000</pubDate>
- <lastBuildDate>Tue, 14 Sep 2021 13:25:41 +0000</lastBuildDate>
+ <pubDate>Wed, 15 Sep 2021 09:04:17 +0000</pubDate>
+ <lastBuildDate>Wed, 15 Sep 2021 09:04:17 +0000</lastBuildDate>
<generator>Jekyll v3.9.1</generator>
<item>
diff --git a/output/zh/docs/limit-clause/index.html
b/output/zh/docs/limit-clause/index.html
index 6572c20..49661cc 100644
--- a/output/zh/docs/limit-clause/index.html
+++ b/output/zh/docs/limit-clause/index.html
@@ -1426,14 +1426,17 @@
<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><strong>Introduced in release:</strong> 1.16</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="/zh/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>
+<p>The LIMIT clause limits the result set to the specified number of rows. You
can use LIMIT with or without ORDER BY and OFFSET clauses.</p>
+
+<p>You can also configure an automatic limit on the number of rows returned
from a result set. See <a
href="/zh/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>
-<p>The LIMIT clause supports the following syntax:</p>
+<p>The LIMIT clause supports the following syntaxes:</p>
+<div class="language-sql highlighter-rouge"><div class="highlight"><pre
class="highlight"><code><span class="k">LIMIT</span> <span class="err">{</span>
<span class="k">count</span> <span class="o">|</span> <span
class="k">ALL</span> <span class="err">}</span>
-<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code> LIMIT { count | ALL }
+<span class="k">FETCH</span> <span class="k">NEXT</span> <span
class="k">count</span> <span class="err">{</span> <span class="k">ROW</span>
<span class="o">|</span> <span class="k">ROWS</span> <span class="err">}</span>
<span class="k">ONLY</span>
</code></pre></div></div>
<h2 id="parameters">Parameters</h2>
diff --git a/output/zh/docs/offset-clause/index.html
b/output/zh/docs/offset-clause/index.html
index ac90f09..04a192b 100644
--- a/output/zh/docs/offset-clause/index.html
+++ b/output/zh/docs/offset-clause/index.html
@@ -1430,12 +1430,10 @@
<h2 id="syntax">Syntax</h2>
<p>The OFFSET clause supports the following syntax:</p>
-
-<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code> OFFSET start { ROW | ROWS }
+<div class="language-sql highlighter-rouge"><div class="highlight"><pre
class="highlight"><code><span class="k">OFFSET</span> <span
class="k">start</span> <span class="err">{</span> <span class="k">ROW</span>
<span class="o">|</span> <span class="k">ROWS</span> <span class="err">}</span>
</code></pre></div></div>
-
<h2 id="parameters">Parameters</h2>
-<p><em>rows</em><br />
+<p><em>rows</em>
Specifies the number of rows Drill should skip before returning the result
set.</p>
<h2 id="usage-notes">Usage Notes</h2>
@@ -1448,11 +1446,9 @@ Specifies the number of rows Drill should skip before
returning the result set.<
<h2 id="examples">Examples</h2>
<p>The following example query returns the result set from row 101 and on,
skipping the first 100 rows of the table:</p>
-
-<div class="language-plaintext highlighter-rouge"><div class="highlight"><pre
class="highlight"><code> SELECT * FROM dfs.logs OFFSET 100 ROWS;
+<div class="language-sql highlighter-rouge"><div class="highlight"><pre
class="highlight"><code><span class="k">SELECT</span> <span class="o">*</span>
<span class="k">FROM</span> <span class="n">dfs</span><span
class="p">.</span><span class="n">logs</span> <span class="k">OFFSET</span>
<span class="mi">100</span> <span class="k">ROWS</span><span class="p">;</span>
</code></pre></div></div>
-
<div class="doc-nav">
diff --git a/output/zh/feed.xml b/output/zh/feed.xml
index cb991db..3cf3ab5 100644
--- a/output/zh/feed.xml
+++ b/output/zh/feed.xml
@@ -6,8 +6,8 @@
</description>
<link>/</link>
<atom:link href="/zh/feed.xml" rel="self" type="application/rss+xml"/>
- <pubDate>Tue, 14 Sep 2021 13:25:41 +0000</pubDate>
- <lastBuildDate>Tue, 14 Sep 2021 13:25:41 +0000</lastBuildDate>
+ <pubDate>Wed, 15 Sep 2021 09:04:17 +0000</pubDate>
+ <lastBuildDate>Wed, 15 Sep 2021 09:04:17 +0000</lastBuildDate>
<generator>Jekyll v3.9.1</generator>
<item>
