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 161868c411 Publish built docs triggered by
227908ff16a6eed6fa2b9c0f89ecd564be67a7a9
161868c411 is described below
commit 161868c4118261dd1fbd23bdd35fbb06a4c8bd83
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Tue Oct 22 15:07:57 2024 +0000
Publish built docs triggered by 227908ff16a6eed6fa2b9c0f89ecd564be67a7a9
---
_sources/user-guide/sql/aggregate_functions.md.txt | 172 +---------
.../user-guide/sql/aggregate_functions_new.md.txt | 126 ++++++++
searchindex.js | 2 +-
user-guide/sql/aggregate_functions.html | 355 +-------------------
user-guide/sql/aggregate_functions_new.html | 357 ++++++++++++++++++---
user-guide/sql/index.html | 5 +-
6 files changed, 449 insertions(+), 568 deletions(-)
diff --git a/_sources/user-guide/sql/aggregate_functions.md.txt
b/_sources/user-guide/sql/aggregate_functions.md.txt
index 4f774fe6d0..77f527c92c 100644
--- a/_sources/user-guide/sql/aggregate_functions.md.txt
+++ b/_sources/user-guide/sql/aggregate_functions.md.txt
@@ -19,174 +19,4 @@
# Aggregate Functions
-Aggregate functions operate on a set of values to compute a single result.
-
-Note: this documentation is in the process of being migrated to be
[automatically created from the codebase].
-Please see the [Aggregate Functions (new)](aggregate_functions_new.md) page for
-the rest of the documentation.
-
-[automatically created from the codebase]:
https://github.com/apache/datafusion/issues/12740
-
-## Statistical
-
-- [covar](#covar)
-- [regr_avgx](#regr_avgx)
-- [regr_avgy](#regr_avgy)
-- [regr_count](#regr_count)
-- [regr_intercept](#regr_intercept)
-- [regr_r2](#regr_r2)
-- [regr_slope](#regr_slope)
-- [regr_sxx](#regr_sxx)
-- [regr_syy](#regr_syy)
-- [regr_sxy](#regr_sxy)
-
-### `covar`
-
-Returns the covariance of a set of number pairs.
-
-```
-covar(expression1, expression2)
-```
-
-#### Arguments
-
-- **expression1**: First expression to operate on.
- Can be a constant, column, or function, and any combination of arithmetic
operators.
-- **expression2**: Second expression to operate on.
- Can be a constant, column, or function, and any combination of arithmetic
operators.
-
-### `regr_slope`
-
-Returns the slope of the linear regression line for non-null pairs in
aggregate columns.
-Given input column Y and X: regr_slope(Y, X) returns the slope (k in Y = k\*X
+ b) using minimal RSS fitting.
-
-```
-regr_slope(expression1, expression2)
-```
-
-#### Arguments
-
-- **expression_y**: Expression to operate on.
- Can be a constant, column, or function, and any combination of arithmetic
operators.
-- **expression_x**: Expression to operate on.
- Can be a constant, column, or function, and any combination of arithmetic
operators.
-
-### `regr_avgx`
-
-Computes the average of the independent variable (input) `expression_x` for
the non-null paired data points.
-
-```
-regr_avgx(expression_y, expression_x)
-```
-
-#### Arguments
-
-- **expression_y**: Dependent variable.
- Can be a constant, column, or function, and any combination of arithmetic
operators.
-- **expression_x**: Independent variable.
- Can be a constant, column, or function, and any combination of arithmetic
operators.
-
-### `regr_avgy`
-
-Computes the average of the dependent variable (output) `expression_y` for the
non-null paired data points.
-
-```
-regr_avgy(expression_y, expression_x)
-```
-
-#### Arguments
-
-- **expression_y**: Dependent variable.
- Can be a constant, column, or function, and any combination of arithmetic
operators.
-- **expression_x**: Independent variable.
- Can be a constant, column, or function, and any combination of arithmetic
operators.
-
-### `regr_count`
-
-Counts the number of non-null paired data points.
-
-```
-regr_count(expression_y, expression_x)
-```
-
-#### Arguments
-
-- **expression_y**: Dependent variable.
- Can be a constant, column, or function, and any combination of arithmetic
operators.
-- **expression_x**: Independent variable.
- Can be a constant, column, or function, and any combination of arithmetic
operators.
-
-### `regr_intercept`
-
-Computes the y-intercept of the linear regression line. For the equation \(y =
kx + b\), this function returns `b`.
-
-```
-regr_intercept(expression_y, expression_x)
-```
-
-#### Arguments
-
-- **expression_y**: Dependent variable.
- Can be a constant, column, or function, and any combination of arithmetic
operators.
-- **expression_x**: Independent variable.
- Can be a constant, column, or function, and any combination of arithmetic
operators.
-
-### `regr_r2`
-
-Computes the square of the correlation coefficient between the independent and
dependent variables.
-
-```
-regr_r2(expression_y, expression_x)
-```
-
-#### Arguments
-
-- **expression_y**: Dependent variable.
- Can be a constant, column, or function, and any combination of arithmetic
operators.
-- **expression_x**: Independent variable.
- Can be a constant, column, or function, and any combination of arithmetic
operators.
-
-### `regr_sxx`
-
-Computes the sum of squares of the independent variable.
-
-```
-regr_sxx(expression_y, expression_x)
-```
-
-#### Arguments
-
-- **expression_y**: Dependent variable.
- Can be a constant, column, or function, and any combination of arithmetic
operators.
-- **expression_x**: Independent variable.
- Can be a constant, column, or function, and any combination of arithmetic
operators.
-
-### `regr_syy`
-
-Computes the sum of squares of the dependent variable.
-
-```
-regr_syy(expression_y, expression_x)
-```
-
-#### Arguments
-
-- **expression_y**: Dependent variable.
- Can be a constant, column, or function, and any combination of arithmetic
operators.
-- **expression_x**: Independent variable.
- Can be a constant, column, or function, and any combination of arithmetic
operators.
-
-### `regr_sxy`
-
-Computes the sum of products of paired data points.
-
-```
-regr_sxy(expression_y, expression_x)
-```
-
-#### Arguments
-
-- **expression_y**: Dependent variable.
- Can be a constant, column, or function, and any combination of arithmetic
operators.
-- **expression_x**: Independent variable.
- Can be a constant, column, or function, and any combination of arithmetic
operators.
+Note: this documentation has been migrated to [Aggregate Functions
(new)](aggregate_functions_new.md)
diff --git a/_sources/user-guide/sql/aggregate_functions_new.md.txt
b/_sources/user-guide/sql/aggregate_functions_new.md.txt
index 24ef313f3d..ad6d15b94e 100644
--- a/_sources/user-guide/sql/aggregate_functions_new.md.txt
+++ b/_sources/user-guide/sql/aggregate_functions_new.md.txt
@@ -468,6 +468,15 @@ _Alias of [var](#var)._
- [covar_pop](#covar_pop)
- [covar_samp](#covar_samp)
- [nth_value](#nth_value)
+- [regr_avgx](#regr_avgx)
+- [regr_avgy](#regr_avgy)
+- [regr_count](#regr_count)
+- [regr_intercept](#regr_intercept)
+- [regr_r2](#regr_r2)
+- [regr_slope](#regr_slope)
+- [regr_sxx](#regr_sxx)
+- [regr_sxy](#regr_sxy)
+- [regr_syy](#regr_syy)
- [stddev](#stddev)
- [stddev_pop](#stddev_pop)
- [stddev_samp](#stddev_samp)
@@ -581,6 +590,123 @@ nth_value(expression, n ORDER BY expression)
+---------+--------+-------------------------+
```
+### `regr_avgx`
+
+Computes the average of the independent variable (input) expression_x for the
non-null paired data points.
+
+```
+regr_avgx(expression_y, expression_x)
+```
+
+#### Arguments
+
+- **expression_y**: Dependent variable expression to operate on. Can be a
constant, column, or function, and any combination of operators.
+- **expression_x**: Independent variable expression to operate on. Can be a
constant, column, or function, and any combination of operators.
+
+### `regr_avgy`
+
+Computes the average of the dependent variable (output) expression_y for the
non-null paired data points.
+
+```
+regr_avgy(expression_y, expression_x)
+```
+
+#### Arguments
+
+- **expression_y**: Dependent variable expression to operate on. Can be a
constant, column, or function, and any combination of operators.
+- **expression_x**: Independent variable expression to operate on. Can be a
constant, column, or function, and any combination of operators.
+
+### `regr_count`
+
+Counts the number of non-null paired data points.
+
+```
+regr_count(expression_y, expression_x)
+```
+
+#### Arguments
+
+- **expression_y**: Dependent variable expression to operate on. Can be a
constant, column, or function, and any combination of operators.
+- **expression_x**: Independent variable expression to operate on. Can be a
constant, column, or function, and any combination of operators.
+
+### `regr_intercept`
+
+Computes the y-intercept of the linear regression line. For the equation (y =
kx + b), this function returns b.
+
+```
+regr_intercept(expression_y, expression_x)
+```
+
+#### Arguments
+
+- **expression_y**: Dependent variable expression to operate on. Can be a
constant, column, or function, and any combination of operators.
+- **expression_x**: Independent variable expression to operate on. Can be a
constant, column, or function, and any combination of operators.
+
+### `regr_r2`
+
+Computes the square of the correlation coefficient between the independent and
dependent variables.
+
+```
+regr_r2(expression_y, expression_x)
+```
+
+#### Arguments
+
+- **expression_y**: Dependent variable expression to operate on. Can be a
constant, column, or function, and any combination of operators.
+- **expression_x**: Independent variable expression to operate on. Can be a
constant, column, or function, and any combination of operators.
+
+### `regr_slope`
+
+Returns the slope of the linear regression line for non-null pairs in
aggregate columns. Given input column Y and X: regr_slope(Y, X) returns the
slope (k in Y = k\*X + b) using minimal RSS fitting.
+
+```
+regr_slope(expression_y, expression_x)
+```
+
+#### Arguments
+
+- **expression_y**: Dependent variable expression to operate on. Can be a
constant, column, or function, and any combination of operators.
+- **expression_x**: Independent variable expression to operate on. Can be a
constant, column, or function, and any combination of operators.
+
+### `regr_sxx`
+
+Computes the sum of squares of the independent variable.
+
+```
+regr_sxx(expression_y, expression_x)
+```
+
+#### Arguments
+
+- **expression_y**: Dependent variable expression to operate on. Can be a
constant, column, or function, and any combination of operators.
+- **expression_x**: Independent variable expression to operate on. Can be a
constant, column, or function, and any combination of operators.
+
+### `regr_sxy`
+
+Computes the sum of products of paired data points.
+
+```
+regr_sxy(expression_y, expression_x)
+```
+
+#### Arguments
+
+- **expression_y**: Dependent variable expression to operate on. Can be a
constant, column, or function, and any combination of operators.
+- **expression_x**: Independent variable expression to operate on. Can be a
constant, column, or function, and any combination of operators.
+
+### `regr_syy`
+
+Computes the sum of squares of the dependent variable.
+
+```
+regr_syy(expression_y, expression_x)
+```
+
+#### Arguments
+
+- **expression_y**: Dependent variable expression to operate on. Can be a
constant, column, or function, and any combination of operators.
+- **expression_x**: Independent variable expression to operate on. Can be a
constant, column, or function, and any combination of operators.
+
### `stddev`
Returns the standard deviation of a set of numbers.
diff --git a/searchindex.js b/searchindex.js
index adf28aea3b..38cc9a077c 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/aggregate_functions.html
b/user-guide/sql/aggregate_functions.html
index 166f4b5b2d..8cc382b341 100644
--- a/user-guide/sql/aggregate_functions.html
+++ b/user-guide/sql/aggregate_functions.html
@@ -497,181 +497,9 @@
<div class="toc-item">
-<div class="tocsection onthispage pt-5 pb-3">
- <i class="fas fa-list"></i> On this page
-</div>
<nav id="bd-toc-nav">
- <ul class="visible nav section-nav flex-column">
- <li class="toc-h2 nav-item toc-entry">
- <a class="reference internal nav-link" href="#statistical">
- Statistical
- </a>
- <ul class="nav section-nav flex-column">
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#covar">
- <code class="docutils literal notranslate">
- <span class="pre">
- covar
- </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="#regr-slope">
- <code class="docutils literal notranslate">
- <span class="pre">
- regr_slope
- </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="#regr-avgx">
- <code class="docutils literal notranslate">
- <span class="pre">
- regr_avgx
- </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="#regr-avgy">
- <code class="docutils literal notranslate">
- <span class="pre">
- regr_avgy
- </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>
- </ul>
- </li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#regr-count">
- <code class="docutils literal notranslate">
- <span class="pre">
- regr_count
- </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="#id4">
- Arguments
- </a>
- </li>
- </ul>
- </li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#regr-intercept">
- <code class="docutils literal notranslate">
- <span class="pre">
- regr_intercept
- </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>
- </ul>
- </li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#regr-r2">
- <code class="docutils literal notranslate">
- <span class="pre">
- regr_r2
- </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="#id6">
- Arguments
- </a>
- </li>
- </ul>
- </li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#regr-sxx">
- <code class="docutils literal notranslate">
- <span class="pre">
- regr_sxx
- </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="#id7">
- Arguments
- </a>
- </li>
- </ul>
- </li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#regr-syy">
- <code class="docutils literal notranslate">
- <span class="pre">
- regr_syy
- </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="#id8">
- Arguments
- </a>
- </li>
- </ul>
- </li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#regr-sxy">
- <code class="docutils literal notranslate">
- <span class="pre">
- regr_sxy
- </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="#id9">
- Arguments
- </a>
- </li>
- </ul>
- </li>
- </ul>
- </li>
-</ul>
-
+
</nav>
</div>
@@ -718,186 +546,7 @@
-->
<section id="aggregate-functions">
<h1>Aggregate Functions<a class="headerlink" href="#aggregate-functions"
title="Link to this heading">¶</a></h1>
-<p>Aggregate functions operate on a set of values to compute a single
result.</p>
-<p>Note: this documentation is in the process of being migrated to be <a
class="reference external"
href="https://github.com/apache/datafusion/issues/12740";>automatically created
from the codebase</a>.
-Please see the <a class="reference internal"
href="aggregate_functions_new.html"><span class="std std-doc">Aggregate
Functions (new)</span></a> page for
-the rest of the documentation.</p>
-<section id="statistical">
-<h2>Statistical<a class="headerlink" href="#statistical" title="Link to this
heading">¶</a></h2>
-<ul class="simple">
-<li><p><a class="reference internal" href="#covar">covar</a></p></li>
-<li><p><a class="reference internal" href="#regr-avgx">regr_avgx</a></p></li>
-<li><p><a class="reference internal" href="#regr-avgy">regr_avgy</a></p></li>
-<li><p><a class="reference internal" href="#regr-count">regr_count</a></p></li>
-<li><p><a class="reference internal"
href="#regr-intercept">regr_intercept</a></p></li>
-<li><p><a class="reference internal" href="#regr-r2">regr_r2</a></p></li>
-<li><p><a class="reference internal" href="#regr-slope">regr_slope</a></p></li>
-<li><p><a class="reference internal" href="#regr-sxx">regr_sxx</a></p></li>
-<li><p><a class="reference internal" href="#regr-syy">regr_syy</a></p></li>
-<li><p><a class="reference internal" href="#regr-sxy">regr_sxy</a></p></li>
-</ul>
-<section id="covar">
-<h3><code class="docutils literal notranslate"><span
class="pre">covar</span></code><a class="headerlink" href="#covar" title="Link
to this heading">¶</a></h3>
-<p>Returns the covariance of a set of number pairs.</p>
-<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="arguments">
-<h4>Arguments<a class="headerlink" href="#arguments" title="Link 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>
-<li><p><strong>expression2</strong>: Second expression to operate on.
-Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
-</ul>
-</section>
-</section>
-<section id="regr-slope">
-<h3><code class="docutils literal notranslate"><span
class="pre">regr_slope</span></code><a class="headerlink" href="#regr-slope"
title="Link to this heading">¶</a></h3>
-<p>Returns the slope of the linear regression line for non-null pairs in
aggregate columns.
-Given input column Y and X: regr_slope(Y, X) returns the slope (k in Y = k*X +
b) using minimal RSS fitting.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_slope</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="id1">
-<h4>Arguments<a class="headerlink" href="#id1" title="Link to this
heading">¶</a></h4>
-<ul class="simple">
-<li><p><strong>expression_y</strong>: Expression to operate on.
-Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
-<li><p><strong>expression_x</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="regr-avgx">
-<h3><code class="docutils literal notranslate"><span
class="pre">regr_avgx</span></code><a class="headerlink" href="#regr-avgx"
title="Link to this heading">¶</a></h3>
-<p>Computes the average of the independent variable (input) <code
class="docutils literal notranslate"><span
class="pre">expression_x</span></code> for the non-null paired data points.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_avgx</span><span
class="p">(</span><span class="n">expression_y</span><span class="p">,</span>
<span class="n">expression_x</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_y</strong>: Dependent variable.
-Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
-<li><p><strong>expression_x</strong>: Independent variable.
-Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
-</ul>
-</section>
-</section>
-<section id="regr-avgy">
-<h3><code class="docutils literal notranslate"><span
class="pre">regr_avgy</span></code><a class="headerlink" href="#regr-avgy"
title="Link to this heading">¶</a></h3>
-<p>Computes the average of the dependent variable (output) <code
class="docutils literal notranslate"><span
class="pre">expression_y</span></code> for the non-null paired data points.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_avgy</span><span
class="p">(</span><span class="n">expression_y</span><span class="p">,</span>
<span class="n">expression_x</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_y</strong>: Dependent variable.
-Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
-<li><p><strong>expression_x</strong>: Independent variable.
-Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
-</ul>
-</section>
-</section>
-<section id="regr-count">
-<h3><code class="docutils literal notranslate"><span
class="pre">regr_count</span></code><a class="headerlink" href="#regr-count"
title="Link to this heading">¶</a></h3>
-<p>Counts the number of non-null paired data points.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_count</span><span
class="p">(</span><span class="n">expression_y</span><span class="p">,</span>
<span class="n">expression_x</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>
-<ul class="simple">
-<li><p><strong>expression_y</strong>: Dependent variable.
-Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
-<li><p><strong>expression_x</strong>: Independent variable.
-Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
-</ul>
-</section>
-</section>
-<section id="regr-intercept">
-<h3><code class="docutils literal notranslate"><span
class="pre">regr_intercept</span></code><a class="headerlink"
href="#regr-intercept" title="Link to this heading">¶</a></h3>
-<p>Computes the y-intercept of the linear regression line. For the equation (y
= kx + b), this function returns <code class="docutils literal
notranslate"><span class="pre">b</span></code>.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_intercept</span><span
class="p">(</span><span class="n">expression_y</span><span class="p">,</span>
<span class="n">expression_x</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_y</strong>: Dependent variable.
-Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
-<li><p><strong>expression_x</strong>: Independent variable.
-Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
-</ul>
-</section>
-</section>
-<section id="regr-r2">
-<h3><code class="docutils literal notranslate"><span
class="pre">regr_r2</span></code><a class="headerlink" href="#regr-r2"
title="Link to this heading">¶</a></h3>
-<p>Computes the square of the correlation coefficient between the independent
and dependent variables.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_r2</span><span
class="p">(</span><span class="n">expression_y</span><span class="p">,</span>
<span class="n">expression_x</span><span class="p">)</span>
-</pre></div>
-</div>
-<section id="id6">
-<h4>Arguments<a class="headerlink" href="#id6" title="Link to this
heading">¶</a></h4>
-<ul class="simple">
-<li><p><strong>expression_y</strong>: Dependent variable.
-Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
-<li><p><strong>expression_x</strong>: Independent variable.
-Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
-</ul>
-</section>
-</section>
-<section id="regr-sxx">
-<h3><code class="docutils literal notranslate"><span
class="pre">regr_sxx</span></code><a class="headerlink" href="#regr-sxx"
title="Link to this heading">¶</a></h3>
-<p>Computes the sum of squares of the independent variable.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_sxx</span><span
class="p">(</span><span class="n">expression_y</span><span class="p">,</span>
<span class="n">expression_x</span><span class="p">)</span>
-</pre></div>
-</div>
-<section id="id7">
-<h4>Arguments<a class="headerlink" href="#id7" title="Link to this
heading">¶</a></h4>
-<ul class="simple">
-<li><p><strong>expression_y</strong>: Dependent variable.
-Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
-<li><p><strong>expression_x</strong>: Independent variable.
-Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
-</ul>
-</section>
-</section>
-<section id="regr-syy">
-<h3><code class="docutils literal notranslate"><span
class="pre">regr_syy</span></code><a class="headerlink" href="#regr-syy"
title="Link to this heading">¶</a></h3>
-<p>Computes the sum of squares of the dependent variable.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_syy</span><span
class="p">(</span><span class="n">expression_y</span><span class="p">,</span>
<span class="n">expression_x</span><span class="p">)</span>
-</pre></div>
-</div>
-<section id="id8">
-<h4>Arguments<a class="headerlink" href="#id8" title="Link to this
heading">¶</a></h4>
-<ul class="simple">
-<li><p><strong>expression_y</strong>: Dependent variable.
-Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
-<li><p><strong>expression_x</strong>: Independent variable.
-Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
-</ul>
-</section>
-</section>
-<section id="regr-sxy">
-<h3><code class="docutils literal notranslate"><span
class="pre">regr_sxy</span></code><a class="headerlink" href="#regr-sxy"
title="Link to this heading">¶</a></h3>
-<p>Computes the sum of products of paired data points.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_sxy</span><span
class="p">(</span><span class="n">expression_y</span><span class="p">,</span>
<span class="n">expression_x</span><span class="p">)</span>
-</pre></div>
-</div>
-<section id="id9">
-<h4>Arguments<a class="headerlink" href="#id9" title="Link to this
heading">¶</a></h4>
-<ul class="simple">
-<li><p><strong>expression_y</strong>: Dependent variable.
-Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
-<li><p><strong>expression_x</strong>: Independent variable.
-Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
-</ul>
-</section>
-</section>
-</section>
+<p>Note: this documentation has been migrated to <a class="reference internal"
href="aggregate_functions_new.html"><span class="std std-doc">Aggregate
Functions (new)</span></a></p>
</section>
diff --git a/user-guide/sql/aggregate_functions_new.html
b/user-guide/sql/aggregate_functions_new.html
index c50f8c479c..aea2f7fd32 100644
--- a/user-guide/sql/aggregate_functions_new.html
+++ b/user-guide/sql/aggregate_functions_new.html
@@ -1018,10 +1018,10 @@
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#stddev">
+ <a class="reference internal nav-link" href="#regr-avgx">
<code class="docutils literal notranslate">
<span class="pre">
- stddev
+ regr_avgx
</span>
</code>
</a>
@@ -1031,13 +1031,157 @@
Arguments
</a>
</li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#regr-avgy">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ regr_avgy
+ </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="#id42">
- Example
+ Arguments
</a>
</li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#regr-count">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ regr_count
+ </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="#id43">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#regr-intercept">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ regr_intercept
+ </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="#id44">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#regr-r2">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ regr_r2
+ </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="#id45">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#regr-slope">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ regr_slope
+ </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="#id46">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#regr-sxx">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ regr_sxx
+ </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="#id47">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#regr-sxy">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ regr_sxy
+ </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="#id48">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#regr-syy">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ regr_syy
+ </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="#id49">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#stddev">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ stddev
+ </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="#id50">
+ Arguments
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id51">
+ Example
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id52">
Aliases
</a>
</li>
@@ -1053,12 +1197,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id44">
+ <a class="reference internal nav-link" href="#id53">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id45">
+ <a class="reference internal nav-link" href="#id54">
Example
</a>
</li>
@@ -1090,12 +1234,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id46">
+ <a class="reference internal nav-link" href="#id55">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id47">
+ <a class="reference internal nav-link" href="#id56">
Example
</a>
</li>
@@ -1111,12 +1255,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id48">
+ <a class="reference internal nav-link" href="#id57">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id49">
+ <a class="reference internal nav-link" href="#id58">
Example
</a>
</li>
@@ -1132,12 +1276,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id50">
+ <a class="reference internal nav-link" href="#id59">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id51">
+ <a class="reference internal nav-link" href="#id60">
Example
</a>
</li>
@@ -1153,12 +1297,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id52">
+ <a class="reference internal nav-link" href="#id61">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id53">
+ <a class="reference internal nav-link" href="#id62">
Example
</a>
</li>
@@ -1685,6 +1829,15 @@ the rest of the documentation.</p>
<li><p><a class="reference internal" href="#covar-pop">covar_pop</a></p></li>
<li><p><a class="reference internal" href="#covar-samp">covar_samp</a></p></li>
<li><p><a class="reference internal" href="#nth-value">nth_value</a></p></li>
+<li><p><a class="reference internal" href="#regr-avgx">regr_avgx</a></p></li>
+<li><p><a class="reference internal" href="#regr-avgy">regr_avgy</a></p></li>
+<li><p><a class="reference internal" href="#regr-count">regr_count</a></p></li>
+<li><p><a class="reference internal"
href="#regr-intercept">regr_intercept</a></p></li>
+<li><p><a class="reference internal" href="#regr-r2">regr_r2</a></p></li>
+<li><p><a class="reference internal" href="#regr-slope">regr_slope</a></p></li>
+<li><p><a class="reference internal" href="#regr-sxx">regr_sxx</a></p></li>
+<li><p><a class="reference internal" href="#regr-sxy">regr_sxy</a></p></li>
+<li><p><a class="reference internal" href="#regr-syy">regr_syy</a></p></li>
<li><p><a class="reference internal" href="#stddev">stddev</a></p></li>
<li><p><a class="reference internal" href="#stddev-pop">stddev_pop</a></p></li>
<li><p><a class="reference internal"
href="#stddev-samp">stddev_samp</a></p></li>
@@ -1804,20 +1957,146 @@ the rest of the documentation.</p>
</div>
</section>
</section>
+<section id="regr-avgx">
+<h3><code class="docutils literal notranslate"><span
class="pre">regr_avgx</span></code><a class="headerlink" href="#regr-avgx"
title="Link to this heading">¶</a></h3>
+<p>Computes the average of the independent variable (input) expression_x for
the non-null paired data points.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_avgx</span><span
class="p">(</span><span class="n">expression_y</span><span class="p">,</span>
<span class="n">expression_x</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id41">
+<h4>Arguments<a class="headerlink" href="#id41" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression_y</strong>: Dependent variable expression to operate
on. Can be a constant, column, or function, and any combination of
operators.</p></li>
+<li><p><strong>expression_x</strong>: Independent variable expression to
operate on. Can be a constant, column, or function, and any combination of
operators.</p></li>
+</ul>
+</section>
+</section>
+<section id="regr-avgy">
+<h3><code class="docutils literal notranslate"><span
class="pre">regr_avgy</span></code><a class="headerlink" href="#regr-avgy"
title="Link to this heading">¶</a></h3>
+<p>Computes the average of the dependent variable (output) expression_y for
the non-null paired data points.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_avgy</span><span
class="p">(</span><span class="n">expression_y</span><span class="p">,</span>
<span class="n">expression_x</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id42">
+<h4>Arguments<a class="headerlink" href="#id42" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression_y</strong>: Dependent variable expression to operate
on. Can be a constant, column, or function, and any combination of
operators.</p></li>
+<li><p><strong>expression_x</strong>: Independent variable expression to
operate on. Can be a constant, column, or function, and any combination of
operators.</p></li>
+</ul>
+</section>
+</section>
+<section id="regr-count">
+<h3><code class="docutils literal notranslate"><span
class="pre">regr_count</span></code><a class="headerlink" href="#regr-count"
title="Link to this heading">¶</a></h3>
+<p>Counts the number of non-null paired data points.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_count</span><span
class="p">(</span><span class="n">expression_y</span><span class="p">,</span>
<span class="n">expression_x</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id43">
+<h4>Arguments<a class="headerlink" href="#id43" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression_y</strong>: Dependent variable expression to operate
on. Can be a constant, column, or function, and any combination of
operators.</p></li>
+<li><p><strong>expression_x</strong>: Independent variable expression to
operate on. Can be a constant, column, or function, and any combination of
operators.</p></li>
+</ul>
+</section>
+</section>
+<section id="regr-intercept">
+<h3><code class="docutils literal notranslate"><span
class="pre">regr_intercept</span></code><a class="headerlink"
href="#regr-intercept" title="Link to this heading">¶</a></h3>
+<p>Computes the y-intercept of the linear regression line. For the equation (y
= kx + b), this function returns b.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_intercept</span><span
class="p">(</span><span class="n">expression_y</span><span class="p">,</span>
<span class="n">expression_x</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id44">
+<h4>Arguments<a class="headerlink" href="#id44" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression_y</strong>: Dependent variable expression to operate
on. Can be a constant, column, or function, and any combination of
operators.</p></li>
+<li><p><strong>expression_x</strong>: Independent variable expression to
operate on. Can be a constant, column, or function, and any combination of
operators.</p></li>
+</ul>
+</section>
+</section>
+<section id="regr-r2">
+<h3><code class="docutils literal notranslate"><span
class="pre">regr_r2</span></code><a class="headerlink" href="#regr-r2"
title="Link to this heading">¶</a></h3>
+<p>Computes the square of the correlation coefficient between the independent
and dependent variables.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_r2</span><span
class="p">(</span><span class="n">expression_y</span><span class="p">,</span>
<span class="n">expression_x</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id45">
+<h4>Arguments<a class="headerlink" href="#id45" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression_y</strong>: Dependent variable expression to operate
on. Can be a constant, column, or function, and any combination of
operators.</p></li>
+<li><p><strong>expression_x</strong>: Independent variable expression to
operate on. Can be a constant, column, or function, and any combination of
operators.</p></li>
+</ul>
+</section>
+</section>
+<section id="regr-slope">
+<h3><code class="docutils literal notranslate"><span
class="pre">regr_slope</span></code><a class="headerlink" href="#regr-slope"
title="Link to this heading">¶</a></h3>
+<p>Returns the slope of the linear regression line for non-null pairs in
aggregate columns. Given input column Y and X: regr_slope(Y, X) returns the
slope (k in Y = k*X + b) using minimal RSS fitting.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_slope</span><span
class="p">(</span><span class="n">expression_y</span><span class="p">,</span>
<span class="n">expression_x</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id46">
+<h4>Arguments<a class="headerlink" href="#id46" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression_y</strong>: Dependent variable expression to operate
on. Can be a constant, column, or function, and any combination of
operators.</p></li>
+<li><p><strong>expression_x</strong>: Independent variable expression to
operate on. Can be a constant, column, or function, and any combination of
operators.</p></li>
+</ul>
+</section>
+</section>
+<section id="regr-sxx">
+<h3><code class="docutils literal notranslate"><span
class="pre">regr_sxx</span></code><a class="headerlink" href="#regr-sxx"
title="Link to this heading">¶</a></h3>
+<p>Computes the sum of squares of the independent variable.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_sxx</span><span
class="p">(</span><span class="n">expression_y</span><span class="p">,</span>
<span class="n">expression_x</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id47">
+<h4>Arguments<a class="headerlink" href="#id47" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression_y</strong>: Dependent variable expression to operate
on. Can be a constant, column, or function, and any combination of
operators.</p></li>
+<li><p><strong>expression_x</strong>: Independent variable expression to
operate on. Can be a constant, column, or function, and any combination of
operators.</p></li>
+</ul>
+</section>
+</section>
+<section id="regr-sxy">
+<h3><code class="docutils literal notranslate"><span
class="pre">regr_sxy</span></code><a class="headerlink" href="#regr-sxy"
title="Link to this heading">¶</a></h3>
+<p>Computes the sum of products of paired data points.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_sxy</span><span
class="p">(</span><span class="n">expression_y</span><span class="p">,</span>
<span class="n">expression_x</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id48">
+<h4>Arguments<a class="headerlink" href="#id48" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression_y</strong>: Dependent variable expression to operate
on. Can be a constant, column, or function, and any combination of
operators.</p></li>
+<li><p><strong>expression_x</strong>: Independent variable expression to
operate on. Can be a constant, column, or function, and any combination of
operators.</p></li>
+</ul>
+</section>
+</section>
+<section id="regr-syy">
+<h3><code class="docutils literal notranslate"><span
class="pre">regr_syy</span></code><a class="headerlink" href="#regr-syy"
title="Link to this heading">¶</a></h3>
+<p>Computes the sum of squares of the dependent variable.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">regr_syy</span><span
class="p">(</span><span class="n">expression_y</span><span class="p">,</span>
<span class="n">expression_x</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id49">
+<h4>Arguments<a class="headerlink" href="#id49" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression_y</strong>: Dependent variable expression to operate
on. Can be a constant, column, or function, and any combination of
operators.</p></li>
+<li><p><strong>expression_x</strong>: Independent variable expression to
operate on. Can be a constant, column, or function, and any combination of
operators.</p></li>
+</ul>
+</section>
+</section>
<section id="stddev">
<h3><code class="docutils literal notranslate"><span
class="pre">stddev</span></code><a class="headerlink" href="#stddev"
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>
</pre></div>
</div>
-<section id="id41">
-<h4>Arguments<a class="headerlink" href="#id41" title="Link to this
heading">¶</a></h4>
+<section id="id50">
+<h4>Arguments<a class="headerlink" href="#id50" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id42">
-<h4>Example<a class="headerlink" href="#id42" title="Link to this
heading">¶</a></h4>
+<section id="id51">
+<h4>Example<a class="headerlink" href="#id51" 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>
@@ -1827,8 +2106,8 @@ the rest of the documentation.</p>
</pre></div>
</div>
</section>
-<section id="id43">
-<h4>Aliases<a class="headerlink" href="#id43" title="Link to this
heading">¶</a></h4>
+<section id="id52">
+<h4>Aliases<a class="headerlink" href="#id52" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>stddev_samp</p></li>
</ul>
@@ -1840,14 +2119,14 @@ the rest of the documentation.</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>
</pre></div>
</div>
-<section id="id44">
-<h4>Arguments<a class="headerlink" href="#id44" title="Link to this
heading">¶</a></h4>
+<section id="id53">
+<h4>Arguments<a class="headerlink" href="#id53" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id45">
-<h4>Example<a class="headerlink" href="#id45" title="Link to this
heading">¶</a></h4>
+<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>
@@ -1877,14 +2156,14 @@ the rest of the documentation.</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="id46">
-<h4>Arguments<a class="headerlink" href="#id46" title="Link to this
heading">¶</a></h4>
+<section id="id55">
+<h4>Arguments<a class="headerlink" href="#id55" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id47">
-<h4>Example<a class="headerlink" href="#id47" title="Link to this
heading">¶</a></h4>
+<section id="id56">
+<h4>Example<a class="headerlink" href="#id56" 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">approx_distinct</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">approx_distinct</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="o">|</span>
@@ -1901,14 +2180,14 @@ the rest of the documentation.</p>
<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="id48">
-<h4>Arguments<a class="headerlink" href="#id48" title="Link to this
heading">¶</a></h4>
+<section id="id57">
+<h4>Arguments<a class="headerlink" href="#id57" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
</ul>
</section>
-<section id="id49">
-<h4>Example<a class="headerlink" href="#id49" title="Link to this
heading">¶</a></h4>
+<section id="id58">
+<h4>Example<a class="headerlink" href="#id58" 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">approx_median</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">approx_median</span><span class="p">(</span><span
class="k">column_name</span><span class="p">)</span><span class="w">
</span><span class="o">|</span>
@@ -1925,16 +2204,16 @@ the rest of the documentation.</p>
<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="id50">
-<h4>Arguments<a class="headerlink" href="#id50" title="Link to this
heading">¶</a></h4>
+<section id="id59">
+<h4>Arguments<a class="headerlink" href="#id59" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>percentile</strong>: Percentile to compute. Must be a float
value between 0 and 1 (inclusive).</p></li>
<li><p><strong>centroids</strong>: Number of centroids to use in the t-digest
algorithm. <em>Default is 100</em>. A higher number results in more accurate
approximation but requires more memory.</p></li>
</ul>
</section>
-<section id="id51">
-<h4>Example<a class="headerlink" href="#id51" title="Link to this
heading">¶</a></h4>
+<section id="id60">
+<h4>Example<a class="headerlink" href="#id60" 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">approx_percentile_cont</span><span class="p">(</span><span
class="k">column_name</span><span class="p">,</span><span class="w">
</span><span class="mi">0</span><span class="p">.</span><span
class="mi">75</span><span class="p">,</span><span class="w"> </span><span
class="mi">100</span><span c [...]
<span class="o">+</span><span
class="c1">-------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">approx_percentile_cont</span><span class="p">(</span><span
class="k">column_name</span><span class="p">,</span><span class="w">
</span><span class="mi">0</span><span class="p">.</span><span
class="mi">75</span><span class="p">,</span><span class="w"> </span><span
class="mi">100</span><span class="p">)</span><span class="w"> </span><span
class="o">|</span>
@@ -1951,16 +2230,16 @@ the rest of the documentation.</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="id52">
-<h4>Arguments<a class="headerlink" href="#id52" title="Link to this
heading">¶</a></h4>
+<section id="id61">
+<h4>Arguments<a class="headerlink" href="#id61" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: The expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
<li><p><strong>weight</strong>: Expression to use as weight. Can be a
constant, column, or function, and any combination of arithmetic
operators.</p></li>
<li><p><strong>percentile</strong>: Percentile to compute. Must be a float
value between 0 and 1 (inclusive).</p></li>
</ul>
</section>
-<section id="id53">
-<h4>Example<a class="headerlink" href="#id53" title="Link to this
heading">¶</a></h4>
+<section id="id62">
+<h4>Example<a class="headerlink" href="#id62" 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">approx_percentile_cont_with_weight</span><span
class="p">(</span><span class="k">column_name</span><span
class="p">,</span><span class="w"> </span><span
class="n">weight_column</span><span class="p">,</span><span class="w">
</span><span class="mi">0</span><span class="p">.</span><span class= [...]
<span class="o">+</span><span
class="c1">----------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">approx_percentile_cont_with_weight</span><span
class="p">(</span><span class="k">column_name</span><span
class="p">,</span><span class="w"> </span><span
class="n">weight_column</span><span class="p">,</span><span class="w">
</span><span class="mi">0</span><span class="p">.</span><span
class="mi">90</span><span class="p">)</span><span class="w"> </span><span
class="o">|</span>
diff --git a/user-guide/sql/index.html b/user-guide/sql/index.html
index 63d3b6f203..9122ccd46c 100644
--- a/user-guide/sql/index.html
+++ b/user-guide/sql/index.html
@@ -592,10 +592,7 @@
<li class="toctree-l2"><a class="reference internal"
href="operators.html#other-operators">Other Operators</a></li>
</ul>
</li>
-<li class="toctree-l1"><a class="reference internal"
href="aggregate_functions.html">Aggregate Functions</a><ul>
-<li class="toctree-l2"><a class="reference internal"
href="aggregate_functions.html#statistical">Statistical</a></li>
-</ul>
-</li>
+<li class="toctree-l1"><a class="reference internal"
href="aggregate_functions.html">Aggregate Functions</a></li>
<li class="toctree-l1"><a class="reference internal"
href="aggregate_functions_new.html">Aggregate Functions (NEW)</a><ul>
<li class="toctree-l2"><a class="reference internal"
href="aggregate_functions_new.html#general-functions">General Functions</a></li>
<li class="toctree-l2"><a class="reference internal"
href="aggregate_functions_new.html#statistical-functions">Statistical
Functions</a></li>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
