This is an automated email from the ASF dual-hosted git repository.
github-bot pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/arrow-datafusion.git
The following commit(s) were added to refs/heads/asf-site by this push:
new f5211a0ab2 Publish built docs triggered by
93ff57e6e080b7cdf7e598784c81587dcd11416f
f5211a0ab2 is described below
commit f5211a0ab2152ebbd43e1996787b5a27cf1f0299
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Mon May 15 14:20:28 2023 +0000
Publish built docs triggered by 93ff57e6e080b7cdf7e598784c81587dcd11416f
---
_sources/user-guide/expressions.md.txt | 5 +
_sources/user-guide/sql/aggregate_functions.md.txt | 70 ++++++
searchindex.js | 2 +-
user-guide/expressions.html | 33 ++-
user-guide/sql/aggregate_functions.html | 275 ++++++++++++++++-----
5 files changed, 315 insertions(+), 70 deletions(-)
diff --git a/_sources/user-guide/expressions.md.txt
b/_sources/user-guide/expressions.md.txt
index e250dc4bb6..f2305cb908 100644
--- a/_sources/user-guide/expressions.md.txt
+++ b/_sources/user-guide/expressions.md.txt
@@ -219,6 +219,11 @@ Unlike to some databases the math functions in Datafusion
works the same way as
| approx_median(expr) |
Calculates an approximation of the median for `expr`.
|
| approx_percentile_cont(expr, percentile) |
Calculates an approximation of the specified `percentile` for `expr`.
|
| approx_percentile_cont_with_weight(expr, weight_expr, percentile) |
Calculates an approximation of the specified `percentile` for `expr` and
`weight_expr`. |
+| bit_and(expr) | Computes
the bitwise AND of all non-null input values for `expr`. |
+| bit_or(expr) | Computes
the bitwise OR of all non-null input values for `expr`. |
+| bit_xor(expr) | Computes
the bitwise exclusive OR of all non-null input values for `expr`. |
+| bool_and(expr) | Returns
true if all non-null input values (`expr`) are true, otherwise false.
|
+| bool_or(expr) | Returns
true if any non-null input value (`expr`) is true, otherwise false.
|
| count(expr) | Returns
the number of rows for `expr`.
|
| count_distinct | Creates
an expression to represent the count(distinct) aggregate function
|
| cube(exprs) | Creates
a grouping set for all combination of `exprs`
|
diff --git a/_sources/user-guide/sql/aggregate_functions.md.txt
b/_sources/user-guide/sql/aggregate_functions.md.txt
index 497cf78aad..68c02ef550 100644
--- a/_sources/user-guide/sql/aggregate_functions.md.txt
+++ b/_sources/user-guide/sql/aggregate_functions.md.txt
@@ -24,6 +24,11 @@ Aggregate functions operate on a set of values to compute a
single result.
## General
- [avg](#avg)
+- [bit_and](#bit_and)
+- [bit_or](#bit_or)
+- [bit_xor](#bit_xor)
+- [bool_and](#bool_and)
+- [bool_or](#bool_or)
- [count](#count)
- [max](#max)
- [mean](#mean)
@@ -49,6 +54,71 @@ avg(expression)
- `mean`
+### `bit_and`
+
+Computes the bitwise AND of all non-null input values.
+
+```
+bit_and(expression)
+```
+
+#### Arguments
+
+- **expression**: Expression to operate on.
+ Can be a constant, column, or function, and any combination of arithmetic
operators.
+
+### `bit_or`
+
+Computes the bitwise OR of all non-null input values.
+
+```
+bit_or(expression)
+```
+
+#### Arguments
+
+- **expression**: Expression to operate on.
+ Can be a constant, column, or function, and any combination of arithmetic
operators.
+
+### `bit_xor`
+
+Computes the bitwise exclusive OR of all non-null input values.
+
+```
+bit_xor(expression)
+```
+
+#### Arguments
+
+- **expression**: Expression to operate on.
+ Can be a constant, column, or function, and any combination of arithmetic
operators.
+
+### `bool_and`
+
+Returns true if all non-null input values are true, otherwise false.
+
+```
+bool_and(expression)
+```
+
+#### Arguments
+
+- **expression**: Expression to operate on.
+ Can be a constant, column, or function, and any combination of arithmetic
operators.
+
+### `bool_or`
+
+Returns true if any non-null input value is true, otherwise false.
+
+```
+bool_or(expression)
+```
+
+#### Arguments
+
+- **expression**: Expression to operate on.
+ Can be a constant, column, or function, and any combination of arithmetic
operators.
+
### `count`
Returns the number of rows in the specified column.
diff --git a/searchindex.js b/searchindex.js
index 701ef524cb..a2b1633f9b 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"docnames": ["contributor-guide/architecture",
"contributor-guide/communication", "contributor-guide/index",
"contributor-guide/quarterly_roadmap", "contributor-guide/roadmap",
"contributor-guide/specification/index",
"contributor-guide/specification/invariants",
"contributor-guide/specification/output-field-name-semantic", "index",
"user-guide/cli", "user-guide/configs", "user-guide/dataframe",
"user-guide/example-usage", "user-guide/expressions", "user-guide/faq", "use
[...]
\ No newline at end of file
+Search.setIndex({"docnames": ["contributor-guide/architecture",
"contributor-guide/communication", "contributor-guide/index",
"contributor-guide/quarterly_roadmap", "contributor-guide/roadmap",
"contributor-guide/specification/index",
"contributor-guide/specification/invariants",
"contributor-guide/specification/output-field-name-semantic", "index",
"user-guide/cli", "user-guide/configs", "user-guide/dataframe",
"user-guide/example-usage", "user-guide/expressions", "user-guide/faq", "use
[...]
\ No newline at end of file
diff --git a/user-guide/expressions.html b/user-guide/expressions.html
index af99b2a097..b1d255aff9 100644
--- a/user-guide/expressions.html
+++ b/user-guide/expressions.html
@@ -912,31 +912,46 @@ expressions such as <code class="docutils literal
notranslate"><span class="pre"
<tr class="row-even"><td><p>approx_percentile_cont_with_weight(expr,
weight_expr, percentile)</p></td>
<td><p>Calculates an approximation of the specified <code class="docutils
literal notranslate"><span class="pre">percentile</span></code> for <code
class="docutils literal notranslate"><span class="pre">expr</span></code> and
<code class="docutils literal notranslate"><span
class="pre">weight_expr</span></code>.</p></td>
</tr>
-<tr class="row-odd"><td><p>count(expr)</p></td>
+<tr class="row-odd"><td><p>bit_and(expr)</p></td>
+<td><p>Computes the bitwise AND of all non-null input values for <code
class="docutils literal notranslate"><span
class="pre">expr</span></code>.</p></td>
+</tr>
+<tr class="row-even"><td><p>bit_or(expr)</p></td>
+<td><p>Computes the bitwise OR of all non-null input values for <code
class="docutils literal notranslate"><span
class="pre">expr</span></code>.</p></td>
+</tr>
+<tr class="row-odd"><td><p>bit_xor(expr)</p></td>
+<td><p>Computes the bitwise exclusive OR of all non-null input values for
<code class="docutils literal notranslate"><span
class="pre">expr</span></code>.</p></td>
+</tr>
+<tr class="row-even"><td><p>bool_and(expr)</p></td>
+<td><p>Returns true if all non-null input values (<code class="docutils
literal notranslate"><span class="pre">expr</span></code>) are true, otherwise
false.</p></td>
+</tr>
+<tr class="row-odd"><td><p>bool_or(expr)</p></td>
+<td><p>Returns true if any non-null input value (<code class="docutils literal
notranslate"><span class="pre">expr</span></code>) is true, otherwise
false.</p></td>
+</tr>
+<tr class="row-even"><td><p>count(expr)</p></td>
<td><p>Returns the number of rows for <code class="docutils literal
notranslate"><span class="pre">expr</span></code>.</p></td>
</tr>
-<tr class="row-even"><td><p>count_distinct</p></td>
+<tr class="row-odd"><td><p>count_distinct</p></td>
<td><p>Creates an expression to represent the count(distinct) aggregate
function</p></td>
</tr>
-<tr class="row-odd"><td><p>cube(exprs)</p></td>
+<tr class="row-even"><td><p>cube(exprs)</p></td>
<td><p>Creates a grouping set for all combination of <code class="docutils
literal notranslate"><span class="pre">exprs</span></code></p></td>
</tr>
-<tr class="row-even"><td><p>grouping_set(exprs)</p></td>
+<tr class="row-odd"><td><p>grouping_set(exprs)</p></td>
<td><p>Create a grouping set.</p></td>
</tr>
-<tr class="row-odd"><td><p>max(expr)</p></td>
+<tr class="row-even"><td><p>max(expr)</p></td>
<td><p>Finds the maximum value of <code class="docutils literal
notranslate"><span class="pre">expr</span></code>.</p></td>
</tr>
-<tr class="row-even"><td><p>median(expr)</p></td>
+<tr class="row-odd"><td><p>median(expr)</p></td>
<td><p>Сalculates the median of <code class="docutils literal
notranslate"><span class="pre">expr</span></code>.</p></td>
</tr>
-<tr class="row-odd"><td><p>min(expr)</p></td>
+<tr class="row-even"><td><p>min(expr)</p></td>
<td><p>Finds the minimum value of <code class="docutils literal
notranslate"><span class="pre">expr</span></code>.</p></td>
</tr>
-<tr class="row-even"><td><p>rollup(exprs)</p></td>
+<tr class="row-odd"><td><p>rollup(exprs)</p></td>
<td><p>Creates a grouping set for rollup sets.</p></td>
</tr>
-<tr class="row-odd"><td><p>sum(expr)</p></td>
+<tr class="row-even"><td><p>sum(expr)</p></td>
<td><p>Сalculates the sum of <code class="docutils literal notranslate"><span
class="pre">expr</span></code>.</p></td>
</tr>
</tbody>
diff --git a/user-guide/sql/aggregate_functions.html
b/user-guide/sql/aggregate_functions.html
index 071e21f1fe..6ebb5b74cd 100644
--- a/user-guide/sql/aggregate_functions.html
+++ b/user-guide/sql/aggregate_functions.html
@@ -304,6 +304,86 @@
</li>
</ul>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#bit-and">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ bit_and
+ </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="#bit-or">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ bit_or
+ </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="#bit-xor">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ bit_xor
+ </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="#bool-and">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ bool_and
+ </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="#bool-or">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ bool_or
+ </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="#count">
<code class="docutils literal notranslate">
@@ -314,7 +394,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id1">
+ <a class="reference internal nav-link" href="#id6">
Arguments
</a>
</li>
@@ -330,7 +410,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id2">
+ <a class="reference internal nav-link" href="#id7">
Arguments
</a>
</li>
@@ -355,7 +435,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id3">
+ <a class="reference internal nav-link" href="#id8">
Arguments
</a>
</li>
@@ -371,7 +451,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id4">
+ <a class="reference internal nav-link" href="#id9">
Arguments
</a>
</li>
@@ -387,7 +467,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id5">
+ <a class="reference internal nav-link" href="#id10">
Arguments
</a>
</li>
@@ -403,7 +483,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id6">
+ <a class="reference internal nav-link" href="#id11">
Arguments
</a>
</li>
@@ -426,7 +506,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id7">
+ <a class="reference internal nav-link" href="#id12">
Arguments
</a>
</li>
@@ -442,7 +522,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id8">
+ <a class="reference internal nav-link" href="#id13">
Arguments
</a>
</li>
@@ -458,7 +538,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id9">
+ <a class="reference internal nav-link" href="#id14">
Arguments
</a>
</li>
@@ -474,7 +554,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id10">
+ <a class="reference internal nav-link" href="#id15">
Arguments
</a>
</li>
@@ -490,7 +570,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id11">
+ <a class="reference internal nav-link" href="#id16">
Arguments
</a>
</li>
@@ -506,7 +586,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id12">
+ <a class="reference internal nav-link" href="#id17">
Arguments
</a>
</li>
@@ -522,7 +602,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id13">
+ <a class="reference internal nav-link" href="#id18">
Arguments
</a>
</li>
@@ -538,7 +618,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id14">
+ <a class="reference internal nav-link" href="#id19">
Arguments
</a>
</li>
@@ -554,7 +634,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id15">
+ <a class="reference internal nav-link" href="#id20">
Arguments
</a>
</li>
@@ -570,7 +650,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id16">
+ <a class="reference internal nav-link" href="#id21">
Arguments
</a>
</li>
@@ -593,7 +673,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id17">
+ <a class="reference internal nav-link" href="#id22">
Arguments
</a>
</li>
@@ -609,7 +689,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id18">
+ <a class="reference internal nav-link" href="#id23">
Arguments
</a>
</li>
@@ -625,7 +705,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id19">
+ <a class="reference internal nav-link" href="#id24">
Arguments
</a>
</li>
@@ -641,7 +721,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id20">
+ <a class="reference internal nav-link" href="#id25">
Arguments
</a>
</li>
@@ -702,6 +782,11 @@
<h2>General<a class="headerlink" href="#general" title="Permalink to this
heading">¶</a></h2>
<ul class="simple">
<li><p><a class="reference internal" href="#avg">avg</a></p></li>
+<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="#bool-and">bool_and</a></p></li>
+<li><p><a class="reference internal" href="#bool-or">bool_or</a></p></li>
<li><p><a class="reference internal" href="#count">count</a></p></li>
<li><p><a class="reference internal" href="#max">max</a></p></li>
<li><p><a class="reference internal" href="#mean">mean</a></p></li>
@@ -730,6 +815,76 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
</ul>
</section>
</section>
+<section id="bit-and">
+<h3><code class="docutils literal notranslate"><span
class="pre">bit_and</span></code><a class="headerlink" href="#bit-and"
title="Permalink to this heading">¶</a></h3>
+<p>Computes the bitwise AND of all non-null input values.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">bit_and</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id1">
+<h4>Arguments<a class="headerlink" href="#id1" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression</strong>: Expression to operate on.
+Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
+</ul>
+</section>
+</section>
+<section id="bit-or">
+<h3><code class="docutils literal notranslate"><span
class="pre">bit_or</span></code><a class="headerlink" href="#bit-or"
title="Permalink to this heading">¶</a></h3>
+<p>Computes the bitwise OR of all non-null input values.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">bit_or</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id2">
+<h4>Arguments<a class="headerlink" href="#id2" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression</strong>: Expression to operate on.
+Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
+</ul>
+</section>
+</section>
+<section id="bit-xor">
+<h3><code class="docutils literal notranslate"><span
class="pre">bit_xor</span></code><a class="headerlink" href="#bit-xor"
title="Permalink to this heading">¶</a></h3>
+<p>Computes the bitwise exclusive OR of all non-null input values.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">bit_xor</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="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression</strong>: Expression to operate on.
+Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
+</ul>
+</section>
+</section>
+<section id="bool-and">
+<h3><code class="docutils literal notranslate"><span
class="pre">bool_and</span></code><a class="headerlink" href="#bool-and"
title="Permalink to this heading">¶</a></h3>
+<p>Returns true if all non-null input values are true, otherwise false.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">bool_and</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="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression</strong>: Expression to operate on.
+Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
+</ul>
+</section>
+</section>
+<section id="bool-or">
+<h3><code class="docutils literal notranslate"><span
class="pre">bool_or</span></code><a class="headerlink" href="#bool-or"
title="Permalink to this heading">¶</a></h3>
+<p>Returns true if any non-null input value is true, otherwise false.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">bool_or</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id5">
+<h4>Arguments<a class="headerlink" href="#id5" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>expression</strong>: Expression to operate on.
+Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
+</ul>
+</section>
+</section>
<section id="count">
<h3><code class="docutils literal notranslate"><span
class="pre">count</span></code><a class="headerlink" href="#count"
title="Permalink to this heading">¶</a></h3>
<p>Returns the number of rows in the specified column.</p>
@@ -739,8 +894,8 @@ in the <code class="docutils literal notranslate"><span
class="pre">WHERE</span>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">count</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id1">
-<h4>Arguments<a class="headerlink" href="#id1" title="Permalink to this
heading">¶</a></h4>
+<section id="id6">
+<h4>Arguments<a class="headerlink" href="#id6" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -753,8 +908,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="nb">max</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id2">
-<h4>Arguments<a class="headerlink" href="#id2" title="Permalink to this
heading">¶</a></h4>
+<section id="id7">
+<h4>Arguments<a class="headerlink" href="#id7" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -771,8 +926,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">median</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="Permalink to this
heading">¶</a></h4>
+<section id="id8">
+<h4>Arguments<a class="headerlink" href="#id8" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -785,8 +940,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="nb">min</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="Permalink to this
heading">¶</a></h4>
+<section id="id9">
+<h4>Arguments<a class="headerlink" href="#id9" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -799,8 +954,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="nb">sum</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id5">
-<h4>Arguments<a class="headerlink" href="#id5" title="Permalink to this
heading">¶</a></h4>
+<section id="id10">
+<h4>Arguments<a class="headerlink" href="#id10" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -813,8 +968,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">array_agg</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="Permalink to this
heading">¶</a></h4>
+<section id="id11">
+<h4>Arguments<a class="headerlink" href="#id11" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -842,8 +997,8 @@ Can be a constant, column, or function, and any combination
of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">corr</span><span
class="p">(</span><span class="n">expression1</span><span class="p">,</span>
<span class="n">expression2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id7">
-<h4>Arguments<a class="headerlink" href="#id7" title="Permalink to this
heading">¶</a></h4>
+<section id="id12">
+<h4>Arguments<a class="headerlink" href="#id12" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression1</strong>: First expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -858,8 +1013,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">covar</span><span
class="p">(</span><span class="n">expression1</span><span class="p">,</span>
<span class="n">expression2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id8">
-<h4>Arguments<a class="headerlink" href="#id8" title="Permalink to this
heading">¶</a></h4>
+<section id="id13">
+<h4>Arguments<a class="headerlink" href="#id13" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression1</strong>: First expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -874,8 +1029,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">covar_pop</span><span
class="p">(</span><span class="n">expression1</span><span class="p">,</span>
<span class="n">expression2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id9">
-<h4>Arguments<a class="headerlink" href="#id9" title="Permalink to this
heading">¶</a></h4>
+<section id="id14">
+<h4>Arguments<a class="headerlink" href="#id14" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression1</strong>: First expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -890,8 +1045,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">covar_samp</span><span
class="p">(</span><span class="n">expression1</span><span class="p">,</span>
<span class="n">expression2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id10">
-<h4>Arguments<a class="headerlink" href="#id10" title="Permalink to this
heading">¶</a></h4>
+<section id="id15">
+<h4>Arguments<a class="headerlink" href="#id15" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression1</strong>: First expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -906,8 +1061,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">stddev</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id11">
-<h4>Arguments<a class="headerlink" href="#id11" title="Permalink to this
heading">¶</a></h4>
+<section id="id16">
+<h4>Arguments<a class="headerlink" href="#id16" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -920,8 +1075,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">stddev_pop</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="Permalink to this
heading">¶</a></h4>
+<section id="id17">
+<h4>Arguments<a class="headerlink" href="#id17" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -934,8 +1089,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">stddev_samp</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id13">
-<h4>Arguments<a class="headerlink" href="#id13" title="Permalink to this
heading">¶</a></h4>
+<section id="id18">
+<h4>Arguments<a class="headerlink" href="#id18" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -948,8 +1103,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">var</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id14">
-<h4>Arguments<a class="headerlink" href="#id14" title="Permalink to this
heading">¶</a></h4>
+<section id="id19">
+<h4>Arguments<a class="headerlink" href="#id19" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -962,8 +1117,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">var_pop</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id15">
-<h4>Arguments<a class="headerlink" href="#id15" title="Permalink to this
heading">¶</a></h4>
+<section id="id20">
+<h4>Arguments<a class="headerlink" href="#id20" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -976,8 +1131,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">var_samp</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id16">
-<h4>Arguments<a class="headerlink" href="#id16" title="Permalink to this
heading">¶</a></h4>
+<section id="id21">
+<h4>Arguments<a class="headerlink" href="#id21" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -1000,8 +1155,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="id17">
-<h4>Arguments<a class="headerlink" href="#id17" title="Permalink to this
heading">¶</a></h4>
+<section id="id22">
+<h4>Arguments<a class="headerlink" href="#id22" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -1015,8 +1170,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="id18">
-<h4>Arguments<a class="headerlink" href="#id18" title="Permalink to this
heading">¶</a></h4>
+<section id="id23">
+<h4>Arguments<a class="headerlink" href="#id23" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -1029,8 +1184,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="id19">
-<h4>Arguments<a class="headerlink" href="#id19" title="Permalink to this
heading">¶</a></h4>
+<section id="id24">
+<h4>Arguments<a class="headerlink" href="#id24" title="Permalink to this
heading">¶</a></h4>
<ul>
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -1050,8 +1205,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="id20">
-<h4>Arguments<a class="headerlink" href="#id20" title="Permalink to this
heading">¶</a></h4>
+<section id="id25">
+<h4>Arguments<a class="headerlink" href="#id25" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
