This is an automated email from the ASF dual-hosted git repository.
github-bot pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/datafusion.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 0d69662247 Publish built docs triggered by
9e636d8fe920340409e527da36cff3d2c25aef5f
0d69662247 is described below
commit 0d696622478c6ce4fac523cfb2175b3477718f2f
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Thu Oct 24 20:28:48 2024 +0000
Publish built docs triggered by 9e636d8fe920340409e527da36cff3d2c25aef5f
---
_sources/user-guide/sql/window_functions.md.txt | 30 --------
.../user-guide/sql/window_functions_new.md.txt | 33 +++++++++
searchindex.js | 2 +-
user-guide/sql/index.html | 1 +
user-guide/sql/window_functions.html | 82 +++-------------------
user-guide/sql/window_functions_new.html | 76 ++++++++++++++++++++
6 files changed, 120 insertions(+), 104 deletions(-)
diff --git a/_sources/user-guide/sql/window_functions.md.txt
b/_sources/user-guide/sql/window_functions.md.txt
index 6c0de711bc..0799859e43 100644
--- a/_sources/user-guide/sql/window_functions.md.txt
+++ b/_sources/user-guide/sql/window_functions.md.txt
@@ -184,8 +184,6 @@ ntile(expression)
- [cume_dist](#cume_dist)
- [percent_rank](#percent_rank)
-- [lag](#lag)
-- [lead](#lead)
- [first_value](#first_value)
- [last_value](#last_value)
- [nth_value](#nth_value)
@@ -206,34 +204,6 @@ Relative rank of the current row: (rank - 1) / (total rows
- 1).
percent_rank()
```
-### `lag`
-
-Returns value evaluated at the row that is offset rows before the current row
within the partition; if there is no such row, instead return default (which
must be of the same type as value). Both offset and default are evaluated with
respect to the current row. If omitted, offset defaults to 1 and default to
null.
-
-```sql
-lag(expression, offset, default)
-```
-
-#### Arguments
-
-- **expression**: Expression to operate on
-- **offset**: Integer. Specifies how many rows back the value of _expression_
should be retrieved. Defaults to 1.
-- **default**: The default value if the offset is not within the partition.
Must be of the same type as _expression_.
-
-### `lead`
-
-Returns value evaluated at the row that is offset rows after the current row
within the partition; if there is no such row, instead return default (which
must be of the same type as value). Both offset and default are evaluated with
respect to the current row. If omitted, offset defaults to 1 and default to
null.
-
-```sql
-lead(expression, offset, default)
-```
-
-#### Arguments
-
-- **expression**: Expression to operate on
-- **offset**: Integer. Specifies how many rows forward the value of
_expression_ should be retrieved. Defaults to 1.
-- **default**: The default value if the offset is not within the partition.
Must be of the same type as _expression_.
-
### `first_value`
Returns value evaluated at the row that is the first row of the window frame.
diff --git a/_sources/user-guide/sql/window_functions_new.md.txt
b/_sources/user-guide/sql/window_functions_new.md.txt
index 89ce2284a7..267060abfd 100644
--- a/_sources/user-guide/sql/window_functions_new.md.txt
+++ b/_sources/user-guide/sql/window_functions_new.md.txt
@@ -202,3 +202,36 @@ Number of the current row within its partition, counting
from 1.
```
row_number()
```
+
+## Analytical Functions
+
+- [lag](#lag)
+- [lead](#lead)
+
+### `lag`
+
+Returns value evaluated at the row that is offset rows before the current row
within the partition; if there is no such row, instead return default (which
must be of the same type as value).
+
+```
+lag(expression, offset, default)
+```
+
+#### Arguments
+
+- **expression**: Expression to operate on
+- **offset**: Integer. Specifies how many rows back the value of expression
should be retrieved. Defaults to 1.
+- **default**: The default value if the offset is not within the partition.
Must be of the same type as expression.
+
+### `lead`
+
+Returns value evaluated at the row that is offset rows after the current row
within the partition; if there is no such row, instead return default (which
must be of the same type as value).
+
+```
+lead(expression, offset, default)
+```
+
+#### Arguments
+
+- **expression**: Expression to operate on
+- **offset**: Integer. Specifies how many rows forward the value of expression
should be retrieved. Defaults to 1.
+- **default**: The default value if the offset is not within the partition.
Must be of the same type as expression.
diff --git a/searchindex.js b/searchindex.js
index 5b19097600..81dc94d844 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"!=": [[48, "op-neq"]], "!~": [[48,
"op-re-not-match"]], "!~*": [[48, "op-re-not-match-i"]], "!~~": [[48, "id18"]],
"!~~*": [[48, "id19"]], "#": [[48, "op-bit-xor"]], "%": [[48, "op-modulo"]],
"&": [[48, "op-bit-and"]], "(relation, name) tuples in logical fields and
logical columns are unique": [[9,
"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]], "*":
[[48, "op-multiply"]], "+": [[48, "op-plus"]], "-": [[48, "op-minus"]], "/":
[[4 [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"!=": [[48, "op-neq"]], "!~": [[48,
"op-re-not-match"]], "!~*": [[48, "op-re-not-match-i"]], "!~~": [[48, "id18"]],
"!~~*": [[48, "id19"]], "#": [[48, "op-bit-xor"]], "%": [[48, "op-modulo"]],
"&": [[48, "op-bit-and"]], "(relation, name) tuples in logical fields and
logical columns are unique": [[9,
"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]], "*":
[[48, "op-multiply"]], "+": [[48, "op-plus"]], "-": [[48, "op-minus"]], "/":
[[4 [...]
\ No newline at end of file
diff --git a/user-guide/sql/index.html b/user-guide/sql/index.html
index e6f1dbb711..e7041c4b96 100644
--- a/user-guide/sql/index.html
+++ b/user-guide/sql/index.html
@@ -610,6 +610,7 @@
<li class="toctree-l2"><a class="reference internal"
href="window_functions_new.html#syntax">Syntax</a></li>
<li class="toctree-l2"><a class="reference internal"
href="window_functions_new.html#aggregate-functions">Aggregate
functions</a></li>
<li class="toctree-l2"><a class="reference internal"
href="window_functions_new.html#ranking-functions">Ranking Functions</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="window_functions_new.html#analytical-functions">Analytical
Functions</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal"
href="scalar_functions.html">Scalar Functions</a><ul>
diff --git a/user-guide/sql/window_functions.html
b/user-guide/sql/window_functions.html
index ab5537388c..478301c640 100644
--- a/user-guide/sql/window_functions.html
+++ b/user-guide/sql/window_functions.html
@@ -577,38 +577,6 @@
</code>
</a>
</li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#lag">
- <code class="docutils literal notranslate">
- <span class="pre">
- lag
- </span>
- </code>
- </a>
- <ul class="nav section-nav flex-column">
- <li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id1">
- Arguments
- </a>
- </li>
- </ul>
- </li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#lead">
- <code class="docutils literal notranslate">
- <span class="pre">
- lead
- </span>
- </code>
- </a>
- <ul class="nav section-nav flex-column">
- <li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id2">
- Arguments
- </a>
- </li>
- </ul>
- </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#first-value">
<code class="docutils literal notranslate">
@@ -619,7 +587,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id3">
+ <a class="reference internal nav-link" href="#id1">
Arguments
</a>
</li>
@@ -635,7 +603,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id4">
+ <a class="reference internal nav-link" href="#id2">
Arguments
</a>
</li>
@@ -651,7 +619,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id5">
+ <a class="reference internal nav-link" href="#id3">
Arguments
</a>
</li>
@@ -853,8 +821,6 @@ the rest of the documentation.</p>
<ul class="simple">
<li><p><a class="reference internal" href="#cume-dist">cume_dist</a></p></li>
<li><p><a class="reference internal"
href="#percent-rank">percent_rank</a></p></li>
-<li><p><a class="reference internal" href="#lag">lag</a></p></li>
-<li><p><a class="reference internal" href="#lead">lead</a></p></li>
<li><p><a class="reference internal"
href="#first-value">first_value</a></p></li>
<li><p><a class="reference internal" href="#last-value">last_value</a></p></li>
<li><p><a class="reference internal" href="#nth-value">nth_value</a></p></li>
@@ -873,44 +839,14 @@ the rest of the documentation.</p>
</pre></div>
</div>
</section>
-<section id="lag">
-<h3><code class="docutils literal notranslate"><span
class="pre">lag</span></code><a class="headerlink" href="#lag" title="Link to
this heading">¶</a></h3>
-<p>Returns value evaluated at the row that is offset rows before the current
row within the partition; if there is no such row, instead return default
(which must be of the same type as value). Both offset and default are
evaluated with respect to the current row. If omitted, offset defaults to 1 and
default to null.</p>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">lag</span><span
class="p">(</span><span class="n">expression</span><span
class="p">,</span><span class="w"> </span><span class="k">offset</span><span
class="p">,</span><span class="w"> </span><span class="k">default</span><span
class="p">)</span>
-</pre></div>
-</div>
-<section id="id1">
-<h4>Arguments<a class="headerlink" href="#id1" title="Link to this
heading">¶</a></h4>
-<ul class="simple">
-<li><p><strong>expression</strong>: Expression to operate on</p></li>
-<li><p><strong>offset</strong>: Integer. Specifies how many rows back the
value of <em>expression</em> should be retrieved. Defaults to 1.</p></li>
-<li><p><strong>default</strong>: The default value if the offset is not within
the partition. Must be of the same type as <em>expression</em>.</p></li>
-</ul>
-</section>
-</section>
-<section id="lead">
-<h3><code class="docutils literal notranslate"><span
class="pre">lead</span></code><a class="headerlink" href="#lead" title="Link to
this heading">¶</a></h3>
-<p>Returns value evaluated at the row that is offset rows after the current
row within the partition; if there is no such row, instead return default
(which must be of the same type as value). Both offset and default are
evaluated with respect to the current row. If omitted, offset defaults to 1 and
default to null.</p>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">lead</span><span
class="p">(</span><span class="n">expression</span><span
class="p">,</span><span class="w"> </span><span class="k">offset</span><span
class="p">,</span><span class="w"> </span><span class="k">default</span><span
class="p">)</span>
-</pre></div>
-</div>
-<section id="id2">
-<h4>Arguments<a class="headerlink" href="#id2" title="Link to this
heading">¶</a></h4>
-<ul class="simple">
-<li><p><strong>expression</strong>: Expression to operate on</p></li>
-<li><p><strong>offset</strong>: Integer. Specifies how many rows forward the
value of <em>expression</em> should be retrieved. Defaults to 1.</p></li>
-<li><p><strong>default</strong>: The default value if the offset is not within
the partition. Must be of the same type as <em>expression</em>.</p></li>
-</ul>
-</section>
-</section>
<section id="first-value">
<h3><code class="docutils literal notranslate"><span
class="pre">first_value</span></code><a class="headerlink" href="#first-value"
title="Link to this heading">¶</a></h3>
<p>Returns value evaluated at the row that is the first row of the window
frame.</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">first_value</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id3">
-<h4>Arguments<a class="headerlink" href="#id3" title="Link to this
heading">¶</a></h4>
+<section id="id1">
+<h4>Arguments<a class="headerlink" href="#id1" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on</p></li>
</ul>
@@ -922,8 +858,8 @@ the rest of the documentation.</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">last_value</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id4">
-<h4>Arguments<a class="headerlink" href="#id4" title="Link to this
heading">¶</a></h4>
+<section id="id2">
+<h4>Arguments<a class="headerlink" href="#id2" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on</p></li>
</ul>
@@ -935,8 +871,8 @@ the rest of the documentation.</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="n">nth_value</span><span
class="p">(</span><span class="n">expression</span><span
class="p">,</span><span class="w"> </span><span class="n">n</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id5">
-<h4>Arguments<a class="headerlink" href="#id5" title="Link to this
heading">¶</a></h4>
+<section id="id3">
+<h4>Arguments<a class="headerlink" href="#id3" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The name the column of which nth value to
retrieve</p></li>
<li><p><strong>n</strong>: Integer. Specifies the <em>n</em> in nth</p></li>
diff --git a/user-guide/sql/window_functions_new.html
b/user-guide/sql/window_functions_new.html
index cb0ed05fc8..a92642bdb3 100644
--- a/user-guide/sql/window_functions_new.html
+++ b/user-guide/sql/window_functions_new.html
@@ -565,6 +565,45 @@
</li>
</ul>
</li>
+ <li class="toc-h2 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#analytical-functions">
+ Analytical Functions
+ </a>
+ <ul class="nav section-nav flex-column">
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#lag">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ lag
+ </span>
+ </code>
+ </a>
+ <ul class="nav section-nav flex-column">
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#arguments">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#lead">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ lead
+ </span>
+ </code>
+ </a>
+ <ul class="nav section-nav flex-column">
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id1">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
+ </ul>
+ </li>
</ul>
</nav>
@@ -773,6 +812,43 @@ Instead, the rows retain their separate identities. Behind
the scenes, the windo
</div>
</section>
</section>
+<section id="analytical-functions">
+<h2>Analytical Functions<a class="headerlink" href="#analytical-functions"
title="Link to this heading">¶</a></h2>
+<ul class="simple">
+<li><p><a class="reference internal" href="#lag">lag</a></p></li>
+<li><p><a class="reference internal" href="#lead">lead</a></p></li>
+</ul>
+<section id="lag">
+<h3><code class="docutils literal notranslate"><span
class="pre">lag</span></code><a class="headerlink" href="#lag" title="Link to
this heading">¶</a></h3>
+<p>Returns value evaluated at the row that is offset rows before the current
row within the partition; if there is no such row, instead return default
(which must be of the same type as value).</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">lag</span><span
class="p">(</span><span class="n">expression</span><span class="p">,</span>
<span class="n">offset</span><span class="p">,</span> <span
class="n">default</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="arguments">
+<h4>Arguments<a class="headerlink" href="#arguments" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression</strong>: Expression to operate on</p></li>
+<li><p><strong>offset</strong>: Integer. Specifies how many rows back the
value of expression should be retrieved. Defaults to 1.</p></li>
+<li><p><strong>default</strong>: The default value if the offset is not within
the partition. Must be of the same type as expression.</p></li>
+</ul>
+</section>
+</section>
+<section id="lead">
+<h3><code class="docutils literal notranslate"><span
class="pre">lead</span></code><a class="headerlink" href="#lead" title="Link to
this heading">¶</a></h3>
+<p>Returns value evaluated at the row that is offset rows after the current
row within the partition; if there is no such row, instead return default
(which must be of the same type as value).</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">lead</span><span
class="p">(</span><span class="n">expression</span><span class="p">,</span>
<span class="n">offset</span><span class="p">,</span> <span
class="n">default</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id1">
+<h4>Arguments<a class="headerlink" href="#id1" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression</strong>: Expression to operate on</p></li>
+<li><p><strong>offset</strong>: Integer. Specifies how many rows forward the
value of expression should be retrieved. Defaults to 1.</p></li>
+<li><p><strong>default</strong>: The default value if the offset is not within
the partition. Must be of the same type as expression.</p></li>
+</ul>
+</section>
+</section>
+</section>
</section>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
