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 06ec99e50d Publish built docs triggered by
b312ac167e965530b78123d04d563575e84d1a42
06ec99e50d is described below
commit 06ec99e50d3a251cc600cf26b682fe11e0988049
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Thu Dec 5 16:20:57 2024 +0000
Publish built docs triggered by b312ac167e965530b78123d04d563575e84d1a42
---
_sources/user-guide/sql/aggregate_functions.md.txt | 36 +++++++++++-----------
searchindex.js | 2 +-
user-guide/sql/aggregate_functions.html | 36 +++++++++++-----------
3 files changed, 37 insertions(+), 37 deletions(-)
diff --git a/_sources/user-guide/sql/aggregate_functions.md.txt
b/_sources/user-guide/sql/aggregate_functions.md.txt
index d9fc28a817..221bb0572e 100644
--- a/_sources/user-guide/sql/aggregate_functions.md.txt
+++ b/_sources/user-guide/sql/aggregate_functions.md.txt
@@ -268,10 +268,10 @@ grouping(expression)
### `last_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.
+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.
```
-first_value(expression [ORDER BY expression])
+last_value(expression [ORDER BY expression])
```
#### Arguments
@@ -281,11 +281,11 @@ first_value(expression [ORDER BY expression])
#### Example
```sql
-> SELECT first_value(column_name ORDER BY other_column) FROM table_name;
+> SELECT last_value(column_name ORDER BY other_column) FROM table_name;
+-----------------------------------------------+
-| first_value(column_name ORDER BY other_column)|
+| last_value(column_name ORDER BY other_column) |
+-----------------------------------------------+
-| first_element |
+| last_element |
+-----------------------------------------------+
```
@@ -341,10 +341,10 @@ median(expression)
### `min`
-Returns the maximum value in the specified column.
+Returns the minimum value in the specified column.
```
-max(expression)
+min(expression)
```
#### Arguments
@@ -354,11 +354,11 @@ max(expression)
#### Example
```sql
-> SELECT max(column_name) FROM table_name;
+> SELECT min(column_name) FROM table_name;
+----------------------+
-| max(column_name) |
+| min(column_name) |
+----------------------+
-| 150 |
+| 12 |
+----------------------+
```
@@ -730,10 +730,10 @@ stddev(expression)
### `stddev_pop`
-Returns the standard deviation of a set of numbers.
+Returns the population standard deviation of a set of numbers.
```
-stddev(expression)
+stddev_pop(expression)
```
#### Arguments
@@ -743,12 +743,12 @@ stddev(expression)
#### Example
```sql
-> SELECT stddev(column_name) FROM table_name;
-+----------------------+
-| stddev(column_name) |
-+----------------------+
-| 12.34 |
-+----------------------+
+> SELECT stddev_pop(column_name) FROM table_name;
++--------------------------+
+| stddev_pop(column_name) |
++--------------------------+
+| 10.56 |
++--------------------------+
```
### `stddev_samp`
diff --git a/searchindex.js b/searchindex.js
index eb169c1c2a..8ee1415c3b 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/aggregate_functions.html
b/user-guide/sql/aggregate_functions.html
index 4efebe1764..7c280506e9 100644
--- a/user-guide/sql/aggregate_functions.html
+++ b/user-guide/sql/aggregate_functions.html
@@ -1618,8 +1618,8 @@ dev/update_function_docs.sh file for updating surrounding
text.
</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 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>
+<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="id16">
@@ -1630,11 +1630,11 @@ dev/update_function_docs.sh file for updating
surrounding text.
</section>
<section id="id17">
<h4>Example<a class="headerlink" href="#id17" title="Link to this
heading">¶</a></h4>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">first_value</span><span class="p">(</span><span
class="k">column_name</span><span class="w"> </span><span
class="k">ORDER</span><span class="w"> </span><span class="k">BY</span><span
class="w"> </span><span class="n">other_column</span><span
class="p">)</span><span class="w"> </span><span cl [...]
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">last_value</span><span class="p">(</span><span
class="k">column_name</span><span class="w"> </span><span
class="k">ORDER</span><span class="w"> </span><span class="k">BY</span><span
class="w"> </span><span class="n">other_column</span><span
class="p">)</span><span class="w"> </span><span cla [...]
<span class="o">+</span><span
class="c1">-----------------------------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">first_value</span><span class="p">(</span><span
class="k">column_name</span><span class="w"> </span><span
class="k">ORDER</span><span class="w"> </span><span class="k">BY</span><span
class="w"> </span><span class="n">other_column</span><span
class="p">)</span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">last_value</span><span class="p">(</span><span
class="k">column_name</span><span class="w"> </span><span
class="k">ORDER</span><span class="w"> </span><span class="k">BY</span><span
class="w"> </span><span class="n">other_column</span><span
class="p">)</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span
class="c1">-----------------------------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">first_element</span><span class="w">
</span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">last_element</span><span class="w">
</span><span class="o">|</span>
<span class="o">+</span><span
class="c1">-----------------------------------------------+</span>
</pre></div>
</div>
@@ -1694,8 +1694,8 @@ dev/update_function_docs.sh file for updating surrounding
text.
</section>
<section id="min">
<h3><code class="docutils literal notranslate"><span
class="pre">min</span></code><a class="headerlink" href="#min" title="Link to
this heading">¶</a></h3>
-<p>Returns the maximum value in the specified column.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="nb">max</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
+<p>Returns the minimum value in the specified column.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="nb">min</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
<section id="id22">
@@ -1706,11 +1706,11 @@ dev/update_function_docs.sh file for updating
surrounding text.
</section>
<section id="id23">
<h4>Example<a class="headerlink" href="#id23" title="Link to this
heading">¶</a></h4>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="k">max</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="k">FROM</span><span class="w"> </span><span
class="k">table_name</span><span class="p">;</span>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="k">min</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="k">FROM</span><span class="w"> </span><span
class="k">table_name</span><span class="p">;</span>
<span class="o">+</span><span class="c1">----------------------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="k">max</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span
class="k">min</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------------------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="mi">150</span><span class="w"> </span><span
class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span
class="mi">12</span><span class="w"> </span><span
class="o">|</span>
<span class="o">+</span><span class="c1">----------------------+</span>
</pre></div>
</div>
@@ -2112,8 +2112,8 @@ dev/update_function_docs.sh file for updating surrounding
text.
</section>
<section id="stddev-pop">
<h3><code class="docutils literal notranslate"><span
class="pre">stddev_pop</span></code><a class="headerlink" href="#stddev-pop"
title="Link to this heading">¶</a></h3>
-<p>Returns the standard deviation of a set of numbers.</p>
-<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>
+<p>Returns the population standard deviation of a set of numbers.</p>
+<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="id53">
@@ -2124,12 +2124,12 @@ dev/update_function_docs.sh file for updating
surrounding text.
</section>
<section id="id54">
<h4>Example<a class="headerlink" href="#id54" title="Link to this
heading">¶</a></h4>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">stddev</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="k">FROM</span><span class="w"> </span><span
class="k">table_name</span><span class="p">;</span>
-<span class="o">+</span><span class="c1">----------------------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">stddev</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="o">|</span>
-<span class="o">+</span><span class="c1">----------------------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="mi">12</span><span class="p">.</span><span class="mi">34</span><span
class="w"> </span><span class="o">|</span>
-<span class="o">+</span><span class="c1">----------------------+</span>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">SELECT</span><span class="w"> </span><span
class="n">stddev_pop</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="k">FROM</span><span class="w"> </span><span
class="k">table_name</span><span class="p">;</span>
+<span class="o">+</span><span class="c1">--------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">stddev_pop</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="o">|</span>
+<span class="o">+</span><span class="c1">--------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="mi">10</span><span class="p">.</span><span class="mi">56</span><span
class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">--------------------------+</span>
</pre></div>
</div>
</section>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
