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/07/22 16:17:56 UTC
[arrow-datafusion] branch asf-site updated: Publish built docs triggered by 49c91b563ad894b2f368690d85402895bdeaa73a
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 37b2671d26 Publish built docs triggered by 49c91b563ad894b2f368690d85402895bdeaa73a
37b2671d26 is described below
commit 37b2671d26e6334e3c52ee2fd6aac9eaa374196a
Author: github-actions[bot] <gi...@users.noreply.github.com>
AuthorDate: Sat Jul 22 16:17:50 2023 +0000
Publish built docs triggered by 49c91b563ad894b2f368690d85402895bdeaa73a
---
_sources/user-guide/expressions.md.txt | 38 +--
_sources/user-guide/sql/scalar_functions.md.txt | 40 ++-
searchindex.js | 2 +-
user-guide/expressions.html | 10 +-
user-guide/sql/scalar_functions.html | 316 ++++++++++++++----------
5 files changed, 254 insertions(+), 152 deletions(-)
diff --git a/_sources/user-guide/expressions.md.txt b/_sources/user-guide/expressions.md.txt
index cf1e2f58af..14cf8dc2ac 100644
--- a/_sources/user-guide/expressions.md.txt
+++ b/_sources/user-guide/expressions.md.txt
@@ -179,24 +179,26 @@ 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_append([1, 2, 3], 4) -> [1, 2, 3, 4]` |
-| array_concat(array[, ..., array_n]) | Concatenates arrays. `array_concat([1, 2, 3], [4, 5, 6]) -> [1, 2, 3, 4, 5, 6]` |
-| 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_dims([[1, 2, 3], [4, 5, 6]]) -> [2, 3]` |
-| 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_length([1, 2, 3, 4, 5]) -> 5` |
-| array_ndims(array) | Returns the number of dimensions of the array. `array_ndims([[1, 2, 3], [4, 5, 6]]) -> 2` |
-| array_position(array, element) | Searches for an element in the array, returns first occurrence. `array_position([1, 2, 2, 3, 4], 2) -> 2` |
-| array_positions(array, element) | Searches for an element in the array, returns all occurrences. `array_positions([1, 2, 2, 3, 4], 2) -> [2, 3]` |
-| array_prepend(array, element) | Prepends an element to the beginning of an array. `array_prepend(1, [2, 3, 4]) -> [1, 2, 3, 4]` |
-| 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. `array_to_string([1, 2, 3, 4], ',') -> 1,2,3,4` |
-| cardinality(array) | Returns the total number of elements in the array. `cardinality([[1, 2, 3], [4, 5, 6]]) -> 6` |
-| make_array(value1, [value2 [, ...]]) | Returns an Arrow array using the specified input expressions. `make_array(1, 2, 3) -> [1, 2, 3]` |
-| 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_append([1, 2, 3], 4) -> [1, 2, 3, 4]` |
+| array_concat(array[, ..., array_n]) | Concatenates arrays. `array_concat([1, 2, 3], [4, 5, 6]) -> [1, 2, 3, 4, 5, 6]` |
+| array_has(array, element) | Returns true if the array contains the element `array_has([1,2,3], 1) -> true` |
+| array_has_all(array, sub-array) | Returns true if all elements of sub-array exist in array `array_has_all([1,2,3], [1,3]) -> true` |
+| array_has_any(array, sub-array) | Returns true if any elements exist in both arrays `array_has_any([1,2,3], [1,4]) -> true` |
+| array_dims(array) | Returns an array of the array's dimensions. `array_dims([[1, 2, 3], [4, 5, 6]]) -> [2, 3]` |
+| 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_length([1, 2, 3, 4, 5]) -> 5` |
+| array_ndims(array) | Returns the number of dimensions of the array. `array_ndims([[1, 2, 3], [4, 5, 6]]) -> 2` |
+| array_position(array, element) | Searches for an element in the array, returns first occurrence. `array_position([1, 2, 2, 3, 4], 2) -> 2` |
+| array_positions(array, element) | Searches for an element in the array, returns all occurrences. `array_positions([1, 2, 2, 3, 4], 2) -> [2, 3]` |
+| array_prepend(array, element) | Prepends an element to the beginning of an array. `array_prepend(1, [2, 3, 4]) -> [1, 2, 3, 4]` |
+| 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. `array_to_string([1, 2, 3, 4], ',') -> 1,2,3,4` |
+| cardinality(array) | Returns the total number of elements in the array. `cardinality([[1, 2, 3], [4, 5, 6]]) -> 6` |
+| make_array(value1, [value2 [, ...]]) | Returns an Arrow array using the specified input expressions. `make_array(1, 2, 3) -> [1, 2, 3]` |
+| 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 31b075821b..bcdd383252 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -1522,19 +1522,49 @@ array_concat(array[, ..., array_n])
- list_cat
- list_concat
-### `array_contains`
+### `array_has`
-Returns true, if each element of the second array appears in the first array, otherwise false.
+Returns true if the array contains the element
```
-array_contains(first_array, second_array)
+array_has(array, element)
```
#### Arguments
-- **first_array**: Array expression.
+- **array**: Array expression.
+ Can be a constant, column, or function, and any combination of array operators.
+- **element**: Scalar or Array expression.
+ Can be a constant, column, or function, and any combination of array operators.
+
+### `array_has_all`
+
+Returns true if all elements of sub-array exist in array
+
+```
+array_has_all(array, sub-array)
+```
+
+#### Arguments
+
+- **array**: Array expression.
+ Can be a constant, column, or function, and any combination of array operators.
+- **sub-array**: Array expression.
+ Can be a constant, column, or function, and any combination of array operators.
+
+### `array_has_any`
+
+Returns true if any elements exist in both arrays
+
+```
+array_has_any(array, sub-array)
+```
+
+#### Arguments
+
+- **array**: Array expression.
Can be a constant, column, or function, and any combination of array operators.
-- **second_array**: Array expression.
+- **sub-array**: Array expression.
Can be a constant, column, or function, and any combination of array operators.
### `array_dims`
diff --git a/searchindex.js b/searchindex.js
index c0c43cd0eb..a4f9f40221 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 639928d8f2..0aba24c808 100644
--- a/user-guide/expressions.html
+++ b/user-guide/expressions.html
@@ -818,8 +818,14 @@ 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. <code class="docutils literal notranslate"><span class="pre">array_concat([1,</span> <span class="pre">2,</span> <span class="pre">3],</span> <span class="pre">[4,</span> <span class="pre">5,</span> <span class="pre">6])</span> <span class="pre">-></span> <span class="pre">[1,</span> <span class="pre">2,</span> <span class="pre">3,</span> <span class="pre">4,</span> <span class="pre">5,</span> <span class="pre">6]</span></code></p></td>
</tr>
-<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 class="row-even"><td><p>array_has(array, element)</p></td>
+<td><p>Returns true if the array contains the element <code class="docutils literal notranslate"><span class="pre">array_has([1,2,3],</span> <span class="pre">1)</span> <span class="pre">-></span> <span class="pre">true</span></code></p></td>
+</tr>
+<tr class="row-odd"><td><p>array_has_all(array, sub-array)</p></td>
+<td><p>Returns true if all elements of sub-array exist in array <code class="docutils literal notranslate"><span class="pre">array_has_all([1,2,3],</span> <span class="pre">[1,3])</span> <span class="pre">-></span> <span class="pre">true</span></code></p></td>
+</tr>
+<tr class="row-even"><td><p>array_has_any(array, sub-array)</p></td>
+<td><p>Returns true if any elements exist in both arrays <code class="docutils literal notranslate"><span class="pre">array_has_any([1,2,3],</span> <span class="pre">[1,4])</span> <span class="pre">-></span> <span class="pre">true</span></code></p></td>
</tr>
<tr class="row-odd"><td><p>array_dims(array)</p></td>
<td><p>Returns an array of the array’s dimensions. <code class="docutils literal notranslate"><span class="pre">array_dims([[1,</span> <span class="pre">2,</span> <span class="pre">3],</span> <span class="pre">[4,</span> <span class="pre">5,</span> <span class="pre">6]])</span> <span class="pre">-></span> <span class="pre">[2,</span> <span class="pre">3]</span></code></p></td>
diff --git a/user-guide/sql/scalar_functions.html b/user-guide/sql/scalar_functions.html
index 1912c3f395..5e44099c94 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -1686,10 +1686,10 @@
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#array-contains">
+ <a class="reference internal nav-link" href="#array-has">
<code class="docutils literal notranslate">
<span class="pre">
- array_contains
+ array_has
</span>
</code>
</a>
@@ -1702,10 +1702,10 @@
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#array-dims">
+ <a class="reference internal nav-link" href="#array-has-all">
<code class="docutils literal notranslate">
<span class="pre">
- array_dims
+ array_has_all
</span>
</code>
</a>
@@ -1715,13 +1715,45 @@
Arguments
</a>
</li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#array-has-any">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ array_has_any
+ </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="#id84">
- Example
+ 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">
+ <span class="pre">
+ array_dims
+ </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="#id85">
+ Arguments
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id86">
+ Example
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id87">
Aliases
</a>
</li>
@@ -1737,7 +1769,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="#id88">
Arguments
</a>
</li>
@@ -1771,17 +1803,17 @@
</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="#id89">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id88">
+ <a class="reference internal nav-link" href="#id90">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id89">
+ <a class="reference internal nav-link" href="#id91">
Aliases
</a>
</li>
@@ -1797,17 +1829,17 @@
</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="#id92">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id91">
+ <a class="reference internal nav-link" href="#id93">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id92">
+ <a class="reference internal nav-link" href="#id94">
Aliases
</a>
</li>
@@ -1823,17 +1855,17 @@
</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="#id95">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id94">
+ <a class="reference internal nav-link" href="#id96">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id95">
+ <a class="reference internal nav-link" href="#id97">
Aliases
</a>
</li>
@@ -1849,17 +1881,17 @@
</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="#id98">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id97">
+ <a class="reference internal nav-link" href="#id99">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id98">
+ <a class="reference internal nav-link" href="#id100">
Aliases
</a>
</li>
@@ -1875,17 +1907,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id99">
+ <a class="reference internal nav-link" href="#id101">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id100">
+ <a class="reference internal nav-link" href="#id102">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id101">
+ <a class="reference internal nav-link" href="#id103">
Aliases
</a>
</li>
@@ -1919,7 +1951,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id102">
+ <a class="reference internal nav-link" href="#id104">
Arguments
</a>
</li>
@@ -1935,7 +1967,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id103">
+ <a class="reference internal nav-link" href="#id105">
Arguments
</a>
</li>
@@ -1951,17 +1983,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id104">
+ <a class="reference internal nav-link" href="#id106">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id105">
+ <a class="reference internal nav-link" href="#id107">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id106">
+ <a class="reference internal nav-link" href="#id108">
Aliases
</a>
</li>
@@ -1977,12 +2009,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id107">
+ <a class="reference internal nav-link" href="#id109">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id108">
+ <a class="reference internal nav-link" href="#id110">
Example
</a>
</li>
@@ -2124,17 +2156,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id109">
+ <a class="reference internal nav-link" href="#id111">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id110">
+ <a class="reference internal nav-link" href="#id112">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id111">
+ <a class="reference internal nav-link" href="#id113">
Aliases
</a>
</li>
@@ -2159,7 +2191,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id112">
+ <a class="reference internal nav-link" href="#id114">
Arguments
</a>
</li>
@@ -2182,7 +2214,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id113">
+ <a class="reference internal nav-link" href="#id115">
Arguments
</a>
</li>
@@ -2205,7 +2237,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id114">
+ <a class="reference internal nav-link" href="#id116">
Arguments
</a>
</li>
@@ -2221,7 +2253,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id115">
+ <a class="reference internal nav-link" href="#id117">
Arguments
</a>
</li>
@@ -2237,7 +2269,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id116">
+ <a class="reference internal nav-link" href="#id118">
Arguments
</a>
</li>
@@ -2253,7 +2285,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id117">
+ <a class="reference internal nav-link" href="#id119">
Arguments
</a>
</li>
@@ -2269,7 +2301,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id118">
+ <a class="reference internal nav-link" href="#id120">
Arguments
</a>
</li>
@@ -2285,7 +2317,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id119">
+ <a class="reference internal nav-link" href="#id121">
Arguments
</a>
</li>
@@ -2308,7 +2340,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id120">
+ <a class="reference internal nav-link" href="#id122">
Arguments
</a>
</li>
@@ -2324,7 +2356,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id121">
+ <a class="reference internal nav-link" href="#id123">
Arguments
</a>
</li>
@@ -3852,7 +3884,7 @@ Can be a constant, column, or function, and any combination of arithmetic operat
<li><p><a class="reference internal" href="#array-append">array_append</a></p></li>
<li><p><a class="reference internal" href="#array-cat">array_cat</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_contains"><span class="xref myst">array_contains</span></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-indexof">array_indexof</a></p></li>
@@ -3958,18 +3990,50 @@ 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>
+<section id="array-has">
+<h3><code class="docutils literal notranslate"><span class="pre">array_has</span></code><a class="headerlink" href="#array-has" title="Permalink to this heading">¶</a></h3>
+<p>Returns true if the array contains the element</p>
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_has</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>
<ul class="simple">
-<li><p><strong>first_array</strong>: Array expression.
+<li><p><strong>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.
+<li><p><strong>element</strong>: Scalar or Array expression.
+Can be a constant, column, or function, and any combination of array operators.</p></li>
+</ul>
+</section>
+</section>
+<section id="array-has-all">
+<h3><code class="docutils literal notranslate"><span class="pre">array_has_all</span></code><a class="headerlink" href="#array-has-all" title="Permalink to this heading">¶</a></h3>
+<p>Returns true if all elements of sub-array exist in array</p>
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_has_all</span><span class="p">(</span><span class="n">array</span><span class="p">,</span> <span class="n">sub</span><span class="o">-</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>
+<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>
+<li><p><strong>sub-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-has-any">
+<h3><code class="docutils literal notranslate"><span class="pre">array_has_any</span></code><a class="headerlink" href="#array-has-any" title="Permalink to this heading">¶</a></h3>
+<p>Returns true if any elements exist in both arrays</p>
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_has_any</span><span class="p">(</span><span class="n">array</span><span class="p">,</span> <span class="n">sub</span><span class="o">-</span><span class="n">array</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>
+<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>
+<li><p><strong>sub-array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
@@ -3980,15 +4044,15 @@ 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_dims</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="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>
</ul>
</section>
-<section id="id84">
-<h4>Example<a class="headerlink" href="#id84" title="Permalink to this heading">¶</a></h4>
+<section id="id86">
+<h4>Example<a class="headerlink" href="#id86" title="Permalink to this heading">¶</a></h4>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>❯ select array_dims([[1, 2, 3], [4, 5, 6]]);
+---------------------------------+
| array_dims(List([1,2,3,4,5,6])) |
@@ -3998,8 +4062,8 @@ Can be a constant, column, or function, and any combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id85">
-<h4>Aliases<a class="headerlink" href="#id85" title="Permalink to this heading">¶</a></h4>
+<section id="id87">
+<h4>Aliases<a class="headerlink" href="#id87" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_dims</p></li>
</ul>
@@ -4011,8 +4075,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="id86">
-<h4>Arguments<a class="headerlink" href="#id86" 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>
@@ -4034,16 +4098,16 @@ 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="id87">
-<h4>Arguments<a class="headerlink" href="#id87" 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>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array operators.</p></li>
<li><p><strong>dimension</strong>: Array dimension.</p></li>
</ul>
</section>
-<section id="id88">
-<h4>Example<a class="headerlink" href="#id88" title="Permalink to this heading">¶</a></h4>
+<section id="id90">
+<h4>Example<a class="headerlink" href="#id90" title="Permalink to this heading">¶</a></h4>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>❯ select array_length([1, 2, 3, 4, 5]);
+---------------------------------+
| array_length(List([1,2,3,4,5])) |
@@ -4053,8 +4117,8 @@ Can be a constant, column, or function, and any combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id89">
-<h4>Aliases<a class="headerlink" href="#id89" title="Permalink to this heading">¶</a></h4>
+<section id="id91">
+<h4>Aliases<a class="headerlink" href="#id91" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_length</p></li>
</ul>
@@ -4066,15 +4130,15 @@ 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="id90">
-<h4>Arguments<a class="headerlink" href="#id90" 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>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id91">
-<h4>Example<a class="headerlink" href="#id91" title="Permalink to this heading">¶</a></h4>
+<section id="id93">
+<h4>Example<a class="headerlink" href="#id93" title="Permalink to this heading">¶</a></h4>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>❯ select array_ndims([[1, 2, 3], [4, 5, 6]]);
+----------------------------------+
| array_ndims(List([1,2,3,4,5,6])) |
@@ -4084,8 +4148,8 @@ Can be a constant, column, or function, and any combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id92">
-<h4>Aliases<a class="headerlink" href="#id92" title="Permalink to this heading">¶</a></h4>
+<section id="id94">
+<h4>Aliases<a class="headerlink" href="#id94" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_ndims</p></li>
</ul>
@@ -4097,16 +4161,16 @@ 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="id93">
-<h4>Arguments<a class="headerlink" href="#id93" 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>element</strong>: Element to prepend to the array.</p></li>
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id94">
-<h4>Example<a class="headerlink" href="#id94" title="Permalink to this heading">¶</a></h4>
+<section id="id96">
+<h4>Example<a class="headerlink" href="#id96" title="Permalink to this heading">¶</a></h4>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>❯ select array_prepend(1, [2, 3, 4]);
+---------------------------------------+
| array_prepend(Int64(1),List([2,3,4])) |
@@ -4116,8 +4180,8 @@ Can be a constant, column, or function, and any combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id95">
-<h4>Aliases<a class="headerlink" href="#id95" title="Permalink to this heading">¶</a></h4>
+<section id="id97">
+<h4>Aliases<a class="headerlink" href="#id97" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p>array_push_front</p></li>
<li><p>list_prepend</p></li>
@@ -4132,8 +4196,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="id96">
-<h4>Arguments<a class="headerlink" href="#id96" 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>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array operators.</p></li>
@@ -4141,8 +4205,8 @@ Can be a constant, column, or function, and any combination of array operators.<
<li><p><strong>index</strong>: Index at which to start searching.</p></li>
</ul>
</section>
-<section id="id97">
-<h4>Example<a class="headerlink" href="#id97" title="Permalink to this heading">¶</a></h4>
+<section id="id99">
+<h4>Example<a class="headerlink" href="#id99" title="Permalink to this heading">¶</a></h4>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>❯ select array_position([1, 2, 2, 3, 1, 4], 2);
+----------------------------------------------+
| array_position(List([1,2,2,3,1,4]),Int64(2)) |
@@ -4152,8 +4216,8 @@ Can be a constant, column, or function, and any combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id98">
-<h4>Aliases<a class="headerlink" href="#id98" title="Permalink to this heading">¶</a></h4>
+<section id="id100">
+<h4>Aliases<a class="headerlink" href="#id100" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p>array_indexof</p></li>
<li><p>list_indexof</p></li>
@@ -4167,16 +4231,16 @@ 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="id99">
-<h4>Arguments<a class="headerlink" href="#id99" title="Permalink to this heading">¶</a></h4>
+<section id="id101">
+<h4>Arguments<a class="headerlink" href="#id101" 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>
<li><p><strong>element</strong>: Element to search for positions in the array.</p></li>
</ul>
</section>
-<section id="id100">
-<h4>Example<a class="headerlink" href="#id100" title="Permalink to this heading">¶</a></h4>
+<section id="id102">
+<h4>Example<a class="headerlink" href="#id102" title="Permalink to this heading">¶</a></h4>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>❯ select array_positions([1, 2, 2, 3, 1, 4], 2);
+-----------------------------------------------+
| array_positions(List([1,2,2,3,1,4]),Int64(2)) |
@@ -4186,8 +4250,8 @@ Can be a constant, column, or function, and any combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id101">
-<h4>Aliases<a class="headerlink" href="#id101" title="Permalink to this heading">¶</a></h4>
+<section id="id103">
+<h4>Aliases<a class="headerlink" href="#id103" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_positions</p></li>
</ul>
@@ -4207,8 +4271,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="id102">
-<h4>Arguments<a class="headerlink" href="#id102" title="Permalink to this heading">¶</a></h4>
+<section id="id104">
+<h4>Arguments<a class="headerlink" href="#id104" 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>
@@ -4222,8 +4286,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="id103">
-<h4>Arguments<a class="headerlink" href="#id103" title="Permalink to this heading">¶</a></h4>
+<section id="id105">
+<h4>Arguments<a class="headerlink" href="#id105" 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>
@@ -4238,16 +4302,16 @@ 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="id104">
-<h4>Arguments<a class="headerlink" href="#id104" title="Permalink to this heading">¶</a></h4>
+<section id="id106">
+<h4>Arguments<a class="headerlink" href="#id106" 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>
<li><p><strong>delimeter</strong>: Array element separator.</p></li>
</ul>
</section>
-<section id="id105">
-<h4>Example<a class="headerlink" href="#id105" title="Permalink to this heading">¶</a></h4>
+<section id="id107">
+<h4>Example<a class="headerlink" href="#id107" title="Permalink to this heading">¶</a></h4>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>❯ select array_to_string([[1, 2, 3, 4], [5, 6, 7, 8]], ',');
+----------------------------------------------------+
| array_to_string(List([1,2,3,4,5,6,7,8]),Utf8(",")) |
@@ -4257,8 +4321,8 @@ Can be a constant, column, or function, and any combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id106">
-<h4>Aliases<a class="headerlink" href="#id106" title="Permalink to this heading">¶</a></h4>
+<section id="id108">
+<h4>Aliases<a class="headerlink" href="#id108" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p>array_join</p></li>
<li><p>list_join</p></li>
@@ -4272,15 +4336,15 @@ 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="id107">
-<h4>Arguments<a class="headerlink" href="#id107" title="Permalink to this heading">¶</a></h4>
+<section id="id109">
+<h4>Arguments<a class="headerlink" href="#id109" 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>
</ul>
</section>
-<section id="id108">
-<h4>Example<a class="headerlink" href="#id108" title="Permalink to this heading">¶</a></h4>
+<section id="id110">
+<h4>Example<a class="headerlink" href="#id110" title="Permalink to this heading">¶</a></h4>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>❯ select cardinality([[1, 2, 3, 4], [5, 6, 7, 8]]);
+--------------------------------------+
| cardinality(List([1,2,3,4,5,6,7,8])) |
@@ -4353,16 +4417,16 @@ 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="id109">
-<h4>Arguments<a class="headerlink" href="#id109" title="Permalink to this heading">¶</a></h4>
+<section id="id111">
+<h4>Arguments<a class="headerlink" href="#id111" 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
string operators.</p></li>
</ul>
</section>
-<section id="id110">
-<h4>Example<a class="headerlink" href="#id110" title="Permalink to this heading">¶</a></h4>
+<section id="id112">
+<h4>Example<a class="headerlink" href="#id112" title="Permalink to this heading">¶</a></h4>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>❯ select make_array(1, 2, 3, 4, 5);
+----------------------------------------------------------+
| make_array(Int64(1),Int64(2),Int64(3),Int64(4),Int64(5)) |
@@ -4372,8 +4436,8 @@ string operators.</p></li>
</pre></div>
</div>
</section>
-<section id="id111">
-<h4>Aliases<a class="headerlink" href="#id111" title="Permalink to this heading">¶</a></h4>
+<section id="id113">
+<h4>Aliases<a class="headerlink" href="#id113" title="Permalink to this heading">¶</a></h4>
<ul class="simple">
<li><p>make_list</p></li>
</ul>
@@ -4389,8 +4453,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="id112">
-<h4>Arguments<a class="headerlink" href="#id112" title="Permalink to this heading">¶</a></h4>
+<section id="id114">
+<h4>Arguments<a class="headerlink" href="#id114" 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>
@@ -4431,8 +4495,8 @@ a struct type of fields <code class="docutils literal notranslate"><span class="
+-----------------+
</pre></div>
</div>
-<section id="id113">
-<h4>Arguments<a class="headerlink" href="#id113" title="Permalink to this heading">¶</a></h4>
+<section id="id115">
+<h4>Arguments<a class="headerlink" href="#id115" 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
@@ -4457,8 +4521,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="id114">
-<h4>Arguments<a class="headerlink" href="#id114" title="Permalink to this heading">¶</a></h4>
+<section id="id116">
+<h4>Arguments<a class="headerlink" href="#id116" 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>
@@ -4484,8 +4548,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="id115">
-<h4>Arguments<a class="headerlink" href="#id115" title="Permalink to this heading">¶</a></h4>
+<section id="id117">
+<h4>Arguments<a class="headerlink" href="#id117" 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>
@@ -4498,8 +4562,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="id116">
-<h4>Arguments<a class="headerlink" href="#id116" title="Permalink to this heading">¶</a></h4>
+<section id="id118">
+<h4>Arguments<a class="headerlink" href="#id118" 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>
@@ -4512,8 +4576,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="id117">
-<h4>Arguments<a class="headerlink" href="#id117" title="Permalink to this heading">¶</a></h4>
+<section id="id119">
+<h4>Arguments<a class="headerlink" href="#id119" 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>
@@ -4526,8 +4590,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="id118">
-<h4>Arguments<a class="headerlink" href="#id118" title="Permalink to this heading">¶</a></h4>
+<section id="id120">
+<h4>Arguments<a class="headerlink" href="#id120" 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>
@@ -4540,8 +4604,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="id119">
-<h4>Arguments<a class="headerlink" href="#id119" title="Permalink to this heading">¶</a></h4>
+<section id="id121">
+<h4>Arguments<a class="headerlink" href="#id121" 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>
@@ -4561,8 +4625,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="id120">
-<h4>Arguments<a class="headerlink" href="#id120" title="Permalink to this heading">¶</a></h4>
+<section id="id122">
+<h4>Arguments<a class="headerlink" href="#id122" 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
@@ -4578,8 +4642,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="id121">
-<h4>Arguments<a class="headerlink" href="#id121" title="Permalink to this heading">¶</a></h4>
+<section id="id123">
+<h4>Arguments<a class="headerlink" href="#id123" 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