You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@datafusion.apache.org by gi...@apache.org on 2024/11/13 16:57:27 UTC
(datafusion) branch asf-site updated: Publish built docs triggered by 54ab12827cc9fecc80e115bc800dabf19e73b1c3
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 e27e196eef Publish built docs triggered by 54ab12827cc9fecc80e115bc800dabf19e73b1c3
e27e196eef is described below
commit e27e196eef82f31216f401649443a2fde7f02e74
Author: github-actions[bot] <gi...@users.noreply.github.com>
AuthorDate: Wed Nov 13 16:57:23 2024 +0000
Publish built docs triggered by 54ab12827cc9fecc80e115bc800dabf19e73b1c3
---
.../user-guide/sql/window_functions_new.md.txt | 40 ++++++++
searchindex.js | 2 +-
user-guide/sql/window_functions_new.html | 103 +++++++++++++++++++--
3 files changed, 138 insertions(+), 7 deletions(-)
diff --git a/_sources/user-guide/sql/window_functions_new.md.txt b/_sources/user-guide/sql/window_functions_new.md.txt
index ae3edb832f..1727dececb 100644
--- a/_sources/user-guide/sql/window_functions_new.md.txt
+++ b/_sources/user-guide/sql/window_functions_new.md.txt
@@ -218,8 +218,23 @@ row_number()
## Analytical Functions
+- [first_value](#first_value)
- [lag](#lag)
+- [last_value](#last_value)
- [lead](#lead)
+- [nth_value](#nth_value)
+
+### `first_value`
+
+Returns value evaluated at the row that is the first row of the window frame.
+
+```
+first_value(expression)
+```
+
+#### Arguments
+
+- **expression**: Expression to operate on
### `lag`
@@ -235,6 +250,18 @@ lag(expression, offset, default)
- **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.
+### `last_value`
+
+Returns value evaluated at the row that is the last row of the window frame.
+
+```
+last_value(expression)
+```
+
+#### Arguments
+
+- **expression**: Expression to operate on
+
### `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).
@@ -248,3 +275,16 @@ lead(expression, offset, default)
- **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.
+
+### `nth_value`
+
+Returns value evaluated at the row that is the nth row of the window frame (counting from 1); null if no such row.
+
+```
+nth_value(expression, n)
+```
+
+#### Arguments
+
+- **expression**: The name the column of which nth value to retrieve
+- **n**: Integer. Specifies the n in nth
diff --git a/searchindex.js b/searchindex.js
index 8de9333bb8..0053acf4f7 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"!=": [[47, "op-neq"]], "!~": [[47, "op-re-not-match"]], "!~*": [[47, "op-re-not-match-i"]], "!~~": [[47, "id18"]], "!~~*": [[47, "id19"]], "#": [[47, "op-bit-xor"]], "%": [[47, "op-modulo"]], "&": [[47, "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"]], "*": [[47, "op-multiply"]], "+": [[47, "op-plus"]], "-": [[47, "op-minus"]], "/": [[4 [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"!=": [[47, "op-neq"]], "!~": [[47, "op-re-not-match"]], "!~*": [[47, "op-re-not-match-i"]], "!~~": [[47, "id18"]], "!~~*": [[47, "id19"]], "#": [[47, "op-bit-xor"]], "%": [[47, "op-modulo"]], "&": [[47, "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"]], "*": [[47, "op-multiply"]], "+": [[47, "op-plus"]], "-": [[47, "op-minus"]], "/": [[4 [...]
\ No newline at end of file
diff --git a/user-guide/sql/window_functions_new.html b/user-guide/sql/window_functions_new.html
index 71258bd135..fd48564e1a 100644
--- a/user-guide/sql/window_functions_new.html
+++ b/user-guide/sql/window_functions_new.html
@@ -586,6 +586,22 @@
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="#first-value">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ first_value
+ </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="#lag">
<code class="docutils literal notranslate">
@@ -596,7 +612,23 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id1">
+ <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="#last-value">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ last_value
+ </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="#id3">
Arguments
</a>
</li>
@@ -612,7 +644,23 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id2">
+ <a class="reference internal nav-link" href="#id4">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#nth-value">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ nth_value
+ </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="#id5">
Arguments
</a>
</li>
@@ -845,17 +893,33 @@ Instead, the rows retain their separate identities. Behind the scenes, the windo
<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="#first-value">first_value</a></p></li>
<li><p><a class="reference internal" href="#lag">lag</a></p></li>
+<li><p><a class="reference internal" href="#last-value">last_value</a></p></li>
<li><p><a class="reference internal" href="#lead">lead</a></p></li>
+<li><p><a class="reference internal" href="#nth-value">nth_value</a></p></li>
+</ul>
+<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-default 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="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>
+</section>
+</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).</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="id1">
-<h4>Arguments<a class="headerlink" href="#id1" 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>
<li><p><strong>offset</strong>: Integer. Specifies how many rows back the value of expression should be retrieved. Defaults to 1.</p></li>
@@ -863,14 +927,27 @@ Instead, the rows retain their separate identities. Behind the scenes, the windo
</ul>
</section>
</section>
+<section id="last-value">
+<h3><code class="docutils literal notranslate"><span class="pre">last_value</span></code><a class="headerlink" href="#last-value" title="Link to this heading">¶</a></h3>
+<p>Returns value evaluated at the row that is the last row of the window frame.</p>
+<div class="highlight-default 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="id3">
+<h4>Arguments<a class="headerlink" href="#id3" title="Link to this heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression</strong>: Expression to operate on</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="id2">
-<h4>Arguments<a class="headerlink" href="#id2" title="Link to this heading">¶</a></h4>
+<section id="id4">
+<h4>Arguments<a class="headerlink" href="#id4" 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>
@@ -878,6 +955,20 @@ Instead, the rows retain their separate identities. Behind the scenes, the windo
</ul>
</section>
</section>
+<section id="nth-value">
+<h3><code class="docutils literal notranslate"><span class="pre">nth_value</span></code><a class="headerlink" href="#nth-value" title="Link to this heading">¶</a></h3>
+<p>Returns value evaluated at the row that is the nth row of the window frame (counting from 1); null if no such row.</p>
+<div class="highlight-default 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="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>
+<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 n in nth</p></li>
+</ul>
+</section>
+</section>
</section>
</section>
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datafusion.apache.org
For additional commands, e-mail: commits-help@datafusion.apache.org