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 00b394f746 Publish built docs triggered by
5907c21f20448fe75b101ebd6a5d9746383386e1
00b394f746 is described below
commit 00b394f746ee503e3ce0e8656211cb77dafe5a8d
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Thu Jul 20 19:17:19 2023 +0000
Publish built docs triggered by 5907c21f20448fe75b101ebd6a5d9746383386e1
---
_sources/user-guide/expressions.md.txt | 36 +-
_sources/user-guide/sql/scalar_functions.md.txt | 289 ++++++++-
searchindex.js | 2 +-
user-guide/expressions.html | 22 +-
user-guide/sql/scalar_functions.html | 750 +++++++++++++++++++++---
5 files changed, 973 insertions(+), 126 deletions(-)
diff --git a/_sources/user-guide/expressions.md.txt
b/_sources/user-guide/expressions.md.txt
index b5d4cfa0ac..cf1e2f58af 100644
--- a/_sources/user-guide/expressions.md.txt
+++ b/_sources/user-guide/expressions.md.txt
@@ -179,24 +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_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. |
+| 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. |
## Regular Expressions
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index 58d0dd253e..31b075821b 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -1420,20 +1420,40 @@ from_unixtime(expression)
## Array Functions
- [array_append](#array_append)
+- [array_cat](#array_cat)
- [array_concat](#array_concat)
- [array_contains](#array_contains)
- [array_dims](#array_dims)
- [array_fill](#array_fill)
+- [array_indexof](#array_indexof)
+- [array_join](#array_join)
- [array_length](#array_length)
- [array_ndims](#array_ndims)
+- [array_prepend](#array_prepend)
- [array_position](#array_position)
- [array_positions](#array_positions)
-- [array_prepend](#array_prepend)
+- [array_push_back](#array_push_back)
+- [array_push_front](#array_push_front)
- [array_remove](#array_remove)
- [array_replace](#array_replace)
- [array_to_string](#array_to_string)
- [cardinality](#cardinality)
+- [list_append](#list_append)
+- [list_cat](#list_cat)
+- [list_concat](#list_concat)
+- [list_dims](#list_dims)
+- [list_indexof](#list_indexof)
+- [list_join](#list_join)
+- [list_length](#list_length)
+- [list_ndims](#list_ndims)
+- [list_prepend](#list_prepend)
+- [list_position](#list_position)
+- [list_positions](#list_positions)
+- [list_push_back](#list_push_back)
+- [list_push_front](#list_push_front)
+- [list_to_string](#list_to_string)
- [make_array](#make_array)
+- [make_list](#make_list)
- [trim_array](#trim_array)
### `array_append`
@@ -1450,6 +1470,27 @@ array_append(array, element)
Can be a constant, column, or function, and any combination of array
operators.
- **element**: Element to append to the array.
+#### Example
+
+```
+❯ select array_append([1, 2, 3], 4);
++--------------------------------------+
+| array_append(List([1,2,3]),Int64(4)) |
++--------------------------------------+
+| [1, 2, 3, 4] |
++--------------------------------------+
+```
+
+#### Aliases
+
+- array_push_back
+- list_append
+- list_push_back
+
+### `array_cat`
+
+_Alias of [array_concat](#array_concat)._
+
### `array_concat`
Concatenates arrays.
@@ -1464,6 +1505,23 @@ 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.
+#### Example
+
+```
+❯ select array_concat([1, 2], [3, 4], [5, 6]);
++---------------------------------------------------+
+| array_concat(List([1,2]),List([3,4]),List([5,6])) |
++---------------------------------------------------+
+| [1, 2, 3, 4, 5, 6] |
++---------------------------------------------------+
+```
+
+#### Aliases
+
+- array_cat
+- list_cat
+- list_concat
+
### `array_contains`
Returns true, if each element of the second array appears in the first array,
otherwise false.
@@ -1492,6 +1550,21 @@ array_dims(array)
- **array**: Array expression.
Can be a constant, column, or function, and any combination of array
operators.
+#### Example
+
+```
+❯ select array_dims([[1, 2, 3], [4, 5, 6]]);
++---------------------------------+
+| array_dims(List([1,2,3,4,5,6])) |
++---------------------------------+
+| [2, 3] |
++---------------------------------+
+```
+
+#### Aliases
+
+- list_dims
+
### `array_fill`
Returns an array filled with copies of the given value.
@@ -1506,6 +1579,14 @@ array_fill(element, array)
Can be a constant, column, or function, and any combination of array
operators.
- **element**: Element to copy to the array.
+### `array_indexof`
+
+_Alias of [array_position](#array_position)._
+
+### `array_join`
+
+_Alias of [array_to_string](#array_to_string)._
+
### `array_length`
Returns the length of the array dimension.
@@ -1520,6 +1601,21 @@ array_length(array, dimension)
Can be a constant, column, or function, and any combination of array
operators.
- **dimension**: Array dimension.
+#### Example
+
+```
+❯ select array_length([1, 2, 3, 4, 5]);
++---------------------------------+
+| array_length(List([1,2,3,4,5])) |
++---------------------------------+
+| 5 |
++---------------------------------+
+```
+
+#### Aliases
+
+- list_length
+
### `array_ndims`
Returns the number of dimensions of the array.
@@ -1533,6 +1629,52 @@ array_ndims(array, element)
- **array**: Array expression.
Can be a constant, column, or function, and any combination of array
operators.
+#### Example
+
+```
+❯ select array_ndims([[1, 2, 3], [4, 5, 6]]);
++----------------------------------+
+| array_ndims(List([1,2,3,4,5,6])) |
++----------------------------------+
+| 2 |
++----------------------------------+
+```
+
+#### Aliases
+
+- list_ndims
+
+### `array_prepend`
+
+Prepends an element to the beginning of an array.
+
+```
+array_prepend(element, array)
+```
+
+#### Arguments
+
+- **element**: Element to prepend to the array.
+- **array**: Array expression.
+ Can be a constant, column, or function, and any combination of array
operators.
+
+#### Example
+
+```
+❯ select array_prepend(1, [2, 3, 4]);
++---------------------------------------+
+| array_prepend(Int64(1),List([2,3,4])) |
++---------------------------------------+
+| [1, 2, 3, 4] |
++---------------------------------------+
+```
+
+#### Aliases
+
+- array_push_front
+- list_prepend
+- list_push_front
+
### `array_position`
Returns a string with an input string repeated a specified number.
@@ -1549,6 +1691,23 @@ array_position(array, element, index)
- **element**: Element to search for position in the array.
- **index**: Index at which to start searching.
+#### Example
+
+```
+❯ select array_position([1, 2, 2, 3, 1, 4], 2);
++----------------------------------------------+
+| array_position(List([1,2,2,3,1,4]),Int64(2)) |
++----------------------------------------------+
+| 2 |
++----------------------------------------------+
+```
+
+#### Aliases
+
+- array_indexof
+- list_indexof
+- list_position
+
### `array_positions`
Searches for an element in the array, returns all occurrences.
@@ -1563,19 +1722,28 @@ array_positions(array, element)
Can be a constant, column, or function, and any combination of array
operators.
- **element**: Element to search for positions in the array.
-### `array_prepend`
-
-Prepends an element to the beginning of an array.
+#### Example
```
-array_prepend(element, array)
+❯ select array_positions([1, 2, 2, 3, 1, 4], 2);
++-----------------------------------------------+
+| array_positions(List([1,2,2,3,1,4]),Int64(2)) |
++-----------------------------------------------+
+| [2, 3] |
++-----------------------------------------------+
```
-#### Arguments
+#### Aliases
-- **element**: Element to prepend to the array.
-- **array**: Array expression.
- Can be a constant, column, or function, and any combination of array
operators.
+- list_positions
+
+### `array_push_back`
+
+_Alias of [array_append](#array_append)._
+
+### `array_push_front`
+
+_Alias of [array_prepend](#array_prepend)._
### `array_remove`
@@ -1620,6 +1788,23 @@ array_to_string(array, delimeter)
Can be a constant, column, or function, and any combination of array
operators.
- **delimeter**: Array element separator.
+#### Example
+
+```
+❯ 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(",")) |
++----------------------------------------------------+
+| 1,2,3,4,5,6,7,8 |
++----------------------------------------------------+
+```
+
+#### Aliases
+
+- array_join
+- list_join
+- list_to_string
+
### `cardinality`
Returns the total number of elements in the array.
@@ -1633,6 +1818,73 @@ cardinality(array)
- **array**: Array expression.
Can be a constant, column, or function, and any combination of array
operators.
+#### Example
+
+```
+❯ select cardinality([[1, 2, 3, 4], [5, 6, 7, 8]]);
++--------------------------------------+
+| cardinality(List([1,2,3,4,5,6,7,8])) |
++--------------------------------------+
+| 8 |
++--------------------------------------+
+```
+
+### `list_append`
+
+_Alias of [array_append](#array_append)._
+
+### `list_cat`
+
+_Alias of [array_concat](#array_concat)._
+
+### `list_concat`
+
+_Alias of [array_concat](#array_concat)._
+
+### `list_dims`
+
+_Alias of [array_dims](#array_dims)._
+
+### `list_indexof`
+
+_Alias of [array_position](#array_position)._
+
+### `list_join`
+
+_Alias of [array_to_string](#array_to_string)._
+
+### `list_length`
+
+_Alias of [array_length](#array_length)._
+
+### `list_ndims`
+
+_Alias of [array_ndims](#array_ndims)._
+
+### `list_prepend`
+
+_Alias of [array_prepend](#array_prepend)._
+
+### `list_position`
+
+_Alias of [array_position](#array_position)._
+
+### `list_positions`
+
+_Alias of [array_positions](#array_positions)._
+
+### `list_push_back`
+
+_Alias of [array_append](#array_append)._
+
+### `list_push_front`
+
+_Alias of [array_prepend](#array_prepend)._
+
+### `list_to_string`
+
+_Alias of [list_to_string](#list_to_string)._
+
### `make_array`
Returns an Arrow array using the specified input expressions.
@@ -1647,6 +1899,25 @@ make_array(expression1[, ..., expression_n])
Can be a constant, column, or function, and any combination of arithmetic or
string operators.
+#### Example
+
+```
+❯ select make_array(1, 2, 3, 4, 5);
++----------------------------------------------------------+
+| make_array(Int64(1),Int64(2),Int64(3),Int64(4),Int64(5)) |
++----------------------------------------------------------+
+| [1, 2, 3, 4, 5] |
++----------------------------------------------------------+
+```
+
+#### Aliases
+
+- make_list
+
+### `make_list`
+
+_Alias of [make_array](#make_array)._
+
### `trim_array`
Removes the last n elements from the array.
diff --git a/searchindex.js b/searchindex.js
index f79b076f15..c0c43cd0eb 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 b6971be717..639928d8f2 100644
--- a/user-guide/expressions.html
+++ b/user-guide/expressions.html
@@ -813,34 +813,34 @@ expressions such as <code class="docutils literal
notranslate"><span class="pre"
</thead>
<tbody>
<tr class="row-even"><td><p>array_append(array, element)</p></td>
-<td><p>Appends an element to the end of an array.</p></td>
+<td><p>Appends an element to the end of an array. <code class="docutils
literal notranslate"><span class="pre">array_append([1,</span> <span
class="pre">2,</span> <span class="pre">3],</span> <span class="pre">4)</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></code></p></td>
</tr>
<tr class="row-odd"><td><p>array_concat(array[, …, array_n])</p></td>
-<td><p>Concatenates arrays.</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>
<tr class="row-odd"><td><p>array_dims(array)</p></td>
-<td><p>Returns an array of the array’s dimensions.</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>
</tr>
<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-odd"><td><p>array_length(array, dimension)</p></td>
-<td><p>Returns the length of the array dimension.</p></td>
+<td><p>Returns the length of the array dimension. <code class="docutils
literal notranslate"><span class="pre">array_length([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">-></span> <span
class="pre">5</span></code></p></td>
</tr>
<tr class="row-even"><td><p>array_ndims(array)</p></td>
-<td><p>Returns the number of dimensions of the array.</p></td>
+<td><p>Returns the number of dimensions of the array. <code class="docutils
literal notranslate"><span class="pre">array_ndims([[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></code></p></td>
</tr>
<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>
+<td><p>Searches for an element in the array, returns first occurrence. <code
class="docutils literal notranslate"><span
class="pre">array_position([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">4],</span>
<span class="pre">2)</span> <span class="pre">-></span> <span
class="pre">2</span></code></p></td>
</tr>
<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>
+<td><p>Searches for an element in the array, returns all occurrences. <code
class="docutils literal notranslate"><span
class="pre">array_positions([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">4],</span>
<span class="pre">2)</span> <span class="pre">-></span> <span
class="pre">[2,</span> <span class="pre">3]</span></code></p></td>
</tr>
<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>
+<td><p>Prepends an element to the beginning of an array. <code class="docutils
literal notranslate"><span class="pre">array_prepend(1,</span> <span
class="pre">[2,</span> <span class="pre">3,</span> <span class="pre">4])</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></code></p></td>
</tr>
<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>
@@ -849,13 +849,13 @@ expressions such as <code class="docutils literal
notranslate"><span class="pre"
<td><p>Replaces a specified element with another specified element.</p></td>
</tr>
<tr class="row-even"><td><p>array_to_string(array, delimeter)</p></td>
-<td><p>Converts each element to its text representation.</p></td>
+<td><p>Converts each element to its text representation. <code class="docutils
literal notranslate"><span class="pre">array_to_string([1,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">4],</span>
<span class="pre">',')</span> <span class="pre">-></span> <span
class="pre">1,2,3,4</span></code></p></td>
</tr>
<tr class="row-odd"><td><p>cardinality(array)</p></td>
-<td><p>Returns the total number of elements in the array.</p></td>
+<td><p>Returns the total number of elements in the array. <code
class="docutils literal notranslate"><span class="pre">cardinality([[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">6</span></code></p></td>
</tr>
<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>
+<td><p>Returns an Arrow array using the specified input expressions. <code
class="docutils literal notranslate"><span class="pre">make_array(1,</span>
<span class="pre">2,</span> <span class="pre">3)</span> <span
class="pre">-></span> <span class="pre">[1,</span> <span
class="pre">2,</span> <span class="pre">3]</span></code></p></td>
</tr>
<tr class="row-odd"><td><p>trim_array(array, n)</p></td>
<td><p>Removes the last n elements from the array.</p></td>
diff --git a/user-guide/sql/scalar_functions.html
b/user-guide/sql/scalar_functions.html
index 89273452e3..1912c3f395 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -1638,8 +1638,27 @@
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#example">
+ Example
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id78">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#array-cat">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ array_cat
+ </span>
+ </code>
+ </a>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#array-concat">
<code class="docutils literal notranslate">
@@ -1650,10 +1669,20 @@
</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>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id80">
+ Example
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id81">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -1666,7 +1695,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="#id82">
Arguments
</a>
</li>
@@ -1682,10 +1711,20 @@
</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="#id83">
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id84">
+ Example
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id85">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -1698,12 +1737,30 @@
</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="#id86">
Arguments
</a>
</li>
</ul>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#array-indexof">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ array_indexof
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#array-join">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ array_join
+ </span>
+ </code>
+ </a>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#array-length">
<code class="docutils literal notranslate">
@@ -1714,10 +1771,20 @@
</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="#id87">
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id88">
+ Example
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id89">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -1730,60 +1797,118 @@
</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="#id90">
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id91">
+ Example
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id92">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#array-position">
+ <a class="reference internal nav-link" href="#array-prepend">
<code class="docutils literal notranslate">
<span class="pre">
- array_position
+ array_prepend
</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">
+ <a class="reference internal nav-link" href="#id93">
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id94">
+ Example
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id95">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#array-positions">
+ <a class="reference internal nav-link" href="#array-position">
<code class="docutils literal notranslate">
<span class="pre">
- array_positions
+ array_position
</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">
+ <a class="reference internal nav-link" href="#id96">
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id97">
+ Example
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id98">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#array-prepend">
+ <a class="reference internal nav-link" href="#array-positions">
<code class="docutils literal notranslate">
<span class="pre">
- array_prepend
+ array_positions
</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="#id86">
+ <a class="reference internal nav-link" href="#id99">
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id100">
+ Example
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id101">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#array-push-back">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ array_push_back
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#array-push-front">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ array_push_front
+ </span>
+ </code>
+ </a>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#array-remove">
<code class="docutils literal notranslate">
@@ -1794,7 +1919,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="#id102">
Arguments
</a>
</li>
@@ -1810,7 +1935,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="#id103">
Arguments
</a>
</li>
@@ -1826,10 +1951,20 @@
</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="#id104">
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id105">
+ Example
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id106">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -1842,12 +1977,143 @@
</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="#id107">
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id108">
+ Example
+ </a>
+ </li>
</ul>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-append">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_append
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-cat">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_cat
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-concat">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_concat
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-dims">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_dims
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-indexof">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_indexof
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-join">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_join
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-length">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_length
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-ndims">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_ndims
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-prepend">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_prepend
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-position">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_position
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-positions">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_positions
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-push-back">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_push_back
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-push-front">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_push_front
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-to-string">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_to_string
+ </span>
+ </code>
+ </a>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#make-array">
<code class="docutils literal notranslate">
@@ -1858,12 +2124,31 @@
</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="#id109">
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id110">
+ Example
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id111">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#make-list">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ make_list
+ </span>
+ </code>
+ </a>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#trim-array">
<code class="docutils literal notranslate">
@@ -1874,7 +2159,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="#id112">
Arguments
</a>
</li>
@@ -1897,7 +2182,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="#id113">
Arguments
</a>
</li>
@@ -1920,7 +2205,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="#id114">
Arguments
</a>
</li>
@@ -1936,7 +2221,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="#id115">
Arguments
</a>
</li>
@@ -1952,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="#id96">
+ <a class="reference internal nav-link" href="#id116">
Arguments
</a>
</li>
@@ -1968,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="#id97">
+ <a class="reference internal nav-link" href="#id117">
Arguments
</a>
</li>
@@ -1984,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="#id98">
+ <a class="reference internal nav-link" href="#id118">
Arguments
</a>
</li>
@@ -2000,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="#id99">
+ <a class="reference internal nav-link" href="#id119">
Arguments
</a>
</li>
@@ -2023,7 +2308,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id100">
+ <a class="reference internal nav-link" href="#id120">
Arguments
</a>
</li>
@@ -2039,7 +2324,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id101">
+ <a class="reference internal nav-link" href="#id121">
Arguments
</a>
</li>
@@ -3565,20 +3850,40 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<h2>Array Functions<a class="headerlink" href="#array-functions"
title="Permalink to this heading">¶</a></h2>
<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-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-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>
+<li><p><a class="reference internal" href="#array-join">array_join</a></p></li>
<li><p><a class="reference internal"
href="#array-length">array_length</a></p></li>
<li><p><a class="reference internal"
href="#array-ndims">array_ndims</a></p></li>
+<li><p><a class="reference internal"
href="#array-prepend">array_prepend</a></p></li>
<li><p><a class="reference internal"
href="#array-position">array_position</a></p></li>
<li><p><a class="reference internal"
href="#array-positions">array_positions</a></p></li>
-<li><p><a class="reference internal"
href="#array-prepend">array_prepend</a></p></li>
+<li><p><a class="reference internal"
href="#array-push-back">array_push_back</a></p></li>
+<li><p><a class="reference internal"
href="#array-push-front">array_push_front</a></p></li>
<li><p><a class="reference internal"
href="#array-remove">array_remove</a></p></li>
<li><p><a class="reference internal"
href="#array-replace">array_replace</a></p></li>
<li><p><a class="reference internal"
href="#array-to-string">array_to_string</a></p></li>
<li><p><a class="reference internal"
href="#cardinality">cardinality</a></p></li>
+<li><p><a class="reference internal"
href="#list-append">list_append</a></p></li>
+<li><p><a class="reference internal" href="#list-cat">list_cat</a></p></li>
+<li><p><a class="reference internal"
href="#list-concat">list_concat</a></p></li>
+<li><p><a class="reference internal" href="#list-dims">list_dims</a></p></li>
+<li><p><a class="reference internal"
href="#list-indexof">list_indexof</a></p></li>
+<li><p><a class="reference internal" href="#list-join">list_join</a></p></li>
+<li><p><a class="reference internal"
href="#list-length">list_length</a></p></li>
+<li><p><a class="reference internal" href="#list-ndims">list_ndims</a></p></li>
+<li><p><a class="reference internal"
href="#list-prepend">list_prepend</a></p></li>
+<li><p><a class="reference internal"
href="#list-position">list_position</a></p></li>
+<li><p><a class="reference internal"
href="#list-positions">list_positions</a></p></li>
+<li><p><a class="reference internal"
href="#list-push-back">list_push_back</a></p></li>
+<li><p><a class="reference internal"
href="#list-push-front">list_push_front</a></p></li>
+<li><p><a class="reference internal"
href="#list-to-string">list_to_string</a></p></li>
<li><p><a class="reference internal" href="#make-array">make_array</a></p></li>
+<li><p><a class="reference internal" href="#make-list">make_list</a></p></li>
<li><p><a class="reference internal" href="#trim-array">trim_array</a></p></li>
</ul>
<section id="array-append">
@@ -3595,6 +3900,29 @@ Can be a constant, column, or function, and any
combination of array operators.<
<li><p><strong>element</strong>: Element to append to the array.</p></li>
</ul>
</section>
+<section id="example">
+<h4>Example<a class="headerlink" href="#example" title="Permalink to this
heading">¶</a></h4>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_append([1, 2, 3], 4);
++--------------------------------------+
+| array_append(List([1,2,3]),Int64(4)) |
++--------------------------------------+
+| [1, 2, 3, 4] |
++--------------------------------------+
+</pre></div>
+</div>
+</section>
+<section id="id78">
+<h4>Aliases<a class="headerlink" href="#id78" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>array_push_back</p></li>
+<li><p>list_append</p></li>
+<li><p>list_push_back</p></li>
+</ul>
+</section>
+</section>
+<section id="array-cat">
+<h3><code class="docutils literal notranslate"><span
class="pre">array_cat</span></code><a class="headerlink" href="#array-cat"
title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-concat">array_concat</a>.</em></p>
</section>
<section id="array-concat">
<h3><code class="docutils literal notranslate"><span
class="pre">array_concat</span></code><a class="headerlink"
href="#array-concat" title="Permalink to this heading">¶</a></h3>
@@ -3602,14 +3930,33 @@ 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_concat</span><span
class="p">(</span><span class="n">array</span><span class="p">[,</span> <span
class="o">...</span><span class="p">,</span> <span
class="n">array_n</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 to concatenate.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
<li><p><strong>array_n</strong>: Subsequent array column or literal array to
concatenate.</p></li>
</ul>
</section>
+<section id="id80">
+<h4>Example<a class="headerlink" href="#id80" title="Permalink to this
heading">¶</a></h4>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_concat([1, 2], [3, 4], [5,
6]);
++---------------------------------------------------+
+| array_concat(List([1,2]),List([3,4]),List([5,6])) |
++---------------------------------------------------+
+| [1, 2, 3, 4, 5, 6] |
++---------------------------------------------------+
+</pre></div>
+</div>
+</section>
+<section id="id81">
+<h4>Aliases<a class="headerlink" href="#id81" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>array_cat</p></li>
+<li><p>list_cat</p></li>
+<li><p>list_concat</p></li>
+</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>
@@ -3617,8 +3964,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_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="id79">
-<h4>Arguments<a class="headerlink" href="#id79" 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>first_array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -3633,13 +3980,30 @@ 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="id80">
-<h4>Arguments<a class="headerlink" href="#id80" 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>
</ul>
</section>
+<section id="id84">
+<h4>Example<a class="headerlink" href="#id84" 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])) |
++---------------------------------+
+| [2, 3] |
++---------------------------------+
+</pre></div>
+</div>
+</section>
+<section id="id85">
+<h4>Aliases<a class="headerlink" href="#id85" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>list_dims</p></li>
+</ul>
+</section>
</section>
<section id="array-fill">
<h3><code class="docutils literal notranslate"><span
class="pre">array_fill</span></code><a class="headerlink" href="#array-fill"
title="Permalink to this heading">¶</a></h3>
@@ -3647,8 +4011,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="id81">
-<h4>Arguments<a class="headerlink" href="#id81" 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>
@@ -3656,20 +4020,45 @@ Can be a constant, column, or function, and any
combination of array operators.<
</ul>
</section>
</section>
+<section id="array-indexof">
+<h3><code class="docutils literal notranslate"><span
class="pre">array_indexof</span></code><a class="headerlink"
href="#array-indexof" title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-position">array_position</a>.</em></p>
+</section>
+<section id="array-join">
+<h3><code class="docutils literal notranslate"><span
class="pre">array_join</span></code><a class="headerlink" href="#array-join"
title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-to-string">array_to_string</a>.</em></p>
+</section>
<section id="array-length">
<h3><code class="docutils literal notranslate"><span
class="pre">array_length</span></code><a class="headerlink"
href="#array-length" title="Permalink to this heading">¶</a></h3>
<p>Returns the length of the array dimension.</p>
<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="id82">
-<h4>Arguments<a class="headerlink" href="#id82" 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>
<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>
+<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])) |
++---------------------------------+
+| 5 |
++---------------------------------+
+</pre></div>
+</div>
+</section>
+<section id="id89">
+<h4>Aliases<a class="headerlink" href="#id89" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>list_length</p></li>
+</ul>
+</section>
</section>
<section id="array-ndims">
<h3><code class="docutils literal notranslate"><span
class="pre">array_ndims</span></code><a class="headerlink" href="#array-ndims"
title="Permalink to this heading">¶</a></h3>
@@ -3677,13 +4066,64 @@ 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="id83">
-<h4>Arguments<a class="headerlink" href="#id83" 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>
</ul>
</section>
+<section id="id91">
+<h4>Example<a class="headerlink" href="#id91" 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])) |
++----------------------------------+
+| 2 |
++----------------------------------+
+</pre></div>
+</div>
+</section>
+<section id="id92">
+<h4>Aliases<a class="headerlink" href="#id92" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>list_ndims</p></li>
+</ul>
+</section>
+</section>
+<section id="array-prepend">
+<h3><code class="docutils literal notranslate"><span
class="pre">array_prepend</span></code><a class="headerlink"
href="#array-prepend" title="Permalink to this heading">¶</a></h3>
+<p>Prepends an element to the beginning of an array.</p>
+<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>
+<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>
+<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])) |
++---------------------------------------+
+| [1, 2, 3, 4] |
++---------------------------------------+
+</pre></div>
+</div>
+</section>
+<section id="id95">
+<h4>Aliases<a class="headerlink" href="#id95" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>array_push_front</p></li>
+<li><p>list_prepend</p></li>
+<li><p>list_push_front</p></li>
+</ul>
+</section>
</section>
<section id="array-position">
<h3><code class="docutils literal notranslate"><span
class="pre">array_position</span></code><a class="headerlink"
href="#array-position" title="Permalink to this heading">¶</a></h3>
@@ -3692,8 +4132,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="id84">
-<h4>Arguments<a class="headerlink" href="#id84" 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>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -3701,6 +4141,25 @@ 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>
+<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)) |
++----------------------------------------------+
+| 2 |
++----------------------------------------------+
+</pre></div>
+</div>
+</section>
+<section id="id98">
+<h4>Aliases<a class="headerlink" href="#id98" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>array_indexof</p></li>
+<li><p>list_indexof</p></li>
+<li><p>list_position</p></li>
+</ul>
+</section>
</section>
<section id="array-positions">
<h3><code class="docutils literal notranslate"><span
class="pre">array_positions</span></code><a class="headerlink"
href="#array-positions" title="Permalink to this heading">¶</a></h3>
@@ -3708,38 +4167,48 @@ 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="id85">
-<h4>Arguments<a class="headerlink" href="#id85" 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>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>
-<section id="array-prepend">
-<h3><code class="docutils literal notranslate"><span
class="pre">array_prepend</span></code><a class="headerlink"
href="#array-prepend" title="Permalink to this heading">¶</a></h3>
-<p>Prepends an element to the beginning of an array.</p>
-<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>
+<section id="id100">
+<h4>Example<a class="headerlink" href="#id100" 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)) |
++-----------------------------------------------+
+| [2, 3] |
++-----------------------------------------------+
</pre></div>
</div>
-<section id="id86">
-<h4>Arguments<a class="headerlink" href="#id86" title="Permalink to this
heading">¶</a></h4>
+</section>
+<section id="id101">
+<h4>Aliases<a class="headerlink" href="#id101" 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>
+<li><p>list_positions</p></li>
</ul>
</section>
</section>
+<section id="array-push-back">
+<h3><code class="docutils literal notranslate"><span
class="pre">array_push_back</span></code><a class="headerlink"
href="#array-push-back" title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-append">array_append</a>.</em></p>
+</section>
+<section id="array-push-front">
+<h3><code class="docutils literal notranslate"><span
class="pre">array_push_front</span></code><a class="headerlink"
href="#array-push-front" title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-prepend">array_prepend</a>.</em></p>
+</section>
<section id="array-remove">
<h3><code class="docutils literal notranslate"><span
class="pre">array_remove</span></code><a class="headerlink"
href="#array-remove" title="Permalink to this heading">¶</a></h3>
<p>Removes all elements equal to the given value from the array.</p>
<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="id87">
-<h4>Arguments<a class="headerlink" href="#id87" title="Permalink to this
heading">¶</a></h4>
+<section id="id102">
+<h4>Arguments<a class="headerlink" href="#id102" 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>
@@ -3753,8 +4222,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="id88">
-<h4>Arguments<a class="headerlink" href="#id88" title="Permalink to this
heading">¶</a></h4>
+<section id="id103">
+<h4>Arguments<a class="headerlink" href="#id103" 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>
@@ -3769,14 +4238,33 @@ 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="id89">
-<h4>Arguments<a class="headerlink" href="#id89" 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>
<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>
+<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(",")) |
++----------------------------------------------------+
+| 1,2,3,4,5,6,7,8 |
++----------------------------------------------------+
+</pre></div>
+</div>
+</section>
+<section id="id106">
+<h4>Aliases<a class="headerlink" href="#id106" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>array_join</p></li>
+<li><p>list_join</p></li>
+<li><p>list_to_string</p></li>
+</ul>
+</section>
</section>
<section id="cardinality">
<h3><code class="docutils literal notranslate"><span
class="pre">cardinality</span></code><a class="headerlink" href="#cardinality"
title="Permalink to this heading">¶</a></h3>
@@ -3784,13 +4272,80 @@ 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="id90">
-<h4>Arguments<a class="headerlink" href="#id90" title="Permalink to this
heading">¶</a></h4>
+<section id="id107">
+<h4>Arguments<a class="headerlink" href="#id107" 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>
+<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])) |
++--------------------------------------+
+| 8 |
++--------------------------------------+
+</pre></div>
+</div>
+</section>
+</section>
+<section id="list-append">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_append</span></code><a class="headerlink" href="#list-append"
title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-append">array_append</a>.</em></p>
+</section>
+<section id="list-cat">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_cat</span></code><a class="headerlink" href="#list-cat"
title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-concat">array_concat</a>.</em></p>
+</section>
+<section id="list-concat">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_concat</span></code><a class="headerlink" href="#list-concat"
title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-concat">array_concat</a>.</em></p>
+</section>
+<section id="list-dims">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_dims</span></code><a class="headerlink" href="#list-dims"
title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-dims">array_dims</a>.</em></p>
+</section>
+<section id="list-indexof">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_indexof</span></code><a class="headerlink"
href="#list-indexof" title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-position">array_position</a>.</em></p>
+</section>
+<section id="list-join">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_join</span></code><a class="headerlink" href="#list-join"
title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-to-string">array_to_string</a>.</em></p>
+</section>
+<section id="list-length">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_length</span></code><a class="headerlink" href="#list-length"
title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-length">array_length</a>.</em></p>
+</section>
+<section id="list-ndims">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_ndims</span></code><a class="headerlink" href="#list-ndims"
title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-ndims">array_ndims</a>.</em></p>
+</section>
+<section id="list-prepend">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_prepend</span></code><a class="headerlink"
href="#list-prepend" title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-prepend">array_prepend</a>.</em></p>
+</section>
+<section id="list-position">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_position</span></code><a class="headerlink"
href="#list-position" title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-position">array_position</a>.</em></p>
+</section>
+<section id="list-positions">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_positions</span></code><a class="headerlink"
href="#list-positions" title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-positions">array_positions</a>.</em></p>
+</section>
+<section id="list-push-back">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_push_back</span></code><a class="headerlink"
href="#list-push-back" title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-append">array_append</a>.</em></p>
+</section>
+<section id="list-push-front">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_push_front</span></code><a class="headerlink"
href="#list-push-front" title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-prepend">array_prepend</a>.</em></p>
+</section>
+<section id="list-to-string">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_to_string</span></code><a class="headerlink"
href="#list-to-string" title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#list-to-string">list_to_string</a>.</em></p>
</section>
<section id="make-array">
<h3><code class="docutils literal notranslate"><span
class="pre">make_array</span></code><a class="headerlink" href="#make-array"
title="Permalink to this heading">¶</a></h3>
@@ -3798,14 +4353,35 @@ 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="id91">
-<h4>Arguments<a class="headerlink" href="#id91" 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>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>
+<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)) |
++----------------------------------------------------------+
+| [1, 2, 3, 4, 5] |
++----------------------------------------------------------+
+</pre></div>
+</div>
+</section>
+<section id="id111">
+<h4>Aliases<a class="headerlink" href="#id111" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>make_list</p></li>
+</ul>
+</section>
+</section>
+<section id="make-list">
+<h3><code class="docutils literal notranslate"><span
class="pre">make_list</span></code><a class="headerlink" href="#make-list"
title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#make-array">make_array</a>.</em></p>
</section>
<section id="trim-array">
<h3><code class="docutils literal notranslate"><span
class="pre">trim_array</span></code><a class="headerlink" href="#trim-array"
title="Permalink to this heading">¶</a></h3>
@@ -3813,8 +4389,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="id92">
-<h4>Arguments<a class="headerlink" href="#id92" title="Permalink to this
heading">¶</a></h4>
+<section id="id112">
+<h4>Arguments<a class="headerlink" href="#id112" 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>
@@ -3855,8 +4431,8 @@ a struct type of fields <code class="docutils literal
notranslate"><span class="
+-----------------+
</pre></div>
</div>
-<section id="id93">
-<h4>Arguments<a class="headerlink" href="#id93" title="Permalink to this
heading">¶</a></h4>
+<section id="id113">
+<h4>Arguments<a class="headerlink" href="#id113" 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
@@ -3881,8 +4457,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="id94">
-<h4>Arguments<a class="headerlink" href="#id94" 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>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -3908,8 +4484,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="id95">
-<h4>Arguments<a class="headerlink" href="#id95" 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</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -3922,8 +4498,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="id96">
-<h4>Arguments<a class="headerlink" href="#id96" 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>
@@ -3936,8 +4512,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="id97">
-<h4>Arguments<a class="headerlink" href="#id97" 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>
@@ -3950,8 +4526,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="id98">
-<h4>Arguments<a class="headerlink" href="#id98" 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>
@@ -3964,8 +4540,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="id99">
-<h4>Arguments<a class="headerlink" href="#id99" 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>
@@ -3985,8 +4561,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="id100">
-<h4>Arguments<a class="headerlink" href="#id100" 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>: Expression to cast.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -4002,8 +4578,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="id101">
-<h4>Arguments<a class="headerlink" href="#id101" 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>: Expression to evaluate.
Can be a constant, column, or function, and any combination of arithmetic or
