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 1c68493792 Publish built docs triggered by
23547587c2773ddddb9b16cba1eb8ebf2eebd85a
1c68493792 is described below
commit 1c684937928e43996a90a7516b7a4382abce808f
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Fri Aug 4 15:15:08 2023 +0000
Publish built docs triggered by 23547587c2773ddddb9b16cba1eb8ebf2eebd85a
---
_sources/user-guide/expressions.md.txt | 4 +-
_sources/user-guide/sql/scalar_functions.md.txt | 103 ++++-
searchindex.js | 2 +-
user-guide/expressions.html | 32 +-
user-guide/sql/scalar_functions.html | 513 +++++++++++++++++-------
5 files changed, 496 insertions(+), 158 deletions(-)
diff --git a/_sources/user-guide/expressions.md.txt
b/_sources/user-guide/expressions.md.txt
index 139e968ecc..0278f77938 100644
--- a/_sources/user-guide/expressions.md.txt
+++ b/_sources/user-guide/expressions.md.txt
@@ -187,6 +187,7 @@ Unlike to some databases the math functions in Datafusion
works the same way as
| 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_element(array, index) | Extracts the element with the index
n from the array `array_element([1, 2, 3, 4], 3) -> 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`
|
@@ -199,10 +200,11 @@ Unlike to some databases the math functions in Datafusion
works the same way as
| array_replace(array, from, to) | Replaces the first occurrence of the
specified element with another specified element. `array_replace([1, 2, 2, 3,
2, 1, 4], 2, 5) -> [1, 5, 2, 3, 2, 1, 4]` |
| array_replace_n(array, from, to, max) | Replaces the first `max` occurrences
of the specified element with another specified element. `array_replace_n([1,
2, 2, 3, 2, 1, 4], 2, 5, 2) -> [1, 5, 5, 3, 2, 1, 4]` |
| array_replace_all(array, from, to) | Replaces all occurrences of the
specified element with another specified element. `array_replace_all([1, 2, 2,
3, 2, 1, 4], 2, 5) -> [1, 5, 5, 3, 5, 1, 4]` |
+| array_slice(array, index) | Returns a slice of the array.
`array_slice([1, 2, 3, 4, 5, 6, 7, 8], 3, 6) -> [3, 4, 5, 6]`
|
| 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.
|
+| trim_array(array, n) | Deprecated
|
## Regular Expressions
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index d8337832d4..fa1bac5d94 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -413,7 +413,6 @@ radians(numeric_expression)
- **numeric_expression**: Numeric expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.
- =======
### `random`
@@ -1447,6 +1446,8 @@ from_unixtime(expression)
- [array_concat](#array_concat)
- [array_contains](#array_contains)
- [array_dims](#array_dims)
+- [array_element](#array_element)
+- [array_extract](#array_extract)
- [array_fill](#array_fill)
- [array_indexof](#array_indexof)
- [array_join](#array_join)
@@ -1463,12 +1464,15 @@ from_unixtime(expression)
- [array_replace](#array_replace)
- [array_replace_n](#array_replace_n)
- [array_replace_all](#array_replace_all)
+- [array_slice](#array_slice)
- [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_element](#list_element)
+- [list_extract](#list_extract)
- [list_indexof](#list_indexof)
- [list_join](#list_join)
- [list_length](#list_length)
@@ -1484,6 +1488,7 @@ from_unixtime(expression)
- [list_replace](#list_replace)
- [list_replace_n](#list_replace_n)
- [list_replace_all](#list_replace_all)
+- [list_slice](#list_slice)
- [list_to_string](#list_to_string)
- [make_array](#make_array)
- [make_list](#make_list)
@@ -1628,6 +1633,41 @@ array_dims(array)
- list_dims
+### `array_element`
+
+Extracts the element with the index n from the array.
+
+```
+array_element(array, index)
+```
+
+#### Arguments
+
+- **array**: Array expression.
+ Can be a constant, column, or function, and any combination of array
operators.
+- **index**: Index to extract the element from the array.
+
+#### Example
+
+```
+❯ select array_element([1, 2, 3, 4], 3);
++-----------------------------------------+
+| array_element(List([1,2,3,4]),Int64(3)) |
++-----------------------------------------+
+| 3 |
++-----------------------------------------+
+```
+
+#### Aliases
+
+- array_extract
+- list_element
+- list_extract
+
+### `array_extract`
+
+_Alias of [array_element](#array_element)._
+
### `array_fill`
Returns an array filled with copies of the given value.
@@ -1833,6 +1873,10 @@ array_remove(array, element)
+----------------------------------------------+
```
+#### Aliases
+
+- list_remove
+
### `array_remove_n`
Removes the first `max` elements from the array equal to the given value.
@@ -1859,6 +1903,10 @@ array_remove_n(array, element, max)
+---------------------------------------------------------+
```
+#### Aliases
+
+- list_remove_n
+
### `array_remove_all`
Removes all elements from the array equal to the given value.
@@ -1884,6 +1932,10 @@ array_remove_all(array, element)
+--------------------------------------------------+
```
+#### Aliases
+
+- list_remove_all
+
### `array_replace`
Replaces the first occurrence of the specified element with another specified
element.
@@ -1910,6 +1962,10 @@ array_replace(array, from, to)
+--------------------------------------------------------+
```
+#### Aliases
+
+- list_replace
+
### `array_replace_n`
Replaces the first `max` occurrences of the specified element with another
specified element.
@@ -1937,6 +1993,10 @@ array_replace_n(array, from, to, max)
+-------------------------------------------------------------------+
```
+#### Aliases
+
+- list_replace_n
+
### `array_replace_all`
Replaces all occurrences of the specified element with another specified
element.
@@ -1963,6 +2023,33 @@ array_replace_all(array, from, to)
+------------------------------------------------------------+
```
+#### Aliases
+
+- list_replace_all
+
+### `array_slice`
+
+Returns a slice of the array.
+
+```
+array_slice(array, begin, end)
+```
+
+#### Example
+
+```
+❯ select array_slice([1, 2, 3, 4, 5, 6, 7, 8], 3, 6);
++--------------------------------------------------------+
+| array_slice(List([1,2,3,4,5,6,7,8]),Int64(3),Int64(6)) |
++--------------------------------------------------------+
+| [3, 4, 5, 6] |
++--------------------------------------------------------+
+```
+
+#### Aliases
+
+- list_slice
+
### `array_to_string`
Converts each element to its text representation.
@@ -2034,6 +2121,14 @@ _Alias of [array_concat](#array_concat)._
_Alias of [array_dims](#array_dims)._
+### `list_element`
+
+_Alias of [array_element](#array_element)._
+
+### `list_extract`
+
+_Alias of [array_element](#array_element)._
+
### `list_indexof`
_Alias of [array_position](#array_position)._
@@ -2094,6 +2189,10 @@ _Alias of [array_replace_n](#array_replace_n)._
_Alias of [array_replace_all](#array_replace_all)._
+### `list_slice`
+
+_Alias of [array_slice](#array_slice)._
+
### `list_to_string`
_Alias of [list_to_string](#list_to_string)._
@@ -2135,6 +2234,8 @@ _Alias of [make_array](#make_array)._
Removes the last n elements from the array.
+DEPRECATED: use `array_slice` instead!
+
```
trim_array(array, n)
```
diff --git a/searchindex.js b/searchindex.js
index 440f7ba922..3a844856de 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 c40ad45086..11f41bcd39 100644
--- a/user-guide/expressions.html
+++ b/user-guide/expressions.html
@@ -830,42 +830,48 @@ expressions such as <code class="docutils literal
notranslate"><span class="pre"
<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>
</tr>
-<tr class="row-even"><td><p>array_fill(element, array)</p></td>
+<tr class="row-even"><td><p>array_element(array, index)</p></td>
+<td><p>Extracts the element with the index n from the array <code
class="docutils literal notranslate"><span class="pre">array_element([1,</span>
<span class="pre">2,</span> <span class="pre">3,</span> <span
class="pre">4],</span> <span class="pre">3)</span> <span
class="pre">-></span> <span class="pre">3</span></code></p></td>
+</tr>
+<tr class="row-odd"><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>
+<tr class="row-even"><td><p>array_length(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>
+<tr class="row-odd"><td><p>array_ndims(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>
+<tr class="row-even"><td><p>array_position(array, element)</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>
+<tr class="row-odd"><td><p>array_positions(array, element)</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>
+<tr class="row-even"><td><p>array_prepend(array, element)</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>
+<tr class="row-odd"><td><p>array_remove(array, element)</p></td>
<td><p>Removes the first element from the array equal to the given value.
<code class="docutils literal notranslate"><span
class="pre">array_remove([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">2,</span>
<span class="pre">1,</span> <span class="pre">4],</span> <span
class="pre">2)</span> <span class="pre">-></span> <span
class="pre">[1,</span> <span class="pre">2,</span> <span class="pre">3,</span>
<span class="pre">2, [...]
</tr>
-<tr class="row-odd"><td><p>array_remove_n(array, element, max)</p></td>
+<tr class="row-even"><td><p>array_remove_n(array, element, max)</p></td>
<td><p>Removes the first <code class="docutils literal notranslate"><span
class="pre">max</span></code> elements from the array equal to the given value.
<code class="docutils literal notranslate"><span
class="pre">array_remove_n([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">2,</span>
<span class="pre">1,</span> <span class="pre">4],</span> <span
class="pre">2,</span> <span class="pre">2)</span> <span class="pre">-></s
[...]
</tr>
-<tr class="row-even"><td><p>array_remove_all(array, element)</p></td>
+<tr class="row-odd"><td><p>array_remove_all(array, element)</p></td>
<td><p>Removes all elements from the array equal to the given value. <code
class="docutils literal notranslate"><span
class="pre">array_remove_all([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">2,</span>
<span class="pre">1,</span> <span class="pre">4],</span> <span
class="pre">2)</span> <span class="pre">-></span> <span
class="pre">[1,</span> <span class="pre">3,</span> <span class="pre">1,</span>
<span class="pre">4]< [...]
</tr>
-<tr class="row-odd"><td><p>array_replace(array, from, to)</p></td>
+<tr class="row-even"><td><p>array_replace(array, from, to)</p></td>
<td><p>Replaces the first occurrence of the specified element with another
specified element. <code class="docutils literal notranslate"><span
class="pre">array_replace([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">2,</span>
<span class="pre">1,</span> <span class="pre">4],</span> <span
class="pre">2,</span> <span class="pre">5)</span> <span
class="pre">-></span> <span class="pre">[1,</span> <span
class="pre">5,</span> [...]
</tr>
-<tr class="row-even"><td><p>array_replace_n(array, from, to, max)</p></td>
+<tr class="row-odd"><td><p>array_replace_n(array, from, to, max)</p></td>
<td><p>Replaces the first <code class="docutils literal notranslate"><span
class="pre">max</span></code> occurrences of the specified element with another
specified element. <code class="docutils literal notranslate"><span
class="pre">array_replace_n([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">2,</span>
<span class="pre">1,</span> <span class="pre">4],</span> <span
class="pre">2,</span> <span class="pre">5,</span> <span [...]
</tr>
-<tr class="row-odd"><td><p>array_replace_all(array, from, to)</p></td>
+<tr class="row-even"><td><p>array_replace_all(array, from, to)</p></td>
<td><p>Replaces all occurrences of the specified element with another
specified element. <code class="docutils literal notranslate"><span
class="pre">array_replace_all([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">2,</span>
<span class="pre">1,</span> <span class="pre">4],</span> <span
class="pre">2,</span> <span class="pre">5)</span> <span
class="pre">-></span> <span class="pre">[1,</span> <span
class="pre">5,</span> [...]
</tr>
+<tr class="row-odd"><td><p>array_slice(array, index)</p></td>
+<td><p>Returns a slice of the array. <code class="docutils literal
notranslate"><span class="pre">array_slice([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">7,</span> <span class="pre">8],</span> <span class="pre">3,</span>
<span class="pre">6)</span> <span class="pre">-></span> <span
class="pre">[3,</span> <span class="pre">4,</span> <span class="pre">5,</span>
<s [...]
+</tr>
<tr class="row-even"><td><p>array_to_string(array, delimeter)</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>
@@ -876,7 +882,7 @@ expressions such as <code class="docutils literal
notranslate"><span class="pre"
<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>
+<td><p>Deprecated</p></td>
</tr>
</tbody>
</table>
diff --git a/user-guide/sql/scalar_functions.html
b/user-guide/sql/scalar_functions.html
index a97bf918a7..c6ca80d242 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -1775,6 +1775,41 @@
</li>
</ul>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#array-element">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ array_element
+ </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="#id89">
+ Arguments
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <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="#id91">
+ Aliases
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#array-extract">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ array_extract
+ </span>
+ </code>
+ </a>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#array-fill">
<code class="docutils literal notranslate">
@@ -1785,7 +1820,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id89">
+ <a class="reference internal nav-link" href="#id92">
Arguments
</a>
</li>
@@ -1819,17 +1854,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="#id93">
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="#id94">
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="#id95">
Aliases
</a>
</li>
@@ -1845,17 +1880,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="#id96">
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="#id97">
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="#id98">
Aliases
</a>
</li>
@@ -1871,17 +1906,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="#id99">
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="#id100">
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="#id101">
Aliases
</a>
</li>
@@ -1897,17 +1932,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="#id102">
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="#id103">
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="#id104">
Aliases
</a>
</li>
@@ -1923,17 +1958,17 @@
</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="#id105">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id103">
+ <a class="reference internal nav-link" href="#id106">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id104">
+ <a class="reference internal nav-link" href="#id107">
Aliases
</a>
</li>
@@ -1967,15 +2002,20 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id105">
+ <a class="reference internal nav-link" href="#id108">
Arguments
</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="#id109">
Example
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id110">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -1988,15 +2028,20 @@
</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="#id111">
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="#id112">
Example
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id113">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -2009,15 +2054,20 @@
</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="#id114">
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="#id115">
Example
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id116">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -2030,15 +2080,20 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id111">
+ <a class="reference internal nav-link" href="#id117">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id112">
+ <a class="reference internal nav-link" href="#id118">
Example
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id119">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -2051,15 +2106,20 @@
</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="#id120">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id114">
+ <a class="reference internal nav-link" href="#id121">
Example
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id122">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -2072,15 +2132,41 @@
</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="#id123">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id116">
+ <a class="reference internal nav-link" href="#id124">
Example
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id125">
+ Aliases
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#array-slice">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ array_slice
+ </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="#id126">
+ Example
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id127">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -2093,17 +2179,17 @@
</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="#id128">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id118">
+ <a class="reference internal nav-link" href="#id129">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id119">
+ <a class="reference internal nav-link" href="#id130">
Aliases
</a>
</li>
@@ -2119,12 +2205,12 @@
</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="#id131">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id121">
+ <a class="reference internal nav-link" href="#id132">
Example
</a>
</li>
@@ -2166,6 +2252,24 @@
</code>
</a>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-element">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_element
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-extract">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_extract
+ </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">
@@ -2301,6 +2405,15 @@
</code>
</a>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-slice">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_slice
+ </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">
@@ -2320,17 +2433,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id122">
+ <a class="reference internal nav-link" href="#id133">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id123">
+ <a class="reference internal nav-link" href="#id134">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id124">
+ <a class="reference internal nav-link" href="#id135">
Aliases
</a>
</li>
@@ -2355,7 +2468,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id125">
+ <a class="reference internal nav-link" href="#id136">
Arguments
</a>
</li>
@@ -2378,7 +2491,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id126">
+ <a class="reference internal nav-link" href="#id137">
Arguments
</a>
</li>
@@ -2401,7 +2514,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id127">
+ <a class="reference internal nav-link" href="#id138">
Arguments
</a>
</li>
@@ -2417,7 +2530,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id128">
+ <a class="reference internal nav-link" href="#id139">
Arguments
</a>
</li>
@@ -2433,7 +2546,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id129">
+ <a class="reference internal nav-link" href="#id140">
Arguments
</a>
</li>
@@ -2449,7 +2562,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id130">
+ <a class="reference internal nav-link" href="#id141">
Arguments
</a>
</li>
@@ -2465,7 +2578,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id131">
+ <a class="reference internal nav-link" href="#id142">
Arguments
</a>
</li>
@@ -2481,7 +2594,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id132">
+ <a class="reference internal nav-link" href="#id143">
Arguments
</a>
</li>
@@ -2504,7 +2617,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id133">
+ <a class="reference internal nav-link" href="#id144">
Arguments
</a>
</li>
@@ -2520,7 +2633,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id134">
+ <a class="reference internal nav-link" href="#id145">
Arguments
</a>
</li>
@@ -2992,10 +3105,9 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
</div>
<section id="id24">
<h4>Arguments<a class="headerlink" href="#id24" title="Permalink to this
heading">¶</a></h4>
-<ul>
-<li><h1 class="rubric"
id="numeric-expression-numeric-expression-to-operate-on-can-be-a-constant-column-or-function-and-any-combination-of-arithmetic-operators"><strong>numeric_expression</strong>:
Numeric expression to operate on.
-Can be a constant, column, or function, and any combination of arithmetic
operators.</h1>
-</li>
+<ul class="simple">
+<li><p><strong>numeric_expression</strong>: Numeric expression to operate on.
+Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
</ul>
</section>
</section>
@@ -4073,6 +4185,8 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<li><p><a class="reference internal"
href="#array-concat">array_concat</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-element">array_element</a></p></li>
+<li><p><a class="reference internal"
href="#array-extract">array_extract</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>
@@ -4089,12 +4203,15 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<li><p><a class="reference internal"
href="#array-replace">array_replace</a></p></li>
<li><p><a class="reference internal"
href="#array-replace-n">array_replace_n</a></p></li>
<li><p><a class="reference internal"
href="#array-replace-all">array_replace_all</a></p></li>
+<li><p><a class="reference internal"
href="#array-slice">array_slice</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-element">list_element</a></p></li>
+<li><p><a class="reference internal"
href="#list-extract">list_extract</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>
@@ -4110,6 +4227,7 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<li><p><a class="reference internal"
href="#list-replace">list_replace</a></p></li>
<li><p><a class="reference internal"
href="#list-replace-n">list_replace_n</a></p></li>
<li><p><a class="reference internal"
href="#list-replace-all">list_replace_all</a></p></li>
+<li><p><a class="reference internal" href="#list-slice">list_slice</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>
@@ -4266,14 +4384,52 @@ Can be a constant, column, or function, and any
combination of array operators.<
</ul>
</section>
</section>
+<section id="array-element">
+<h3><code class="docutils literal notranslate"><span
class="pre">array_element</span></code><a class="headerlink"
href="#array-element" title="Permalink to this heading">¶</a></h3>
+<p>Extracts the element with the index n from the array.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_element</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">index</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>
+<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>index</strong>: Index to extract the element from the
array.</p></li>
+</ul>
+</section>
+<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_element([1, 2, 3, 4], 3);
++-----------------------------------------+
+| array_element(List([1,2,3,4]),Int64(3)) |
++-----------------------------------------+
+| 3 |
++-----------------------------------------+
+</pre></div>
+</div>
+</section>
+<section id="id91">
+<h4>Aliases<a class="headerlink" href="#id91" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>array_extract</p></li>
+<li><p>list_element</p></li>
+<li><p>list_extract</p></li>
+</ul>
+</section>
+</section>
+<section id="array-extract">
+<h3><code class="docutils literal notranslate"><span
class="pre">array_extract</span></code><a class="headerlink"
href="#array-extract" title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-element">array_element</a>.</em></p>
+</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>
<p>Returns an array filled with copies of the given value.</p>
<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="id89">
-<h4>Arguments<a class="headerlink" href="#id89" 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>
@@ -4295,16 +4451,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="id90">
-<h4>Arguments<a class="headerlink" href="#id90" title="Permalink to this
heading">¶</a></h4>
+<section id="id93">
+<h4>Arguments<a class="headerlink" href="#id93" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>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="id91">
-<h4>Example<a class="headerlink" href="#id91" title="Permalink to this
heading">¶</a></h4>
+<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_length([1, 2, 3, 4, 5]);
+---------------------------------+
| array_length(List([1,2,3,4,5])) |
@@ -4314,8 +4470,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="id95">
+<h4>Aliases<a class="headerlink" href="#id95" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_length</p></li>
</ul>
@@ -4327,15 +4483,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="id93">
-<h4>Arguments<a class="headerlink" href="#id93" 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>
</ul>
</section>
-<section id="id94">
-<h4>Example<a class="headerlink" href="#id94" title="Permalink to this
heading">¶</a></h4>
+<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_ndims([[1, 2, 3], [4, 5,
6]]);
+----------------------------------+
| array_ndims(List([1,2,3,4,5,6])) |
@@ -4345,8 +4501,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="id98">
+<h4>Aliases<a class="headerlink" href="#id98" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_ndims</p></li>
</ul>
@@ -4358,16 +4514,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="id96">
-<h4>Arguments<a class="headerlink" href="#id96" 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>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="id97">
-<h4>Example<a class="headerlink" href="#id97" title="Permalink to this
heading">¶</a></h4>
+<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_prepend(1, [2, 3, 4]);
+---------------------------------------+
| array_prepend(Int64(1),List([2,3,4])) |
@@ -4377,8 +4533,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="id101">
+<h4>Aliases<a class="headerlink" href="#id101" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_push_front</p></li>
<li><p>list_prepend</p></li>
@@ -4393,8 +4549,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="id99">
-<h4>Arguments<a class="headerlink" href="#id99" 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>
@@ -4402,8 +4558,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="id100">
-<h4>Example<a class="headerlink" href="#id100" title="Permalink to this
heading">¶</a></h4>
+<section id="id103">
+<h4>Example<a class="headerlink" href="#id103" 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)) |
@@ -4413,8 +4569,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="id104">
+<h4>Aliases<a class="headerlink" href="#id104" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_indexof</p></li>
<li><p>list_indexof</p></li>
@@ -4428,16 +4584,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="id102">
-<h4>Arguments<a class="headerlink" href="#id102" 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>
<li><p><strong>element</strong>: Element to search for positions in the
array.</p></li>
</ul>
</section>
-<section id="id103">
-<h4>Example<a class="headerlink" href="#id103" title="Permalink to this
heading">¶</a></h4>
+<section id="id106">
+<h4>Example<a class="headerlink" href="#id106" 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)) |
@@ -4447,8 +4603,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id104">
-<h4>Aliases<a class="headerlink" href="#id104" title="Permalink to this
heading">¶</a></h4>
+<section id="id107">
+<h4>Aliases<a class="headerlink" href="#id107" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_positions</p></li>
</ul>
@@ -4468,16 +4624,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_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="id105">
-<h4>Arguments<a class="headerlink" href="#id105" title="Permalink to this
heading">¶</a></h4>
+<section id="id108">
+<h4>Arguments<a class="headerlink" href="#id108" 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 be removed from the array.</p></li>
</ul>
</section>
-<section id="id106">
-<h4>Example<a class="headerlink" href="#id106" title="Permalink to this
heading">¶</a></h4>
+<section id="id109">
+<h4>Example<a class="headerlink" href="#id109" title="Permalink to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_remove([1, 2, 2, 3, 2, 1,
4], 2);
+----------------------------------------------+
| array_remove(List([1,2,2,3,2,1,4]),Int64(2)) |
@@ -4487,6 +4643,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
+<section id="id110">
+<h4>Aliases<a class="headerlink" href="#id110" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>list_remove</p></li>
+</ul>
+</section>
</section>
<section id="array-remove-n">
<h3><code class="docutils literal notranslate"><span
class="pre">array_remove_n</span></code><a class="headerlink"
href="#array-remove-n" title="Permalink to this heading">¶</a></h3>
@@ -4494,8 +4656,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_n</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="nb">max</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="id111">
+<h4>Arguments<a class="headerlink" href="#id111" 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>
@@ -4503,8 +4665,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<li><p><strong>max</strong>: Number of first occurrences to remove.</p></li>
</ul>
</section>
-<section id="id108">
-<h4>Example<a class="headerlink" href="#id108" 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 array_remove_n([1, 2, 2, 3, 2, 1,
4], 2, 2);
+---------------------------------------------------------+
| array_remove_n(List([1,2,2,3,2,1,4]),Int64(2),Int64(2)) |
@@ -4514,6 +4676,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
+<section id="id113">
+<h4>Aliases<a class="headerlink" href="#id113" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>list_remove_n</p></li>
+</ul>
+</section>
</section>
<section id="array-remove-all">
<h3><code class="docutils literal notranslate"><span
class="pre">array_remove_all</span></code><a class="headerlink"
href="#array-remove-all" title="Permalink to this heading">¶</a></h3>
@@ -4521,16 +4689,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_remove_all</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="id109">
-<h4>Arguments<a class="headerlink" href="#id109" 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>
<li><p><strong>element</strong>: Element to be removed from the array.</p></li>
</ul>
</section>
-<section id="id110">
-<h4>Example<a class="headerlink" href="#id110" title="Permalink to this
heading">¶</a></h4>
+<section id="id115">
+<h4>Example<a class="headerlink" href="#id115" title="Permalink to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_remove_all([1, 2, 2, 3, 2,
1, 4], 2);
+--------------------------------------------------+
| array_remove_all(List([1,2,2,3,2,1,4]),Int64(2)) |
@@ -4540,6 +4708,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
+<section id="id116">
+<h4>Aliases<a class="headerlink" href="#id116" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>list_remove_all</p></li>
+</ul>
+</section>
</section>
<section id="array-replace">
<h3><code class="docutils literal notranslate"><span
class="pre">array_replace</span></code><a class="headerlink"
href="#array-replace" title="Permalink to this heading">¶</a></h3>
@@ -4547,8 +4721,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="id111">
-<h4>Arguments<a class="headerlink" href="#id111" 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>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -4556,8 +4730,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<li><p><strong>to</strong>: Final element.</p></li>
</ul>
</section>
-<section id="id112">
-<h4>Example<a class="headerlink" href="#id112" title="Permalink to this
heading">¶</a></h4>
+<section id="id118">
+<h4>Example<a class="headerlink" href="#id118" title="Permalink to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_replace([1, 2, 2, 3, 2, 1,
4], 2, 5);
+--------------------------------------------------------+
| array_replace(List([1,2,2,3,2,1,4]),Int64(2),Int64(5)) |
@@ -4567,6 +4741,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
+<section id="id119">
+<h4>Aliases<a class="headerlink" href="#id119" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>list_replace</p></li>
+</ul>
+</section>
</section>
<section id="array-replace-n">
<h3><code class="docutils literal notranslate"><span
class="pre">array_replace_n</span></code><a class="headerlink"
href="#array-replace-n" title="Permalink to this heading">¶</a></h3>
@@ -4574,8 +4754,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_n</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> <span class="nb">max</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id113">
-<h4>Arguments<a class="headerlink" href="#id113" 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>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -4584,8 +4764,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<li><p><strong>max</strong>: Number of first occurrences to replace.</p></li>
</ul>
</section>
-<section id="id114">
-<h4>Example<a class="headerlink" href="#id114" title="Permalink to this
heading">¶</a></h4>
+<section id="id121">
+<h4>Example<a class="headerlink" href="#id121" title="Permalink to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_replace_n([1, 2, 2, 3, 2, 1,
4], 2, 5, 2);
+-------------------------------------------------------------------+
| array_replace_n(List([1,2,2,3,2,1,4]),Int64(2),Int64(5),Int64(2)) |
@@ -4595,6 +4775,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
+<section id="id122">
+<h4>Aliases<a class="headerlink" href="#id122" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>list_replace_n</p></li>
+</ul>
+</section>
</section>
<section id="array-replace-all">
<h3><code class="docutils literal notranslate"><span
class="pre">array_replace_all</span></code><a class="headerlink"
href="#array-replace-all" title="Permalink to this heading">¶</a></h3>
@@ -4602,8 +4788,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_all</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="id115">
-<h4>Arguments<a class="headerlink" href="#id115" 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>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -4611,8 +4797,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<li><p><strong>to</strong>: Final element.</p></li>
</ul>
</section>
-<section id="id116">
-<h4>Example<a class="headerlink" href="#id116" title="Permalink to this
heading">¶</a></h4>
+<section id="id124">
+<h4>Example<a class="headerlink" href="#id124" title="Permalink to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_replace_all([1, 2, 2, 3, 2,
1, 4], 2, 5);
+------------------------------------------------------------+
| array_replace_all(List([1,2,2,3,2,1,4]),Int64(2),Int64(5)) |
@@ -4622,6 +4808,36 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
+<section id="id125">
+<h4>Aliases<a class="headerlink" href="#id125" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>list_replace_all</p></li>
+</ul>
+</section>
+</section>
+<section id="array-slice">
+<h3><code class="docutils literal notranslate"><span
class="pre">array_slice</span></code><a class="headerlink" href="#array-slice"
title="Permalink to this heading">¶</a></h3>
+<p>Returns a slice of the array.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_slice</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">begin</span><span class="p">,</span> <span class="n">end</span><span
class="p">)</span>
+</pre></div>
+</div>
+<section id="id126">
+<h4>Example<a class="headerlink" href="#id126" title="Permalink to this
heading">¶</a></h4>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_slice([1, 2, 3, 4, 5, 6, 7,
8], 3, 6);
++--------------------------------------------------------+
+| array_slice(List([1,2,3,4,5,6,7,8]),Int64(3),Int64(6)) |
++--------------------------------------------------------+
+| [3, 4, 5, 6] |
++--------------------------------------------------------+
+</pre></div>
+</div>
+</section>
+<section id="id127">
+<h4>Aliases<a class="headerlink" href="#id127" title="Permalink to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>list_slice</p></li>
+</ul>
+</section>
</section>
<section id="array-to-string">
<h3><code class="docutils literal notranslate"><span
class="pre">array_to_string</span></code><a class="headerlink"
href="#array-to-string" title="Permalink to this heading">¶</a></h3>
@@ -4629,16 +4845,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="id117">
-<h4>Arguments<a class="headerlink" href="#id117" title="Permalink to this
heading">¶</a></h4>
+<section id="id128">
+<h4>Arguments<a class="headerlink" href="#id128" 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="id118">
-<h4>Example<a class="headerlink" href="#id118" title="Permalink to this
heading">¶</a></h4>
+<section id="id129">
+<h4>Example<a class="headerlink" href="#id129" 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(",")) |
@@ -4648,8 +4864,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id119">
-<h4>Aliases<a class="headerlink" href="#id119" title="Permalink to this
heading">¶</a></h4>
+<section id="id130">
+<h4>Aliases<a class="headerlink" href="#id130" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_join</p></li>
<li><p>list_join</p></li>
@@ -4663,15 +4879,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="id120">
-<h4>Arguments<a class="headerlink" href="#id120" title="Permalink to this
heading">¶</a></h4>
+<section id="id131">
+<h4>Arguments<a class="headerlink" href="#id131" 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="id121">
-<h4>Example<a class="headerlink" href="#id121" title="Permalink to this
heading">¶</a></h4>
+<section id="id132">
+<h4>Example<a class="headerlink" href="#id132" 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])) |
@@ -4698,6 +4914,14 @@ Can be a constant, column, or function, and any
combination of array operators.<
<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-element">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_element</span></code><a class="headerlink"
href="#list-element" title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-element">array_element</a>.</em></p>
+</section>
+<section id="list-extract">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_extract</span></code><a class="headerlink"
href="#list-extract" title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-element">array_element</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>
@@ -4758,6 +4982,10 @@ Can be a constant, column, or function, and any
combination of array operators.<
<h3><code class="docutils literal notranslate"><span
class="pre">list_replace_all</span></code><a class="headerlink"
href="#list-replace-all" title="Permalink to this heading">¶</a></h3>
<p><em>Alias of <a class="reference internal"
href="#array-replace-all">array_replace_all</a>.</em></p>
</section>
+<section id="list-slice">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_slice</span></code><a class="headerlink" href="#list-slice"
title="Permalink to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-slice">array_slice</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>
@@ -4768,16 +4996,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="id122">
-<h4>Arguments<a class="headerlink" href="#id122" title="Permalink to this
heading">¶</a></h4>
+<section id="id133">
+<h4>Arguments<a class="headerlink" href="#id133" 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="id123">
-<h4>Example<a class="headerlink" href="#id123" title="Permalink to this
heading">¶</a></h4>
+<section id="id134">
+<h4>Example<a class="headerlink" href="#id134" 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)) |
@@ -4787,8 +5015,8 @@ string operators.</p></li>
</pre></div>
</div>
</section>
-<section id="id124">
-<h4>Aliases<a class="headerlink" href="#id124" title="Permalink to this
heading">¶</a></h4>
+<section id="id135">
+<h4>Aliases<a class="headerlink" href="#id135" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>make_list</p></li>
</ul>
@@ -4801,11 +5029,12 @@ string operators.</p></li>
<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>
<p>Removes the last n elements from the array.</p>
+<p>DEPRECATED: use <code class="docutils literal notranslate"><span
class="pre">array_slice</span></code> instead!</p>
<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="id125">
-<h4>Arguments<a class="headerlink" href="#id125" title="Permalink to this
heading">¶</a></h4>
+<section id="id136">
+<h4>Arguments<a class="headerlink" href="#id136" 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>
@@ -4846,8 +5075,8 @@ a struct type of fields <code class="docutils literal
notranslate"><span class="
+-----------------+
</pre></div>
</div>
-<section id="id126">
-<h4>Arguments<a class="headerlink" href="#id126" title="Permalink to this
heading">¶</a></h4>
+<section id="id137">
+<h4>Arguments<a class="headerlink" href="#id137" 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
@@ -4872,8 +5101,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="id127">
-<h4>Arguments<a class="headerlink" href="#id127" title="Permalink to this
heading">¶</a></h4>
+<section id="id138">
+<h4>Arguments<a class="headerlink" href="#id138" 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>
@@ -4899,8 +5128,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="id128">
-<h4>Arguments<a class="headerlink" href="#id128" title="Permalink to this
heading">¶</a></h4>
+<section id="id139">
+<h4>Arguments<a class="headerlink" href="#id139" 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>
@@ -4913,8 +5142,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="id129">
-<h4>Arguments<a class="headerlink" href="#id129" title="Permalink to this
heading">¶</a></h4>
+<section id="id140">
+<h4>Arguments<a class="headerlink" href="#id140" 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>
@@ -4927,8 +5156,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="id130">
-<h4>Arguments<a class="headerlink" href="#id130" title="Permalink to this
heading">¶</a></h4>
+<section id="id141">
+<h4>Arguments<a class="headerlink" href="#id141" 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>
@@ -4941,8 +5170,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="id131">
-<h4>Arguments<a class="headerlink" href="#id131" title="Permalink to this
heading">¶</a></h4>
+<section id="id142">
+<h4>Arguments<a class="headerlink" href="#id142" 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>
@@ -4955,8 +5184,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="id132">
-<h4>Arguments<a class="headerlink" href="#id132" title="Permalink to this
heading">¶</a></h4>
+<section id="id143">
+<h4>Arguments<a class="headerlink" href="#id143" 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>
@@ -4976,8 +5205,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="id133">
-<h4>Arguments<a class="headerlink" href="#id133" title="Permalink to this
heading">¶</a></h4>
+<section id="id144">
+<h4>Arguments<a class="headerlink" href="#id144" 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
@@ -4993,8 +5222,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="id134">
-<h4>Arguments<a class="headerlink" href="#id134" title="Permalink to this
heading">¶</a></h4>
+<section id="id145">
+<h4>Arguments<a class="headerlink" href="#id145" 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
