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 771dd53565 Publish built docs triggered by
ee59dcc730ce6dda2340cde31a6168ff7a5e9c7a
771dd53565 is described below
commit 771dd5356546f2d23c65c6fe7e511bff7bef1fc1
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Wed Aug 9 17:14:42 2023 +0000
Publish built docs triggered by ee59dcc730ce6dda2340cde31a6168ff7a5e9c7a
---
_sources/user-guide/expressions.md.txt | 1 +
_sources/user-guide/sql/scalar_functions.md.txt | 18 ++
searchindex.js | 2 +-
user-guide/expressions.html | 37 +--
user-guide/sql/scalar_functions.html | 365 +++++++++++++-----------
5 files changed, 240 insertions(+), 183 deletions(-)
diff --git a/_sources/user-guide/expressions.md.txt
b/_sources/user-guide/expressions.md.txt
index a04f43fd4b..88a5a73a6d 100644
--- a/_sources/user-guide/expressions.md.txt
+++ b/_sources/user-guide/expressions.md.txt
@@ -188,6 +188,7 @@ Unlike to some databases the math functions in Datafusion
works the same way as
| 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`
|
+| flatten(array) | Converts an array of arrays to a
flat array `flatten([[1], [2, 3], [4, 5, 6]]) -> [1, 2, 3, 4, 5, 6]`
|
| 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`
|
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index dec120db18..9bcf2ae0b0 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -1685,6 +1685,24 @@ array_fill(element, array)
Can be a constant, column, or function, and any combination of array
operators.
- **element**: Element to copy to the array.
+### `flatten`
+
+Converts an array of arrays to a flat array
+
+- Applies to any depth of nested arrays
+- Does not change arrays that are already flat
+
+The flattened array contains all the elements from all source arrays.
+
+#### Arguments
+
+- **array**: Array expression
+ Can be a constant, column, or function, and any combination of array
operators.
+
+```
+flatten(array)
+```
+
### `array_indexof`
_Alias of [array_position](#array_position)._
diff --git a/searchindex.js b/searchindex.js
index e74b1d83ee..b1e23bba1f 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 9e28268453..06a9a56bd9 100644
--- a/user-guide/expressions.html
+++ b/user-guide/expressions.html
@@ -833,55 +833,58 @@ expressions such as <code class="docutils literal
notranslate"><span class="pre"
<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_length(array, dimension)</p></td>
+<tr class="row-odd"><td><p>flatten(array)</p></td>
+<td><p>Converts an array of arrays to a flat array <code class="docutils
literal notranslate"><span class="pre">flatten([[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_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_repeat(element, count)</p></td>
+<tr class="row-odd"><td><p>array_repeat(element, count)</p></td>
<td><p>Returns an array containing element <code class="docutils literal
notranslate"><span class="pre">count</span></code> times. <code class="docutils
literal notranslate"><span class="pre">array_repeat(1,</span> <span
class="pre">3)</span> <span class="pre">-></span> <span
class="pre">[1,</span> <span class="pre">1,</span> <span
class="pre">1]</span></code></p></td>
</tr>
-<tr class="row-odd"><td><p>array_remove(array, element)</p></td>
+<tr class="row-even"><td><p>array_remove(array, element)</p></td>
<td><p>Removes 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-even"><td><p>array_remove_n(array, element, max)</p></td>
+<tr class="row-odd"><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-odd"><td><p>array_remove_all(array, element)</p></td>
+<tr class="row-even"><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-even"><td><p>array_replace(array, from, to)</p></td>
+<tr class="row-odd"><td><p>array_replace(array, from, to)</p></td>
<td><p>Replaces 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-odd"><td><p>array_replace_n(array, from, to, max)</p></td>
+<tr class="row-even"><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-even"><td><p>array_replace_all(array, from, to)</p></td>
+<tr class="row-odd"><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>
+<tr class="row-even"><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>
+<tr class="row-odd"><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>
-<tr class="row-odd"><td><p>cardinality(array)</p></td>
+<tr class="row-even"><td><p>cardinality(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>
+<tr class="row-odd"><td><p>make_array(value1, [value2 [, …]])</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>
+<tr class="row-even"><td><p>trim_array(array, n)</p></td>
<td><p>Deprecated</p></td>
</tr>
</tbody>
diff --git a/user-guide/sql/scalar_functions.html
b/user-guide/sql/scalar_functions.html
index b0df2c60dd..5c68f09bfd 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -1826,6 +1826,22 @@
</li>
</ul>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#flatten">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ flatten
+ </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="#id93">
+ 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">
@@ -1854,17 +1870,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="#id94">
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="#id95">
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="#id96">
Aliases
</a>
</li>
@@ -1880,17 +1896,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="#id97">
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="#id98">
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="#id99">
Aliases
</a>
</li>
@@ -1906,17 +1922,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="#id100">
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="#id101">
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="#id102">
Aliases
</a>
</li>
@@ -1932,17 +1948,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="#id103">
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="#id104">
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="#id105">
Aliases
</a>
</li>
@@ -1958,17 +1974,17 @@
</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="#id106">
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="#id107">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id107">
+ <a class="reference internal nav-link" href="#id108">
Aliases
</a>
</li>
@@ -2002,12 +2018,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id108">
+ <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="#id109">
+ <a class="reference internal nav-link" href="#id110">
Example
</a>
</li>
@@ -2023,17 +2039,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id110">
+ <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="#id111">
+ <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="#id112">
+ <a class="reference internal nav-link" href="#id113">
Aliases
</a>
</li>
@@ -2049,17 +2065,17 @@
</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="#id114">
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="#id115">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id115">
+ <a class="reference internal nav-link" href="#id116">
Aliases
</a>
</li>
@@ -2075,17 +2091,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id116">
+ <a class="reference internal nav-link" href="#id117">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id117">
+ <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="#id118">
+ <a class="reference internal nav-link" href="#id119">
Aliases
</a>
</li>
@@ -2101,17 +2117,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id119">
+ <a class="reference internal nav-link" href="#id120">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id120">
+ <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="#id121">
+ <a class="reference internal nav-link" href="#id122">
Aliases
</a>
</li>
@@ -2127,17 +2143,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="#id123">
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="#id124">
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="#id125">
Aliases
</a>
</li>
@@ -2153,17 +2169,17 @@
</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="#id126">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id126">
+ <a class="reference internal nav-link" href="#id127">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id127">
+ <a class="reference internal nav-link" href="#id128">
Aliases
</a>
</li>
@@ -2179,12 +2195,12 @@
</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="#id129">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id129">
+ <a class="reference internal nav-link" href="#id130">
Aliases
</a>
</li>
@@ -2200,17 +2216,17 @@
</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="#id131">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id131">
+ <a class="reference internal nav-link" href="#id132">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id132">
+ <a class="reference internal nav-link" href="#id133">
Aliases
</a>
</li>
@@ -2226,12 +2242,12 @@
</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="#id134">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id134">
+ <a class="reference internal nav-link" href="#id135">
Example
</a>
</li>
@@ -2463,17 +2479,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id135">
+ <a class="reference internal nav-link" href="#id136">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id136">
+ <a class="reference internal nav-link" href="#id137">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id137">
+ <a class="reference internal nav-link" href="#id138">
Aliases
</a>
</li>
@@ -2498,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="#id138">
+ <a class="reference internal nav-link" href="#id139">
Arguments
</a>
</li>
@@ -2521,7 +2537,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id139">
+ <a class="reference internal nav-link" href="#id140">
Arguments
</a>
</li>
@@ -2544,7 +2560,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id140">
+ <a class="reference internal nav-link" href="#id141">
Arguments
</a>
</li>
@@ -2560,7 +2576,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id141">
+ <a class="reference internal nav-link" href="#id142">
Arguments
</a>
</li>
@@ -2576,7 +2592,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id142">
+ <a class="reference internal nav-link" href="#id143">
Arguments
</a>
</li>
@@ -2592,7 +2608,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id143">
+ <a class="reference internal nav-link" href="#id144">
Arguments
</a>
</li>
@@ -2608,7 +2624,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id144">
+ <a class="reference internal nav-link" href="#id145">
Arguments
</a>
</li>
@@ -2624,7 +2640,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id145">
+ <a class="reference internal nav-link" href="#id146">
Arguments
</a>
</li>
@@ -2647,7 +2663,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id146">
+ <a class="reference internal nav-link" href="#id147">
Arguments
</a>
</li>
@@ -2663,7 +2679,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id147">
+ <a class="reference internal nav-link" href="#id148">
Arguments
</a>
</li>
@@ -4469,6 +4485,25 @@ Can be a constant, column, or function, and any
combination of array operators.<
</ul>
</section>
</section>
+<section id="flatten">
+<h3><code class="docutils literal notranslate"><span
class="pre">flatten</span></code><a class="headerlink" href="#flatten"
title="Permalink to this heading">¶</a></h3>
+<p>Converts an array of arrays to a flat array</p>
+<ul class="simple">
+<li><p>Applies to any depth of nested arrays</p></li>
+<li><p>Does not change arrays that are already flat</p></li>
+</ul>
+<p>The flattened array contains all the elements from all source arrays.</p>
+<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>
+</ul>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">flatten</span><span
class="p">(</span><span class="n">array</span><span class="p">)</span>
+</pre></div>
+</div>
+</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>
@@ -4483,16 +4518,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="id93">
-<h4>Arguments<a class="headerlink" href="#id93" title="Permalink to this
heading">¶</a></h4>
+<section id="id94">
+<h4>Arguments<a class="headerlink" href="#id94" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>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="id94">
-<h4>Example<a class="headerlink" href="#id94" title="Permalink to this
heading">¶</a></h4>
+<section id="id95">
+<h4>Example<a class="headerlink" href="#id95" 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])) |
@@ -4502,8 +4537,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="id96">
+<h4>Aliases<a class="headerlink" href="#id96" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_length</p></li>
</ul>
@@ -4515,15 +4550,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="id96">
-<h4>Arguments<a class="headerlink" href="#id96" title="Permalink to this
heading">¶</a></h4>
+<section id="id97">
+<h4>Arguments<a class="headerlink" href="#id97" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>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="id98">
+<h4>Example<a class="headerlink" href="#id98" 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])) |
@@ -4533,8 +4568,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="id99">
+<h4>Aliases<a class="headerlink" href="#id99" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_ndims</p></li>
</ul>
@@ -4546,16 +4581,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="id99">
-<h4>Arguments<a class="headerlink" href="#id99" title="Permalink to this
heading">¶</a></h4>
+<section id="id100">
+<h4>Arguments<a class="headerlink" href="#id100" 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="id100">
-<h4>Example<a class="headerlink" href="#id100" title="Permalink to this
heading">¶</a></h4>
+<section id="id101">
+<h4>Example<a class="headerlink" href="#id101" 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])) |
@@ -4565,8 +4600,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="id102">
+<h4>Aliases<a class="headerlink" href="#id102" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_push_front</p></li>
<li><p>list_prepend</p></li>
@@ -4581,8 +4616,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="id102">
-<h4>Arguments<a class="headerlink" href="#id102" 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>
@@ -4590,8 +4625,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="id103">
-<h4>Example<a class="headerlink" href="#id103" title="Permalink to this
heading">¶</a></h4>
+<section id="id104">
+<h4>Example<a class="headerlink" href="#id104" 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)) |
@@ -4601,8 +4636,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="id105">
+<h4>Aliases<a class="headerlink" href="#id105" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_indexof</p></li>
<li><p>list_indexof</p></li>
@@ -4616,16 +4651,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="id105">
-<h4>Arguments<a class="headerlink" href="#id105" title="Permalink to this
heading">¶</a></h4>
+<section id="id106">
+<h4>Arguments<a class="headerlink" href="#id106" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
<li><p><strong>element</strong>: Element to search for positions in 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="id107">
+<h4>Example<a class="headerlink" href="#id107" title="Permalink to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_positions([1, 2, 2, 3, 1,
4], 2);
+-----------------------------------------------+
| array_positions(List([1,2,2,3,1,4]),Int64(2)) |
@@ -4635,8 +4670,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id107">
-<h4>Aliases<a class="headerlink" href="#id107" title="Permalink to this
heading">¶</a></h4>
+<section id="id108">
+<h4>Aliases<a class="headerlink" href="#id108" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_positions</p></li>
</ul>
@@ -4656,16 +4691,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_repeat</span><span
class="p">(</span><span class="n">element</span><span class="p">,</span> <span
class="n">count</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id108">
-<h4>Arguments<a class="headerlink" href="#id108" 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>element</strong>: Element expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
<li><p><strong>count</strong>: Value of how many times to repeat the
element.</p></li>
</ul>
</section>
-<section id="id109">
-<h4>Example<a class="headerlink" href="#id109" title="Permalink to this
heading">¶</a></h4>
+<section id="id110">
+<h4>Example<a class="headerlink" href="#id110" title="Permalink to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_repeat(1, 3);
+---------------------------------+
| array_repeat(Int64(1),Int64(3)) |
@@ -4690,16 +4725,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="id110">
-<h4>Arguments<a class="headerlink" href="#id110" 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>
<li><p><strong>element</strong>: Element to be removed from the array.</p></li>
</ul>
</section>
-<section id="id111">
-<h4>Example<a class="headerlink" href="#id111" 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([1, 2, 2, 3, 2, 1,
4], 2);
+----------------------------------------------+
| array_remove(List([1,2,2,3,2,1,4]),Int64(2)) |
@@ -4709,8 +4744,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id112">
-<h4>Aliases<a class="headerlink" href="#id112" title="Permalink to this
heading">¶</a></h4>
+<section id="id113">
+<h4>Aliases<a class="headerlink" href="#id113" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove</p></li>
</ul>
@@ -4722,8 +4757,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="id113">
-<h4>Arguments<a class="headerlink" href="#id113" 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>
@@ -4731,8 +4766,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="id114">
-<h4>Example<a class="headerlink" href="#id114" 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_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)) |
@@ -4742,8 +4777,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id115">
-<h4>Aliases<a class="headerlink" href="#id115" title="Permalink to this
heading">¶</a></h4>
+<section id="id116">
+<h4>Aliases<a class="headerlink" href="#id116" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove_n</p></li>
</ul>
@@ -4755,16 +4790,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="id116">
-<h4>Arguments<a class="headerlink" href="#id116" 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>
<li><p><strong>element</strong>: Element to be removed from the array.</p></li>
</ul>
</section>
-<section id="id117">
-<h4>Example<a class="headerlink" href="#id117" 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_remove_all([1, 2, 2, 3, 2,
1, 4], 2);
+--------------------------------------------------+
| array_remove_all(List([1,2,2,3,2,1,4]),Int64(2)) |
@@ -4774,8 +4809,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id118">
-<h4>Aliases<a class="headerlink" href="#id118" title="Permalink to this
heading">¶</a></h4>
+<section id="id119">
+<h4>Aliases<a class="headerlink" href="#id119" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove_all</p></li>
</ul>
@@ -4787,8 +4822,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="id119">
-<h4>Arguments<a class="headerlink" href="#id119" 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>
@@ -4796,8 +4831,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="id120">
-<h4>Example<a class="headerlink" href="#id120" 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([1, 2, 2, 3, 2, 1,
4], 2, 5);
+--------------------------------------------------------+
| array_replace(List([1,2,2,3,2,1,4]),Int64(2),Int64(5)) |
@@ -4807,8 +4842,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id121">
-<h4>Aliases<a class="headerlink" href="#id121" title="Permalink to this
heading">¶</a></h4>
+<section id="id122">
+<h4>Aliases<a class="headerlink" href="#id122" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace</p></li>
</ul>
@@ -4820,8 +4855,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="id122">
-<h4>Arguments<a class="headerlink" href="#id122" 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>
@@ -4830,8 +4865,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="id123">
-<h4>Example<a class="headerlink" href="#id123" 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_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)) |
@@ -4841,8 +4876,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id124">
-<h4>Aliases<a class="headerlink" href="#id124" title="Permalink to this
heading">¶</a></h4>
+<section id="id125">
+<h4>Aliases<a class="headerlink" href="#id125" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace_n</p></li>
</ul>
@@ -4854,8 +4889,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="id125">
-<h4>Arguments<a class="headerlink" href="#id125" title="Permalink to this
heading">¶</a></h4>
+<section id="id126">
+<h4>Arguments<a class="headerlink" href="#id126" 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>
@@ -4863,8 +4898,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="id126">
-<h4>Example<a class="headerlink" href="#id126" title="Permalink to this
heading">¶</a></h4>
+<section id="id127">
+<h4>Example<a class="headerlink" href="#id127" 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)) |
@@ -4874,8 +4909,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id127">
-<h4>Aliases<a class="headerlink" href="#id127" title="Permalink to this
heading">¶</a></h4>
+<section id="id128">
+<h4>Aliases<a class="headerlink" href="#id128" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace_all</p></li>
</ul>
@@ -4887,8 +4922,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_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="id128">
-<h4>Example<a class="headerlink" href="#id128" 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_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)) |
@@ -4898,8 +4933,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id129">
-<h4>Aliases<a class="headerlink" href="#id129" 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>list_slice</p></li>
</ul>
@@ -4911,16 +4946,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="id130">
-<h4>Arguments<a class="headerlink" href="#id130" 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>
<li><p><strong>delimeter</strong>: Array element separator.</p></li>
</ul>
</section>
-<section id="id131">
-<h4>Example<a class="headerlink" href="#id131" 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 array_to_string([[1, 2, 3, 4], [5,
6, 7, 8]], ',');
+----------------------------------------------------+
| array_to_string(List([1,2,3,4,5,6,7,8]),Utf8(",")) |
@@ -4930,8 +4965,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id132">
-<h4>Aliases<a class="headerlink" href="#id132" title="Permalink to this
heading">¶</a></h4>
+<section id="id133">
+<h4>Aliases<a class="headerlink" href="#id133" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_join</p></li>
<li><p>list_join</p></li>
@@ -4945,15 +4980,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="id133">
-<h4>Arguments<a class="headerlink" href="#id133" title="Permalink to this
heading">¶</a></h4>
+<section id="id134">
+<h4>Arguments<a class="headerlink" href="#id134" 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="id134">
-<h4>Example<a class="headerlink" href="#id134" title="Permalink to this
heading">¶</a></h4>
+<section id="id135">
+<h4>Example<a class="headerlink" href="#id135" 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])) |
@@ -5066,16 +5101,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="id135">
-<h4>Arguments<a class="headerlink" href="#id135" 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>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="id136">
-<h4>Example<a class="headerlink" href="#id136" title="Permalink to this
heading">¶</a></h4>
+<section id="id137">
+<h4>Example<a class="headerlink" href="#id137" 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)) |
@@ -5085,8 +5120,8 @@ string operators.</p></li>
</pre></div>
</div>
</section>
-<section id="id137">
-<h4>Aliases<a class="headerlink" href="#id137" title="Permalink to this
heading">¶</a></h4>
+<section id="id138">
+<h4>Aliases<a class="headerlink" href="#id138" title="Permalink to this
heading">¶</a></h4>
<ul class="simple">
<li><p>make_list</p></li>
</ul>
@@ -5103,8 +5138,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="id138">
-<h4>Arguments<a class="headerlink" href="#id138" 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>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5145,8 +5180,8 @@ a struct type of fields <code class="docutils literal
notranslate"><span class="
+-----------------+
</pre></div>
</div>
-<section id="id139">
-<h4>Arguments<a class="headerlink" href="#id139" 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_n</strong>: Expression to include in the output
struct.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -5171,8 +5206,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="id140">
-<h4>Arguments<a class="headerlink" href="#id140" 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>
@@ -5198,8 +5233,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="id141">
-<h4>Arguments<a class="headerlink" href="#id141" 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>
@@ -5212,8 +5247,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="id142">
-<h4>Arguments<a class="headerlink" href="#id142" 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>
@@ -5226,8 +5261,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="id143">
-<h4>Arguments<a class="headerlink" href="#id143" 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>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -5240,8 +5275,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="id144">
-<h4>Arguments<a class="headerlink" href="#id144" 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>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -5254,8 +5289,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="id145">
-<h4>Arguments<a class="headerlink" href="#id145" title="Permalink to this
heading">¶</a></h4>
+<section id="id146">
+<h4>Arguments<a class="headerlink" href="#id146" 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>
@@ -5275,8 +5310,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="id146">
-<h4>Arguments<a class="headerlink" href="#id146" title="Permalink to this
heading">¶</a></h4>
+<section id="id147">
+<h4>Arguments<a class="headerlink" href="#id147" 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
@@ -5292,8 +5327,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="id147">
-<h4>Arguments<a class="headerlink" href="#id147" title="Permalink to this
heading">¶</a></h4>
+<section id="id148">
+<h4>Arguments<a class="headerlink" href="#id148" 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
