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 ffeab7017d Publish built docs triggered by
3eb7080671e0a80ebb7d75ea76f0dcbf2cfe4e68
ffeab7017d is described below
commit ffeab7017dc32175b17e3e058e58fb3d0485b88b
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Tue Jan 30 01:49:22 2024 +0000
Publish built docs triggered by 3eb7080671e0a80ebb7d75ea76f0dcbf2cfe4e68
---
_sources/user-guide/sql/scalar_functions.md.txt | 63 ++-
searchindex.js | 2 +-
user-guide/sql/scalar_functions.html | 659 ++++++++++++++----------
3 files changed, 461 insertions(+), 263 deletions(-)
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index 4ad58a5067..04044560f7 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -1765,11 +1765,16 @@ from_unixtime(expression)
- [list_dims](#list_dims)
- [list_element](#list_element)
- [list_extract](#list_extract)
+- [list_has](#list_has)
+- [list_has_all](#list_has_all)
+- [list_has_any](#list_has_any)
- [list_indexof](#list_indexof)
- [list_join](#list_join)
- [list_length](#list_length)
- [list_ndims](#list_ndims)
- [list_prepend](#list_prepend)
+- [list_pop_back](#list_pop_back)
+- [list_pop_front](#list_pop_front)
- [list_position](#list_position)
- [list_positions](#list_positions)
- [list_push_back](#list_push_back)
@@ -1901,6 +1906,10 @@ array_has(array, element)
- **element**: Scalar or Array expression.
Can be a constant, column, or function, and any combination of array
operators.
+#### Aliases
+
+- list_has
+
### `array_has_all`
Returns true if all elements of sub-array exist in array
@@ -1916,6 +1925,10 @@ array_has_all(array, sub-array)
- **sub-array**: Array expression.
Can be a constant, column, or function, and any combination of array
operators.
+#### Aliases
+
+- list_has_all
+
### `array_has_any`
Returns true if any elements exist in both arrays
@@ -1931,6 +1944,10 @@ array_has_any(array, sub-array)
- **sub-array**: Array expression.
Can be a constant, column, or function, and any combination of array
operators.
+#### Aliases
+
+- list_has_any
+
### `array_dims`
Returns an array of the array's dimensions.
@@ -1990,8 +2007,6 @@ array_element(array, index)
- list_element
- list_extract
-### `array_empty`
-
### `array_extract`
_Alias of [array_element](#array_element)._
@@ -2150,6 +2165,10 @@ array_pop_front(array)
+-------------------------------+
```
+#### Aliases
+
+- list_pop_front
+
### `array_pop_back`
Returns the array without the last element.
@@ -2174,6 +2193,10 @@ array_pop_back(array)
+-------------------------------+
```
+#### Aliases
+
+- list_pop_back
+
### `array_position`
Returns the position of the first occurrence of the specified element in the
array.
@@ -2278,6 +2301,10 @@ array_repeat(element, count)
+------------------------------------+
```
+#### Aliases
+
+- list_repeat
+
### `array_remove`
Removes the first element from the array equal to the given value.
@@ -2459,12 +2486,22 @@ array_replace_all(array, from, to)
### `array_slice`
-Returns a slice of the array.
+Returns a slice of the array based on 1-indexed start and end positions.
```
array_slice(array, begin, end)
```
+#### Arguments
+
+- **array**: Array expression.
+ Can be a constant, column, or function, and any combination of array
operators.
+- **begin**: Index of the first element.
+ If negative, it counts backward from the end of the array.
+- **end**: Index of the last element.
+ If negative, it counts backward from the end of the array.
+- **stride**: Stride of the array slice. The default is 1.
+
#### Example
```
@@ -2663,6 +2700,18 @@ _Alias of [array_element](#array_element)._
_Alias of [array_element](#array_element)._
+### `list_has`
+
+_Alias of [array_has](#array_has)._
+
+### `list_has_all`
+
+_Alias of [array_has_all](#array_has_all)._
+
+### `list_has_any`
+
+_Alias of [array_has_any](#array_has_any)._
+
### `list_indexof`
_Alias of [array_position](#array_position)._
@@ -2683,6 +2732,14 @@ _Alias of [array_ndims](#array_ndims)._
_Alias of [array_prepend](#array_prepend)._
+### `list_pop_back`
+
+_Alias of [array_pop_back](#array_pop_back)._
+
+### `list_pop_front`
+
+_Alias of [array_pop_front](#array_pop_front)._
+
### `list_position`
_Alias of [array_position](#array_position)._
diff --git a/searchindex.js b/searchindex.js
index 6152e7e07a..7198ae6d84 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/sql/scalar_functions.html
b/user-guide/sql/scalar_functions.html
index 279e8c306b..c76358a512 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -2000,6 +2000,11 @@
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id102">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -2012,10 +2017,15 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id102">
+ <a class="reference internal nav-link" href="#id103">
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id104">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -2028,10 +2038,15 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id103">
+ <a class="reference internal nav-link" href="#id105">
Arguments
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id106">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -2044,17 +2059,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id104">
+ <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="#id105">
+ <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="#id106">
+ <a class="reference internal nav-link" href="#id109">
Aliases
</a>
</li>
@@ -2070,31 +2085,22 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id107">
+ <a class="reference internal nav-link" href="#id110">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id108">
+ <a class="reference internal nav-link" href="#id111">
Example
</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="#id112">
Aliases
</a>
</li>
</ul>
</li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#array-empty">
- <code class="docutils literal notranslate">
- <span class="pre">
- array_empty
- </span>
- </code>
- </a>
- </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#array-extract">
<code class="docutils literal notranslate">
@@ -2114,7 +2120,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id110">
+ <a class="reference internal nav-link" href="#id113">
Arguments
</a>
</li>
@@ -2130,7 +2136,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id111">
+ <a class="reference internal nav-link" href="#id114">
Arguments
</a>
</li>
@@ -2164,17 +2170,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id112">
+ <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="#id113">
+ <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="#id114">
+ <a class="reference internal nav-link" href="#id117">
Aliases
</a>
</li>
@@ -2190,17 +2196,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id115">
+ <a class="reference internal nav-link" href="#id118">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id116">
+ <a class="reference internal nav-link" href="#id119">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id117">
+ <a class="reference internal nav-link" href="#id120">
Aliases
</a>
</li>
@@ -2216,17 +2222,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id118">
+ <a class="reference internal nav-link" href="#id121">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id119">
+ <a class="reference internal nav-link" href="#id122">
Example
</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="#id123">
Aliases
</a>
</li>
@@ -2242,15 +2248,20 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id121">
+ <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="#id122">
+ <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="#id126">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -2263,15 +2274,20 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id123">
+ <a class="reference internal nav-link" href="#id127">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id124">
+ <a class="reference internal nav-link" href="#id128">
Example
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id129">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -2284,17 +2300,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="#id130">
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="#id131">
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="#id132">
Aliases
</a>
</li>
@@ -2310,17 +2326,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="#id133">
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="#id134">
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="#id135">
Aliases
</a>
</li>
@@ -2354,15 +2370,20 @@
</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="#id136">
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="#id137">
Example
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id138">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -2375,17 +2396,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="#id139">
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="#id140">
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="#id141">
Aliases
</a>
</li>
@@ -2401,17 +2422,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="#id142">
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="#id143">
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="#id144">
Aliases
</a>
</li>
@@ -2427,17 +2448,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="#id145">
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="#id146">
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="#id147">
Aliases
</a>
</li>
@@ -2453,17 +2474,17 @@
</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="#id148">
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="#id149">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id144">
+ <a class="reference internal nav-link" href="#id150">
Aliases
</a>
</li>
@@ -2479,17 +2500,17 @@
</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="#id151">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id146">
+ <a class="reference internal nav-link" href="#id152">
Example
</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="#id153">
Aliases
</a>
</li>
@@ -2505,17 +2526,17 @@
</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="#id154">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id149">
+ <a class="reference internal nav-link" href="#id155">
Example
</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="#id156">
Aliases
</a>
</li>
@@ -2531,12 +2552,17 @@
</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="#id157">
+ Arguments
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id158">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id152">
+ <a class="reference internal nav-link" href="#id159">
Aliases
</a>
</li>
@@ -2552,17 +2578,17 @@
</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="#id160">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id154">
+ <a class="reference internal nav-link" href="#id161">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id155">
+ <a class="reference internal nav-link" href="#id162">
Aliases
</a>
</li>
@@ -2578,17 +2604,17 @@
</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="#id163">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id157">
+ <a class="reference internal nav-link" href="#id164">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id158">
+ <a class="reference internal nav-link" href="#id165">
Aliases
</a>
</li>
@@ -2604,17 +2630,17 @@
</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="#id166">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id160">
+ <a class="reference internal nav-link" href="#id167">
Example
</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="#id168">
Aliases
</a>
</li>
@@ -2630,12 +2656,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="#id169">
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="#id170">
Example
</a>
</li>
@@ -2651,12 +2677,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id164">
+ <a class="reference internal nav-link" href="#id171">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id165">
+ <a class="reference internal nav-link" href="#id172">
Example
</a>
</li>
@@ -2725,6 +2751,33 @@
</code>
</a>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-has">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_has
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-has-all">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_has_all
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-has-any">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_has_any
+ </span>
+ </code>
+ </a>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#list-indexof">
<code class="docutils literal notranslate">
@@ -2770,6 +2823,24 @@
</code>
</a>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-pop-back">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_pop_back
+ </span>
+ </code>
+ </a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-pop-front">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_pop_front
+ </span>
+ </code>
+ </a>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#list-position">
<code class="docutils literal notranslate">
@@ -2897,17 +2968,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id166">
+ <a class="reference internal nav-link" href="#id173">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id167">
+ <a class="reference internal nav-link" href="#id174">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id168">
+ <a class="reference internal nav-link" href="#id175">
Aliases
</a>
</li>
@@ -2932,12 +3003,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id169">
+ <a class="reference internal nav-link" href="#id176">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id170">
+ <a class="reference internal nav-link" href="#id177">
Aliases
</a>
</li>
@@ -2962,7 +3033,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id171">
+ <a class="reference internal nav-link" href="#id178">
Arguments
</a>
</li>
@@ -2978,7 +3049,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id172">
+ <a class="reference internal nav-link" href="#id179">
Arguments
</a>
</li>
@@ -3001,7 +3072,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id173">
+ <a class="reference internal nav-link" href="#id180">
Arguments
</a>
</li>
@@ -3024,7 +3095,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id174">
+ <a class="reference internal nav-link" href="#id181">
Arguments
</a>
</li>
@@ -3040,7 +3111,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id175">
+ <a class="reference internal nav-link" href="#id182">
Arguments
</a>
</li>
@@ -3056,7 +3127,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id176">
+ <a class="reference internal nav-link" href="#id183">
Arguments
</a>
</li>
@@ -3072,7 +3143,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id177">
+ <a class="reference internal nav-link" href="#id184">
Arguments
</a>
</li>
@@ -3088,7 +3159,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id178">
+ <a class="reference internal nav-link" href="#id185">
Arguments
</a>
</li>
@@ -3104,7 +3175,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id179">
+ <a class="reference internal nav-link" href="#id186">
Arguments
</a>
</li>
@@ -3127,12 +3198,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id180">
+ <a class="reference internal nav-link" href="#id187">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id181">
+ <a class="reference internal nav-link" href="#id188">
Example
</a>
</li>
@@ -3148,12 +3219,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id182">
+ <a class="reference internal nav-link" href="#id189">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id183">
+ <a class="reference internal nav-link" href="#id190">
Example
</a>
</li>
@@ -5017,11 +5088,16 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<li><p><a class="reference internal" href="#list-dims">list_dims</a></p></li>
<li><p><a class="reference internal"
href="#list-element">list_element</a></p></li>
<li><p><a class="reference internal"
href="#list-extract">list_extract</a></p></li>
+<li><p><a class="reference internal" href="#list-has">list_has</a></p></li>
+<li><p><a class="reference internal"
href="#list-has-all">list_has_all</a></p></li>
+<li><p><a class="reference internal"
href="#list-has-any">list_has_any</a></p></li>
<li><p><a class="reference internal"
href="#list-indexof">list_indexof</a></p></li>
<li><p><a class="reference internal" href="#list-join">list_join</a></p></li>
<li><p><a class="reference internal"
href="#list-length">list_length</a></p></li>
<li><p><a class="reference internal" href="#list-ndims">list_ndims</a></p></li>
<li><p><a class="reference internal"
href="#list-prepend">list_prepend</a></p></li>
+<li><p><a class="reference internal"
href="#list-pop-back">list_pop_back</a></p></li>
+<li><p><a class="reference internal"
href="#list-pop-front">list_pop_front</a></p></li>
<li><p><a class="reference internal"
href="#list-position">list_position</a></p></li>
<li><p><a class="reference internal"
href="#list-positions">list_positions</a></p></li>
<li><p><a class="reference internal"
href="#list-push-back">list_push_back</a></p></li>
@@ -5162,6 +5238,12 @@ 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="id102">
+<h4>Aliases<a class="headerlink" href="#id102" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>list_has</p></li>
+</ul>
+</section>
</section>
<section id="array-has-all">
<h3><code class="docutils literal notranslate"><span
class="pre">array_has_all</span></code><a class="headerlink"
href="#array-has-all" title="Link to this heading">¶</a></h3>
@@ -5169,8 +5251,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_has_all</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">sub</span><span class="o">-</span><span class="n">array</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id102">
-<h4>Arguments<a class="headerlink" href="#id102" title="Link to this
heading">¶</a></h4>
+<section id="id103">
+<h4>Arguments<a class="headerlink" href="#id103" 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>
@@ -5178,6 +5260,12 @@ 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="id104">
+<h4>Aliases<a class="headerlink" href="#id104" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>list_has_all</p></li>
+</ul>
+</section>
</section>
<section id="array-has-any">
<h3><code class="docutils literal notranslate"><span
class="pre">array_has_any</span></code><a class="headerlink"
href="#array-has-any" title="Link to this heading">¶</a></h3>
@@ -5185,8 +5273,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_has_any</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">sub</span><span class="o">-</span><span class="n">array</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id103">
-<h4>Arguments<a class="headerlink" href="#id103" title="Link to this
heading">¶</a></h4>
+<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>
@@ -5194,6 +5282,12 @@ 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="id106">
+<h4>Aliases<a class="headerlink" href="#id106" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>list_has_any</p></li>
+</ul>
+</section>
</section>
<section id="array-dims">
<h3><code class="docutils literal notranslate"><span
class="pre">array_dims</span></code><a class="headerlink" href="#array-dims"
title="Link to this heading">¶</a></h3>
@@ -5201,15 +5295,15 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_dims</span><span
class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id104">
-<h4>Arguments<a class="headerlink" href="#id104" 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>
</ul>
</section>
-<section id="id105">
-<h4>Example<a class="headerlink" href="#id105" 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_dims([[1, 2, 3], [4, 5, 6]]);
+---------------------------------+
| array_dims(List([1,2,3,4,5,6])) |
@@ -5219,8 +5313,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id106">
-<h4>Aliases<a class="headerlink" href="#id106" 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>list_dims</p></li>
</ul>
@@ -5232,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">array_element</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">index</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id107">
-<h4>Arguments<a class="headerlink" href="#id107" 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>index</strong>: Index to extract the element from the
array.</p></li>
</ul>
</section>
-<section id="id108">
-<h4>Example<a class="headerlink" href="#id108" 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_element([1, 2, 3, 4], 3);
+-----------------------------------------+
| array_element(List([1,2,3,4]),Int64(3)) |
@@ -5251,8 +5345,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id109">
-<h4>Aliases<a class="headerlink" href="#id109" 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_extract</p></li>
<li><p>list_element</p></li>
@@ -5260,9 +5354,6 @@ Can be a constant, column, or function, and any
combination of array operators.<
</ul>
</section>
</section>
-<section id="array-empty">
-<h3><code class="docutils literal notranslate"><span
class="pre">array_empty</span></code><a class="headerlink" href="#array-empty"
title="Link to this heading">¶</a></h3>
-</section>
<section id="array-extract">
<h3><code class="docutils literal notranslate"><span
class="pre">array_extract</span></code><a class="headerlink"
href="#array-extract" title="Link to this heading">¶</a></h3>
<p><em>Alias of <a class="reference internal"
href="#array-element">array_element</a>.</em></p>
@@ -5274,8 +5365,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_fill</span><span
class="p">(</span><span class="n">element</span><span class="p">,</span> <span
class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id110">
-<h4>Arguments<a class="headerlink" href="#id110" 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>
@@ -5291,8 +5382,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<li><p>Does not change arrays that are already flat</p></li>
</ul>
<p>The flattened array contains all the elements from all source arrays.</p>
-<section id="id111">
-<h4>Arguments<a class="headerlink" href="#id111" title="Link to this
heading">¶</a></h4>
+<section id="id114">
+<h4>Arguments<a class="headerlink" href="#id114" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5316,16 +5407,16 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_length</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">dimension</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id112">
-<h4>Arguments<a class="headerlink" href="#id112" 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>dimension</strong>: Array dimension.</p></li>
</ul>
</section>
-<section id="id113">
-<h4>Example<a class="headerlink" href="#id113" 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_length([1, 2, 3, 4, 5]);
+---------------------------------+
| array_length(List([1,2,3,4,5])) |
@@ -5335,8 +5426,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id114">
-<h4>Aliases<a class="headerlink" href="#id114" 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_length</p></li>
</ul>
@@ -5348,15 +5439,15 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_ndims</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">element</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id115">
-<h4>Arguments<a class="headerlink" href="#id115" 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>
</ul>
</section>
-<section id="id116">
-<h4>Example<a class="headerlink" href="#id116" 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_ndims([[1, 2, 3], [4, 5,
6]]);
+----------------------------------+
| array_ndims(List([1,2,3,4,5,6])) |
@@ -5366,8 +5457,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id117">
-<h4>Aliases<a class="headerlink" href="#id117" title="Link to this
heading">¶</a></h4>
+<section id="id120">
+<h4>Aliases<a class="headerlink" href="#id120" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_ndims</p></li>
</ul>
@@ -5379,16 +5470,16 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_prepend</span><span
class="p">(</span><span class="n">element</span><span class="p">,</span> <span
class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id118">
-<h4>Arguments<a class="headerlink" href="#id118" title="Link to this
heading">¶</a></h4>
+<section id="id121">
+<h4>Arguments<a class="headerlink" href="#id121" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>element</strong>: Element to prepend to the array.</p></li>
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id119">
-<h4>Example<a class="headerlink" href="#id119" 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_prepend(1, [2, 3, 4]);
+---------------------------------------+
| array_prepend(Int64(1),List([2,3,4])) |
@@ -5398,8 +5489,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id120">
-<h4>Aliases<a class="headerlink" href="#id120" 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>array_push_front</p></li>
<li><p>list_prepend</p></li>
@@ -5413,15 +5504,15 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_pop_front</span><span
class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id121">
-<h4>Arguments<a class="headerlink" href="#id121" 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>
</ul>
</section>
-<section id="id122">
-<h4>Example<a class="headerlink" href="#id122" 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_pop_front([1, 2, 3]);
+-------------------------------+
| array_pop_front(List([1,2,3])) |
@@ -5431,6 +5522,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
+<section id="id126">
+<h4>Aliases<a class="headerlink" href="#id126" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>list_pop_front</p></li>
+</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>
@@ -5438,15 +5535,15 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_pop_back</span><span
class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id123">
-<h4>Arguments<a class="headerlink" href="#id123" 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>
</ul>
</section>
-<section id="id124">
-<h4>Example<a class="headerlink" href="#id124" 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_pop_back([1, 2, 3]);
+-------------------------------+
| array_pop_back(List([1,2,3])) |
@@ -5456,6 +5553,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
+<section id="id129">
+<h4>Aliases<a class="headerlink" href="#id129" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>list_pop_back</p></li>
+</ul>
+</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>
@@ -5464,8 +5567,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="id125">
-<h4>Arguments<a class="headerlink" href="#id125" 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>
@@ -5473,8 +5576,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="id126">
-<h4>Example<a class="headerlink" href="#id126" 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_position([1, 2, 2, 3, 1, 4],
2);
+----------------------------------------------+
| array_position(List([1,2,2,3,1,4]),Int64(2)) |
@@ -5484,8 +5587,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="id132">
+<h4>Aliases<a class="headerlink" href="#id132" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_indexof</p></li>
<li><p>list_indexof</p></li>
@@ -5499,16 +5602,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="id128">
-<h4>Arguments<a class="headerlink" href="#id128" 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>
<li><p><strong>element</strong>: Element to search for positions in the
array.</p></li>
</ul>
</section>
-<section id="id129">
-<h4>Example<a class="headerlink" href="#id129" 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_positions([1, 2, 2, 3, 1,
4], 2);
+-----------------------------------------------+
| array_positions(List([1,2,2,3,1,4]),Int64(2)) |
@@ -5518,8 +5621,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="id135">
+<h4>Aliases<a class="headerlink" href="#id135" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_positions</p></li>
</ul>
@@ -5539,16 +5642,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="id131">
-<h4>Arguments<a class="headerlink" href="#id131" title="Link to this
heading">¶</a></h4>
+<section id="id136">
+<h4>Arguments<a class="headerlink" href="#id136" 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="id132">
-<h4>Example<a class="headerlink" href="#id132" title="Link to this
heading">¶</a></h4>
+<section id="id137">
+<h4>Example<a class="headerlink" href="#id137" 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)) |
@@ -5566,6 +5669,12 @@ 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>
+<ul class="simple">
+<li><p>list_repeat</p></li>
+</ul>
+</section>
</section>
<section id="array-remove">
<h3><code class="docutils literal notranslate"><span
class="pre">array_remove</span></code><a class="headerlink"
href="#array-remove" title="Link to this heading">¶</a></h3>
@@ -5573,16 +5682,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="id133">
-<h4>Arguments<a class="headerlink" href="#id133" title="Link to this
heading">¶</a></h4>
+<section id="id139">
+<h4>Arguments<a class="headerlink" href="#id139" 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="id134">
-<h4>Example<a class="headerlink" href="#id134" title="Link to this
heading">¶</a></h4>
+<section id="id140">
+<h4>Example<a class="headerlink" href="#id140" 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)) |
@@ -5592,8 +5701,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="id141">
+<h4>Aliases<a class="headerlink" href="#id141" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove</p></li>
</ul>
@@ -5605,8 +5714,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="id136">
-<h4>Arguments<a class="headerlink" href="#id136" 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>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5614,8 +5723,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="id137">
-<h4>Example<a class="headerlink" href="#id137" 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 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)) |
@@ -5625,8 +5734,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="id144">
+<h4>Aliases<a class="headerlink" href="#id144" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove_n</p></li>
</ul>
@@ -5638,16 +5747,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="id139">
-<h4>Arguments<a class="headerlink" href="#id139" 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>
<li><p><strong>element</strong>: Element to be removed from the array.</p></li>
</ul>
</section>
-<section id="id140">
-<h4>Example<a class="headerlink" href="#id140" title="Link to this
heading">¶</a></h4>
+<section id="id146">
+<h4>Example<a class="headerlink" href="#id146" 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)) |
@@ -5657,8 +5766,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id141">
-<h4>Aliases<a class="headerlink" href="#id141" title="Link to this
heading">¶</a></h4>
+<section id="id147">
+<h4>Aliases<a class="headerlink" href="#id147" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove_all</p></li>
</ul>
@@ -5670,8 +5779,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="id142">
-<h4>Arguments<a class="headerlink" href="#id142" 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>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5679,8 +5788,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="id143">
-<h4>Example<a class="headerlink" href="#id143" 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 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)) |
@@ -5690,8 +5799,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id144">
-<h4>Aliases<a class="headerlink" href="#id144" 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>list_replace</p></li>
</ul>
@@ -5703,8 +5812,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="id145">
-<h4>Arguments<a class="headerlink" href="#id145" 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>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5713,8 +5822,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="id146">
-<h4>Example<a class="headerlink" href="#id146" title="Link to this
heading">¶</a></h4>
+<section id="id152">
+<h4>Example<a class="headerlink" href="#id152" 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)) |
@@ -5724,8 +5833,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id147">
-<h4>Aliases<a class="headerlink" href="#id147" title="Link to this
heading">¶</a></h4>
+<section id="id153">
+<h4>Aliases<a class="headerlink" href="#id153" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace_n</p></li>
</ul>
@@ -5737,8 +5846,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="id148">
-<h4>Arguments<a class="headerlink" href="#id148" 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>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5746,8 +5855,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="id149">
-<h4>Example<a class="headerlink" href="#id149" title="Link to this
heading">¶</a></h4>
+<section id="id155">
+<h4>Example<a class="headerlink" href="#id155" 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)) |
@@ -5757,8 +5866,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id150">
-<h4>Aliases<a class="headerlink" href="#id150" title="Link to this
heading">¶</a></h4>
+<section id="id156">
+<h4>Aliases<a class="headerlink" href="#id156" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace_all</p></li>
</ul>
@@ -5766,12 +5875,24 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="array-slice">
<h3><code class="docutils literal notranslate"><span
class="pre">array_slice</span></code><a class="headerlink" href="#array-slice"
title="Link to this heading">¶</a></h3>
-<p>Returns a slice of the array.</p>
+<p>Returns a slice of the array based on 1-indexed start and end positions.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_slice</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">begin</span><span class="p">,</span> <span class="n">end</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id151">
-<h4>Example<a class="headerlink" href="#id151" 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>array</strong>: Array expression.
+Can be a constant, column, or function, and any combination of array
operators.</p></li>
+<li><p><strong>begin</strong>: Index of the first element.
+If negative, it counts backward from the end of the array.</p></li>
+<li><p><strong>end</strong>: Index of the last element.
+If negative, it counts backward from the end of the array.</p></li>
+<li><p><strong>stride</strong>: Stride of the array slice. The default is
1.</p></li>
+</ul>
+</section>
+<section id="id158">
+<h4>Example<a class="headerlink" href="#id158" 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)) |
@@ -5781,8 +5902,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id152">
-<h4>Aliases<a class="headerlink" href="#id152" title="Link to this
heading">¶</a></h4>
+<section id="id159">
+<h4>Aliases<a class="headerlink" href="#id159" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_slice</p></li>
</ul>
@@ -5794,16 +5915,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="id153">
-<h4>Arguments<a class="headerlink" href="#id153" 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>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="id154">
-<h4>Example<a class="headerlink" href="#id154" title="Link to this
heading">¶</a></h4>
+<section id="id161">
+<h4>Example<a class="headerlink" href="#id161" 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(",")) |
@@ -5813,8 +5934,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id155">
-<h4>Aliases<a class="headerlink" href="#id155" title="Link to this
heading">¶</a></h4>
+<section id="id162">
+<h4>Aliases<a class="headerlink" href="#id162" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_join</p></li>
<li><p>list_join</p></li>
@@ -5828,8 +5949,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="id156">
-<h4>Arguments<a class="headerlink" href="#id156" title="Link to this
heading">¶</a></h4>
+<section id="id163">
+<h4>Arguments<a class="headerlink" href="#id163" 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>
@@ -5837,8 +5958,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="id157">
-<h4>Example<a class="headerlink" href="#id157" title="Link to this
heading">¶</a></h4>
+<section id="id164">
+<h4>Example<a class="headerlink" href="#id164" 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]); |
@@ -5855,8 +5976,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</div>
</section>
<hr class="docutils" />
-<section id="id158">
-<h4>Aliases<a class="headerlink" href="#id158" title="Link to this
heading">¶</a></h4>
+<section id="id165">
+<h4>Aliases<a class="headerlink" href="#id165" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_union</p></li>
</ul>
@@ -5868,8 +5989,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_except</span><span
class="p">(</span><span class="n">array1</span><span class="p">,</span> <span
class="n">array2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id159">
-<h4>Arguments<a class="headerlink" href="#id159" title="Link to this
heading">¶</a></h4>
+<section id="id166">
+<h4>Arguments<a class="headerlink" href="#id166" 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>
@@ -5877,8 +5998,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="id160">
-<h4>Example<a class="headerlink" href="#id160" title="Link to this
heading">¶</a></h4>
+<section id="id167">
+<h4>Example<a class="headerlink" href="#id167" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_except([1, 2, 3, 4], [5, 6,
3, 4]);
+----------------------------------------------------+
| array_except([1, 2, 3, 4], [5, 6, 3, 4]); |
@@ -5895,8 +6016,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</div>
</section>
<hr class="docutils" />
-<section id="id161">
-<h4>Aliases<a class="headerlink" href="#id161" title="Link to this
heading">¶</a></h4>
+<section id="id168">
+<h4>Aliases<a class="headerlink" href="#id168" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_except</p></li>
</ul>
@@ -5908,15 +6029,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="id162">
-<h4>Arguments<a class="headerlink" href="#id162" title="Link to this
heading">¶</a></h4>
+<section id="id169">
+<h4>Arguments<a class="headerlink" href="#id169" 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="id163">
-<h4>Example<a class="headerlink" href="#id163" title="Link to this
heading">¶</a></h4>
+<section id="id170">
+<h4>Example<a class="headerlink" href="#id170" 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])) |
@@ -5933,15 +6054,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="id164">
-<h4>Arguments<a class="headerlink" href="#id164" title="Link to this
heading">¶</a></h4>
+<section id="id171">
+<h4>Arguments<a class="headerlink" href="#id171" 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="id165">
-<h4>Example<a class="headerlink" href="#id165" title="Link to this
heading">¶</a></h4>
+<section id="id172">
+<h4>Example<a class="headerlink" href="#id172" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select empty([1]);
+------------------+
| empty(List([1])) |
@@ -5980,6 +6101,18 @@ Can be a constant, column, or function, and any
combination of array operators.<
<h3><code class="docutils literal notranslate"><span
class="pre">list_extract</span></code><a class="headerlink"
href="#list-extract" title="Link to this heading">¶</a></h3>
<p><em>Alias of <a class="reference internal"
href="#array-element">array_element</a>.</em></p>
</section>
+<section id="list-has">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_has</span></code><a class="headerlink" href="#list-has"
title="Link to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-has">array_has</a>.</em></p>
+</section>
+<section id="list-has-all">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_has_all</span></code><a class="headerlink"
href="#list-has-all" title="Link to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-has-all">array_has_all</a>.</em></p>
+</section>
+<section id="list-has-any">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_has_any</span></code><a class="headerlink"
href="#list-has-any" title="Link to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-has-any">array_has_any</a>.</em></p>
+</section>
<section id="list-indexof">
<h3><code class="docutils literal notranslate"><span
class="pre">list_indexof</span></code><a class="headerlink"
href="#list-indexof" title="Link to this heading">¶</a></h3>
<p><em>Alias of <a class="reference internal"
href="#array-position">array_position</a>.</em></p>
@@ -6000,6 +6133,14 @@ Can be a constant, column, or function, and any
combination of array operators.<
<h3><code class="docutils literal notranslate"><span
class="pre">list_prepend</span></code><a class="headerlink"
href="#list-prepend" title="Link to this heading">¶</a></h3>
<p><em>Alias of <a class="reference internal"
href="#array-prepend">array_prepend</a>.</em></p>
</section>
+<section id="list-pop-back">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_pop_back</span></code><a class="headerlink"
href="#list-pop-back" title="Link to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-pop-back">array_pop_back</a>.</em></p>
+</section>
+<section id="list-pop-front">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_pop_front</span></code><a class="headerlink"
href="#list-pop-front" title="Link to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-pop-front">array_pop_front</a>.</em></p>
+</section>
<section id="list-position">
<h3><code class="docutils literal notranslate"><span
class="pre">list_position</span></code><a class="headerlink"
href="#list-position" title="Link to this heading">¶</a></h3>
<p><em>Alias of <a class="reference internal"
href="#array-position">array_position</a>.</em></p>
@@ -6058,16 +6199,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="id166">
-<h4>Arguments<a class="headerlink" href="#id166" title="Link to this
heading">¶</a></h4>
+<section id="id173">
+<h4>Arguments<a class="headerlink" href="#id173" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>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="id167">
-<h4>Example<a class="headerlink" href="#id167" title="Link to this
heading">¶</a></h4>
+<section id="id174">
+<h4>Example<a class="headerlink" href="#id174" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select make_array(1, 2, 3, 4, 5);
+----------------------------------------------------------+
| make_array(Int64(1),Int64(2),Int64(3),Int64(4),Int64(5)) |
@@ -6077,8 +6218,8 @@ string operators.</p></li>
</pre></div>
</div>
</section>
-<section id="id168">
-<h4>Aliases<a class="headerlink" href="#id168" title="Link to this
heading">¶</a></h4>
+<section id="id175">
+<h4>Aliases<a class="headerlink" href="#id175" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>make_list</p></li>
</ul>
@@ -6094,16 +6235,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="id169">
-<h4>Arguments<a class="headerlink" href="#id169" title="Link to this
heading">¶</a></h4>
+<section id="id176">
+<h4>Arguments<a class="headerlink" href="#id176" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>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="id170">
-<h4>Aliases<a class="headerlink" href="#id170" title="Link to this
heading">¶</a></h4>
+<section id="id177">
+<h4>Aliases<a class="headerlink" href="#id177" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>string_to_list</p></li>
</ul>
@@ -6120,8 +6261,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="id171">
-<h4>Arguments<a class="headerlink" href="#id171" title="Link to this
heading">¶</a></h4>
+<section id="id178">
+<h4>Arguments<a class="headerlink" href="#id178" 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>
@@ -6134,8 +6275,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="id172">
-<h4>Arguments<a class="headerlink" href="#id172" title="Link to this
heading">¶</a></h4>
+<section id="id179">
+<h4>Arguments<a class="headerlink" href="#id179" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>start</strong>: start of the range</p></li>
<li><p><strong>end</strong>: end of the range (not included)</p></li>
@@ -6176,8 +6317,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="id173">
-<h4>Arguments<a class="headerlink" href="#id173" title="Link to this
heading">¶</a></h4>
+<section id="id180">
+<h4>Arguments<a class="headerlink" href="#id180" 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
@@ -6202,8 +6343,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="id174">
-<h4>Arguments<a class="headerlink" href="#id174" title="Link to this
heading">¶</a></h4>
+<section id="id181">
+<h4>Arguments<a class="headerlink" href="#id181" 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>
@@ -6229,8 +6370,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="id175">
-<h4>Arguments<a class="headerlink" href="#id175" title="Link to this
heading">¶</a></h4>
+<section id="id182">
+<h4>Arguments<a class="headerlink" href="#id182" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -6243,8 +6384,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="id176">
-<h4>Arguments<a class="headerlink" href="#id176" title="Link to this
heading">¶</a></h4>
+<section id="id183">
+<h4>Arguments<a class="headerlink" href="#id183" 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>
@@ -6257,8 +6398,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="id177">
-<h4>Arguments<a class="headerlink" href="#id177" title="Link to this
heading">¶</a></h4>
+<section id="id184">
+<h4>Arguments<a class="headerlink" href="#id184" 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>
@@ -6271,8 +6412,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="id178">
-<h4>Arguments<a class="headerlink" href="#id178" title="Link to this
heading">¶</a></h4>
+<section id="id185">
+<h4>Arguments<a class="headerlink" href="#id185" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -6285,8 +6426,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="id179">
-<h4>Arguments<a class="headerlink" href="#id179" title="Link to this
heading">¶</a></h4>
+<section id="id186">
+<h4>Arguments<a class="headerlink" href="#id186" 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>
@@ -6306,8 +6447,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="id180">
-<h4>Arguments<a class="headerlink" href="#id180" title="Link to this
heading">¶</a></h4>
+<section id="id187">
+<h4>Arguments<a class="headerlink" href="#id187" 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
@@ -6316,8 +6457,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="id181">
-<h4>Example<a class="headerlink" href="#id181" title="Link to this
heading">¶</a></h4>
+<section id="id188">
+<h4>Example<a class="headerlink" href="#id188" 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,
@@ -6339,16 +6480,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="id182">
-<h4>Arguments<a class="headerlink" href="#id182" title="Link to this
heading">¶</a></h4>
+<section id="id189">
+<h4>Arguments<a class="headerlink" href="#id189" 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="id183">
-<h4>Example<a class="headerlink" href="#id183" title="Link to this
heading">¶</a></h4>
+<section id="id190">
+<h4>Example<a class="headerlink" href="#id190" 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)) |
