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 da269c8bb4 Publish built docs triggered by
6b945a4409e1c8e9c50124e30a0996b65e9d31c6
da269c8bb4 is described below
commit da269c8bb49055afe3e0a693850938ac55eead2c
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Wed Nov 15 21:17:36 2023 +0000
Publish built docs triggered by 6b945a4409e1c8e9c50124e30a0996b65e9d31c6
---
_sources/user-guide/expressions.md.txt | 1 +
_sources/user-guide/sql/scalar_functions.md.txt | 25 ++
searchindex.js | 2 +-
user-guide/expressions.html | 41 +--
user-guide/sql/scalar_functions.html | 393 +++++++++++++-----------
5 files changed, 269 insertions(+), 193 deletions(-)
diff --git a/_sources/user-guide/expressions.md.txt
b/_sources/user-guide/expressions.md.txt
index 6b2ab46eb3..191ef6cd91 100644
--- a/_sources/user-guide/expressions.md.txt
+++ b/_sources/user-guide/expressions.md.txt
@@ -219,6 +219,7 @@ Unlike to some databases the math functions in Datafusion
works the same way as
| flatten(array) | Converts an array of arrays to a
flat array `flatten([[1], [2, 3], [4, 5, 6]]) -> [1, 2, 3, 4, 5, 6]`
|
| array_length(array, dimension) | Returns the length of the array
dimension. `array_length([1, 2, 3, 4, 5]) -> 5`
|
| array_ndims(array) | Returns the number of dimensions of
the array. `array_ndims([[1, 2, 3], [4, 5, 6]]) -> 2`
|
+| array_pop_front(array) | Returns the array without the first
element. `array_pop_front([1, 2, 3]) -> [2, 3]`
|
| array_pop_back(array) | Returns the array without the last
element. `array_pop_back([1, 2, 3]) -> [1, 2]`
|
| array_position(array, element) | Searches for an element in the
array, returns first occurrence. `array_position([1, 2, 2, 3, 4], 2) -> 2`
|
| array_positions(array, element) | Searches for an element in the
array, returns all occurrences. `array_positions([1, 2, 2, 3, 4], 2) -> [2, 3]`
|
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index 826782e1a0..baaea3926f 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -1515,6 +1515,7 @@ from_unixtime(expression)
- [array_length](#array_length)
- [array_ndims](#array_ndims)
- [array_prepend](#array_prepend)
+- [array_pop_front](#array_pop_front)
- [array_pop_back](#array_pop_back)
- [array_position](#array_position)
- [array_positions](#array_positions)
@@ -1868,6 +1869,30 @@ array_prepend(element, array)
- list_prepend
- list_push_front
+### `array_pop_front`
+
+Returns the array without the first element.
+
+```
+array_pop_first(array)
+```
+
+#### Arguments
+
+- **array**: Array expression.
+ Can be a constant, column, or function, and any combination of array
operators.
+
+#### Example
+
+```
+❯ select array_pop_first([1, 2, 3]);
++-------------------------------+
+| array_pop_first(List([1,2,3])) |
++-------------------------------+
+| [2, 3] |
++-------------------------------+
+```
+
### `array_pop_back`
Returns the array without the last element.
diff --git a/searchindex.js b/searchindex.js
index a9dd80744c..650247dec5 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 577036af4b..752a3b8d7c 100644
--- a/user-guide/expressions.html
+++ b/user-guide/expressions.html
@@ -943,61 +943,64 @@ but these operators always return a <code class="docutils
literal notranslate"><
<tr class="row-odd"><td><p>array_ndims(array)</p></td>
<td><p>Returns the number of dimensions of the array. <code class="docutils
literal notranslate"><span class="pre">array_ndims([[1,</span> <span
class="pre">2,</span> <span class="pre">3],</span> <span class="pre">[4,</span>
<span class="pre">5,</span> <span class="pre">6]])</span> <span
class="pre">-></span> <span class="pre">2</span></code></p></td>
</tr>
-<tr class="row-even"><td><p>array_pop_back(array)</p></td>
+<tr class="row-even"><td><p>array_pop_front(array)</p></td>
+<td><p>Returns the array without the first element. <code class="docutils
literal notranslate"><span class="pre">array_pop_front([1,</span> <span
class="pre">2,</span> <span class="pre">3])</span> <span
class="pre">-></span> <span class="pre">[2,</span> <span
class="pre">3]</span></code></p></td>
+</tr>
+<tr class="row-odd"><td><p>array_pop_back(array)</p></td>
<td><p>Returns the array without the last element. <code class="docutils
literal notranslate"><span class="pre">array_pop_back([1,</span> <span
class="pre">2,</span> <span class="pre">3])</span> <span
class="pre">-></span> <span class="pre">[1,</span> <span
class="pre">2]</span></code></p></td>
</tr>
-<tr class="row-odd"><td><p>array_position(array, element)</p></td>
+<tr class="row-even"><td><p>array_position(array, element)</p></td>
<td><p>Searches for an element in the array, returns first occurrence. <code
class="docutils literal notranslate"><span
class="pre">array_position([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">4],</span>
<span class="pre">2)</span> <span class="pre">-></span> <span
class="pre">2</span></code></p></td>
</tr>
-<tr class="row-even"><td><p>array_positions(array, element)</p></td>
+<tr class="row-odd"><td><p>array_positions(array, element)</p></td>
<td><p>Searches for an element in the array, returns all occurrences. <code
class="docutils literal notranslate"><span
class="pre">array_positions([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">4],</span>
<span class="pre">2)</span> <span class="pre">-></span> <span
class="pre">[2,</span> <span class="pre">3]</span></code></p></td>
</tr>
-<tr class="row-odd"><td><p>array_prepend(array, element)</p></td>
+<tr class="row-even"><td><p>array_prepend(array, element)</p></td>
<td><p>Prepends an element to the beginning of an array. <code class="docutils
literal notranslate"><span class="pre">array_prepend(1,</span> <span
class="pre">[2,</span> <span class="pre">3,</span> <span class="pre">4])</span>
<span class="pre">-></span> <span class="pre">[1,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span
class="pre">4]</span></code></p></td>
</tr>
-<tr class="row-even"><td><p>array_repeat(element, count)</p></td>
+<tr class="row-odd"><td><p>array_repeat(element, count)</p></td>
<td><p>Returns an array containing element <code class="docutils literal
notranslate"><span class="pre">count</span></code> times. <code class="docutils
literal notranslate"><span class="pre">array_repeat(1,</span> <span
class="pre">3)</span> <span class="pre">-></span> <span
class="pre">[1,</span> <span class="pre">1,</span> <span
class="pre">1]</span></code></p></td>
</tr>
-<tr class="row-odd"><td><p>array_remove(array, element)</p></td>
+<tr class="row-even"><td><p>array_remove(array, element)</p></td>
<td><p>Removes the first element from the array equal to the given value.
<code class="docutils literal notranslate"><span
class="pre">array_remove([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">2,</span>
<span class="pre">1,</span> <span class="pre">4],</span> <span
class="pre">2)</span> <span class="pre">-></span> <span
class="pre">[1,</span> <span class="pre">2,</span> <span class="pre">3,</span>
<span class="pre">2, [...]
</tr>
-<tr class="row-even"><td><p>array_remove_n(array, element, max)</p></td>
+<tr class="row-odd"><td><p>array_remove_n(array, element, max)</p></td>
<td><p>Removes the first <code class="docutils literal notranslate"><span
class="pre">max</span></code> elements from the array equal to the given value.
<code class="docutils literal notranslate"><span
class="pre">array_remove_n([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">2,</span>
<span class="pre">1,</span> <span class="pre">4],</span> <span
class="pre">2,</span> <span class="pre">2)</span> <span class="pre">-></s
[...]
</tr>
-<tr class="row-odd"><td><p>array_remove_all(array, element)</p></td>
+<tr class="row-even"><td><p>array_remove_all(array, element)</p></td>
<td><p>Removes all elements from the array equal to the given value. <code
class="docutils literal notranslate"><span
class="pre">array_remove_all([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">2,</span>
<span class="pre">1,</span> <span class="pre">4],</span> <span
class="pre">2)</span> <span class="pre">-></span> <span
class="pre">[1,</span> <span class="pre">3,</span> <span class="pre">1,</span>
<span class="pre">4]< [...]
</tr>
-<tr class="row-even"><td><p>array_replace(array, from, to)</p></td>
+<tr class="row-odd"><td><p>array_replace(array, from, to)</p></td>
<td><p>Replaces the first occurrence of the specified element with another
specified element. <code class="docutils literal notranslate"><span
class="pre">array_replace([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">2,</span>
<span class="pre">1,</span> <span class="pre">4],</span> <span
class="pre">2,</span> <span class="pre">5)</span> <span
class="pre">-></span> <span class="pre">[1,</span> <span
class="pre">5,</span> [...]
</tr>
-<tr class="row-odd"><td><p>array_replace_n(array, from, to, max)</p></td>
+<tr class="row-even"><td><p>array_replace_n(array, from, to, max)</p></td>
<td><p>Replaces the first <code class="docutils literal notranslate"><span
class="pre">max</span></code> occurrences of the specified element with another
specified element. <code class="docutils literal notranslate"><span
class="pre">array_replace_n([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">2,</span>
<span class="pre">1,</span> <span class="pre">4],</span> <span
class="pre">2,</span> <span class="pre">5,</span> <span [...]
</tr>
-<tr class="row-even"><td><p>array_replace_all(array, from, to)</p></td>
+<tr class="row-odd"><td><p>array_replace_all(array, from, to)</p></td>
<td><p>Replaces all occurrences of the specified element with another
specified element. <code class="docutils literal notranslate"><span
class="pre">array_replace_all([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">2,</span>
<span class="pre">1,</span> <span class="pre">4],</span> <span
class="pre">2,</span> <span class="pre">5)</span> <span
class="pre">-></span> <span class="pre">[1,</span> <span
class="pre">5,</span> [...]
</tr>
-<tr class="row-odd"><td><p>array_slice(array, index)</p></td>
+<tr class="row-even"><td><p>array_slice(array, index)</p></td>
<td><p>Returns a slice of the array. <code class="docutils literal
notranslate"><span class="pre">array_slice([1,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">4,</span>
<span class="pre">5,</span> <span class="pre">6,</span> <span
class="pre">7,</span> <span class="pre">8],</span> <span class="pre">3,</span>
<span class="pre">6)</span> <span class="pre">-></span> <span
class="pre">[3,</span> <span class="pre">4,</span> <span class="pre">5,</span>
<s [...]
</tr>
-<tr class="row-even"><td><p>array_to_string(array, delimiter)</p></td>
+<tr class="row-odd"><td><p>array_to_string(array, delimiter)</p></td>
<td><p>Converts each element to its text representation. <code class="docutils
literal notranslate"><span class="pre">array_to_string([1,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">4],</span>
<span class="pre">',')</span> <span class="pre">-></span> <span
class="pre">1,2,3,4</span></code></p></td>
</tr>
-<tr class="row-odd"><td><p>array_intersect(array1, array2)</p></td>
+<tr class="row-even"><td><p>array_intersect(array1, array2)</p></td>
<td><p>Returns an array of the elements in the intersection of array1 and
array2. <code class="docutils literal notranslate"><span
class="pre">array_intersect([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-even"><td><p>array_union(array1, array2)</p></td>
+<tr class="row-odd"><td><p>array_union(array1, array2)</p></td>
<td><p>Returns an array of the elements in the union of array1 and array2
without duplicates. <code class="docutils literal notranslate"><span
class="pre">array_union([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">[1,</span> <span class="pre">2,</span> <span class="pre">3,</span>
[...]
</tr>
-<tr class="row-odd"><td><p>cardinality(array)</p></td>
+<tr class="row-even"><td><p>cardinality(array)</p></td>
<td><p>Returns the total number of elements in the array. <code
class="docutils literal notranslate"><span class="pre">cardinality([[1,</span>
<span class="pre">2,</span> <span class="pre">3],</span> <span
class="pre">[4,</span> <span class="pre">5,</span> <span
class="pre">6]])</span> <span class="pre">-></span> <span
class="pre">6</span></code></p></td>
</tr>
-<tr class="row-even"><td><p>make_array(value1, [value2 [, …]])</p></td>
+<tr class="row-odd"><td><p>make_array(value1, [value2 [, …]])</p></td>
<td><p>Returns an Arrow array using the specified input expressions. <code
class="docutils literal notranslate"><span class="pre">make_array(1,</span>
<span class="pre">2,</span> <span class="pre">3)</span> <span
class="pre">-></span> <span class="pre">[1,</span> <span
class="pre">2,</span> <span class="pre">3]</span></code></p></td>
</tr>
-<tr class="row-odd"><td><p>range(start [, stop, step])</p></td>
+<tr class="row-even"><td><p>range(start [, stop, step])</p></td>
<td><p>Returns an Arrow array between start and stop with step. <code
class="docutils literal notranslate"><span class="pre">SELECT</span> <span
class="pre">range(2,</span> <span class="pre">10,</span> <span
class="pre">3)</span> <span class="pre">-></span> <span
class="pre">[2,</span> <span class="pre">5,</span> <span
class="pre">8]</span></code></p></td>
</tr>
-<tr class="row-even"><td><p>trim_array(array, n)</p></td>
+<tr class="row-odd"><td><p>trim_array(array, n)</p></td>
<td><p>Deprecated</p></td>
</tr>
</tbody>
diff --git a/user-guide/sql/scalar_functions.html
b/user-guide/sql/scalar_functions.html
index 02966c8644..d3915da662 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -2073,10 +2073,10 @@
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#array-pop-back">
+ <a class="reference internal nav-link" href="#array-pop-front">
<code class="docutils literal notranslate">
<span class="pre">
- array_pop_back
+ array_pop_front
</span>
</code>
</a>
@@ -2094,10 +2094,10 @@
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#array-position">
+ <a class="reference internal nav-link" href="#array-pop-back">
<code class="docutils literal notranslate">
<span class="pre">
- array_position
+ array_pop_back
</span>
</code>
</a>
@@ -2112,8 +2112,29 @@
Example
</a>
</li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#array-position">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ array_position
+ </span>
+ </code>
+ </a>
+ <ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
<a class="reference internal nav-link" href="#id110">
+ Arguments
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id111">
+ Example
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id112">
Aliases
</a>
</li>
@@ -2129,17 +2150,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="#id113">
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="#id114">
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="#id115">
Aliases
</a>
</li>
@@ -2173,12 +2194,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="#id116">
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="#id117">
Example
</a>
</li>
@@ -2194,17 +2215,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id116">
+ <a class="reference internal nav-link" href="#id118">
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="#id119">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id118">
+ <a class="reference internal nav-link" href="#id120">
Aliases
</a>
</li>
@@ -2220,17 +2241,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id119">
+ <a class="reference internal nav-link" href="#id121">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id120">
+ <a class="reference internal nav-link" href="#id122">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id121">
+ <a class="reference internal nav-link" href="#id123">
Aliases
</a>
</li>
@@ -2246,17 +2267,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id122">
+ <a class="reference internal nav-link" href="#id124">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id123">
+ <a class="reference internal nav-link" href="#id125">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id124">
+ <a class="reference internal nav-link" href="#id126">
Aliases
</a>
</li>
@@ -2272,17 +2293,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id125">
+ <a class="reference internal nav-link" href="#id127">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id126">
+ <a class="reference internal nav-link" href="#id128">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id127">
+ <a class="reference internal nav-link" href="#id129">
Aliases
</a>
</li>
@@ -2298,17 +2319,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id128">
+ <a class="reference internal nav-link" href="#id130">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id129">
+ <a class="reference internal nav-link" href="#id131">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id130">
+ <a class="reference internal nav-link" href="#id132">
Aliases
</a>
</li>
@@ -2324,17 +2345,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="#id133">
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="#id134">
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="#id135">
Aliases
</a>
</li>
@@ -2350,12 +2371,12 @@
</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="#id136">
Example
</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="#id137">
Aliases
</a>
</li>
@@ -2371,17 +2392,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id136">
+ <a class="reference internal nav-link" href="#id138">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id137">
+ <a class="reference internal nav-link" href="#id139">
Example
</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="#id140">
Aliases
</a>
</li>
@@ -2397,17 +2418,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id139">
+ <a class="reference internal nav-link" href="#id141">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id140">
+ <a class="reference internal nav-link" href="#id142">
Example
</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="#id143">
Aliases
</a>
</li>
@@ -2423,12 +2444,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id142">
+ <a class="reference internal nav-link" href="#id144">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id143">
+ <a class="reference internal nav-link" href="#id145">
Example
</a>
</li>
@@ -2444,12 +2465,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id144">
+ <a class="reference internal nav-link" href="#id146">
Arguments
</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="#id147">
Example
</a>
</li>
@@ -2681,17 +2702,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="#id148">
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="#id149">
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="#id150">
Aliases
</a>
</li>
@@ -2716,12 +2737,12 @@
</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="#id151">
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="#id152">
Aliases
</a>
</li>
@@ -2746,7 +2767,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id151">
+ <a class="reference internal nav-link" href="#id153">
Arguments
</a>
</li>
@@ -2762,7 +2783,7 @@
</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="#id154">
Arguments
</a>
</li>
@@ -2785,7 +2806,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id153">
+ <a class="reference internal nav-link" href="#id155">
Arguments
</a>
</li>
@@ -2808,7 +2829,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id154">
+ <a class="reference internal nav-link" href="#id156">
Arguments
</a>
</li>
@@ -2824,7 +2845,7 @@
</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="#id157">
Arguments
</a>
</li>
@@ -2840,7 +2861,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id156">
+ <a class="reference internal nav-link" href="#id158">
Arguments
</a>
</li>
@@ -2856,7 +2877,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id157">
+ <a class="reference internal nav-link" href="#id159">
Arguments
</a>
</li>
@@ -2872,7 +2893,7 @@
</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="#id160">
Arguments
</a>
</li>
@@ -2888,7 +2909,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id159">
+ <a class="reference internal nav-link" href="#id161">
Arguments
</a>
</li>
@@ -2911,12 +2932,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id160">
+ <a class="reference internal nav-link" href="#id162">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id161">
+ <a class="reference internal nav-link" href="#id163">
Example
</a>
</li>
@@ -2932,12 +2953,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id162">
+ <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="#id163">
+ <a class="reference internal nav-link" href="#id165">
Example
</a>
</li>
@@ -4560,6 +4581,7 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<li><p><a class="reference internal"
href="#array-length">array_length</a></p></li>
<li><p><a class="reference internal"
href="#array-ndims">array_ndims</a></p></li>
<li><p><a class="reference internal"
href="#array-prepend">array_prepend</a></p></li>
+<li><p><a class="reference internal"
href="#array-pop-front">array_pop_front</a></p></li>
<li><p><a class="reference internal"
href="#array-pop-back">array_pop_back</a></p></li>
<li><p><a class="reference internal"
href="#array-position">array_position</a></p></li>
<li><p><a class="reference internal"
href="#array-positions">array_positions</a></p></li>
@@ -4939,10 +4961,10 @@ Can be a constant, column, or function, and any
combination of array operators.<
</ul>
</section>
</section>
-<section id="array-pop-back">
-<h3><code class="docutils literal notranslate"><span
class="pre">array_pop_back</span></code><a class="headerlink"
href="#array-pop-back" title="Link to this heading">¶</a></h3>
-<p>Returns the array without the last element.</p>
-<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>
+<section id="array-pop-front">
+<h3><code class="docutils literal notranslate"><span
class="pre">array_pop_front</span></code><a class="headerlink"
href="#array-pop-front" title="Link to this heading">¶</a></h3>
+<p>Returns the array without the first element.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_pop_first</span><span
class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
<section id="id106">
@@ -4954,6 +4976,31 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id107">
<h4>Example<a class="headerlink" href="#id107" title="Link to this
heading">¶</a></h4>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_pop_first([1, 2, 3]);
++-------------------------------+
+| array_pop_first(List([1,2,3])) |
++-------------------------------+
+| [2, 3] |
++-------------------------------+
+</pre></div>
+</div>
+</section>
+</section>
+<section id="array-pop-back">
+<h3><code class="docutils literal notranslate"><span
class="pre">array_pop_back</span></code><a class="headerlink"
href="#array-pop-back" title="Link to this heading">¶</a></h3>
+<p>Returns the array without the last element.</p>
+<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="id108">
+<h4>Arguments<a class="headerlink" href="#id108" 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="id109">
+<h4>Example<a class="headerlink" href="#id109" 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])) |
@@ -4971,8 +5018,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="id108">
-<h4>Arguments<a class="headerlink" href="#id108" title="Link to this
heading">¶</a></h4>
+<section id="id110">
+<h4>Arguments<a class="headerlink" href="#id110" 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>
@@ -4980,8 +5027,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="id109">
-<h4>Example<a class="headerlink" href="#id109" title="Link to this
heading">¶</a></h4>
+<section id="id111">
+<h4>Example<a class="headerlink" href="#id111" 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)) |
@@ -4991,8 +5038,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id110">
-<h4>Aliases<a class="headerlink" href="#id110" title="Link to this
heading">¶</a></h4>
+<section id="id112">
+<h4>Aliases<a class="headerlink" href="#id112" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_indexof</p></li>
<li><p>list_indexof</p></li>
@@ -5006,16 +5053,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="id111">
-<h4>Arguments<a class="headerlink" href="#id111" title="Link to this
heading">¶</a></h4>
+<section id="id113">
+<h4>Arguments<a class="headerlink" href="#id113" 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="id112">
-<h4>Example<a class="headerlink" href="#id112" title="Link to this
heading">¶</a></h4>
+<section id="id114">
+<h4>Example<a class="headerlink" href="#id114" 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)) |
@@ -5025,8 +5072,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id113">
-<h4>Aliases<a class="headerlink" href="#id113" title="Link to this
heading">¶</a></h4>
+<section id="id115">
+<h4>Aliases<a class="headerlink" href="#id115" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_positions</p></li>
</ul>
@@ -5046,16 +5093,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="id114">
-<h4>Arguments<a class="headerlink" href="#id114" title="Link to this
heading">¶</a></h4>
+<section id="id116">
+<h4>Arguments<a class="headerlink" href="#id116" 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="id115">
-<h4>Example<a class="headerlink" href="#id115" title="Link to this
heading">¶</a></h4>
+<section id="id117">
+<h4>Example<a class="headerlink" href="#id117" 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)) |
@@ -5080,16 +5127,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="id116">
-<h4>Arguments<a class="headerlink" href="#id116" title="Link to this
heading">¶</a></h4>
+<section id="id118">
+<h4>Arguments<a class="headerlink" href="#id118" 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="id117">
-<h4>Example<a class="headerlink" href="#id117" title="Link to this
heading">¶</a></h4>
+<section id="id119">
+<h4>Example<a class="headerlink" href="#id119" 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)) |
@@ -5099,8 +5146,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id118">
-<h4>Aliases<a class="headerlink" href="#id118" title="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_remove</p></li>
</ul>
@@ -5112,8 +5159,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="id119">
-<h4>Arguments<a class="headerlink" href="#id119" 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>
@@ -5121,8 +5168,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="id120">
-<h4>Example<a class="headerlink" href="#id120" title="Link to this
heading">¶</a></h4>
+<section id="id122">
+<h4>Example<a class="headerlink" href="#id122" 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)) |
@@ -5132,8 +5179,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id121">
-<h4>Aliases<a class="headerlink" href="#id121" title="Link to this
heading">¶</a></h4>
+<section id="id123">
+<h4>Aliases<a class="headerlink" href="#id123" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove_n</p></li>
</ul>
@@ -5145,16 +5192,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="id122">
-<h4>Arguments<a class="headerlink" href="#id122" title="Link to this
heading">¶</a></h4>
+<section id="id124">
+<h4>Arguments<a class="headerlink" href="#id124" 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="id123">
-<h4>Example<a class="headerlink" href="#id123" title="Link to this
heading">¶</a></h4>
+<section id="id125">
+<h4>Example<a class="headerlink" href="#id125" 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)) |
@@ -5164,8 +5211,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id124">
-<h4>Aliases<a class="headerlink" href="#id124" title="Link to this
heading">¶</a></h4>
+<section id="id126">
+<h4>Aliases<a class="headerlink" href="#id126" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove_all</p></li>
</ul>
@@ -5177,8 +5224,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="id125">
-<h4>Arguments<a class="headerlink" href="#id125" title="Link to this
heading">¶</a></h4>
+<section id="id127">
+<h4>Arguments<a class="headerlink" href="#id127" 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>
@@ -5186,8 +5233,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<li><p><strong>to</strong>: Final element.</p></li>
</ul>
</section>
-<section id="id126">
-<h4>Example<a class="headerlink" href="#id126" title="Link to this
heading">¶</a></h4>
+<section id="id128">
+<h4>Example<a class="headerlink" href="#id128" 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)) |
@@ -5197,8 +5244,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id127">
-<h4>Aliases<a class="headerlink" href="#id127" title="Link to this
heading">¶</a></h4>
+<section id="id129">
+<h4>Aliases<a class="headerlink" href="#id129" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace</p></li>
</ul>
@@ -5210,8 +5257,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="id128">
-<h4>Arguments<a class="headerlink" href="#id128" title="Link to this
heading">¶</a></h4>
+<section id="id130">
+<h4>Arguments<a class="headerlink" href="#id130" 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>
@@ -5220,8 +5267,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="id129">
-<h4>Example<a class="headerlink" href="#id129" title="Link to this
heading">¶</a></h4>
+<section id="id131">
+<h4>Example<a class="headerlink" href="#id131" 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)) |
@@ -5231,8 +5278,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id130">
-<h4>Aliases<a class="headerlink" href="#id130" title="Link to this
heading">¶</a></h4>
+<section id="id132">
+<h4>Aliases<a class="headerlink" href="#id132" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace_n</p></li>
</ul>
@@ -5244,8 +5291,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="id131">
-<h4>Arguments<a class="headerlink" href="#id131" 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>
@@ -5253,8 +5300,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="id132">
-<h4>Example<a class="headerlink" href="#id132" title="Link to this
heading">¶</a></h4>
+<section id="id134">
+<h4>Example<a class="headerlink" href="#id134" 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)) |
@@ -5264,8 +5311,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="id135">
+<h4>Aliases<a class="headerlink" href="#id135" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace_all</p></li>
</ul>
@@ -5277,8 +5324,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="id134">
-<h4>Example<a class="headerlink" href="#id134" title="Link to this
heading">¶</a></h4>
+<section id="id136">
+<h4>Example<a class="headerlink" href="#id136" 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)) |
@@ -5288,8 +5335,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id135">
-<h4>Aliases<a class="headerlink" href="#id135" title="Link to this
heading">¶</a></h4>
+<section id="id137">
+<h4>Aliases<a class="headerlink" href="#id137" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_slice</p></li>
</ul>
@@ -5301,16 +5348,16 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_to_string</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">delimiter</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id136">
-<h4>Arguments<a class="headerlink" href="#id136" title="Link to this
heading">¶</a></h4>
+<section id="id138">
+<h4>Arguments<a class="headerlink" href="#id138" 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="id137">
-<h4>Example<a class="headerlink" href="#id137" title="Link to this
heading">¶</a></h4>
+<section id="id139">
+<h4>Example<a class="headerlink" href="#id139" 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(",")) |
@@ -5320,8 +5367,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id138">
-<h4>Aliases<a class="headerlink" href="#id138" title="Link to this
heading">¶</a></h4>
+<section id="id140">
+<h4>Aliases<a class="headerlink" href="#id140" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_join</p></li>
<li><p>list_join</p></li>
@@ -5335,8 +5382,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="id139">
-<h4>Arguments<a class="headerlink" href="#id139" title="Link to this
heading">¶</a></h4>
+<section id="id141">
+<h4>Arguments<a class="headerlink" href="#id141" 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>
@@ -5344,8 +5391,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="id140">
-<h4>Example<a class="headerlink" href="#id140" title="Link to this
heading">¶</a></h4>
+<section id="id142">
+<h4>Example<a class="headerlink" href="#id142" 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]); |
@@ -5362,8 +5409,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</div>
</section>
<hr class="docutils" />
-<section id="id141">
-<h4>Aliases<a class="headerlink" href="#id141" title="Link to this
heading">¶</a></h4>
+<section id="id143">
+<h4>Aliases<a class="headerlink" href="#id143" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_union</p></li>
</ul>
@@ -5375,15 +5422,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="id142">
-<h4>Arguments<a class="headerlink" href="#id142" title="Link to this
heading">¶</a></h4>
+<section id="id144">
+<h4>Arguments<a class="headerlink" href="#id144" 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="id143">
-<h4>Example<a class="headerlink" href="#id143" title="Link to this
heading">¶</a></h4>
+<section id="id145">
+<h4>Example<a class="headerlink" href="#id145" 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])) |
@@ -5400,15 +5447,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="id144">
-<h4>Arguments<a class="headerlink" href="#id144" 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="id145">
-<h4>Example<a class="headerlink" href="#id145" 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 empty([1]);
+------------------+
| empty(List([1])) |
@@ -5521,16 +5568,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="id146">
-<h4>Arguments<a class="headerlink" href="#id146" title="Link to this
heading">¶</a></h4>
+<section id="id148">
+<h4>Arguments<a class="headerlink" href="#id148" 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="id147">
-<h4>Example<a class="headerlink" href="#id147" title="Link to this
heading">¶</a></h4>
+<section id="id149">
+<h4>Example<a class="headerlink" href="#id149" 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)) |
@@ -5540,8 +5587,8 @@ string operators.</p></li>
</pre></div>
</div>
</section>
-<section id="id148">
-<h4>Aliases<a class="headerlink" href="#id148" title="Link to this
heading">¶</a></h4>
+<section id="id150">
+<h4>Aliases<a class="headerlink" href="#id150" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>make_list</p></li>
</ul>
@@ -5557,16 +5604,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="id149">
-<h4>Arguments<a class="headerlink" href="#id149" title="Link to this
heading">¶</a></h4>
+<section id="id151">
+<h4>Arguments<a class="headerlink" href="#id151" 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="id150">
-<h4>Aliases<a class="headerlink" href="#id150" title="Link to this
heading">¶</a></h4>
+<section id="id152">
+<h4>Aliases<a class="headerlink" href="#id152" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>string_to_list</p></li>
</ul>
@@ -5583,8 +5630,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="id151">
-<h4>Arguments<a class="headerlink" href="#id151" title="Link to this
heading">¶</a></h4>
+<section id="id153">
+<h4>Arguments<a class="headerlink" href="#id153" 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>
@@ -5597,8 +5644,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<p>Returns an Arrow array between start and stop with step. <code
class="docutils literal notranslate"><span class="pre">SELECT</span> <span
class="pre">range(2,</span> <span class="pre">10,</span> <span
class="pre">3)</span> <span class="pre">-></span> <span
class="pre">[2,</span> <span class="pre">5,</span> <span
class="pre">8]</span></code></p>
<p>The range start..end contains all values with start <= x < end. It is
empty if start >= end.</p>
<p>Step can not be 0 (then the range will be nonsense.).</p>
-<section id="id152">
-<h4>Arguments<a class="headerlink" href="#id152" title="Link to this
heading">¶</a></h4>
+<section id="id154">
+<h4>Arguments<a class="headerlink" href="#id154" 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>
@@ -5639,8 +5686,8 @@ a struct type of fields <code class="docutils literal
notranslate"><span class="
<span class="o">+</span><span class="c1">-----------------+</span>
</pre></div>
</div>
-<section id="id153">
-<h4>Arguments<a class="headerlink" href="#id153" 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>expression_n</strong>: Expression to include in the output
struct.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -5665,8 +5712,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="id154">
-<h4>Arguments<a class="headerlink" href="#id154" title="Link to this
heading">¶</a></h4>
+<section id="id156">
+<h4>Arguments<a class="headerlink" href="#id156" 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>
@@ -5692,8 +5739,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="id155">
-<h4>Arguments<a class="headerlink" href="#id155" title="Link to this
heading">¶</a></h4>
+<section id="id157">
+<h4>Arguments<a class="headerlink" href="#id157" 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>
@@ -5706,8 +5753,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="id156">
-<h4>Arguments<a class="headerlink" href="#id156" 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>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -5720,8 +5767,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="id157">
-<h4>Arguments<a class="headerlink" href="#id157" title="Link to this
heading">¶</a></h4>
+<section id="id159">
+<h4>Arguments<a class="headerlink" href="#id159" 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>
@@ -5734,8 +5781,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="id158">
-<h4>Arguments<a class="headerlink" href="#id158" title="Link to this
heading">¶</a></h4>
+<section id="id160">
+<h4>Arguments<a class="headerlink" href="#id160" 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>
@@ -5748,8 +5795,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="id159">
-<h4>Arguments<a class="headerlink" href="#id159" 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>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -5769,8 +5816,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="id160">
-<h4>Arguments<a class="headerlink" href="#id160" title="Link to this
heading">¶</a></h4>
+<section id="id162">
+<h4>Arguments<a class="headerlink" href="#id162" 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
@@ -5779,8 +5826,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="id161">
-<h4>Example<a class="headerlink" href="#id161" title="Link to this
heading">¶</a></h4>
+<section id="id163">
+<h4>Example<a class="headerlink" href="#id163" 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,
@@ -5802,16 +5849,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="id162">
-<h4>Arguments<a class="headerlink" href="#id162" 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>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="id163">
-<h4>Example<a class="headerlink" href="#id163" 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 arrow_typeof('foo'),
arrow_typeof(1);
+---------------------------+------------------------+
| arrow_typeof(Utf8("foo")) | arrow_typeof(Int64(1)) |
