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/arrow-datafusion.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 9be2f2a9f4 Publish built docs triggered by
f54f514a4923bc49e0e1c57a4cf570aebd1b6137
9be2f2a9f4 is described below
commit 9be2f2a9f4336e0af11edacc23f18794227f9dee
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Fri May 26 21:23:43 2023 +0000
Publish built docs triggered by f54f514a4923bc49e0e1c57a4cf570aebd1b6137
---
_sources/user-guide/sql/aggregate_functions.md.txt | 28 ++++
searchindex.js | 2 +-
user-guide/sql/aggregate_functions.html | 146 +++++++++++++++------
3 files changed, 133 insertions(+), 43 deletions(-)
diff --git a/_sources/user-guide/sql/aggregate_functions.md.txt
b/_sources/user-guide/sql/aggregate_functions.md.txt
index d02c733efc..132ba47e24 100644
--- a/_sources/user-guide/sql/aggregate_functions.md.txt
+++ b/_sources/user-guide/sql/aggregate_functions.md.txt
@@ -36,6 +36,8 @@ Aggregate functions operate on a set of values to compute a
single result.
- [min](#min)
- [sum](#sum)
- [array_agg](#array_agg)
+- [first_value](#first_value)
+- [last_value](#last_value)
### `avg`
@@ -202,6 +204,32 @@ array_agg(expression [ORDER BY expression])
#### Arguments
+- **expression**: Expression to operate on.
+ Can be a constant, column, or function, and any combination of arithmetic
operators.
+
+### `first_value`
+
+Returns the first element in an aggregation group according to the requested
ordering. If no ordering is given, returns an arbitrary element from the group.
+
+```
+first_value(expression [ORDER BY expression])
+```
+
+#### Arguments
+
+- **expression**: Expression to operate on.
+ Can be a constant, column, or function, and any combination of arithmetic
operators.
+
+### `last_value`
+
+Returns the last element in an aggregation group according to the requested
ordering. If no ordering is given, returns an arbitrary element from the group.
+
+```
+last_value(expression [ORDER BY expression])
+```
+
+#### Arguments
+
- **expression**: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.
diff --git a/searchindex.js b/searchindex.js
index c63c8d40aa..9a57707f60 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"docnames": ["contributor-guide/architecture",
"contributor-guide/communication", "contributor-guide/index",
"contributor-guide/quarterly_roadmap", "contributor-guide/roadmap",
"contributor-guide/specification/index",
"contributor-guide/specification/invariants",
"contributor-guide/specification/output-field-name-semantic", "index",
"user-guide/cli", "user-guide/configs", "user-guide/dataframe",
"user-guide/example-usage", "user-guide/expressions", "user-guide/faq", "use
[...]
\ No newline at end of file
+Search.setIndex({"docnames": ["contributor-guide/architecture",
"contributor-guide/communication", "contributor-guide/index",
"contributor-guide/quarterly_roadmap", "contributor-guide/roadmap",
"contributor-guide/specification/index",
"contributor-guide/specification/invariants",
"contributor-guide/specification/output-field-name-semantic", "index",
"user-guide/cli", "user-guide/configs", "user-guide/dataframe",
"user-guide/example-usage", "user-guide/expressions", "user-guide/faq", "use
[...]
\ No newline at end of file
diff --git a/user-guide/sql/aggregate_functions.html
b/user-guide/sql/aggregate_functions.html
index 73e42629cf..9b5b19262d 100644
--- a/user-guide/sql/aggregate_functions.html
+++ b/user-guide/sql/aggregate_functions.html
@@ -489,6 +489,38 @@
</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">
+ <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="#id12">
+ 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="#id13">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
</ul>
</li>
<li class="toc-h2 nav-item toc-entry">
@@ -506,7 +538,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id12">
+ <a class="reference internal nav-link" href="#id14">
Arguments
</a>
</li>
@@ -522,7 +554,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id13">
+ <a class="reference internal nav-link" href="#id15">
Arguments
</a>
</li>
@@ -538,7 +570,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id14">
+ <a class="reference internal nav-link" href="#id16">
Arguments
</a>
</li>
@@ -554,7 +586,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id15">
+ <a class="reference internal nav-link" href="#id17">
Arguments
</a>
</li>
@@ -570,7 +602,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id16">
+ <a class="reference internal nav-link" href="#id18">
Arguments
</a>
</li>
@@ -586,7 +618,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id17">
+ <a class="reference internal nav-link" href="#id19">
Arguments
</a>
</li>
@@ -602,7 +634,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id18">
+ <a class="reference internal nav-link" href="#id20">
Arguments
</a>
</li>
@@ -618,7 +650,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id19">
+ <a class="reference internal nav-link" href="#id21">
Arguments
</a>
</li>
@@ -634,7 +666,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id20">
+ <a class="reference internal nav-link" href="#id22">
Arguments
</a>
</li>
@@ -650,7 +682,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id21">
+ <a class="reference internal nav-link" href="#id23">
Arguments
</a>
</li>
@@ -673,7 +705,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id22">
+ <a class="reference internal nav-link" href="#id24">
Arguments
</a>
</li>
@@ -689,7 +721,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id23">
+ <a class="reference internal nav-link" href="#id25">
Arguments
</a>
</li>
@@ -705,7 +737,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id24">
+ <a class="reference internal nav-link" href="#id26">
Arguments
</a>
</li>
@@ -721,7 +753,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id25">
+ <a class="reference internal nav-link" href="#id27">
Arguments
</a>
</li>
@@ -794,6 +826,8 @@
<li><p><a class="reference internal" href="#min">min</a></p></li>
<li><p><a class="reference internal" href="#sum">sum</a></p></li>
<li><p><a class="reference internal" href="#array-agg">array_agg</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>
</ul>
<section id="avg">
<h3><code class="docutils literal notranslate"><span
class="pre">avg</span></code><a class="headerlink" href="#avg" title="Permalink
to this heading">¶</a></h3>
@@ -976,6 +1010,34 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
</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="Permalink to this heading">¶</a></h3>
+<p>Returns the first element in an aggregation group according to the
requested ordering. If no ordering is given, returns an arbitrary element from
the group.</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><span class="n">ORDER</span> <span class="n">BY</span> <span
class="n">expression</span><span class="p">])</span>
+</pre></div>
+</div>
+<section id="id12">
+<h4>Arguments<a class="headerlink" href="#id12" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression</strong>: Expression to operate on.
+Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
+</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="Permalink to this heading">¶</a></h3>
+<p>Returns the last element in an aggregation group according to the requested
ordering. If no ordering is given, returns an arbitrary element from the
group.</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><span class="n">ORDER</span> <span class="n">BY</span> <span
class="n">expression</span><span class="p">])</span>
+</pre></div>
+</div>
+<section id="id13">
+<h4>Arguments<a class="headerlink" href="#id13" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression</strong>: Expression to operate on.
+Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
+</ul>
+</section>
+</section>
</section>
<section id="statistical">
<h2>Statistical<a class="headerlink" href="#statistical" title="Permalink to
this heading">¶</a></h2>
@@ -997,8 +1059,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">corr</span><span
class="p">(</span><span class="n">expression1</span><span class="p">,</span>
<span class="n">expression2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id12">
-<h4>Arguments<a class="headerlink" href="#id12" title="Permalink to this
heading">¶</a></h4>
+<section id="id14">
+<h4>Arguments<a class="headerlink" href="#id14" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression1</strong>: First expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -1013,8 +1075,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">covar</span><span
class="p">(</span><span class="n">expression1</span><span class="p">,</span>
<span class="n">expression2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id13">
-<h4>Arguments<a class="headerlink" href="#id13" title="Permalink to this
heading">¶</a></h4>
+<section id="id15">
+<h4>Arguments<a class="headerlink" href="#id15" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression1</strong>: First expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -1029,8 +1091,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">covar_pop</span><span
class="p">(</span><span class="n">expression1</span><span class="p">,</span>
<span class="n">expression2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id14">
-<h4>Arguments<a class="headerlink" href="#id14" title="Permalink to this
heading">¶</a></h4>
+<section id="id16">
+<h4>Arguments<a class="headerlink" href="#id16" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression1</strong>: First expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -1045,8 +1107,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">covar_samp</span><span
class="p">(</span><span class="n">expression1</span><span class="p">,</span>
<span class="n">expression2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id15">
-<h4>Arguments<a class="headerlink" href="#id15" title="Permalink to this
heading">¶</a></h4>
+<section id="id17">
+<h4>Arguments<a class="headerlink" href="#id17" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression1</strong>: First expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -1061,8 +1123,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">stddev</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id16">
-<h4>Arguments<a class="headerlink" href="#id16" title="Permalink to this
heading">¶</a></h4>
+<section id="id18">
+<h4>Arguments<a class="headerlink" href="#id18" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -1075,8 +1137,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">stddev_pop</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id17">
-<h4>Arguments<a class="headerlink" href="#id17" title="Permalink to this
heading">¶</a></h4>
+<section id="id19">
+<h4>Arguments<a class="headerlink" href="#id19" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -1089,8 +1151,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">stddev_samp</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id18">
-<h4>Arguments<a class="headerlink" href="#id18" title="Permalink to this
heading">¶</a></h4>
+<section id="id20">
+<h4>Arguments<a class="headerlink" href="#id20" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -1103,8 +1165,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">var</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id19">
-<h4>Arguments<a class="headerlink" href="#id19" title="Permalink to this
heading">¶</a></h4>
+<section id="id21">
+<h4>Arguments<a class="headerlink" href="#id21" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -1117,8 +1179,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">var_pop</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id20">
-<h4>Arguments<a class="headerlink" href="#id20" title="Permalink to this
heading">¶</a></h4>
+<section id="id22">
+<h4>Arguments<a class="headerlink" href="#id22" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -1131,8 +1193,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">var_samp</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id21">
-<h4>Arguments<a class="headerlink" href="#id21" title="Permalink to this
heading">¶</a></h4>
+<section id="id23">
+<h4>Arguments<a class="headerlink" href="#id23" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -1155,8 +1217,8 @@ HyperLogLog algorithm.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">approx_distinct</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id22">
-<h4>Arguments<a class="headerlink" href="#id22" title="Permalink to this
heading">¶</a></h4>
+<section id="id24">
+<h4>Arguments<a class="headerlink" href="#id24" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -1170,8 +1232,8 @@ It is an alias of <code class="docutils literal
notranslate"><span class="pre">a
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">approx_median</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id23">
-<h4>Arguments<a class="headerlink" href="#id23" title="Permalink to this
heading">¶</a></h4>
+<section id="id25">
+<h4>Arguments<a class="headerlink" href="#id25" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -1184,8 +1246,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span
class="n">approx_percentile_cont</span><span class="p">(</span><span
class="n">expression</span><span class="p">,</span> <span
class="n">percentile</span><span class="p">,</span> <span
class="n">centroids</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id24">
-<h4>Arguments<a class="headerlink" href="#id24" title="Permalink to this
heading">¶</a></h4>
+<section id="id26">
+<h4>Arguments<a class="headerlink" href="#id26" title="Permalink to this
heading">¶</a></h4>
<ul>
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -1205,8 +1267,8 @@ t-digest algorithm.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span
class="n">approx_percentile_cont_with_weight</span><span
class="p">(</span><span class="n">expression</span><span class="p">,</span>
<span class="n">weight</span><span class="p">,</span> <span
class="n">percentile</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id25">
-<h4>Arguments<a class="headerlink" href="#id25" title="Permalink to this
heading">¶</a></h4>
+<section id="id27">
+<h4>Arguments<a class="headerlink" href="#id27" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
