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 191c8fc1a3 Publish built docs triggered by
3ffeb52c1c9891e63fcb17db41283d7299af6f18
191c8fc1a3 is described below
commit 191c8fc1a3a57329677cbcb4c24d29613901c153
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Wed Aug 23 16:36:15 2023 +0000
Publish built docs triggered by 3ffeb52c1c9891e63fcb17db41283d7299af6f18
---
_sources/user-guide/expressions.md.txt | 1 +
_sources/user-guide/sql/scalar_functions.md.txt | 25 ++
searchindex.js | 2 +-
user-guide/expressions.html | 33 +--
user-guide/sql/scalar_functions.html | 333 ++++++++++++++----------
5 files changed, 235 insertions(+), 159 deletions(-)
diff --git a/_sources/user-guide/expressions.md.txt
b/_sources/user-guide/expressions.md.txt
index d8dfa7af53..a481e525fe 100644
--- a/_sources/user-guide/expressions.md.txt
+++ b/_sources/user-guide/expressions.md.txt
@@ -194,6 +194,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_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]`
|
| array_prepend(array, element) | Prepends an element to the beginning
of an array. `array_prepend(1, [2, 3, 4]) -> [1, 2, 3, 4]`
|
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index c6e2f5ddd8..fc62938502 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -1481,6 +1481,7 @@ from_unixtime(expression)
- [array_length](#array_length)
- [array_ndims](#array_ndims)
- [array_prepend](#array_prepend)
+- [array_pop_back](#array_pop_back)
- [array_position](#array_position)
- [array_positions](#array_positions)
- [array_push_back](#array_push_back)
@@ -1830,6 +1831,30 @@ array_prepend(element, array)
- list_prepend
- list_push_front
+### `array_pop_back`
+
+Returns the array without the last element.
+
+```
+array_pop_back(array)
+```
+
+#### Arguments
+
+- **array**: Array expression.
+ Can be a constant, column, or function, and any combination of array
operators.
+
+#### Example
+
+```
+❯ select array_pop_back([1, 2, 3]);
++-------------------------------+
+| array_pop_back(List([1,2,3])) |
++-------------------------------+
+| [1, 2] |
++-------------------------------+
+```
+
### `array_position`
Returns a string with an input string repeated a specified number.
diff --git a/searchindex.js b/searchindex.js
index 1c0611f9cc..0ca75b13f1 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 fd1444ba19..96635fb822 100644
--- a/user-guide/expressions.html
+++ b/user-guide/expressions.html
@@ -908,49 +908,52 @@ expressions such as <code class="docutils literal
notranslate"><span class="pre"
<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_position(array, element)</p></td>
+<tr class="row-even"><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>
<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-odd"><td><p>array_positions(array, element)</p></td>
+<tr class="row-even"><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-even"><td><p>array_prepend(array, element)</p></td>
+<tr class="row-odd"><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-odd"><td><p>array_repeat(element, count)</p></td>
+<tr class="row-even"><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-even"><td><p>array_remove(array, element)</p></td>
+<tr class="row-odd"><td><p>array_remove(array, element)</p></td>
<td><p>Removes the first element from the array equal to the given value.
<code class="docutils literal notranslate"><span
class="pre">array_remove([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">2,</span>
<span class="pre">1,</span> <span class="pre">4],</span> <span
class="pre">2)</span> <span class="pre">-></span> <span
class="pre">[1,</span> <span class="pre">2,</span> <span class="pre">3,</span>
<span class="pre">2, [...]
</tr>
-<tr class="row-odd"><td><p>array_remove_n(array, element, max)</p></td>
+<tr class="row-even"><td><p>array_remove_n(array, element, max)</p></td>
<td><p>Removes the first <code class="docutils literal notranslate"><span
class="pre">max</span></code> elements from the array equal to the given value.
<code class="docutils literal notranslate"><span
class="pre">array_remove_n([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">2,</span>
<span class="pre">1,</span> <span class="pre">4],</span> <span
class="pre">2,</span> <span class="pre">2)</span> <span class="pre">-></s
[...]
</tr>
-<tr class="row-even"><td><p>array_remove_all(array, element)</p></td>
+<tr class="row-odd"><td><p>array_remove_all(array, element)</p></td>
<td><p>Removes all elements from the array equal to the given value. <code
class="docutils literal notranslate"><span
class="pre">array_remove_all([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">2,</span>
<span class="pre">1,</span> <span class="pre">4],</span> <span
class="pre">2)</span> <span class="pre">-></span> <span
class="pre">[1,</span> <span class="pre">3,</span> <span class="pre">1,</span>
<span class="pre">4]< [...]
</tr>
-<tr class="row-odd"><td><p>array_replace(array, from, to)</p></td>
+<tr class="row-even"><td><p>array_replace(array, from, to)</p></td>
<td><p>Replaces the first occurrence of the specified element with another
specified element. <code class="docutils literal notranslate"><span
class="pre">array_replace([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">2,</span>
<span class="pre">1,</span> <span class="pre">4],</span> <span
class="pre">2,</span> <span class="pre">5)</span> <span
class="pre">-></span> <span class="pre">[1,</span> <span
class="pre">5,</span> [...]
</tr>
-<tr class="row-even"><td><p>array_replace_n(array, from, to, max)</p></td>
+<tr class="row-odd"><td><p>array_replace_n(array, from, to, max)</p></td>
<td><p>Replaces the first <code class="docutils literal notranslate"><span
class="pre">max</span></code> occurrences of the specified element with another
specified element. <code class="docutils literal notranslate"><span
class="pre">array_replace_n([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">2,</span>
<span class="pre">1,</span> <span class="pre">4],</span> <span
class="pre">2,</span> <span class="pre">5,</span> <span [...]
</tr>
-<tr class="row-odd"><td><p>array_replace_all(array, from, to)</p></td>
+<tr class="row-even"><td><p>array_replace_all(array, from, to)</p></td>
<td><p>Replaces all occurrences of the specified element with another
specified element. <code class="docutils literal notranslate"><span
class="pre">array_replace_all([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">2,</span>
<span class="pre">1,</span> <span class="pre">4],</span> <span
class="pre">2,</span> <span class="pre">5)</span> <span
class="pre">-></span> <span class="pre">[1,</span> <span
class="pre">5,</span> [...]
</tr>
-<tr class="row-even"><td><p>array_slice(array, index)</p></td>
+<tr class="row-odd"><td><p>array_slice(array, index)</p></td>
<td><p>Returns a slice of the array. <code class="docutils literal
notranslate"><span class="pre">array_slice([1,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">4,</span>
<span class="pre">5,</span> <span class="pre">6,</span> <span
class="pre">7,</span> <span class="pre">8],</span> <span class="pre">3,</span>
<span class="pre">6)</span> <span class="pre">-></span> <span
class="pre">[3,</span> <span class="pre">4,</span> <span class="pre">5,</span>
<s [...]
</tr>
-<tr class="row-odd"><td><p>array_to_string(array, delimeter)</p></td>
+<tr class="row-even"><td><p>array_to_string(array, delimeter)</p></td>
<td><p>Converts each element to its text representation. <code class="docutils
literal notranslate"><span class="pre">array_to_string([1,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">4],</span>
<span class="pre">',')</span> <span class="pre">-></span> <span
class="pre">1,2,3,4</span></code></p></td>
</tr>
-<tr class="row-even"><td><p>cardinality(array)</p></td>
+<tr class="row-odd"><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-odd"><td><p>make_array(value1, [value2 [, …]])</p></td>
+<tr class="row-even"><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-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 8f1d60e54c..5ec314b9e5 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -2037,10 +2037,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>
@@ -2055,8 +2055,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="#id107">
+ Arguments
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id108">
+ Example
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id109">
Aliases
</a>
</li>
@@ -2072,17 +2093,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id108">
+ <a class="reference internal nav-link" href="#id110">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id109">
+ <a class="reference internal nav-link" href="#id111">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id110">
+ <a class="reference internal nav-link" href="#id112">
Aliases
</a>
</li>
@@ -2116,12 +2137,12 @@
</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>
@@ -2137,17 +2158,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id113">
+ <a class="reference internal nav-link" href="#id115">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id114">
+ <a class="reference internal nav-link" href="#id116">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id115">
+ <a class="reference internal nav-link" href="#id117">
Aliases
</a>
</li>
@@ -2163,17 +2184,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>
@@ -2189,17 +2210,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>
@@ -2215,17 +2236,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>
@@ -2241,17 +2262,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>
@@ -2267,17 +2288,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>
@@ -2293,12 +2314,12 @@
</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">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id132">
+ <a class="reference internal nav-link" href="#id134">
Aliases
</a>
</li>
@@ -2314,17 +2335,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id133">
+ <a class="reference internal nav-link" href="#id135">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id134">
+ <a class="reference internal nav-link" href="#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>
@@ -2340,12 +2361,12 @@
</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>
@@ -2361,12 +2382,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id138">
+ <a class="reference internal nav-link" href="#id140">
Arguments
</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="#id141">
Example
</a>
</li>
@@ -2598,17 +2619,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="#id142">
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="#id143">
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="#id144">
Aliases
</a>
</li>
@@ -2633,7 +2654,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id143">
+ <a class="reference internal nav-link" href="#id145">
Arguments
</a>
</li>
@@ -2656,7 +2677,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id144">
+ <a class="reference internal nav-link" href="#id146">
Arguments
</a>
</li>
@@ -2679,7 +2700,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id145">
+ <a class="reference internal nav-link" href="#id147">
Arguments
</a>
</li>
@@ -2695,7 +2716,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id146">
+ <a class="reference internal nav-link" href="#id148">
Arguments
</a>
</li>
@@ -2711,7 +2732,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id147">
+ <a class="reference internal nav-link" href="#id149">
Arguments
</a>
</li>
@@ -2727,7 +2748,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id148">
+ <a class="reference internal nav-link" href="#id150">
Arguments
</a>
</li>
@@ -2743,7 +2764,7 @@
</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>
@@ -2759,7 +2780,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id150">
+ <a class="reference internal nav-link" href="#id152">
Arguments
</a>
</li>
@@ -2782,7 +2803,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>
@@ -2798,7 +2819,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>
@@ -4387,6 +4408,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-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>
<li><p><a class="reference internal"
href="#array-push-back">array_push_back</a></p></li>
@@ -4762,6 +4784,31 @@ 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>
+</pre></div>
+</div>
+<section id="id105">
+<h4>Arguments<a class="headerlink" href="#id105" 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="id106">
+<h4>Example<a class="headerlink" href="#id106" 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])) |
++-------------------------------+
+| [1, 2] |
++-------------------------------+
+</pre></div>
+</div>
+</section>
+</section>
<section id="array-position">
<h3><code class="docutils literal notranslate"><span
class="pre">array_position</span></code><a class="headerlink"
href="#array-position" title="Link to this heading">¶</a></h3>
<p>Returns a string with an input string repeated a specified number.</p>
@@ -4769,8 +4816,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="id105">
-<h4>Arguments<a class="headerlink" href="#id105" title="Link to this
heading">¶</a></h4>
+<section id="id107">
+<h4>Arguments<a class="headerlink" href="#id107" 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>
@@ -4778,8 +4825,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="id106">
-<h4>Example<a class="headerlink" href="#id106" title="Link to this
heading">¶</a></h4>
+<section id="id108">
+<h4>Example<a class="headerlink" href="#id108" 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)) |
@@ -4789,8 +4836,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id107">
-<h4>Aliases<a class="headerlink" href="#id107" title="Link to this
heading">¶</a></h4>
+<section id="id109">
+<h4>Aliases<a class="headerlink" href="#id109" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_indexof</p></li>
<li><p>list_indexof</p></li>
@@ -4804,16 +4851,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="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>
<li><p><strong>element</strong>: Element to search for positions in the
array.</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_positions([1, 2, 2, 3, 1,
4], 2);
+-----------------------------------------------+
| array_positions(List([1,2,2,3,1,4]),Int64(2)) |
@@ -4823,8 +4870,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>list_positions</p></li>
</ul>
@@ -4844,16 +4891,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="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>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="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_repeat(1, 3);
+---------------------------------+
| array_repeat(Int64(1),Int64(3)) |
@@ -4878,16 +4925,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="id113">
-<h4>Arguments<a class="headerlink" href="#id113" title="Link to this
heading">¶</a></h4>
+<section id="id115">
+<h4>Arguments<a class="headerlink" href="#id115" 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="id114">
-<h4>Example<a class="headerlink" href="#id114" title="Link to this
heading">¶</a></h4>
+<section id="id116">
+<h4>Example<a class="headerlink" href="#id116" 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)) |
@@ -4897,8 +4944,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id115">
-<h4>Aliases<a class="headerlink" href="#id115" title="Link to this
heading">¶</a></h4>
+<section id="id117">
+<h4>Aliases<a class="headerlink" href="#id117" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove</p></li>
</ul>
@@ -4910,8 +4957,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="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>
@@ -4919,8 +4966,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="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_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)) |
@@ -4930,8 +4977,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_n</p></li>
</ul>
@@ -4943,16 +4990,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="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>
<li><p><strong>element</strong>: Element to be removed from the array.</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_all([1, 2, 2, 3, 2,
1, 4], 2);
+--------------------------------------------------+
| array_remove_all(List([1,2,2,3,2,1,4]),Int64(2)) |
@@ -4962,8 +5009,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_all</p></li>
</ul>
@@ -4975,8 +5022,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="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>
@@ -4984,8 +5031,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="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_replace([1, 2, 2, 3, 2, 1,
4], 2, 5);
+--------------------------------------------------------+
| array_replace(List([1,2,2,3,2,1,4]),Int64(2),Int64(5)) |
@@ -4995,8 +5042,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_replace</p></li>
</ul>
@@ -5008,8 +5055,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="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>
@@ -5018,8 +5065,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="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_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)) |
@@ -5029,8 +5076,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_n</p></li>
</ul>
@@ -5042,8 +5089,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="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>
@@ -5051,8 +5098,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="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_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)) |
@@ -5062,8 +5109,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_all</p></li>
</ul>
@@ -5075,8 +5122,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="id131">
-<h4>Example<a class="headerlink" href="#id131" title="Link to this
heading">¶</a></h4>
+<section id="id133">
+<h4>Example<a class="headerlink" href="#id133" 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)) |
@@ -5086,8 +5133,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id132">
-<h4>Aliases<a class="headerlink" href="#id132" title="Link to this
heading">¶</a></h4>
+<section id="id134">
+<h4>Aliases<a class="headerlink" href="#id134" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_slice</p></li>
</ul>
@@ -5099,16 +5146,16 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_to_string</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">delimeter</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id133">
-<h4>Arguments<a class="headerlink" href="#id133" title="Link to this
heading">¶</a></h4>
+<section id="id135">
+<h4>Arguments<a class="headerlink" href="#id135" 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>delimeter</strong>: Array element separator.</p></li>
</ul>
</section>
-<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_to_string([[1, 2, 3, 4], [5,
6, 7, 8]], ',');
+----------------------------------------------------+
| array_to_string(List([1,2,3,4,5,6,7,8]),Utf8(",")) |
@@ -5118,8 +5165,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>array_join</p></li>
<li><p>list_join</p></li>
@@ -5133,15 +5180,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="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>
</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 cardinality([[1, 2, 3, 4], [5, 6,
7, 8]]);
+--------------------------------------+
| cardinality(List([1,2,3,4,5,6,7,8])) |
@@ -5158,15 +5205,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="id138">
-<h4>Arguments<a class="headerlink" href="#id138" 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>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id139">
-<h4>Example<a class="headerlink" href="#id139" 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 empty([1]);
+------------------+
| empty(List([1])) |
@@ -5279,16 +5326,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="id140">
-<h4>Arguments<a class="headerlink" href="#id140" title="Link to this
heading">¶</a></h4>
+<section id="id142">
+<h4>Arguments<a class="headerlink" href="#id142" 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="id141">
-<h4>Example<a class="headerlink" href="#id141" title="Link to this
heading">¶</a></h4>
+<section id="id143">
+<h4>Example<a class="headerlink" href="#id143" 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)) |
@@ -5298,8 +5345,8 @@ string operators.</p></li>
</pre></div>
</div>
</section>
-<section id="id142">
-<h4>Aliases<a class="headerlink" href="#id142" title="Link to this
heading">¶</a></h4>
+<section id="id144">
+<h4>Aliases<a class="headerlink" href="#id144" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>make_list</p></li>
</ul>
@@ -5316,8 +5363,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="id143">
-<h4>Arguments<a class="headerlink" href="#id143" title="Link to this
heading">¶</a></h4>
+<section id="id145">
+<h4>Arguments<a class="headerlink" href="#id145" 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>
@@ -5358,8 +5405,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="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>expression_n</strong>: Expression to include in the output
struct.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -5384,8 +5431,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="id145">
-<h4>Arguments<a class="headerlink" href="#id145" title="Link to this
heading">¶</a></h4>
+<section id="id147">
+<h4>Arguments<a class="headerlink" href="#id147" 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>
@@ -5411,8 +5458,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="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</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -5425,8 +5472,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="id147">
-<h4>Arguments<a class="headerlink" href="#id147" 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>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -5439,8 +5486,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="id148">
-<h4>Arguments<a class="headerlink" href="#id148" title="Link to this
heading">¶</a></h4>
+<section id="id150">
+<h4>Arguments<a class="headerlink" href="#id150" 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>
@@ -5453,8 +5500,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="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>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -5467,8 +5514,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="id150">
-<h4>Arguments<a class="headerlink" href="#id150" 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>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -5488,8 +5535,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="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>expression</strong>: Expression to cast.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -5505,8 +5552,8 @@ to cast to.</p></li>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">arrow_typeof</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="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>expression</strong>: Expression to evaluate.
Can be a constant, column, or function, and any combination of arithmetic or
