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 8e6df099c1 Publish built docs triggered by
b3bf3af36eff83addca83507ef18a58b52b533bb
8e6df099c1 is described below
commit 8e6df099c15e7108eeb27b5744e4b47cc4e98d94
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Mon Oct 7 10:42:24 2024 +0000
Publish built docs triggered by b3bf3af36eff83addca83507ef18a58b52b533bb
---
_sources/user-guide/sql/aggregate_functions.md.txt | 42 -----
.../user-guide/sql/aggregate_functions_new.md.txt | 81 +++++++++
searchindex.js | 2 +-
user-guide/sql/aggregate_functions.html | 171 ++++--------------
user-guide/sql/aggregate_functions_new.html | 199 +++++++++++++++++++++
5 files changed, 320 insertions(+), 175 deletions(-)
diff --git a/_sources/user-guide/sql/aggregate_functions.md.txt
b/_sources/user-guide/sql/aggregate_functions.md.txt
index edb0e1d0c9..fe6a61e74e 100644
--- a/_sources/user-guide/sql/aggregate_functions.md.txt
+++ b/_sources/user-guide/sql/aggregate_functions.md.txt
@@ -240,9 +240,6 @@ last_value(expression [ORDER BY expression])
- [stddev](#stddev)
- [stddev_pop](#stddev_pop)
- [stddev_samp](#stddev_samp)
-- [var](#var)
-- [var_pop](#var_pop)
-- [var_samp](#var_samp)
- [regr_avgx](#regr_avgx)
- [regr_avgy](#regr_avgy)
- [regr_count](#regr_count)
@@ -349,45 +346,6 @@ stddev_samp(expression)
#### Arguments
-- **expression**: Expression to operate on.
- Can be a constant, column, or function, and any combination of arithmetic
operators.
-
-### `var`
-
-Returns the statistical variance of a set of numbers.
-
-```
-var(expression)
-```
-
-#### Arguments
-
-- **expression**: Expression to operate on.
- Can be a constant, column, or function, and any combination of arithmetic
operators.
-
-### `var_pop`
-
-Returns the statistical population variance of a set of numbers.
-
-```
-var_pop(expression)
-```
-
-#### Arguments
-
-- **expression**: Expression to operate on.
- Can be a constant, column, or function, and any combination of arithmetic
operators.
-
-### `var_samp`
-
-Returns the statistical sample variance of a set of numbers.
-
-```
-var_samp(expression)
-```
-
-#### Arguments
-
- **expression**: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.
diff --git a/_sources/user-guide/sql/aggregate_functions_new.md.txt
b/_sources/user-guide/sql/aggregate_functions_new.md.txt
index 2c8ebc3be9..213894d7da 100644
--- a/_sources/user-guide/sql/aggregate_functions_new.md.txt
+++ b/_sources/user-guide/sql/aggregate_functions_new.md.txt
@@ -36,6 +36,11 @@ Aggregate functions operate on a set of values to compute a
single result.
- [bit_and](#bit_and)
- [bit_or](#bit_or)
- [bit_xor](#bit_xor)
+- [var](#var)
+- [var_pop](#var_pop)
+- [var_population](#var_population)
+- [var_samp](#var_samp)
+- [var_sample](#var_sample)
### `bit_and`
@@ -72,3 +77,79 @@ bit_xor(expression)
#### Arguments
- **expression**: Integer expression to operate on. Can be a constant, column,
or function, and any combination of operators.
+
+### `var`
+
+Returns the statistical sample variance of a set of numbers.
+
+```
+var(expression)
+```
+
+#### Arguments
+
+- **expression**: Numeric expression to operate on. Can be a constant, column,
or function, and any combination of operators.
+
+#### Aliases- var_sample
+
+- var_samp
+
+### `var_pop`
+
+Returns the statistical population variance of a set of numbers.
+
+```
+var_pop(expression)
+```
+
+#### Arguments
+
+- **expression**: Numeric expression to operate on. Can be a constant, column,
or function, and any combination of operators.
+
+#### Aliases- var_population
+
+### `var_pop`
+
+Returns the statistical population variance of a set of numbers.
+
+```
+var_pop(expression)
+```
+
+#### Arguments
+
+- **expression**: Numeric expression to operate on. Can be a constant, column,
or function, and any combination of operators.
+
+#### Aliases- var_population
+
+### `var`
+
+Returns the statistical sample variance of a set of numbers.
+
+```
+var(expression)
+```
+
+#### Arguments
+
+- **expression**: Numeric expression to operate on. Can be a constant, column,
or function, and any combination of operators.
+
+#### Aliases- var_sample
+
+- var_samp
+
+### `var`
+
+Returns the statistical sample variance of a set of numbers.
+
+```
+var(expression)
+```
+
+#### Arguments
+
+- **expression**: Numeric expression to operate on. Can be a constant, column,
or function, and any combination of operators.
+
+#### Aliases- var_sample
+
+- var_samp
diff --git a/searchindex.js b/searchindex.js
index fcb23a71c3..dcfe2db727 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 420491d776..50bc6893d6 100644
--- a/user-guide/sql/aggregate_functions.html
+++ b/user-guide/sql/aggregate_functions.html
@@ -865,54 +865,6 @@
</li>
</ul>
</li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#var">
- <code class="docutils literal notranslate">
- <span class="pre">
- var
- </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="#id21">
- Arguments
- </a>
- </li>
- </ul>
- </li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#var-pop">
- <code class="docutils literal notranslate">
- <span class="pre">
- var_pop
- </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="#id22">
- Arguments
- </a>
- </li>
- </ul>
- </li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#var-samp">
- <code class="docutils literal notranslate">
- <span class="pre">
- var_samp
- </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="#id23">
- 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">
@@ -923,7 +875,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="#id21">
Arguments
</a>
</li>
@@ -939,7 +891,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="#id22">
Arguments
</a>
</li>
@@ -955,7 +907,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id26">
+ <a class="reference internal nav-link" href="#id23">
Arguments
</a>
</li>
@@ -971,7 +923,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id27">
+ <a class="reference internal nav-link" href="#id24">
Arguments
</a>
</li>
@@ -987,7 +939,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id28">
+ <a class="reference internal nav-link" href="#id25">
Arguments
</a>
</li>
@@ -1003,7 +955,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id29">
+ <a class="reference internal nav-link" href="#id26">
Arguments
</a>
</li>
@@ -1019,7 +971,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id30">
+ <a class="reference internal nav-link" href="#id27">
Arguments
</a>
</li>
@@ -1035,7 +987,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id31">
+ <a class="reference internal nav-link" href="#id28">
Arguments
</a>
</li>
@@ -1051,7 +1003,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id32">
+ <a class="reference internal nav-link" href="#id29">
Arguments
</a>
</li>
@@ -1074,7 +1026,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id33">
+ <a class="reference internal nav-link" href="#id30">
Arguments
</a>
</li>
@@ -1090,7 +1042,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id34">
+ <a class="reference internal nav-link" href="#id31">
Arguments
</a>
</li>
@@ -1106,7 +1058,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id35">
+ <a class="reference internal nav-link" href="#id32">
Arguments
</a>
</li>
@@ -1122,7 +1074,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id36">
+ <a class="reference internal nav-link" href="#id33">
Arguments
</a>
</li>
@@ -1416,9 +1368,6 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<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>
-<li><p><a class="reference internal" href="#var">var</a></p></li>
-<li><p><a class="reference internal" href="#var-pop">var_pop</a></p></li>
-<li><p><a class="reference internal" href="#var-samp">var_samp</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>
@@ -1535,48 +1484,6 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
</ul>
</section>
</section>
-<section id="var">
-<h3><code class="docutils literal notranslate"><span
class="pre">var</span></code><a class="headerlink" href="#var" title="Link to
this heading">¶</a></h3>
-<p>Returns the statistical variance of a set of numbers.</p>
-<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="id21">
-<h4>Arguments<a class="headerlink" href="#id21" title="Link 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="var-pop">
-<h3><code class="docutils literal notranslate"><span
class="pre">var_pop</span></code><a class="headerlink" href="#var-pop"
title="Link to this heading">¶</a></h3>
-<p>Returns the statistical population variance of a set of numbers.</p>
-<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="id22">
-<h4>Arguments<a class="headerlink" href="#id22" title="Link 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="var-samp">
-<h3><code class="docutils literal notranslate"><span
class="pre">var_samp</span></code><a class="headerlink" href="#var-samp"
title="Link to this heading">¶</a></h3>
-<p>Returns the statistical sample variance of a set of numbers.</p>
-<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="id23">
-<h4>Arguments<a class="headerlink" href="#id23" title="Link 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="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.
@@ -1584,8 +1491,8 @@ Given input column Y and X: regr_slope(Y, X) returns the
slope (k in Y = k*X + b
<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="id24">
-<h4>Arguments<a class="headerlink" href="#id24" title="Link to this
heading">¶</a></h4>
+<section id="id21">
+<h4>Arguments<a class="headerlink" href="#id21" 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>
@@ -1600,8 +1507,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">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="id25">
-<h4>Arguments<a class="headerlink" href="#id25" title="Link to this
heading">¶</a></h4>
+<section id="id22">
+<h4>Arguments<a class="headerlink" href="#id22" 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>
@@ -1616,8 +1523,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">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="id26">
-<h4>Arguments<a class="headerlink" href="#id26" title="Link to this
heading">¶</a></h4>
+<section id="id23">
+<h4>Arguments<a class="headerlink" href="#id23" 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>
@@ -1632,8 +1539,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">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="id27">
-<h4>Arguments<a class="headerlink" href="#id27" title="Link to this
heading">¶</a></h4>
+<section id="id24">
+<h4>Arguments<a class="headerlink" href="#id24" 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>
@@ -1648,8 +1555,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">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="id28">
-<h4>Arguments<a class="headerlink" href="#id28" title="Link to this
heading">¶</a></h4>
+<section id="id25">
+<h4>Arguments<a class="headerlink" href="#id25" 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>
@@ -1664,8 +1571,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">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="id29">
-<h4>Arguments<a class="headerlink" href="#id29" title="Link to this
heading">¶</a></h4>
+<section id="id26">
+<h4>Arguments<a class="headerlink" href="#id26" 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>
@@ -1680,8 +1587,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">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="id30">
-<h4>Arguments<a class="headerlink" href="#id30" title="Link to this
heading">¶</a></h4>
+<section id="id27">
+<h4>Arguments<a class="headerlink" href="#id27" 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>
@@ -1696,8 +1603,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">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="id31">
-<h4>Arguments<a class="headerlink" href="#id31" title="Link to this
heading">¶</a></h4>
+<section id="id28">
+<h4>Arguments<a class="headerlink" href="#id28" 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>
@@ -1712,8 +1619,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">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="id32">
-<h4>Arguments<a class="headerlink" href="#id32" title="Link to this
heading">¶</a></h4>
+<section id="id29">
+<h4>Arguments<a class="headerlink" href="#id29" 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>
@@ -1738,8 +1645,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="id33">
-<h4>Arguments<a class="headerlink" href="#id33" title="Link to this
heading">¶</a></h4>
+<section id="id30">
+<h4>Arguments<a class="headerlink" href="#id30" title="Link 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>
@@ -1753,8 +1660,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="id34">
-<h4>Arguments<a class="headerlink" href="#id34" title="Link to this
heading">¶</a></h4>
+<section id="id31">
+<h4>Arguments<a class="headerlink" href="#id31" title="Link 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>
@@ -1767,8 +1674,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="id35">
-<h4>Arguments<a class="headerlink" href="#id35" title="Link to this
heading">¶</a></h4>
+<section id="id32">
+<h4>Arguments<a class="headerlink" href="#id32" title="Link 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>
@@ -1788,8 +1695,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="id36">
-<h4>Arguments<a class="headerlink" href="#id36" title="Link to this
heading">¶</a></h4>
+<section id="id33">
+<h4>Arguments<a class="headerlink" href="#id33" title="Link 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>
diff --git a/user-guide/sql/aggregate_functions_new.html
b/user-guide/sql/aggregate_functions_new.html
index a96e31ad21..b98d269552 100644
--- a/user-guide/sql/aggregate_functions_new.html
+++ b/user-guide/sql/aggregate_functions_new.html
@@ -556,6 +556,111 @@
</li>
</ul>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#var">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ var
+ </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>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#aliases-var-sample">
+ Aliases- var_sample
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#var-pop">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ var_pop
+ </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>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#aliases-var-population">
+ Aliases- var_population
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id5">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ var_pop
+ </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>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id7">
+ Aliases- var_population
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id8">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ var
+ </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>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id10">
+ Aliases- var_sample
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id11">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ var
+ </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>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id13">
+ Aliases- var_sample
+ </a>
+ </li>
+ </ul>
+ </li>
</ul>
</li>
</ul>
@@ -621,6 +726,11 @@ dev/update_function_docs.sh file for updating surrounding
text.
<li><p><a class="reference internal" href="#bit-and">bit_and</a></p></li>
<li><p><a class="reference internal" href="#bit-or">bit_or</a></p></li>
<li><p><a class="reference internal" href="#bit-xor">bit_xor</a></p></li>
+<li><p><a class="reference internal" href="#var">var</a></p></li>
+<li><p><a class="reference internal" href="#var-pop">var_pop</a></p></li>
+<li><p><a class="reference internal" href="#var_population"><span class="xref
myst">var_population</span></a></p></li>
+<li><p><a class="reference internal" href="#var_samp"><span class="xref
myst">var_samp</span></a></p></li>
+<li><p><a class="reference internal" href="#var_sample"><span class="xref
myst">var_sample</span></a></p></li>
</ul>
<section id="bit-and">
<h3><code class="docutils literal notranslate"><span
class="pre">bit_and</span></code><a class="headerlink" href="#bit-and"
title="Link to this heading">¶</a></h3>
@@ -661,6 +771,95 @@ dev/update_function_docs.sh file for updating surrounding
text.
</ul>
</section>
</section>
+<section id="var">
+<h3><code class="docutils literal notranslate"><span
class="pre">var</span></code><a class="headerlink" href="#var" title="Link to
this heading">¶</a></h3>
+<p>Returns the statistical sample variance of a set of numbers.</p>
+<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="id3">
+<h4>Arguments<a class="headerlink" href="#id3" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression</strong>: Numeric expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
+</ul>
+</section>
+<section id="aliases-var-sample">
+<h4>Aliases- var_sample<a class="headerlink" href="#aliases-var-sample"
title="Link to this heading">¶</a></h4>
+<ul class="simple">
+<li><p>var_samp</p></li>
+</ul>
+</section>
+</section>
+<section id="var-pop">
+<h3><code class="docutils literal notranslate"><span
class="pre">var_pop</span></code><a class="headerlink" href="#var-pop"
title="Link to this heading">¶</a></h3>
+<p>Returns the statistical population variance of a set of numbers.</p>
+<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="id4">
+<h4>Arguments<a class="headerlink" href="#id4" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression</strong>: Numeric expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
+</ul>
+</section>
+<section id="aliases-var-population">
+<h4>Aliases- var_population<a class="headerlink"
href="#aliases-var-population" title="Link to this heading">¶</a></h4>
+</section>
+</section>
+<section id="id5">
+<h3><code class="docutils literal notranslate"><span
class="pre">var_pop</span></code><a class="headerlink" href="#id5" title="Link
to this heading">¶</a></h3>
+<p>Returns the statistical population variance of a set of numbers.</p>
+<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="id6">
+<h4>Arguments<a class="headerlink" href="#id6" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression</strong>: Numeric expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
+</ul>
+</section>
+<section id="id7">
+<h4>Aliases- var_population<a class="headerlink" href="#id7" title="Link to
this heading">¶</a></h4>
+</section>
+</section>
+<section id="id8">
+<h3><code class="docutils literal notranslate"><span
class="pre">var</span></code><a class="headerlink" href="#id8" title="Link to
this heading">¶</a></h3>
+<p>Returns the statistical sample variance of a set of numbers.</p>
+<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="id9">
+<h4>Arguments<a class="headerlink" href="#id9" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression</strong>: Numeric expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
+</ul>
+</section>
+<section id="id10">
+<h4>Aliases- var_sample<a class="headerlink" href="#id10" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>var_samp</p></li>
+</ul>
+</section>
+</section>
+<section id="id11">
+<h3><code class="docutils literal notranslate"><span
class="pre">var</span></code><a class="headerlink" href="#id11" title="Link to
this heading">¶</a></h3>
+<p>Returns the statistical sample variance of a set of numbers.</p>
+<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="id12">
+<h4>Arguments<a class="headerlink" href="#id12" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression</strong>: Numeric expression to operate on. Can be a
constant, column, or function, and any combination of operators.</p></li>
+</ul>
+</section>
+<section id="id13">
+<h4>Aliases- var_sample<a class="headerlink" href="#id13" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>var_samp</p></li>
+</ul>
+</section>
+</section>
</section>
</section>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
