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 8ce26d7bc8 Publish built docs triggered by
9d0c05b9c2e5f9e774ab1ea08599ac8d4b23c93f
8ce26d7bc8 is described below
commit 8ce26d7bc804f1726957300a7ecd1242b815b1cd
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Thu Mar 14 12:06:49 2024 +0000
Publish built docs triggered by 9d0c05b9c2e5f9e774ab1ea08599ac8d4b23c93f
---
_sources/user-guide/expressions.md.txt | 2 +-
_sources/user-guide/sql/scalar_functions.md.txt | 36 ++
searchindex.js | 2 +-
user-guide/expressions.html | 2 +-
user-guide/sql/scalar_functions.html | 720 +++++++++++++-----------
5 files changed, 436 insertions(+), 326 deletions(-)
diff --git a/_sources/user-guide/expressions.md.txt
b/_sources/user-guide/expressions.md.txt
index 05eb063c3d..8a1d822143 100644
--- a/_sources/user-guide/expressions.md.txt
+++ b/_sources/user-guide/expressions.md.txt
@@ -238,7 +238,7 @@ select log(-1), log(0), sqrt(-1);
| array_intersect(array1, array2) | Returns an array of the
elements in the intersection of array1 and array2. `array_intersect([1, 2, 3,
4], [5, 6, 3, 4]) -> [3, 4]`
|
| array_union(array1, array2) | Returns an array of the
elements in the union of array1 and array2 without duplicates. `array_union([1,
2, 3, 4], [5, 6, 3, 4]) -> [1, 2, 3, 4, 5, 6]`
|
| array_except(array1, array2) | Returns an array of the
elements that appear in the first array but not in the second.
`array_except([1, 2, 3, 4], [5, 6, 3, 4]) -> [3, 4]`
|
-| array_resize(array, size, value) | Resizes the list to contain
size elements. Initializes new elements with value or empty if value is not
set. `array_resize([1, 2, 3], 5, 0) -> [1, 2, 3, 4, 5, 6]`
|
+| array_resize(array, size, value) | Resizes the list to contain
size elements. Initializes new elements with value or empty if value is not
set. `array_resize([1, 2, 3], 5, 0) -> [1, 2, 3, 0, 0]`
|
| array_sort(array, desc, null_first) | Returns sorted array.
`array_sort([3, 1, 2, 5, 4]) -> [1, 2, 3, 4, 5]`
|
| 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]`
|
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index 420de5f3fd..cb26472abb 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -1969,6 +1969,7 @@ from_unixtime(expression)
- [array_push_back](#array_push_back)
- [array_push_front](#array_push_front)
- [array_repeat](#array_repeat)
+- [array_resize](#array_resize)
- [array_remove](#array_remove)
- [array_remove_n](#array_remove_n)
- [array_remove_all](#array_remove_all)
@@ -2006,6 +2007,7 @@ from_unixtime(expression)
- [list_push_back](#list_push_back)
- [list_push_front](#list_push_front)
- [list_repeat](#list_repeat)
+- [list_resize](#list_resize)
- [list_remove](#list_remove)
- [list_remove_n](#list_remove_n)
- [list_remove_all](#list_remove_all)
@@ -2082,6 +2084,36 @@ array_sort(array, desc, nulls_first)
- list_sort
+### `array_resize`
+
+Resizes the list to contain size elements. Initializes new elements with value
or empty if value is not set.
+
+```
+array_resize(array, size, value)
+```
+
+#### Arguments
+
+- **array**: Array expression.
+ Can be a constant, column, or function, and any combination of array
operators.
+- **size**: New size of given array.
+- **value**: Defines new elements' value or empty if value is not set.
+
+#### Example
+
+```
+❯ select array_resize([1, 2, 3], 5, 0);
++-------------------------------------+
+| array_resize(List([1,2,3],5,0)) |
++-------------------------------------+
+| [1, 2, 3, 0, 0] |
++-------------------------------------+
+```
+
+#### Aliases
+
+- list_resize
+
### `array_cat`
_Alias of [array_concat](#array_concat)._
@@ -3071,6 +3103,10 @@ _Alias of [array_prepend](#array_prepend)._
_Alias of [array_repeat](#array_repeat)._
+### `list_resize`
+
+_Alias of [array_resize](#array_resize)._
+
### `list_remove`
_Alias of [array_remove](#array_remove)._
diff --git a/searchindex.js b/searchindex.js
index 42cee4b746..d9a77d3c77 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",
"library-user-guide/adding-udfs", "library-user-guide/building-logical-plans",
"library-user-guide/catalogs", "library-user-guide/custom-tab [...]
\ 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",
"library-user-guide/adding-udfs", "library-user-guide/building-logical-plans",
"library-user-guide/catalogs", "library-user-guide/custom-tab [...]
\ No newline at end of file
diff --git a/user-guide/expressions.html b/user-guide/expressions.html
index a5859d5b6c..900ff93ea6 100644
--- a/user-guide/expressions.html
+++ b/user-guide/expressions.html
@@ -1007,7 +1007,7 @@ but these operators always return a <code class="docutils
literal notranslate"><
<td><p>Returns an array of the elements that appear in the first array but not
in the second. <code class="docutils literal notranslate"><span
class="pre">array_except([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">3,</span> <span
class="pre">4])</span> <span class="pre">-></span> <span
class="pre">[3,</span> <span class="pre">4]</span></code></p></td>
</tr>
<tr class="row-odd"><td><p>array_resize(array, size, value)</p></td>
-<td><p>Resizes the list to contain size elements. Initializes new elements
with value or empty if value is not set. <code class="docutils literal
notranslate"><span class="pre">array_resize([1,</span> <span
class="pre">2,</span> <span class="pre">3],</span> <span class="pre">5,</span>
<span class="pre">0)</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 [...]
+<td><p>Resizes the list to contain size elements. Initializes new elements
with value or empty if value is not set. <code class="docutils literal
notranslate"><span class="pre">array_resize([1,</span> <span
class="pre">2,</span> <span class="pre">3],</span> <span class="pre">5,</span>
<span class="pre">0)</span> <span class="pre">-></span> <span
class="pre">[1,</span> <span class="pre">2,</span> <span class="pre">3,</span>
<span class="pre">0,</span> <span class="pre">0]</span></code> [...]
</tr>
<tr class="row-even"><td><p>array_sort(array, desc, null_first)</p></td>
<td><p>Returns sorted array. <code class="docutils literal notranslate"><span
class="pre">array_sort([3,</span> <span class="pre">1,</span> <span
class="pre">2,</span> <span class="pre">5,</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>
<span class="pre">5]</span></code></p></td>
diff --git a/user-guide/sql/scalar_functions.html
b/user-guide/sql/scalar_functions.html
index 61705fddce..96e343b2dc 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -2091,6 +2091,32 @@
</li>
</ul>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#array-resize">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ array_resize
+ </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="#id111">
+ Arguments
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <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">
<a class="reference internal nav-link" href="#array-cat">
<code class="docutils literal notranslate">
@@ -2110,17 +2136,17 @@
</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="#id114">
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="#id115">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id113">
+ <a class="reference internal nav-link" href="#id116">
Aliases
</a>
</li>
@@ -2145,12 +2171,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id114">
+ <a class="reference internal nav-link" href="#id117">
Arguments
</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="#id118">
Aliases
</a>
</li>
@@ -2166,12 +2192,12 @@
</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="#id119">
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="#id120">
Aliases
</a>
</li>
@@ -2187,12 +2213,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id118">
+ <a class="reference internal nav-link" href="#id121">
Arguments
</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="#id122">
Aliases
</a>
</li>
@@ -2208,17 +2234,17 @@
</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="#id123">
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="#id124">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id122">
+ <a class="reference internal nav-link" href="#id125">
Aliases
</a>
</li>
@@ -2234,17 +2260,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id123">
+ <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="#id124">
+ <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="#id125">
+ <a class="reference internal nav-link" href="#id128">
Aliases
</a>
</li>
@@ -2260,17 +2286,17 @@
</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="#id129">
Arguments
</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="#id130">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id128">
+ <a class="reference internal nav-link" href="#id131">
Aliases
</a>
</li>
@@ -2295,7 +2321,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="#id132">
Arguments
</a>
</li>
@@ -2311,7 +2337,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="#id133">
Arguments
</a>
</li>
@@ -2345,17 +2371,17 @@
</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="#id134">
Arguments
</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="#id135">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id133">
+ <a class="reference internal nav-link" href="#id136">
Aliases
</a>
</li>
@@ -2371,17 +2397,17 @@
</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="#id137">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id135">
+ <a class="reference internal nav-link" href="#id138">
Example
</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="#id139">
Aliases
</a>
</li>
@@ -2397,17 +2423,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id137">
+ <a class="reference internal nav-link" href="#id140">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id138">
+ <a class="reference internal nav-link" href="#id141">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id139">
+ <a class="reference internal nav-link" href="#id142">
Aliases
</a>
</li>
@@ -2423,17 +2449,17 @@
</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="#id143">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id141">
+ <a class="reference internal nav-link" href="#id144">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id142">
+ <a class="reference internal nav-link" href="#id145">
Aliases
</a>
</li>
@@ -2449,17 +2475,17 @@
</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="#id146">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id144">
+ <a class="reference internal nav-link" href="#id147">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id145">
+ <a class="reference internal nav-link" href="#id148">
Aliases
</a>
</li>
@@ -2475,17 +2501,17 @@
</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="#id149">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id147">
+ <a class="reference internal nav-link" href="#id150">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id148">
+ <a class="reference internal nav-link" href="#id151">
Aliases
</a>
</li>
@@ -2501,17 +2527,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id149">
+ <a class="reference internal nav-link" href="#id152">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id150">
+ <a class="reference internal nav-link" href="#id153">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id151">
+ <a class="reference internal nav-link" href="#id154">
Aliases
</a>
</li>
@@ -2545,17 +2571,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id152">
+ <a class="reference internal nav-link" href="#id155">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id153">
+ <a class="reference internal nav-link" href="#id156">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id154">
+ <a class="reference internal nav-link" href="#id157">
Aliases
</a>
</li>
@@ -2571,17 +2597,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id155">
+ <a class="reference internal nav-link" href="#id158">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id156">
+ <a class="reference internal nav-link" href="#id159">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id157">
+ <a class="reference internal nav-link" href="#id160">
Aliases
</a>
</li>
@@ -2597,17 +2623,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id158">
+ <a class="reference internal nav-link" href="#id161">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id159">
+ <a class="reference internal nav-link" href="#id162">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id160">
+ <a class="reference internal nav-link" href="#id163">
Aliases
</a>
</li>
@@ -2623,17 +2649,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id161">
+ <a class="reference internal nav-link" href="#id164">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id162">
+ <a class="reference internal nav-link" href="#id165">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id163">
+ <a class="reference internal nav-link" href="#id166">
Aliases
</a>
</li>
@@ -2649,17 +2675,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id164">
+ <a class="reference internal nav-link" href="#id167">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id165">
+ <a class="reference internal nav-link" href="#id168">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id166">
+ <a class="reference internal nav-link" href="#id169">
Aliases
</a>
</li>
@@ -2675,17 +2701,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id167">
+ <a class="reference internal nav-link" href="#id170">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id168">
+ <a class="reference internal nav-link" href="#id171">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id169">
+ <a class="reference internal nav-link" href="#id172">
Aliases
</a>
</li>
@@ -2701,17 +2727,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id170">
+ <a class="reference internal nav-link" href="#id173">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id171">
+ <a class="reference internal nav-link" href="#id174">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id172">
+ <a class="reference internal nav-link" href="#id175">
Aliases
</a>
</li>
@@ -2727,17 +2753,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id173">
+ <a class="reference internal nav-link" href="#id176">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id174">
+ <a class="reference internal nav-link" href="#id177">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id175">
+ <a class="reference internal nav-link" href="#id178">
Aliases
</a>
</li>
@@ -2753,17 +2779,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id176">
+ <a class="reference internal nav-link" href="#id179">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id177">
+ <a class="reference internal nav-link" href="#id180">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id178">
+ <a class="reference internal nav-link" href="#id181">
Aliases
</a>
</li>
@@ -2779,17 +2805,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id179">
+ <a class="reference internal nav-link" href="#id182">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id180">
+ <a class="reference internal nav-link" href="#id183">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id181">
+ <a class="reference internal nav-link" href="#id184">
Aliases
</a>
</li>
@@ -2805,17 +2831,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id182">
+ <a class="reference internal nav-link" href="#id185">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id183">
+ <a class="reference internal nav-link" href="#id186">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id184">
+ <a class="reference internal nav-link" href="#id187">
Aliases
</a>
</li>
@@ -2831,17 +2857,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id185">
+ <a class="reference internal nav-link" href="#id188">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id186">
+ <a class="reference internal nav-link" href="#id189">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id187">
+ <a class="reference internal nav-link" href="#id190">
Aliases
</a>
</li>
@@ -2857,12 +2883,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id188">
+ <a class="reference internal nav-link" href="#id191">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id189">
+ <a class="reference internal nav-link" href="#id192">
Example
</a>
</li>
@@ -2878,12 +2904,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id190">
+ <a class="reference internal nav-link" href="#id193">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id191">
+ <a class="reference internal nav-link" href="#id194">
Example
</a>
</li>
@@ -2899,12 +2925,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id192">
+ <a class="reference internal nav-link" href="#id195">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id193">
+ <a class="reference internal nav-link" href="#id196">
Example
</a>
</li>
@@ -3108,6 +3134,15 @@
</code>
</a>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-resize">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_resize
+ </span>
+ </code>
+ </a>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#list-remove">
<code class="docutils literal notranslate">
@@ -3199,17 +3234,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id194">
+ <a class="reference internal nav-link" href="#id197">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id195">
+ <a class="reference internal nav-link" href="#id198">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id196">
+ <a class="reference internal nav-link" href="#id199">
Aliases
</a>
</li>
@@ -3234,12 +3269,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id197">
+ <a class="reference internal nav-link" href="#id200">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id198">
+ <a class="reference internal nav-link" href="#id201">
Aliases
</a>
</li>
@@ -3264,7 +3299,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id199">
+ <a class="reference internal nav-link" href="#id202">
Arguments
</a>
</li>
@@ -3280,12 +3315,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id200">
+ <a class="reference internal nav-link" href="#id203">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id201">
+ <a class="reference internal nav-link" href="#id204">
Aliases
</a>
</li>
@@ -3308,7 +3343,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id202">
+ <a class="reference internal nav-link" href="#id205">
Arguments
</a>
</li>
@@ -3331,7 +3366,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id203">
+ <a class="reference internal nav-link" href="#id206">
Arguments
</a>
</li>
@@ -3347,7 +3382,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id204">
+ <a class="reference internal nav-link" href="#id207">
Arguments
</a>
</li>
@@ -3363,7 +3398,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id205">
+ <a class="reference internal nav-link" href="#id208">
Arguments
</a>
</li>
@@ -3379,7 +3414,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id206">
+ <a class="reference internal nav-link" href="#id209">
Arguments
</a>
</li>
@@ -3395,7 +3430,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id207">
+ <a class="reference internal nav-link" href="#id210">
Arguments
</a>
</li>
@@ -3411,7 +3446,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id208">
+ <a class="reference internal nav-link" href="#id211">
Arguments
</a>
</li>
@@ -3434,12 +3469,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id209">
+ <a class="reference internal nav-link" href="#id212">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id210">
+ <a class="reference internal nav-link" href="#id213">
Example
</a>
</li>
@@ -3455,12 +3490,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id211">
+ <a class="reference internal nav-link" href="#id214">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id212">
+ <a class="reference internal nav-link" href="#id215">
Example
</a>
</li>
@@ -5543,6 +5578,7 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<li><p><a class="reference internal"
href="#array-push-back">array_push_back</a></p></li>
<li><p><a class="reference internal"
href="#array-push-front">array_push_front</a></p></li>
<li><p><a class="reference internal"
href="#array-repeat">array_repeat</a></p></li>
+<li><p><a class="reference internal"
href="#array-resize">array_resize</a></p></li>
<li><p><a class="reference internal"
href="#array-remove">array_remove</a></p></li>
<li><p><a class="reference internal"
href="#array-remove-n">array_remove_n</a></p></li>
<li><p><a class="reference internal"
href="#array-remove-all">array_remove_all</a></p></li>
@@ -5580,6 +5616,7 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<li><p><a class="reference internal"
href="#list-push-back">list_push_back</a></p></li>
<li><p><a class="reference internal"
href="#list-push-front">list_push_front</a></p></li>
<li><p><a class="reference internal"
href="#list-repeat">list_repeat</a></p></li>
+<li><p><a class="reference internal"
href="#list-resize">list_resize</a></p></li>
<li><p><a class="reference internal"
href="#list-remove">list_remove</a></p></li>
<li><p><a class="reference internal"
href="#list-remove-n">list_remove_n</a></p></li>
<li><p><a class="reference internal"
href="#list-remove-all">list_remove_all</a></p></li>
@@ -5662,56 +5699,89 @@ Can be a constant, column, or function, and any
combination of array operators.<
</ul>
</section>
</section>
-<section id="array-cat">
-<h3><code class="docutils literal notranslate"><span
class="pre">array_cat</span></code><a class="headerlink" href="#array-cat"
title="Link to this heading">¶</a></h3>
-<p><em>Alias of <a class="reference internal"
href="#array-concat">array_concat</a>.</em></p>
-</section>
-<section id="array-concat">
-<h3><code class="docutils literal notranslate"><span
class="pre">array_concat</span></code><a class="headerlink"
href="#array-concat" title="Link to this heading">¶</a></h3>
-<p>Concatenates arrays.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_concat</span><span
class="p">(</span><span class="n">array</span><span class="p">[,</span> <span
class="o">...</span><span class="p">,</span> <span
class="n">array_n</span><span class="p">])</span>
+<section id="array-resize">
+<h3><code class="docutils literal notranslate"><span
class="pre">array_resize</span></code><a class="headerlink"
href="#array-resize" title="Link to this heading">¶</a></h3>
+<p>Resizes the list to contain size elements. Initializes new elements with
value or empty if value is not set.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_resize</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">size</span><span class="p">,</span> <span class="n">value</span><span
class="p">)</span>
</pre></div>
</div>
<section id="id111">
<h4>Arguments<a class="headerlink" href="#id111" title="Link to this
heading">¶</a></h4>
<ul class="simple">
-<li><p><strong>array</strong>: Array expression to concatenate.
+<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>array_n</strong>: Subsequent array column or literal array to
concatenate.</p></li>
+<li><p><strong>size</strong>: New size of given array.</p></li>
+<li><p><strong>value</strong>: Defines new elements’ value or empty if value
is not set.</p></li>
</ul>
</section>
<section id="id112">
<h4>Example<a class="headerlink" href="#id112" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_concat([1, 2], [3, 4], [5,
6]);
-+---------------------------------------------------+
-| array_concat(List([1,2]),List([3,4]),List([5,6])) |
-+---------------------------------------------------+
-| [1, 2, 3, 4, 5, 6] |
-+---------------------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_resize([1, 2, 3], 5, 0);
++-------------------------------------+
+| array_resize(List([1,2,3],5,0)) |
++-------------------------------------+
+| [1, 2, 3, 0, 0] |
++-------------------------------------+
</pre></div>
</div>
</section>
<section id="id113">
<h4>Aliases<a class="headerlink" href="#id113" title="Link to this
heading">¶</a></h4>
<ul class="simple">
-<li><p>array_cat</p></li>
-<li><p>list_cat</p></li>
-<li><p>list_concat</p></li>
+<li><p>list_resize</p></li>
</ul>
</section>
</section>
-<section id="array-contains">
-<h3><code class="docutils literal notranslate"><span
class="pre">array_contains</span></code><a class="headerlink"
href="#array-contains" title="Link to this heading">¶</a></h3>
-<p><em>Alias of <a class="reference internal"
href="#array-has">array_has</a>.</em></p>
-</section>
+<section id="array-cat">
+<h3><code class="docutils literal notranslate"><span
class="pre">array_cat</span></code><a class="headerlink" href="#array-cat"
title="Link to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-concat">array_concat</a>.</em></p>
+</section>
+<section id="array-concat">
+<h3><code class="docutils literal notranslate"><span
class="pre">array_concat</span></code><a class="headerlink"
href="#array-concat" title="Link to this heading">¶</a></h3>
+<p>Concatenates arrays.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_concat</span><span
class="p">(</span><span class="n">array</span><span class="p">[,</span> <span
class="o">...</span><span class="p">,</span> <span
class="n">array_n</span><span class="p">])</span>
+</pre></div>
+</div>
+<section id="id114">
+<h4>Arguments<a class="headerlink" href="#id114" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>array</strong>: Array expression to concatenate.
+Can be a constant, column, or function, and any combination of array
operators.</p></li>
+<li><p><strong>array_n</strong>: Subsequent array column or literal array to
concatenate.</p></li>
+</ul>
+</section>
+<section id="id115">
+<h4>Example<a class="headerlink" href="#id115" title="Link to this
heading">¶</a></h4>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_concat([1, 2], [3, 4], [5,
6]);
++---------------------------------------------------+
+| array_concat(List([1,2]),List([3,4]),List([5,6])) |
++---------------------------------------------------+
+| [1, 2, 3, 4, 5, 6] |
++---------------------------------------------------+
+</pre></div>
+</div>
+</section>
+<section id="id116">
+<h4>Aliases<a class="headerlink" href="#id116" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>array_cat</p></li>
+<li><p>list_cat</p></li>
+<li><p>list_concat</p></li>
+</ul>
+</section>
+</section>
+<section id="array-contains">
+<h3><code class="docutils literal notranslate"><span
class="pre">array_contains</span></code><a class="headerlink"
href="#array-contains" title="Link to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-has">array_has</a>.</em></p>
+</section>
<section id="array-has">
<h3><code class="docutils literal notranslate"><span
class="pre">array_has</span></code><a class="headerlink" href="#array-has"
title="Link to this heading">¶</a></h3>
<p>Returns true if the array contains the element</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_has</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">element</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id114">
-<h4>Arguments<a class="headerlink" href="#id114" title="Link to this
heading">¶</a></h4>
+<section id="id117">
+<h4>Arguments<a class="headerlink" href="#id117" title="Link 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>
@@ -5719,8 +5789,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id115">
-<h4>Aliases<a class="headerlink" href="#id115" title="Link to this
heading">¶</a></h4>
+<section id="id118">
+<h4>Aliases<a class="headerlink" href="#id118" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_has</p></li>
</ul>
@@ -5732,8 +5802,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_has_all</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">sub</span><span class="o">-</span><span class="n">array</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id116">
-<h4>Arguments<a class="headerlink" href="#id116" title="Link to this
heading">¶</a></h4>
+<section id="id119">
+<h4>Arguments<a class="headerlink" href="#id119" title="Link 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>
@@ -5741,8 +5811,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id117">
-<h4>Aliases<a class="headerlink" href="#id117" title="Link to this
heading">¶</a></h4>
+<section id="id120">
+<h4>Aliases<a class="headerlink" href="#id120" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_has_all</p></li>
</ul>
@@ -5754,8 +5824,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_has_any</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">sub</span><span class="o">-</span><span class="n">array</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id118">
-<h4>Arguments<a class="headerlink" href="#id118" title="Link to this
heading">¶</a></h4>
+<section id="id121">
+<h4>Arguments<a class="headerlink" href="#id121" title="Link 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>
@@ -5763,8 +5833,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id119">
-<h4>Aliases<a class="headerlink" href="#id119" title="Link to this
heading">¶</a></h4>
+<section id="id122">
+<h4>Aliases<a class="headerlink" href="#id122" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_has_any</p></li>
</ul>
@@ -5776,15 +5846,15 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_dims</span><span
class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id120">
-<h4>Arguments<a class="headerlink" href="#id120" title="Link to this
heading">¶</a></h4>
+<section id="id123">
+<h4>Arguments<a class="headerlink" href="#id123" title="Link 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="Link to this
heading">¶</a></h4>
+<section id="id124">
+<h4>Example<a class="headerlink" href="#id124" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_dims([[1, 2, 3], [4, 5, 6]]);
+---------------------------------+
| array_dims(List([1,2,3,4,5,6])) |
@@ -5794,8 +5864,8 @@ 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="Link to this
heading">¶</a></h4>
+<section id="id125">
+<h4>Aliases<a class="headerlink" href="#id125" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_dims</p></li>
</ul>
@@ -5807,15 +5877,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_distinct</span><span
class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id123">
-<h4>Arguments<a class="headerlink" href="#id123" title="Link to this
heading">¶</a></h4>
+<section id="id126">
+<h4>Arguments<a class="headerlink" href="#id126" title="Link 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="id124">
-<h4>Example<a class="headerlink" href="#id124" title="Link to this
heading">¶</a></h4>
+<section id="id127">
+<h4>Example<a class="headerlink" href="#id127" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_distinct([1, 3, 2, 3, 1, 2,
4]);
+---------------------------------+
| array_distinct(List([1,2,3,4])) |
@@ -5825,8 +5895,8 @@ 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="Link to this
heading">¶</a></h4>
+<section id="id128">
+<h4>Aliases<a class="headerlink" href="#id128" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_distinct</p></li>
</ul>
@@ -5838,16 +5908,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_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="id126">
-<h4>Arguments<a class="headerlink" href="#id126" title="Link to this
heading">¶</a></h4>
+<section id="id129">
+<h4>Arguments<a class="headerlink" href="#id129" title="Link 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="id127">
-<h4>Example<a class="headerlink" href="#id127" title="Link to this
heading">¶</a></h4>
+<section id="id130">
+<h4>Example<a class="headerlink" href="#id130" title="Link 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)) |
@@ -5857,8 +5927,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id128">
-<h4>Aliases<a class="headerlink" href="#id128" title="Link to this
heading">¶</a></h4>
+<section id="id131">
+<h4>Aliases<a class="headerlink" href="#id131" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_extract</p></li>
<li><p>list_element</p></li>
@@ -5877,8 +5947,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_fill</span><span
class="p">(</span><span class="n">element</span><span class="p">,</span> <span
class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id129">
-<h4>Arguments<a class="headerlink" href="#id129" title="Link to this
heading">¶</a></h4>
+<section id="id132">
+<h4>Arguments<a class="headerlink" href="#id132" title="Link 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>
@@ -5894,8 +5964,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<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="id130">
-<h4>Arguments<a class="headerlink" href="#id130" title="Link to this
heading">¶</a></h4>
+<section id="id133">
+<h4>Arguments<a class="headerlink" href="#id133" title="Link 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>
@@ -5919,16 +5989,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="id131">
-<h4>Arguments<a class="headerlink" href="#id131" title="Link to this
heading">¶</a></h4>
+<section id="id134">
+<h4>Arguments<a class="headerlink" href="#id134" title="Link 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="id132">
-<h4>Example<a class="headerlink" href="#id132" title="Link to this
heading">¶</a></h4>
+<section id="id135">
+<h4>Example<a class="headerlink" href="#id135" title="Link 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])) |
@@ -5938,8 +6008,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id133">
-<h4>Aliases<a class="headerlink" href="#id133" title="Link to this
heading">¶</a></h4>
+<section id="id136">
+<h4>Aliases<a class="headerlink" href="#id136" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_length</p></li>
</ul>
@@ -5951,15 +6021,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="id134">
-<h4>Arguments<a class="headerlink" href="#id134" title="Link to this
heading">¶</a></h4>
+<section id="id137">
+<h4>Arguments<a class="headerlink" href="#id137" title="Link 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="id135">
-<h4>Example<a class="headerlink" href="#id135" title="Link to this
heading">¶</a></h4>
+<section id="id138">
+<h4>Example<a class="headerlink" href="#id138" title="Link 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])) |
@@ -5969,8 +6039,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id136">
-<h4>Aliases<a class="headerlink" href="#id136" title="Link to this
heading">¶</a></h4>
+<section id="id139">
+<h4>Aliases<a class="headerlink" href="#id139" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_ndims</p></li>
</ul>
@@ -5982,16 +6052,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="id137">
-<h4>Arguments<a class="headerlink" href="#id137" title="Link to this
heading">¶</a></h4>
+<section id="id140">
+<h4>Arguments<a class="headerlink" href="#id140" title="Link 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="id138">
-<h4>Example<a class="headerlink" href="#id138" title="Link to this
heading">¶</a></h4>
+<section id="id141">
+<h4>Example<a class="headerlink" href="#id141" title="Link 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])) |
@@ -6001,8 +6071,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id139">
-<h4>Aliases<a class="headerlink" href="#id139" title="Link to this
heading">¶</a></h4>
+<section id="id142">
+<h4>Aliases<a class="headerlink" href="#id142" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_push_front</p></li>
<li><p>list_prepend</p></li>
@@ -6016,15 +6086,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_pop_front</span><span
class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id140">
-<h4>Arguments<a class="headerlink" href="#id140" title="Link to this
heading">¶</a></h4>
+<section id="id143">
+<h4>Arguments<a class="headerlink" href="#id143" title="Link 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="id141">
-<h4>Example<a class="headerlink" href="#id141" title="Link to this
heading">¶</a></h4>
+<section id="id144">
+<h4>Example<a class="headerlink" href="#id144" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_pop_front([1, 2, 3]);
+-------------------------------+
| array_pop_front(List([1,2,3])) |
@@ -6034,8 +6104,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id142">
-<h4>Aliases<a class="headerlink" href="#id142" title="Link to this
heading">¶</a></h4>
+<section id="id145">
+<h4>Aliases<a class="headerlink" href="#id145" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_pop_front</p></li>
</ul>
@@ -6047,15 +6117,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_pop_back</span><span
class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id143">
-<h4>Arguments<a class="headerlink" href="#id143" title="Link to this
heading">¶</a></h4>
+<section id="id146">
+<h4>Arguments<a class="headerlink" href="#id146" title="Link 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="id144">
-<h4>Example<a class="headerlink" href="#id144" title="Link to this
heading">¶</a></h4>
+<section id="id147">
+<h4>Example<a class="headerlink" href="#id147" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_pop_back([1, 2, 3]);
+-------------------------------+
| array_pop_back(List([1,2,3])) |
@@ -6065,8 +6135,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id145">
-<h4>Aliases<a class="headerlink" href="#id145" title="Link to this
heading">¶</a></h4>
+<section id="id148">
+<h4>Aliases<a class="headerlink" href="#id148" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_pop_back</p></li>
</ul>
@@ -6079,8 +6149,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="id146">
-<h4>Arguments<a class="headerlink" href="#id146" title="Link to this
heading">¶</a></h4>
+<section id="id149">
+<h4>Arguments<a class="headerlink" href="#id149" title="Link 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>
@@ -6088,8 +6158,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="id147">
-<h4>Example<a class="headerlink" href="#id147" title="Link to this
heading">¶</a></h4>
+<section id="id150">
+<h4>Example<a class="headerlink" href="#id150" title="Link 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)) |
@@ -6099,8 +6169,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id148">
-<h4>Aliases<a class="headerlink" href="#id148" title="Link to this
heading">¶</a></h4>
+<section id="id151">
+<h4>Aliases<a class="headerlink" href="#id151" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_indexof</p></li>
<li><p>list_indexof</p></li>
@@ -6114,16 +6184,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="id149">
-<h4>Arguments<a class="headerlink" href="#id149" title="Link to this
heading">¶</a></h4>
+<section id="id152">
+<h4>Arguments<a class="headerlink" href="#id152" title="Link 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="id150">
-<h4>Example<a class="headerlink" href="#id150" title="Link to this
heading">¶</a></h4>
+<section id="id153">
+<h4>Example<a class="headerlink" href="#id153" title="Link 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)) |
@@ -6133,8 +6203,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id151">
-<h4>Aliases<a class="headerlink" href="#id151" title="Link to this
heading">¶</a></h4>
+<section id="id154">
+<h4>Aliases<a class="headerlink" href="#id154" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_positions</p></li>
</ul>
@@ -6154,16 +6224,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="id152">
-<h4>Arguments<a class="headerlink" href="#id152" title="Link to this
heading">¶</a></h4>
+<section id="id155">
+<h4>Arguments<a class="headerlink" href="#id155" title="Link 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="id153">
-<h4>Example<a class="headerlink" href="#id153" title="Link to this
heading">¶</a></h4>
+<section id="id156">
+<h4>Example<a class="headerlink" href="#id156" title="Link 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)) |
@@ -6181,8 +6251,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id154">
-<h4>Aliases<a class="headerlink" href="#id154" title="Link to this
heading">¶</a></h4>
+<section id="id157">
+<h4>Aliases<a class="headerlink" href="#id157" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_repeat</p></li>
</ul>
@@ -6194,16 +6264,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="id155">
-<h4>Arguments<a class="headerlink" href="#id155" title="Link to this
heading">¶</a></h4>
+<section id="id158">
+<h4>Arguments<a class="headerlink" href="#id158" title="Link 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="id156">
-<h4>Example<a class="headerlink" href="#id156" title="Link to this
heading">¶</a></h4>
+<section id="id159">
+<h4>Example<a class="headerlink" href="#id159" title="Link 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)) |
@@ -6213,8 +6283,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id157">
-<h4>Aliases<a class="headerlink" href="#id157" title="Link to this
heading">¶</a></h4>
+<section id="id160">
+<h4>Aliases<a class="headerlink" href="#id160" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove</p></li>
</ul>
@@ -6226,8 +6296,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="id158">
-<h4>Arguments<a class="headerlink" href="#id158" title="Link to this
heading">¶</a></h4>
+<section id="id161">
+<h4>Arguments<a class="headerlink" href="#id161" title="Link 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>
@@ -6235,8 +6305,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="id159">
-<h4>Example<a class="headerlink" href="#id159" title="Link to this
heading">¶</a></h4>
+<section id="id162">
+<h4>Example<a class="headerlink" href="#id162" title="Link 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)) |
@@ -6246,8 +6316,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id160">
-<h4>Aliases<a class="headerlink" href="#id160" title="Link to this
heading">¶</a></h4>
+<section id="id163">
+<h4>Aliases<a class="headerlink" href="#id163" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove_n</p></li>
</ul>
@@ -6259,16 +6329,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="id161">
-<h4>Arguments<a class="headerlink" href="#id161" title="Link to this
heading">¶</a></h4>
+<section id="id164">
+<h4>Arguments<a class="headerlink" href="#id164" title="Link 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="id162">
-<h4>Example<a class="headerlink" href="#id162" title="Link to this
heading">¶</a></h4>
+<section id="id165">
+<h4>Example<a class="headerlink" href="#id165" title="Link 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)) |
@@ -6278,8 +6348,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id163">
-<h4>Aliases<a class="headerlink" href="#id163" title="Link to this
heading">¶</a></h4>
+<section id="id166">
+<h4>Aliases<a class="headerlink" href="#id166" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove_all</p></li>
</ul>
@@ -6291,8 +6361,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="id164">
-<h4>Arguments<a class="headerlink" href="#id164" title="Link to this
heading">¶</a></h4>
+<section id="id167">
+<h4>Arguments<a class="headerlink" href="#id167" title="Link 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>
@@ -6300,8 +6370,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="id165">
-<h4>Example<a class="headerlink" href="#id165" title="Link to this
heading">¶</a></h4>
+<section id="id168">
+<h4>Example<a class="headerlink" href="#id168" title="Link 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)) |
@@ -6311,8 +6381,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id166">
-<h4>Aliases<a class="headerlink" href="#id166" title="Link to this
heading">¶</a></h4>
+<section id="id169">
+<h4>Aliases<a class="headerlink" href="#id169" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace</p></li>
</ul>
@@ -6324,8 +6394,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="id167">
-<h4>Arguments<a class="headerlink" href="#id167" title="Link to this
heading">¶</a></h4>
+<section id="id170">
+<h4>Arguments<a class="headerlink" href="#id170" title="Link 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>
@@ -6334,8 +6404,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="id168">
-<h4>Example<a class="headerlink" href="#id168" title="Link to this
heading">¶</a></h4>
+<section id="id171">
+<h4>Example<a class="headerlink" href="#id171" title="Link 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)) |
@@ -6345,8 +6415,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id169">
-<h4>Aliases<a class="headerlink" href="#id169" title="Link to this
heading">¶</a></h4>
+<section id="id172">
+<h4>Aliases<a class="headerlink" href="#id172" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace_n</p></li>
</ul>
@@ -6358,8 +6428,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="id170">
-<h4>Arguments<a class="headerlink" href="#id170" title="Link to this
heading">¶</a></h4>
+<section id="id173">
+<h4>Arguments<a class="headerlink" href="#id173" title="Link 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>
@@ -6367,8 +6437,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="id171">
-<h4>Example<a class="headerlink" href="#id171" title="Link to this
heading">¶</a></h4>
+<section id="id174">
+<h4>Example<a class="headerlink" href="#id174" title="Link 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)) |
@@ -6378,8 +6448,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id172">
-<h4>Aliases<a class="headerlink" href="#id172" title="Link to this
heading">¶</a></h4>
+<section id="id175">
+<h4>Aliases<a class="headerlink" href="#id175" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace_all</p></li>
</ul>
@@ -6391,15 +6461,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_reverse</span><span
class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id173">
-<h4>Arguments<a class="headerlink" href="#id173" title="Link to this
heading">¶</a></h4>
+<section id="id176">
+<h4>Arguments<a class="headerlink" href="#id176" title="Link 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="id174">
-<h4>Example<a class="headerlink" href="#id174" title="Link to this
heading">¶</a></h4>
+<section id="id177">
+<h4>Example<a class="headerlink" href="#id177" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_reverse([1, 2, 3, 4]);
+------------------------------------------------------------+
| array_reverse(List([1, 2, 3, 4])) |
@@ -6409,8 +6479,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id175">
-<h4>Aliases<a class="headerlink" href="#id175" title="Link to this
heading">¶</a></h4>
+<section id="id178">
+<h4>Aliases<a class="headerlink" href="#id178" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_reverse</p></li>
</ul>
@@ -6422,8 +6492,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="id176">
-<h4>Arguments<a class="headerlink" href="#id176" title="Link to this
heading">¶</a></h4>
+<section id="id179">
+<h4>Arguments<a class="headerlink" href="#id179" title="Link 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>
@@ -6434,8 +6504,8 @@ If negative, it counts backward from the end of the
array.</p></li>
<li><p><strong>stride</strong>: Stride of the array slice. The default is
1.</p></li>
</ul>
</section>
-<section id="id177">
-<h4>Example<a class="headerlink" href="#id177" title="Link to this
heading">¶</a></h4>
+<section id="id180">
+<h4>Example<a class="headerlink" href="#id180" title="Link 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)) |
@@ -6445,8 +6515,8 @@ If negative, it counts backward from the end of the
array.</p></li>
</pre></div>
</div>
</section>
-<section id="id178">
-<h4>Aliases<a class="headerlink" href="#id178" title="Link to this
heading">¶</a></h4>
+<section id="id181">
+<h4>Aliases<a class="headerlink" href="#id181" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_slice</p></li>
</ul>
@@ -6458,16 +6528,16 @@ If negative, it counts backward from the end of the
array.</p></li>
<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">delimiter</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id179">
-<h4>Arguments<a class="headerlink" href="#id179" title="Link to this
heading">¶</a></h4>
+<section id="id182">
+<h4>Arguments<a class="headerlink" href="#id182" title="Link 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>delimiter</strong>: Array element separator.</p></li>
</ul>
</section>
-<section id="id180">
-<h4>Example<a class="headerlink" href="#id180" title="Link to this
heading">¶</a></h4>
+<section id="id183">
+<h4>Example<a class="headerlink" href="#id183" title="Link 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(",")) |
@@ -6477,8 +6547,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id181">
-<h4>Aliases<a class="headerlink" href="#id181" title="Link to this
heading">¶</a></h4>
+<section id="id184">
+<h4>Aliases<a class="headerlink" href="#id184" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_join</p></li>
<li><p>list_join</p></li>
@@ -6492,8 +6562,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_union</span><span
class="p">(</span><span class="n">array1</span><span class="p">,</span> <span
class="n">array2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id182">
-<h4>Arguments<a class="headerlink" href="#id182" title="Link to this
heading">¶</a></h4>
+<section id="id185">
+<h4>Arguments<a class="headerlink" href="#id185" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array1</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -6501,8 +6571,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id183">
-<h4>Example<a class="headerlink" href="#id183" title="Link to this
heading">¶</a></h4>
+<section id="id186">
+<h4>Example<a class="headerlink" href="#id186" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_union([1, 2, 3, 4], [5, 6,
3, 4]);
+----------------------------------------------------+
| array_union([1, 2, 3, 4], [5, 6, 3, 4]); |
@@ -6519,8 +6589,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</div>
</section>
<hr class="docutils" />
-<section id="id184">
-<h4>Aliases<a class="headerlink" href="#id184" title="Link to this
heading">¶</a></h4>
+<section id="id187">
+<h4>Aliases<a class="headerlink" href="#id187" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_union</p></li>
</ul>
@@ -6532,8 +6602,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_except</span><span
class="p">(</span><span class="n">array1</span><span class="p">,</span> <span
class="n">array2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id185">
-<h4>Arguments<a class="headerlink" href="#id185" title="Link to this
heading">¶</a></h4>
+<section id="id188">
+<h4>Arguments<a class="headerlink" href="#id188" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array1</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -6541,8 +6611,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id186">
-<h4>Example<a class="headerlink" href="#id186" title="Link to this
heading">¶</a></h4>
+<section id="id189">
+<h4>Example<a class="headerlink" href="#id189" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_except([1, 2, 3, 4], [5, 6,
3, 4]);
+----------------------------------------------------+
| array_except([1, 2, 3, 4], [5, 6, 3, 4]); |
@@ -6559,8 +6629,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</div>
</section>
<hr class="docutils" />
-<section id="id187">
-<h4>Aliases<a class="headerlink" href="#id187" title="Link to this
heading">¶</a></h4>
+<section id="id190">
+<h4>Aliases<a class="headerlink" href="#id190" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_except</p></li>
</ul>
@@ -6572,15 +6642,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="id188">
-<h4>Arguments<a class="headerlink" href="#id188" title="Link to this
heading">¶</a></h4>
+<section id="id191">
+<h4>Arguments<a class="headerlink" href="#id191" title="Link 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="id189">
-<h4>Example<a class="headerlink" href="#id189" title="Link to this
heading">¶</a></h4>
+<section id="id192">
+<h4>Example<a class="headerlink" href="#id192" title="Link 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])) |
@@ -6597,15 +6667,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">empty</span><span
class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id190">
-<h4>Arguments<a class="headerlink" href="#id190" title="Link to this
heading">¶</a></h4>
+<section id="id193">
+<h4>Arguments<a class="headerlink" href="#id193" title="Link 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="id191">
-<h4>Example<a class="headerlink" href="#id191" title="Link to this
heading">¶</a></h4>
+<section id="id194">
+<h4>Example<a class="headerlink" href="#id194" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select empty([1]);
+------------------+
| empty(List([1])) |
@@ -6622,16 +6692,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">generate_series</span><span
class="p">(</span><span class="n">start</span><span class="p">,</span> <span
class="n">stop</span><span class="p">,</span> <span class="n">step</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id192">
-<h4>Arguments<a class="headerlink" href="#id192" title="Link to this
heading">¶</a></h4>
+<section id="id195">
+<h4>Arguments<a class="headerlink" href="#id195" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>start</strong>: start of the range</p></li>
<li><p><strong>end</strong>: end of the range (included)</p></li>
<li><p><strong>step</strong>: increase by step (can not be 0)</p></li>
</ul>
</section>
-<section id="id193">
-<h4>Example<a class="headerlink" href="#id193" title="Link to this
heading">¶</a></h4>
+<section id="id196">
+<h4>Example<a class="headerlink" href="#id196" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select generate_series(1,3);
+------------------------------------+
| generate_series(Int64(1),Int64(3)) |
@@ -6730,6 +6800,10 @@ Can be a constant, column, or function, and any
combination of array operators.<
<h3><code class="docutils literal notranslate"><span
class="pre">list_repeat</span></code><a class="headerlink" href="#list-repeat"
title="Link to this heading">¶</a></h3>
<p><em>Alias of <a class="reference internal"
href="#array-repeat">array_repeat</a>.</em></p>
</section>
+<section id="list-resize">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_resize</span></code><a class="headerlink" href="#list-resize"
title="Link to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-resize">array_resize</a>.</em></p>
+</section>
<section id="list-remove">
<h3><code class="docutils literal notranslate"><span
class="pre">list_remove</span></code><a class="headerlink" href="#list-remove"
title="Link to this heading">¶</a></h3>
<p><em>Alias of <a class="reference internal"
href="#array-remove">array_remove</a>.</em></p>
@@ -6772,16 +6846,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="id194">
-<h4>Arguments<a class="headerlink" href="#id194" title="Link to this
heading">¶</a></h4>
+<section id="id197">
+<h4>Arguments<a class="headerlink" href="#id197" title="Link 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="id195">
-<h4>Example<a class="headerlink" href="#id195" title="Link to this
heading">¶</a></h4>
+<section id="id198">
+<h4>Example<a class="headerlink" href="#id198" title="Link 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)) |
@@ -6791,8 +6865,8 @@ string operators.</p></li>
</pre></div>
</div>
</section>
-<section id="id196">
-<h4>Aliases<a class="headerlink" href="#id196" title="Link to this
heading">¶</a></h4>
+<section id="id199">
+<h4>Aliases<a class="headerlink" href="#id199" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>make_list</p></li>
</ul>
@@ -6809,16 +6883,16 @@ string operators.</p></li>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">starts_with</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">delimiter</span><span class="p">[,</span> <span
class="n">null_str</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id197">
-<h4>Arguments<a class="headerlink" href="#id197" title="Link to this
heading">¶</a></h4>
+<section id="id200">
+<h4>Arguments<a class="headerlink" href="#id200" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>str</strong>: String expression to split.</p></li>
<li><p><strong>delimiter</strong>: Delimiter string to split on.</p></li>
<li><p><strong>null_str</strong>: Substring values to be replaced with <code
class="docutils literal notranslate"><span
class="pre">NULL</span></code></p></li>
</ul>
</section>
-<section id="id198">
-<h4>Aliases<a class="headerlink" href="#id198" title="Link to this
heading">¶</a></h4>
+<section id="id201">
+<h4>Aliases<a class="headerlink" href="#id201" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>string_to_list</p></li>
</ul>
@@ -6835,8 +6909,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="id199">
-<h4>Arguments<a class="headerlink" href="#id199" title="Link to this
heading">¶</a></h4>
+<section id="id202">
+<h4>Arguments<a class="headerlink" href="#id202" title="Link 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>
@@ -6868,16 +6942,16 @@ For example,</p>
</pre></div>
</div>
<p>are not allowed</p>
-<section id="id200">
-<h4>Arguments<a class="headerlink" href="#id200" title="Link to this
heading">¶</a></h4>
+<section id="id203">
+<h4>Arguments<a class="headerlink" href="#id203" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>start</strong>: start of the range</p></li>
<li><p><strong>end</strong>: end of the range (not included)</p></li>
<li><p><strong>step</strong>: increase by step (can not be 0)</p></li>
</ul>
</section>
-<section id="id201">
-<h4>Aliases<a class="headerlink" href="#id201" title="Link to this
heading">¶</a></h4>
+<section id="id204">
+<h4>Aliases<a class="headerlink" href="#id204" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>generate_series</p></li>
</ul>
@@ -6916,8 +6990,8 @@ a struct type of fields <code class="docutils literal
notranslate"><span class="
<span class="o">+-----------------+</span>
</pre></div>
</div>
-<section id="id202">
-<h4>Arguments<a class="headerlink" href="#id202" title="Link to this
heading">¶</a></h4>
+<section id="id205">
+<h4>Arguments<a class="headerlink" href="#id205" title="Link 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
@@ -6942,8 +7016,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="id203">
-<h4>Arguments<a class="headerlink" href="#id203" title="Link to this
heading">¶</a></h4>
+<section id="id206">
+<h4>Arguments<a class="headerlink" href="#id206" title="Link 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>
@@ -6969,8 +7043,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="id204">
-<h4>Arguments<a class="headerlink" href="#id204" title="Link to this
heading">¶</a></h4>
+<section id="id207">
+<h4>Arguments<a class="headerlink" href="#id207" title="Link 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>
@@ -6983,8 +7057,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="id205">
-<h4>Arguments<a class="headerlink" href="#id205" title="Link to this
heading">¶</a></h4>
+<section id="id208">
+<h4>Arguments<a class="headerlink" href="#id208" title="Link 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>
@@ -6997,8 +7071,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="id206">
-<h4>Arguments<a class="headerlink" href="#id206" title="Link to this
heading">¶</a></h4>
+<section id="id209">
+<h4>Arguments<a class="headerlink" href="#id209" title="Link 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>
@@ -7011,8 +7085,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="id207">
-<h4>Arguments<a class="headerlink" href="#id207" title="Link to this
heading">¶</a></h4>
+<section id="id210">
+<h4>Arguments<a class="headerlink" href="#id210" title="Link 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>
@@ -7025,8 +7099,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="id208">
-<h4>Arguments<a class="headerlink" href="#id208" title="Link to this
heading">¶</a></h4>
+<section id="id211">
+<h4>Arguments<a class="headerlink" href="#id211" title="Link 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>
@@ -7046,8 +7120,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="id209">
-<h4>Arguments<a class="headerlink" href="#id209" title="Link to this
heading">¶</a></h4>
+<section id="id212">
+<h4>Arguments<a class="headerlink" href="#id212" title="Link 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
@@ -7056,8 +7130,8 @@ string operators.</p></li>
to cast to, as a string. The format is the same as that returned by [<code
class="docutils literal notranslate"><span
class="pre">arrow_typeof</span></code>]</p></li>
</ul>
</section>
-<section id="id210">
-<h4>Example<a class="headerlink" href="#id210" title="Link to this
heading">¶</a></h4>
+<section id="id213">
+<h4>Example<a class="headerlink" href="#id213" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select arrow_cast(-5, 'Int8') as
a,
arrow_cast('foo', 'Dictionary(Int32, Utf8)') as b,
arrow_cast('bar', 'LargeUtf8') as c,
@@ -7079,16 +7153,16 @@ to cast to, as a string. The format is the same as that
returned by [<code class
<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="id211">
-<h4>Arguments<a class="headerlink" href="#id211" title="Link to this
heading">¶</a></h4>
+<section id="id214">
+<h4>Arguments<a class="headerlink" href="#id214" title="Link 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
string operators.</p></li>
</ul>
</section>
-<section id="id212">
-<h4>Example<a class="headerlink" href="#id212" title="Link to this
heading">¶</a></h4>
+<section id="id215">
+<h4>Example<a class="headerlink" href="#id215" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select arrow_typeof('foo'),
arrow_typeof(1);
+---------------------------+------------------------+
| arrow_typeof(Utf8("foo")) | arrow_typeof(Int64(1)) |