You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@arrow.apache.org by gi...@apache.org on 2023/06/27 18:40:24 UTC
[arrow-datafusion] branch asf-site updated: Publish built docs triggered by 1dd1fbda716a43560b4d5cfe61bd79a9293bc46d
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 d08da46b8f Publish built docs triggered by 1dd1fbda716a43560b4d5cfe61bd79a9293bc46d
d08da46b8f is described below
commit d08da46b8fca992bff8ca8d217224a40605521a7
Author: github-actions[bot] <gi...@users.noreply.github.com>
AuthorDate: Tue Jun 27 18:40:20 2023 +0000
Publish built docs triggered by 1dd1fbda716a43560b4d5cfe61bd79a9293bc46d
---
_sources/user-guide/expressions.md.txt | 35 ++---
_sources/user-guide/sql/scalar_functions.md.txt | 16 +++
searchindex.js | 2 +-
user-guide/expressions.html | 29 +++--
user-guide/sql/scalar_functions.html | 165 ++++++++++++++----------
5 files changed, 150 insertions(+), 97 deletions(-)
diff --git a/_sources/user-guide/expressions.md.txt b/_sources/user-guide/expressions.md.txt
index 07f5923a6a..b5d4cfa0ac 100644
--- a/_sources/user-guide/expressions.md.txt
+++ b/_sources/user-guide/expressions.md.txt
@@ -179,23 +179,24 @@ Unlike to some databases the math functions in Datafusion works the same way as
## Array Expressions
-| Function | Notes |
-| ------------------------------------ | --------------------------------------------------------------- |
-| array_append(array, element) | Appends an element to the end of an array. |
-| array_concat(array[, ..., array_n]) | Concatenates arrays. |
-| array_dims(array) | Returns an array of the array's dimensions. |
-| array_fill(element, array) | Returns an array filled with copies of the given value. |
-| array_length(array, dimension) | Returns the length of the array dimension. |
-| array_ndims(array) | Returns the number of dimensions of the array. |
-| array_position(array, element) | Searches for an element in the array, returns first occurrence. |
-| array_positions(array, element) | Searches for an element in the array, returns all occurrences. |
-| array_prepend(array, element) | Prepends an element to the beginning of an array. |
-| array_remove(array, element) | Removes all elements equal to the given value from the array. |
-| array_replace(array, from, to) | Replaces a specified element with another specified element. |
-| array_to_string(array, delimeter) | Converts each element to its text representation. |
-| cardinality(array) | Returns the total number of elements in the array. |
-| make_array(value1, [value2 [, ...]]) | Returns an Arrow array using the specified input expressions. |
-| trim_array(array, n) | Removes the last n elements from the array. |
+| Function | Notes |
+| ----------------------------------------- | ------------------------------------------------------------------------------------------------ |
+| array_append(array, element) | Appends an element to the end of an array. |
+| array_concat(array[, ..., array_n]) | Concatenates arrays. |
+| array_contains(first_array, second_array) | Returns true, if each element of the second array appearing in the first array, otherwise false. |
+| array_dims(array) | Returns an array of the array's dimensions. |
+| array_fill(element, array) | Returns an array filled with copies of the given value. |
+| array_length(array, dimension) | Returns the length of the array dimension. |
+| array_ndims(array) | Returns the number of dimensions of the array. |
+| array_position(array, element) | Searches for an element in the array, returns first occurrence. |
+| array_positions(array, element) | Searches for an element in the array, returns all occurrences. |
+| array_prepend(array, element) | Prepends an element to the beginning of an array. |
+| array_remove(array, element) | Removes all elements equal to the given value from the array. |
+| array_replace(array, from, to) | Replaces a specified element with another specified element. |
+| array_to_string(array, delimeter) | Converts each element to its text representation. |
+| cardinality(array) | Returns the total number of elements in the array. |
+| make_array(value1, [value2 [, ...]]) | Returns an Arrow array using the specified input expressions. |
+| trim_array(array, n) | Removes the last n elements from the array. |
## Regular Expressions
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt b/_sources/user-guide/sql/scalar_functions.md.txt
index c24b6dc91a..34999ddf16 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -1382,6 +1382,7 @@ from_unixtime(expression)
- [array_append](#array_append)
- [array_concat](#array_concat)
+- [array_contains](#array_contains)
- [array_dims](#array_dims)
- [array_fill](#array_fill)
- [array_length](#array_length)
@@ -1424,6 +1425,21 @@ array_concat(array[, ..., array_n])
Can be a constant, column, or function, and any combination of array operators.
- **array_n**: Subsequent array column or literal array to concatenate.
+### `array_contains`
+
+Returns true, if each element of the second array appears in the first array, otherwise false.
+
+```
+array_contains(first_array, second_array)
+```
+
+#### Arguments
+
+- **first_array**: Array expression.
+ Can be a constant, column, or function, and any combination of array operators.
+- **second_array**: Array expression.
+ Can be a constant, column, or function, and any combination of array operators.
+
### `array_dims`
Returns an array of the array's dimensions.
diff --git a/searchindex.js b/searchindex.js
index 07d1b18eb8..6212d08b5c 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 475ebd268a..b6971be717 100644
--- a/user-guide/expressions.html
+++ b/user-guide/expressions.html
@@ -818,43 +818,46 @@ expressions such as <code class="docutils literal notranslate"><span class="pre"
<tr class="row-odd"><td><p>array_concat(array[, …, array_n])</p></td>
<td><p>Concatenates arrays.</p></td>
</tr>
-<tr class="row-even"><td><p>array_dims(array)</p></td>
+<tr class="row-even"><td><p>array_contains(first_array, second_array)</p></td>
+<td><p>Returns true, if each element of the second array appearing in the first array, otherwise false.</p></td>
+</tr>
+<tr class="row-odd"><td><p>array_dims(array)</p></td>
<td><p>Returns an array of the array’s dimensions.</p></td>
</tr>
-<tr class="row-odd"><td><p>array_fill(element, array)</p></td>
+<tr class="row-even"><td><p>array_fill(element, array)</p></td>
<td><p>Returns an array filled with copies of the given value.</p></td>
</tr>
-<tr class="row-even"><td><p>array_length(array, dimension)</p></td>
+<tr class="row-odd"><td><p>array_length(array, dimension)</p></td>
<td><p>Returns the length of the array dimension.</p></td>
</tr>
-<tr class="row-odd"><td><p>array_ndims(array)</p></td>
+<tr class="row-even"><td><p>array_ndims(array)</p></td>
<td><p>Returns the number of dimensions of the array.</p></td>
</tr>
-<tr class="row-even"><td><p>array_position(array, element)</p></td>
+<tr class="row-odd"><td><p>array_position(array, element)</p></td>
<td><p>Searches for an element in the array, returns first occurrence.</p></td>
</tr>
-<tr class="row-odd"><td><p>array_positions(array, element)</p></td>
+<tr class="row-even"><td><p>array_positions(array, element)</p></td>
<td><p>Searches for an element in the array, returns all occurrences.</p></td>
</tr>
-<tr class="row-even"><td><p>array_prepend(array, element)</p></td>
+<tr class="row-odd"><td><p>array_prepend(array, element)</p></td>
<td><p>Prepends an element to the beginning of an array.</p></td>
</tr>
-<tr class="row-odd"><td><p>array_remove(array, element)</p></td>
+<tr class="row-even"><td><p>array_remove(array, element)</p></td>
<td><p>Removes all elements equal to the given value from the array.</p></td>
</tr>
-<tr class="row-even"><td><p>array_replace(array, from, to)</p></td>
+<tr class="row-odd"><td><p>array_replace(array, from, to)</p></td>
<td><p>Replaces a specified element with another specified element.</p></td>
</tr>
-<tr class="row-odd"><td><p>array_to_string(array, delimeter)</p></td>
+<tr class="row-even"><td><p>array_to_string(array, delimeter)</p></td>
<td><p>Converts each element to its text representation.</p></td>
</tr>
-<tr class="row-even"><td><p>cardinality(array)</p></td>
+<tr class="row-odd"><td><p>cardinality(array)</p></td>
<td><p>Returns the total number of elements in the array.</p></td>
</tr>
-<tr class="row-odd"><td><p>make_array(value1, [value2 [, …]])</p></td>
+<tr class="row-even"><td><p>make_array(value1, [value2 [, …]])</p></td>
<td><p>Returns an Arrow array using the specified input expressions.</p></td>
</tr>
-<tr class="row-even"><td><p>trim_array(array, n)</p></td>
+<tr class="row-odd"><td><p>trim_array(array, n)</p></td>
<td><p>Removes the last n elements from the array.</p></td>
</tr>
</tbody>
diff --git a/user-guide/sql/scalar_functions.html b/user-guide/sql/scalar_functions.html
index 9946e72043..13433f6b8c 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -1617,6 +1617,22 @@
</li>
</ul>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#array-contains">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ array_contains
+ </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="#id77">
+ Arguments
+ </a>
+ </li>
+ </ul>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#array-dims">
<code class="docutils literal notranslate">
@@ -1627,7 +1643,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id77">
+ <a class="reference internal nav-link" href="#id78">
Arguments
</a>
</li>
@@ -1643,7 +1659,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id78">
+ <a class="reference internal nav-link" href="#id79">
Arguments
</a>
</li>
@@ -1659,7 +1675,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id79">
+ <a class="reference internal nav-link" href="#id80">
Arguments
</a>
</li>
@@ -1675,7 +1691,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id80">
+ <a class="reference internal nav-link" href="#id81">
Arguments
</a>
</li>
@@ -1691,7 +1707,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id81">
+ <a class="reference internal nav-link" href="#id82">
Arguments
</a>
</li>
@@ -1707,7 +1723,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id82">
+ <a class="reference internal nav-link" href="#id83">
Arguments
</a>
</li>
@@ -1723,7 +1739,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id83">
+ <a class="reference internal nav-link" href="#id84">
Arguments
</a>
</li>
@@ -1739,7 +1755,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id84">
+ <a class="reference internal nav-link" href="#id85">
Arguments
</a>
</li>
@@ -1755,7 +1771,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id85">
+ <a class="reference internal nav-link" href="#id86">
Arguments
</a>
</li>
@@ -1771,7 +1787,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id86">
+ <a class="reference internal nav-link" href="#id87">
Arguments
</a>
</li>
@@ -1787,7 +1803,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id87">
+ <a class="reference internal nav-link" href="#id88">
Arguments
</a>
</li>
@@ -1803,7 +1819,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id88">
+ <a class="reference internal nav-link" href="#id89">
Arguments
</a>
</li>
@@ -1819,7 +1835,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id89">
+ <a class="reference internal nav-link" href="#id90">
Arguments
</a>
</li>
@@ -1842,7 +1858,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id90">
+ <a class="reference internal nav-link" href="#id91">
Arguments
</a>
</li>
@@ -1865,7 +1881,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id91">
+ <a class="reference internal nav-link" href="#id92">
Arguments
</a>
</li>
@@ -1881,7 +1897,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id92">
+ <a class="reference internal nav-link" href="#id93">
Arguments
</a>
</li>
@@ -1897,7 +1913,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id93">
+ <a class="reference internal nav-link" href="#id94">
Arguments
</a>
</li>
@@ -1913,7 +1929,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id94">
+ <a class="reference internal nav-link" href="#id95">
Arguments
</a>
</li>
@@ -1929,7 +1945,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id95">
+ <a class="reference internal nav-link" href="#id96">
Arguments
</a>
</li>
@@ -1945,7 +1961,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id96">
+ <a class="reference internal nav-link" href="#id97">
Arguments
</a>
</li>
@@ -1968,7 +1984,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id97">
+ <a class="reference internal nav-link" href="#id98">
Arguments
</a>
</li>
@@ -1984,7 +2000,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id98">
+ <a class="reference internal nav-link" href="#id99">
Arguments
</a>
</li>
@@ -3472,6 +3488,7 @@ Can be a constant, column, or function, and any combination of arithmetic operat
<ul class="simple">
<li><p><a class="reference internal" href="#array-append">array_append</a></p></li>
<li><p><a class="reference internal" href="#array-concat">array_concat</a></p></li>
+<li><p><a class="reference internal" href="#array-contains">array_contains</a></p></li>
<li><p><a class="reference internal" href="#array-dims">array_dims</a></p></li>
<li><p><a class="reference internal" href="#array-fill">array_fill</a></p></li>
<li><p><a class="reference internal" href="#array-length">array_length</a></p></li>
@@ -3516,14 +3533,30 @@ Can be a constant, column, or function, and any combination of array operators.<
</ul>
</section>
</section>
+<section id="array-contains">
+<h3><code class="docutils literal notranslate"><span class="pre">array_contains</span></code><a class="headerlink" href="#array-contains" title="Permalink to this heading">¶</a></h3>
+<p>Returns true, if each element of the second array appears in the first array, otherwise false.</p>
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_contains</span><span class="p">(</span><span class="n">first_array</span><span class="p">,</span> <span class="n">second_array</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id77">
+<h4>Arguments<a class="headerlink" href="#id77" title="Permalink to this heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>first_array</strong>: Array expression.
+Can be a constant, column, or function, and any combination of array operators.</p></li>
+<li><p><strong>second_array</strong>: Array expression.
+Can be a constant, column, or function, and any combination of array operators.</p></li>
+</ul>
+</section>
+</section>
<section id="array-dims">
<h3><code class="docutils literal notranslate"><span class="pre">array_dims</span></code><a class="headerlink" href="#array-dims" title="Permalink to this heading">¶</a></h3>
<p>Returns an array of the array’s dimensions.</p>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_dims</span><span class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id77">
-<h4>Arguments<a class="headerlink" href="#id77" title="Permalink to this heading">¶</a></h4>
+<section id="id78">
+<h4>Arguments<a class="headerlink" href="#id78" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array operators.</p></li>
@@ -3536,8 +3569,8 @@ Can be a constant, column, or function, and any combination of array operators.<
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_fill</span><span class="p">(</span><span class="n">element</span><span class="p">,</span> <span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id78">
-<h4>Arguments<a class="headerlink" href="#id78" title="Permalink to this heading">¶</a></h4>
+<section id="id79">
+<h4>Arguments<a class="headerlink" href="#id79" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array operators.</p></li>
@@ -3551,8 +3584,8 @@ Can be a constant, column, or function, and any combination of array operators.<
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_length</span><span class="p">(</span><span class="n">array</span><span class="p">,</span> <span class="n">dimension</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id79">
-<h4>Arguments<a class="headerlink" href="#id79" title="Permalink to this heading">¶</a></h4>
+<section id="id80">
+<h4>Arguments<a class="headerlink" href="#id80" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array operators.</p></li>
@@ -3566,8 +3599,8 @@ Can be a constant, column, or function, and any combination of array operators.<
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_ndims</span><span class="p">(</span><span class="n">array</span><span class="p">,</span> <span class="n">element</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id80">
-<h4>Arguments<a class="headerlink" href="#id80" title="Permalink to this heading">¶</a></h4>
+<section id="id81">
+<h4>Arguments<a class="headerlink" href="#id81" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array operators.</p></li>
@@ -3581,8 +3614,8 @@ Can be a constant, column, or function, and any combination of array operators.<
<span class="n">array_position</span><span class="p">(</span><span class="n">array</span><span class="p">,</span> <span class="n">element</span><span class="p">,</span> <span class="n">index</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id81">
-<h4>Arguments<a class="headerlink" href="#id81" title="Permalink to this heading">¶</a></h4>
+<section id="id82">
+<h4>Arguments<a class="headerlink" href="#id82" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array operators.</p></li>
@@ -3597,8 +3630,8 @@ Can be a constant, column, or function, and any combination of array operators.<
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_positions</span><span class="p">(</span><span class="n">array</span><span class="p">,</span> <span class="n">element</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id82">
-<h4>Arguments<a class="headerlink" href="#id82" title="Permalink to this heading">¶</a></h4>
+<section id="id83">
+<h4>Arguments<a class="headerlink" href="#id83" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array operators.</p></li>
@@ -3612,8 +3645,8 @@ Can be a constant, column, or function, and any combination of array operators.<
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_prepend</span><span class="p">(</span><span class="n">element</span><span class="p">,</span> <span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id83">
-<h4>Arguments<a class="headerlink" href="#id83" title="Permalink to this heading">¶</a></h4>
+<section id="id84">
+<h4>Arguments<a class="headerlink" href="#id84" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>element</strong>: Element to prepend to the array.</p></li>
<li><p><strong>array</strong>: Array expression.
@@ -3627,8 +3660,8 @@ Can be a constant, column, or function, and any combination of array operators.<
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_remove</span><span class="p">(</span><span class="n">array</span><span class="p">,</span> <span class="n">element</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id84">
-<h4>Arguments<a class="headerlink" href="#id84" title="Permalink to this heading">¶</a></h4>
+<section id="id85">
+<h4>Arguments<a class="headerlink" href="#id85" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array operators.</p></li>
@@ -3642,8 +3675,8 @@ Can be a constant, column, or function, and any combination of array operators.<
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_replace</span><span class="p">(</span><span class="n">array</span><span class="p">,</span> <span class="n">from</span><span class="p">,</span> <span class="n">to</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id85">
-<h4>Arguments<a class="headerlink" href="#id85" title="Permalink to this heading">¶</a></h4>
+<section id="id86">
+<h4>Arguments<a class="headerlink" href="#id86" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array operators.</p></li>
@@ -3658,8 +3691,8 @@ Can be a constant, column, or function, and any combination of array operators.<
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_to_string</span><span class="p">(</span><span class="n">array</span><span class="p">,</span> <span class="n">delimeter</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id86">
-<h4>Arguments<a class="headerlink" href="#id86" title="Permalink to this heading">¶</a></h4>
+<section id="id87">
+<h4>Arguments<a class="headerlink" href="#id87" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array operators.</p></li>
@@ -3673,8 +3706,8 @@ Can be a constant, column, or function, and any combination of array operators.<
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">cardinality</span><span class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id87">
-<h4>Arguments<a class="headerlink" href="#id87" title="Permalink to this heading">¶</a></h4>
+<section id="id88">
+<h4>Arguments<a class="headerlink" href="#id88" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array operators.</p></li>
@@ -3687,8 +3720,8 @@ Can be a constant, column, or function, and any combination of array operators.<
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">make_array</span><span class="p">(</span><span class="n">expression1</span><span class="p">[,</span> <span class="o">...</span><span class="p">,</span> <span class="n">expression_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id88">
-<h4>Arguments<a class="headerlink" href="#id88" title="Permalink to this heading">¶</a></h4>
+<section id="id89">
+<h4>Arguments<a class="headerlink" href="#id89" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression_n</strong>: Expression to include in the output array.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -3702,8 +3735,8 @@ string operators.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">trim_array</span><span class="p">(</span><span class="n">array</span><span class="p">,</span> <span class="n">n</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id89">
-<h4>Arguments<a class="headerlink" href="#id89" title="Permalink to this heading">¶</a></h4>
+<section id="id90">
+<h4>Arguments<a class="headerlink" href="#id90" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array operators.</p></li>
@@ -3744,8 +3777,8 @@ a struct type of fields <code class="docutils literal notranslate"><span class="
+-----------------+
</pre></div>
</div>
-<section id="id90">
-<h4>Arguments<a class="headerlink" href="#id90" title="Permalink to this heading">¶</a></h4>
+<section id="id91">
+<h4>Arguments<a class="headerlink" href="#id91" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression_n</strong>: Expression to include in the output struct.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -3770,8 +3803,8 @@ string operators.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">digest</span><span class="p">(</span><span class="n">expression</span><span class="p">,</span> <span class="n">algorithm</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id91">
-<h4>Arguments<a class="headerlink" href="#id91" title="Permalink to this heading">¶</a></h4>
+<section id="id92">
+<h4>Arguments<a class="headerlink" href="#id92" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string operators.</p></li>
@@ -3797,8 +3830,8 @@ Must be one of:</p>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">md5</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id92">
-<h4>Arguments<a class="headerlink" href="#id92" title="Permalink to this heading">¶</a></h4>
+<section id="id93">
+<h4>Arguments<a class="headerlink" href="#id93" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string operators.</p></li>
@@ -3811,8 +3844,8 @@ Can be a constant, column, or function, and any combination of string operators.
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">sha224</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id93">
-<h4>Arguments<a class="headerlink" href="#id93" title="Permalink to this heading">¶</a></h4>
+<section id="id94">
+<h4>Arguments<a class="headerlink" href="#id94" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string operators.</p></li>
@@ -3825,8 +3858,8 @@ Can be a constant, column, or function, and any combination of string operators.
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">sha256</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id94">
-<h4>Arguments<a class="headerlink" href="#id94" title="Permalink to this heading">¶</a></h4>
+<section id="id95">
+<h4>Arguments<a class="headerlink" href="#id95" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string operators.</p></li>
@@ -3839,8 +3872,8 @@ Can be a constant, column, or function, and any combination of string operators.
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">sha384</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id95">
-<h4>Arguments<a class="headerlink" href="#id95" title="Permalink to this heading">¶</a></h4>
+<section id="id96">
+<h4>Arguments<a class="headerlink" href="#id96" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string operators.</p></li>
@@ -3853,8 +3886,8 @@ Can be a constant, column, or function, and any combination of string operators.
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">sha512</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id96">
-<h4>Arguments<a class="headerlink" href="#id96" title="Permalink to this heading">¶</a></h4>
+<section id="id97">
+<h4>Arguments<a class="headerlink" href="#id97" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string operators.</p></li>
@@ -3874,8 +3907,8 @@ Can be a constant, column, or function, and any combination of string operators.
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">arrow_cast</span><span class="p">(</span><span class="n">expression</span><span class="p">,</span> <span class="n">datatype</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id97">
-<h4>Arguments<a class="headerlink" href="#id97" title="Permalink to this heading">¶</a></h4>
+<section id="id98">
+<h4>Arguments<a class="headerlink" href="#id98" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to cast.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -3891,8 +3924,8 @@ to cast to.</p></li>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">arrow_typeof</span><span class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id98">
-<h4>Arguments<a class="headerlink" href="#id98" title="Permalink to this heading">¶</a></h4>
+<section id="id99">
+<h4>Arguments<a class="headerlink" href="#id99" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to evaluate.
Can be a constant, column, or function, and any combination of arithmetic or