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] <github-actions[bot]@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