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 c2d2a4474f Publish built docs triggered by
dc373a3550610ce041fd73a1eabe08b096d6ed27
c2d2a4474f is described below
commit c2d2a4474f7e072202f4cf20a07f54d591ebd81f
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Thu Mar 21 14:14:20 2024 +0000
Publish built docs triggered by dc373a3550610ce041fd73a1eabe08b096d6ed27
---
_sources/user-guide/sql/scalar_functions.md.txt | 27 +-
searchindex.js | 2 +-
user-guide/sql/scalar_functions.html | 822 ++++++++++++------------
3 files changed, 404 insertions(+), 447 deletions(-)
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index b63fa9950a..d4570dbc35 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -1624,34 +1624,19 @@ _Alias of [date_part](#date_part)._
### `extract`
Returns a sub-field from a time value as an integer.
-Similar to `date_part`, but with different arguments.
```
extract(field FROM source)
```
-#### Arguments
-
-- **field**: Part or field of the date to return.
- The following date fields are supported:
+Equivalent to calling `date_part('field', source)`. For example, these are
equivalent:
- - year
- - quarter _(emits value in inclusive range [1, 4] based on which quartile of
the year the date is in)_
- - month
- - week _(week of the year)_
- - day _(day of the month)_
- - hour
- - minute
- - second
- - millisecond
- - microsecond
- - nanosecond
- - dow _(day of the week)_
- - doy _(day of the year)_
- - epoch _(seconds since Unix epoch)_
+```sql
+extract(day FROM '2024-04-13'::date)
+date_part('day', '2024-04-13'::date)
+```
-- **source**: Source time expression to operate on.
- Can be a constant, column, or function.
+See [date_part](#date_part).
### `make_date`
diff --git a/searchindex.js b/searchindex.js
index e9182b2979..601faddb12 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 007621f779..ce9107902b 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -1861,13 +1861,6 @@
</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="#id88">
- Arguments
- </a>
- </li>
- </ul>
</li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#make-date">
@@ -1879,12 +1872,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id89">
+ <a class="reference internal nav-link" href="#id88">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id90">
+ <a class="reference internal nav-link" href="#id89">
Example
</a>
</li>
@@ -1900,17 +1893,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id91">
+ <a class="reference internal nav-link" href="#id90">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id92">
+ <a class="reference internal nav-link" href="#id91">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id93">
+ <a class="reference internal nav-link" href="#id92">
Aliases
</a>
</li>
@@ -1926,12 +1919,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id94">
+ <a class="reference internal nav-link" href="#id93">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id95">
+ <a class="reference internal nav-link" href="#id94">
Example
</a>
</li>
@@ -1947,12 +1940,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id96">
+ <a class="reference internal nav-link" href="#id95">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id97">
+ <a class="reference internal nav-link" href="#id96">
Example
</a>
</li>
@@ -1968,12 +1961,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id98">
+ <a class="reference internal nav-link" href="#id97">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id99">
+ <a class="reference internal nav-link" href="#id98">
Example
</a>
</li>
@@ -1989,12 +1982,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id100">
+ <a class="reference internal nav-link" href="#id99">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id101">
+ <a class="reference internal nav-link" href="#id100">
Example
</a>
</li>
@@ -2010,12 +2003,12 @@
</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="#id101">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id103">
+ <a class="reference internal nav-link" href="#id102">
Example
</a>
</li>
@@ -2031,7 +2024,7 @@
</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="#id103">
Arguments
</a>
</li>
@@ -2054,17 +2047,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id105">
+ <a class="reference internal nav-link" href="#id104">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id106">
+ <a class="reference internal nav-link" href="#id105">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id107">
+ <a class="reference internal nav-link" href="#id106">
Aliases
</a>
</li>
@@ -2080,17 +2073,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="#id107">
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="#id108">
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="#id109">
Aliases
</a>
</li>
@@ -2106,17 +2099,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id111">
+ <a class="reference internal nav-link" href="#id110">
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="#id111">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id113">
+ <a class="reference internal nav-link" href="#id112">
Aliases
</a>
</li>
@@ -2141,17 +2134,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id114">
+ <a class="reference internal nav-link" href="#id113">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id115">
+ <a class="reference internal nav-link" href="#id114">
Example
</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="#id115">
Aliases
</a>
</li>
@@ -2176,12 +2169,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id117">
+ <a class="reference internal nav-link" href="#id116">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id118">
+ <a class="reference internal nav-link" href="#id117">
Aliases
</a>
</li>
@@ -2197,12 +2190,12 @@
</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="#id118">
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="#id119">
Aliases
</a>
</li>
@@ -2218,12 +2211,12 @@
</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="#id120">
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="#id121">
Aliases
</a>
</li>
@@ -2239,17 +2232,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id123">
+ <a class="reference internal nav-link" href="#id122">
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="#id123">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id125">
+ <a class="reference internal nav-link" href="#id124">
Aliases
</a>
</li>
@@ -2265,17 +2258,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id126">
+ <a class="reference internal nav-link" href="#id125">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id127">
+ <a class="reference internal nav-link" href="#id126">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id128">
+ <a class="reference internal nav-link" href="#id127">
Aliases
</a>
</li>
@@ -2291,17 +2284,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id129">
+ <a class="reference internal nav-link" href="#id128">
Arguments
</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="#id129">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id131">
+ <a class="reference internal nav-link" href="#id130">
Aliases
</a>
</li>
@@ -2326,7 +2319,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id132">
+ <a class="reference internal nav-link" href="#id131">
Arguments
</a>
</li>
@@ -2342,7 +2335,7 @@
</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="#id132">
Arguments
</a>
</li>
@@ -2367,17 +2360,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id134">
+ <a class="reference internal nav-link" href="#id133">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id135">
+ <a class="reference internal nav-link" href="#id134">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id136">
+ <a class="reference internal nav-link" href="#id135">
Aliases
</a>
</li>
@@ -2402,17 +2395,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id137">
+ <a class="reference internal nav-link" href="#id136">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id138">
+ <a class="reference internal nav-link" href="#id137">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id139">
+ <a class="reference internal nav-link" href="#id138">
Aliases
</a>
</li>
@@ -2428,17 +2421,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="#id139">
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="#id140">
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="#id141">
Aliases
</a>
</li>
@@ -2454,17 +2447,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id143">
+ <a class="reference internal nav-link" href="#id142">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id144">
+ <a class="reference internal nav-link" href="#id143">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id145">
+ <a class="reference internal nav-link" href="#id144">
Aliases
</a>
</li>
@@ -2480,17 +2473,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id146">
+ <a class="reference internal nav-link" href="#id145">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id147">
+ <a class="reference internal nav-link" href="#id146">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id148">
+ <a class="reference internal nav-link" href="#id147">
Aliases
</a>
</li>
@@ -2506,17 +2499,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id149">
+ <a class="reference internal nav-link" href="#id148">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id150">
+ <a class="reference internal nav-link" href="#id149">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id151">
+ <a class="reference internal nav-link" href="#id150">
Aliases
</a>
</li>
@@ -2532,17 +2525,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id152">
+ <a class="reference internal nav-link" href="#id151">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id153">
+ <a class="reference internal nav-link" href="#id152">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id154">
+ <a class="reference internal nav-link" href="#id153">
Aliases
</a>
</li>
@@ -2558,17 +2551,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id155">
+ <a class="reference internal nav-link" href="#id154">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id156">
+ <a class="reference internal nav-link" href="#id155">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id157">
+ <a class="reference internal nav-link" href="#id156">
Aliases
</a>
</li>
@@ -2602,17 +2595,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id158">
+ <a class="reference internal nav-link" href="#id157">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id159">
+ <a class="reference internal nav-link" href="#id158">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id160">
+ <a class="reference internal nav-link" href="#id159">
Aliases
</a>
</li>
@@ -2628,17 +2621,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id161">
+ <a class="reference internal nav-link" href="#id160">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id162">
+ <a class="reference internal nav-link" href="#id161">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id163">
+ <a class="reference internal nav-link" href="#id162">
Aliases
</a>
</li>
@@ -2654,17 +2647,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id164">
+ <a class="reference internal nav-link" href="#id163">
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="#id164">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id166">
+ <a class="reference internal nav-link" href="#id165">
Aliases
</a>
</li>
@@ -2680,17 +2673,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id167">
+ <a class="reference internal nav-link" href="#id166">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id168">
+ <a class="reference internal nav-link" href="#id167">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id169">
+ <a class="reference internal nav-link" href="#id168">
Aliases
</a>
</li>
@@ -2706,17 +2699,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id170">
+ <a class="reference internal nav-link" href="#id169">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id171">
+ <a class="reference internal nav-link" href="#id170">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id172">
+ <a class="reference internal nav-link" href="#id171">
Aliases
</a>
</li>
@@ -2732,17 +2725,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id173">
+ <a class="reference internal nav-link" href="#id172">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id174">
+ <a class="reference internal nav-link" href="#id173">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id175">
+ <a class="reference internal nav-link" href="#id174">
Aliases
</a>
</li>
@@ -2758,17 +2751,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id176">
+ <a class="reference internal nav-link" href="#id175">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id177">
+ <a class="reference internal nav-link" href="#id176">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id178">
+ <a class="reference internal nav-link" href="#id177">
Aliases
</a>
</li>
@@ -2784,17 +2777,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id179">
+ <a class="reference internal nav-link" href="#id178">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id180">
+ <a class="reference internal nav-link" href="#id179">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id181">
+ <a class="reference internal nav-link" href="#id180">
Aliases
</a>
</li>
@@ -2810,17 +2803,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id182">
+ <a class="reference internal nav-link" href="#id181">
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="#id182">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id184">
+ <a class="reference internal nav-link" href="#id183">
Aliases
</a>
</li>
@@ -2836,17 +2829,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id185">
+ <a class="reference internal nav-link" href="#id184">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id186">
+ <a class="reference internal nav-link" href="#id185">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id187">
+ <a class="reference internal nav-link" href="#id186">
Aliases
</a>
</li>
@@ -2862,17 +2855,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id188">
+ <a class="reference internal nav-link" href="#id187">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id189">
+ <a class="reference internal nav-link" href="#id188">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id190">
+ <a class="reference internal nav-link" href="#id189">
Aliases
</a>
</li>
@@ -2888,17 +2881,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id191">
+ <a class="reference internal nav-link" href="#id190">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id192">
+ <a class="reference internal nav-link" href="#id191">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id193">
+ <a class="reference internal nav-link" href="#id192">
Aliases
</a>
</li>
@@ -2914,12 +2907,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id194">
+ <a class="reference internal nav-link" href="#id193">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id195">
+ <a class="reference internal nav-link" href="#id194">
Example
</a>
</li>
@@ -2935,12 +2928,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id196">
+ <a class="reference internal nav-link" href="#id195">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id197">
+ <a class="reference internal nav-link" href="#id196">
Example
</a>
</li>
@@ -2956,12 +2949,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id198">
+ <a class="reference internal nav-link" href="#id197">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id199">
+ <a class="reference internal nav-link" href="#id198">
Example
</a>
</li>
@@ -3301,17 +3294,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id200">
+ <a class="reference internal nav-link" href="#id199">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id201">
+ <a class="reference internal nav-link" href="#id200">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id202">
+ <a class="reference internal nav-link" href="#id201">
Aliases
</a>
</li>
@@ -3336,12 +3329,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id203">
+ <a class="reference internal nav-link" href="#id202">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id204">
+ <a class="reference internal nav-link" href="#id203">
Aliases
</a>
</li>
@@ -3366,7 +3359,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id205">
+ <a class="reference internal nav-link" href="#id204">
Arguments
</a>
</li>
@@ -3382,12 +3375,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id206">
+ <a class="reference internal nav-link" href="#id205">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id207">
+ <a class="reference internal nav-link" href="#id206">
Aliases
</a>
</li>
@@ -3410,7 +3403,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id208">
+ <a class="reference internal nav-link" href="#id207">
Arguments
</a>
</li>
@@ -3433,7 +3426,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id209">
+ <a class="reference internal nav-link" href="#id208">
Arguments
</a>
</li>
@@ -3449,7 +3442,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id210">
+ <a class="reference internal nav-link" href="#id209">
Arguments
</a>
</li>
@@ -3465,7 +3458,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id211">
+ <a class="reference internal nav-link" href="#id210">
Arguments
</a>
</li>
@@ -3481,7 +3474,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id212">
+ <a class="reference internal nav-link" href="#id211">
Arguments
</a>
</li>
@@ -3497,7 +3490,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id213">
+ <a class="reference internal nav-link" href="#id212">
Arguments
</a>
</li>
@@ -3513,7 +3506,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id214">
+ <a class="reference internal nav-link" href="#id213">
Arguments
</a>
</li>
@@ -3536,12 +3529,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id215">
+ <a class="reference internal nav-link" href="#id214">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id216">
+ <a class="reference internal nav-link" href="#id215">
Example
</a>
</li>
@@ -3557,12 +3550,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id217">
+ <a class="reference internal nav-link" href="#id216">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id218">
+ <a class="reference internal nav-link" href="#id217">
Example
</a>
</li>
@@ -5297,37 +5290,16 @@ Can be a constant, column, or function.</p></li>
</section>
<section id="extract">
<h3><code class="docutils literal notranslate"><span
class="pre">extract</span></code><a class="headerlink" href="#extract"
title="Link to this heading">¶</a></h3>
-<p>Returns a sub-field from a time value as an integer.
-Similar to <code class="docutils literal notranslate"><span
class="pre">date_part</span></code>, but with different arguments.</p>
+<p>Returns a sub-field from a time value as an integer.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">extract</span><span
class="p">(</span><span class="n">field</span> <span class="n">FROM</span>
<span class="n">source</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id88">
-<h4>Arguments<a class="headerlink" href="#id88" title="Link to this
heading">¶</a></h4>
-<ul class="simple">
-<li><p><strong>field</strong>: Part or field of the date to return.
-The following date fields are supported:</p>
-<ul>
-<li><p>year</p></li>
-<li><p>quarter <em>(emits value in inclusive range [1, 4] based on which
quartile of the year the date is in)</em></p></li>
-<li><p>month</p></li>
-<li><p>week <em>(week of the year)</em></p></li>
-<li><p>day <em>(day of the month)</em></p></li>
-<li><p>hour</p></li>
-<li><p>minute</p></li>
-<li><p>second</p></li>
-<li><p>millisecond</p></li>
-<li><p>microsecond</p></li>
-<li><p>nanosecond</p></li>
-<li><p>dow <em>(day of the week)</em></p></li>
-<li><p>doy <em>(day of the year)</em></p></li>
-<li><p>epoch <em>(seconds since Unix epoch)</em></p></li>
-</ul>
-</li>
-<li><p><strong>source</strong>: Source time expression to operate on.
-Can be a constant, column, or function.</p></li>
-</ul>
-</section>
+<p>Equivalent to calling <code class="docutils literal notranslate"><span
class="pre">date_part('field',</span> <span class="pre">source)</span></code>.
For example, these are equivalent:</p>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">extract</span><span
class="p">(</span><span class="k">day</span><span class="w"> </span><span
class="k">FROM</span><span class="w"> </span><span
class="s1">'2024-04-13'</span><span class="p">::</span><span
class="nb">date</span><span class="p">)</span>
+<span class="n">date_part</span><span class="p">(</span><span
class="s1">'day'</span><span class="p">,</span><span class="w">
</span><span class="s1">'2024-04-13'</span><span
class="p">::</span><span class="nb">date</span><span class="p">)</span>
+</pre></div>
+</div>
+<p>See <a class="reference internal" href="#date-part">date_part</a>.</p>
</section>
<section id="make-date">
<h3><code class="docutils literal notranslate"><span
class="pre">make_date</span></code><a class="headerlink" href="#make-date"
title="Link to this heading">¶</a></h3>
@@ -5335,8 +5307,8 @@ Can be a constant, column, or function.</p></li>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">make_date</span><span
class="p">(</span><span class="n">year</span><span class="p">,</span> <span
class="n">month</span><span class="p">,</span> <span class="n">day</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id89">
-<h4>Arguments<a class="headerlink" href="#id89" title="Link to this
heading">¶</a></h4>
+<section id="id88">
+<h4>Arguments<a class="headerlink" href="#id88" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>year</strong>: Year to use when making the date.
Can be a constant, column or function, and any combination of arithmetic
operators.</p></li>
@@ -5346,8 +5318,8 @@ Can be a constant, column or function, and any
combination of arithmetic operato
Can be a constant, column or function, and any combination of arithmetic
operators.</p></li>
</ul>
</section>
-<section id="id90">
-<h4>Example<a class="headerlink" href="#id90" title="Link to this
heading">¶</a></h4>
+<section id="id89">
+<h4>Example<a class="headerlink" href="#id89" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select make_date(2023, 1, 31);
+-------------------------------------------+
| make_date(Int64(2023),Int64(1),Int64(31)) |
@@ -5373,8 +5345,8 @@ numerical formatting is not supported.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">to_char</span><span
class="p">(</span><span class="n">expression</span><span class="p">,</span>
<span class="nb">format</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id91">
-<h4>Arguments<a class="headerlink" href="#id91" title="Link to this
heading">¶</a></h4>
+<section id="id90">
+<h4>Arguments<a class="headerlink" href="#id90" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function that results in a
@@ -5382,8 +5354,8 @@ date, time, timestamp or duration.</p></li>
<li><p><strong>format</strong>: A <a class="reference external"
href="https://docs.rs/chrono/latest/chrono/format/strftime/index.html";>Chrono
format</a> string to use to convert the expression.</p></li>
</ul>
</section>
-<section id="id92">
-<h4>Example<a class="headerlink" href="#id92" title="Link to this
heading">¶</a></h4>
+<section id="id91">
+<h4>Example<a class="headerlink" href="#id91" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ ❯ select
to_char('2023-03-01'::date, '%d-%m-%Y');
+----------------------------------------------+
| to_char(Utf8("2023-03-01"),Utf8("%d-%m-%Y")) |
@@ -5394,8 +5366,8 @@ date, time, timestamp or duration.</p></li>
</div>
<p>Additional examples can be found <a class="reference external"
href="https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/to_char.rs";>here</a></p>
</section>
-<section id="id93">
-<h4>Aliases<a class="headerlink" href="#id93" title="Link to this
heading">¶</a></h4>
+<section id="id92">
+<h4>Aliases<a class="headerlink" href="#id92" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>date_format</p></li>
</ul>
@@ -5414,8 +5386,8 @@ for the input outside of supported bounds.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">to_timestamp</span><span
class="p">(</span><span class="n">expression</span><span class="p">[,</span>
<span class="o">...</span><span class="p">,</span> <span
class="n">format_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id94">
-<h4>Arguments<a class="headerlink" href="#id94" title="Link to this
heading">¶</a></h4>
+<section id="id93">
+<h4>Arguments<a class="headerlink" href="#id93" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -5424,8 +5396,8 @@ they appear with the first successful one being returned.
If none of the formats
an error will be returned.</p></li>
</ul>
</section>
-<section id="id95">
-<h4>Example<a class="headerlink" href="#id95" title="Link to this
heading">¶</a></h4>
+<section id="id94">
+<h4>Example<a class="headerlink" href="#id94" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select
to_timestamp('2023-01-31T09:26:56.123456789-05:00');
+-----------------------------------------------------------+
| to_timestamp(Utf8("2023-01-31T09:26:56.123456789-05:00")) |
@@ -5453,8 +5425,8 @@ Returns the corresponding timestamp.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span
class="n">to_timestamp_millis</span><span class="p">(</span><span
class="n">expression</span><span class="p">[,</span> <span
class="o">...</span><span class="p">,</span> <span
class="n">format_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id96">
-<h4>Arguments<a class="headerlink" href="#id96" title="Link to this
heading">¶</a></h4>
+<section id="id95">
+<h4>Arguments<a class="headerlink" href="#id95" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -5463,8 +5435,8 @@ they appear with the first successful one being returned.
If none of the formats
an error will be returned.</p></li>
</ul>
</section>
-<section id="id97">
-<h4>Example<a class="headerlink" href="#id97" title="Link to this
heading">¶</a></h4>
+<section id="id96">
+<h4>Example<a class="headerlink" href="#id96" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select
to_timestamp_millis('2023-01-31T09:26:56.123456789-05:00');
+------------------------------------------------------------------+
| to_timestamp_millis(Utf8("2023-01-31T09:26:56.123456789-05:00")) |
@@ -5492,8 +5464,8 @@ Returns the corresponding timestamp.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span
class="n">to_timestamp_micros</span><span class="p">(</span><span
class="n">expression</span><span class="p">[,</span> <span
class="o">...</span><span class="p">,</span> <span
class="n">format_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id98">
-<h4>Arguments<a class="headerlink" href="#id98" title="Link to this
heading">¶</a></h4>
+<section id="id97">
+<h4>Arguments<a class="headerlink" href="#id97" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -5502,8 +5474,8 @@ they appear with the first successful one being returned.
If none of the formats
an error will be returned.</p></li>
</ul>
</section>
-<section id="id99">
-<h4>Example<a class="headerlink" href="#id99" title="Link to this
heading">¶</a></h4>
+<section id="id98">
+<h4>Example<a class="headerlink" href="#id98" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select
to_timestamp_micros('2023-01-31T09:26:56.123456789-05:00');
+------------------------------------------------------------------+
| to_timestamp_micros(Utf8("2023-01-31T09:26:56.123456789-05:00")) |
@@ -5531,8 +5503,8 @@ Returns the corresponding timestamp.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span
class="n">to_timestamp_nanos</span><span class="p">(</span><span
class="n">expression</span><span class="p">[,</span> <span
class="o">...</span><span class="p">,</span> <span
class="n">format_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id100">
-<h4>Arguments<a class="headerlink" href="#id100" title="Link to this
heading">¶</a></h4>
+<section id="id99">
+<h4>Arguments<a class="headerlink" href="#id99" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -5541,8 +5513,8 @@ they appear with the first successful one being returned.
If none of the formats
an error will be returned.</p></li>
</ul>
</section>
-<section id="id101">
-<h4>Example<a class="headerlink" href="#id101" title="Link to this
heading">¶</a></h4>
+<section id="id100">
+<h4>Example<a class="headerlink" href="#id100" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select
to_timestamp_nanos('2023-01-31T09:26:56.123456789-05:00');
+-----------------------------------------------------------------+
| to_timestamp_nanos(Utf8("2023-01-31T09:26:56.123456789-05:00")) |
@@ -5570,8 +5542,8 @@ Returns the corresponding timestamp.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span
class="n">to_timestamp_seconds</span><span class="p">(</span><span
class="n">expression</span><span class="p">[,</span> <span
class="o">...</span><span class="p">,</span> <span
class="n">format_n</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="id101">
+<h4>Arguments<a class="headerlink" href="#id101" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -5580,8 +5552,8 @@ they appear with the first successful one being returned.
If none of the formats
an error will be returned.</p></li>
</ul>
</section>
-<section id="id103">
-<h4>Example<a class="headerlink" href="#id103" title="Link to this
heading">¶</a></h4>
+<section id="id102">
+<h4>Example<a class="headerlink" href="#id102" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select
to_timestamp_seconds('2023-01-31T09:26:56.123456789-05:00');
+-------------------------------------------------------------------+
| to_timestamp_seconds(Utf8("2023-01-31T09:26:56.123456789-05:00")) |
@@ -5607,8 +5579,8 @@ return the corresponding timestamp.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">from_unixtime</span><span
class="p">(</span><span class="n">expression</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="id103">
+<h4>Arguments<a class="headerlink" href="#id103" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -5709,16 +5681,16 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_append</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">element</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id105">
-<h4>Arguments<a class="headerlink" href="#id105" title="Link to this
heading">¶</a></h4>
+<section id="id104">
+<h4>Arguments<a class="headerlink" href="#id104" 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 append to the array.</p></li>
</ul>
</section>
-<section id="id106">
-<h4>Example<a class="headerlink" href="#id106" title="Link to this
heading">¶</a></h4>
+<section id="id105">
+<h4>Example<a class="headerlink" href="#id105" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_append([1, 2, 3], 4);
+--------------------------------------+
| array_append(List([1,2,3]),Int64(4)) |
@@ -5728,8 +5700,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="id106">
+<h4>Aliases<a class="headerlink" href="#id106" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_push_back</p></li>
<li><p>list_append</p></li>
@@ -5743,8 +5715,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_sort</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">desc</span><span class="p">,</span> <span
class="n">nulls_first</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="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>
@@ -5752,8 +5724,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<li><p><strong>nulls_first</strong>: Whether to sort nulls first(<code
class="docutils literal notranslate"><span class="pre">NULLS</span> <span
class="pre">FIRST</span></code> or <code class="docutils literal
notranslate"><span class="pre">NULLS</span> <span
class="pre">LAST</span></code>).</p></li>
</ul>
</section>
-<section id="id109">
-<h4>Example<a class="headerlink" href="#id109" 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_sort([3, 1, 2]);
+-----------------------------+
| array_sort(List([3,1,2])) |
@@ -5763,8 +5735,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="id109">
+<h4>Aliases<a class="headerlink" href="#id109" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_sort</p></li>
</ul>
@@ -5776,8 +5748,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_resize</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">size</span><span class="p">,</span> <span class="n">value</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id111">
-<h4>Arguments<a class="headerlink" href="#id111" title="Link to this
heading">¶</a></h4>
+<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>
@@ -5785,8 +5757,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<li><p><strong>value</strong>: Defines new elements’ value or empty if value
is not set.</p></li>
</ul>
</section>
-<section id="id112">
-<h4>Example<a class="headerlink" href="#id112" title="Link to this
heading">¶</a></h4>
+<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_resize([1, 2, 3], 5, 0);
+-------------------------------------+
| array_resize(List([1,2,3],5,0)) |
@@ -5796,8 +5768,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id113">
-<h4>Aliases<a class="headerlink" href="#id113" title="Link to this
heading">¶</a></h4>
+<section id="id112">
+<h4>Aliases<a class="headerlink" href="#id112" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_resize</p></li>
</ul>
@@ -5813,16 +5785,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_concat</span><span
class="p">(</span><span class="n">array</span><span class="p">[,</span> <span
class="o">...</span><span class="p">,</span> <span
class="n">array_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id114">
-<h4>Arguments<a class="headerlink" href="#id114" title="Link to this
heading">¶</a></h4>
+<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 to concatenate.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
<li><p><strong>array_n</strong>: Subsequent array column or literal array to
concatenate.</p></li>
</ul>
</section>
-<section id="id115">
-<h4>Example<a class="headerlink" href="#id115" title="Link to this
heading">¶</a></h4>
+<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_concat([1, 2], [3, 4], [5,
6]);
+---------------------------------------------------+
| array_concat(List([1,2]),List([3,4]),List([5,6])) |
@@ -5832,8 +5804,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id116">
-<h4>Aliases<a class="headerlink" href="#id116" title="Link to this
heading">¶</a></h4>
+<section id="id115">
+<h4>Aliases<a class="headerlink" href="#id115" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_cat</p></li>
<li><p>list_cat</p></li>
@@ -5851,8 +5823,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</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="id117">
-<h4>Arguments<a class="headerlink" href="#id117" title="Link to this
heading">¶</a></h4>
+<section id="id116">
+<h4>Arguments<a class="headerlink" href="#id116" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5860,8 +5832,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="id118">
-<h4>Aliases<a class="headerlink" href="#id118" 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_has</p></li>
</ul>
@@ -5873,8 +5845,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="id119">
-<h4>Arguments<a class="headerlink" href="#id119" 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>
@@ -5882,8 +5854,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="id120">
-<h4>Aliases<a class="headerlink" href="#id120" title="Link to this
heading">¶</a></h4>
+<section id="id119">
+<h4>Aliases<a class="headerlink" href="#id119" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_has_all</p></li>
</ul>
@@ -5895,8 +5867,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="id121">
-<h4>Arguments<a class="headerlink" href="#id121" title="Link to this
heading">¶</a></h4>
+<section id="id120">
+<h4>Arguments<a class="headerlink" href="#id120" 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>
@@ -5904,8 +5876,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="id122">
-<h4>Aliases<a class="headerlink" href="#id122" title="Link to this
heading">¶</a></h4>
+<section id="id121">
+<h4>Aliases<a class="headerlink" href="#id121" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_has_any</p></li>
</ul>
@@ -5917,15 +5889,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="id123">
-<h4>Arguments<a class="headerlink" href="#id123" title="Link to this
heading">¶</a></h4>
+<section id="id122">
+<h4>Arguments<a class="headerlink" href="#id122" 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="id123">
+<h4>Example<a class="headerlink" href="#id123" 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])) |
@@ -5935,8 +5907,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id125">
-<h4>Aliases<a class="headerlink" href="#id125" title="Link to this
heading">¶</a></h4>
+<section id="id124">
+<h4>Aliases<a class="headerlink" href="#id124" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_dims</p></li>
</ul>
@@ -5948,15 +5920,15 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_distinct</span><span
class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id126">
-<h4>Arguments<a class="headerlink" href="#id126" title="Link to this
heading">¶</a></h4>
+<section id="id125">
+<h4>Arguments<a class="headerlink" href="#id125" 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="id127">
-<h4>Example<a class="headerlink" href="#id127" title="Link to this
heading">¶</a></h4>
+<section id="id126">
+<h4>Example<a class="headerlink" href="#id126" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_distinct([1, 3, 2, 3, 1, 2,
4]);
+---------------------------------+
| array_distinct(List([1,2,3,4])) |
@@ -5966,8 +5938,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id128">
-<h4>Aliases<a class="headerlink" href="#id128" title="Link to this
heading">¶</a></h4>
+<section id="id127">
+<h4>Aliases<a class="headerlink" href="#id127" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_distinct</p></li>
</ul>
@@ -5979,16 +5951,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="id129">
-<h4>Arguments<a class="headerlink" href="#id129" title="Link to this
heading">¶</a></h4>
+<section id="id128">
+<h4>Arguments<a class="headerlink" href="#id128" 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="id130">
-<h4>Example<a class="headerlink" href="#id130" title="Link to this
heading">¶</a></h4>
+<section id="id129">
+<h4>Example<a class="headerlink" href="#id129" 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)) |
@@ -5998,8 +5970,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id131">
-<h4>Aliases<a class="headerlink" href="#id131" title="Link to this
heading">¶</a></h4>
+<section id="id130">
+<h4>Aliases<a class="headerlink" href="#id130" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_extract</p></li>
<li><p>list_element</p></li>
@@ -6018,8 +5990,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="id132">
-<h4>Arguments<a class="headerlink" href="#id132" title="Link to this
heading">¶</a></h4>
+<section id="id131">
+<h4>Arguments<a class="headerlink" href="#id131" 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>
@@ -6035,8 +6007,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="id133">
-<h4>Arguments<a class="headerlink" href="#id133" title="Link to this
heading">¶</a></h4>
+<section id="id132">
+<h4>Arguments<a class="headerlink" href="#id132" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -6056,8 +6028,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_intersect</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="id134">
-<h4>Arguments<a class="headerlink" href="#id134" 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>array1</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -6065,8 +6037,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="id135">
-<h4>Example<a class="headerlink" href="#id135" 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_intersect([1, 2, 3, 4], [5,
6, 3, 4]);
+----------------------------------------------------+
| array_intersect([1, 2, 3, 4], [5, 6, 3, 4]); |
@@ -6083,8 +6055,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</div>
</section>
<hr class="docutils" />
-<section id="id136">
-<h4>Aliases<a class="headerlink" href="#id136" 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_intersect</p></li>
</ul>
@@ -6100,16 +6072,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="id137">
-<h4>Arguments<a class="headerlink" href="#id137" 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>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="id138">
-<h4>Example<a class="headerlink" href="#id138" 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_length([1, 2, 3, 4, 5]);
+---------------------------------+
| array_length(List([1,2,3,4,5])) |
@@ -6119,8 +6091,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id139">
-<h4>Aliases<a class="headerlink" href="#id139" title="Link to this
heading">¶</a></h4>
+<section id="id138">
+<h4>Aliases<a class="headerlink" href="#id138" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_length</p></li>
</ul>
@@ -6132,15 +6104,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="id140">
-<h4>Arguments<a class="headerlink" href="#id140" 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>
</ul>
</section>
-<section id="id141">
-<h4>Example<a class="headerlink" href="#id141" 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_ndims([[1, 2, 3], [4, 5,
6]]);
+----------------------------------+
| array_ndims(List([1,2,3,4,5,6])) |
@@ -6150,8 +6122,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id142">
-<h4>Aliases<a class="headerlink" href="#id142" title="Link to this
heading">¶</a></h4>
+<section id="id141">
+<h4>Aliases<a class="headerlink" href="#id141" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_ndims</p></li>
</ul>
@@ -6163,16 +6135,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="id143">
-<h4>Arguments<a class="headerlink" href="#id143" 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>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="id144">
-<h4>Example<a class="headerlink" href="#id144" 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_prepend(1, [2, 3, 4]);
+---------------------------------------+
| array_prepend(Int64(1),List([2,3,4])) |
@@ -6182,8 +6154,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id145">
-<h4>Aliases<a class="headerlink" href="#id145" title="Link to this
heading">¶</a></h4>
+<section id="id144">
+<h4>Aliases<a class="headerlink" href="#id144" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_push_front</p></li>
<li><p>list_prepend</p></li>
@@ -6197,15 +6169,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="id146">
-<h4>Arguments<a class="headerlink" href="#id146" 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>
</ul>
</section>
-<section id="id147">
-<h4>Example<a class="headerlink" href="#id147" 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_pop_front([1, 2, 3]);
+-------------------------------+
| array_pop_front(List([1,2,3])) |
@@ -6215,8 +6187,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id148">
-<h4>Aliases<a class="headerlink" href="#id148" title="Link to this
heading">¶</a></h4>
+<section id="id147">
+<h4>Aliases<a class="headerlink" href="#id147" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_pop_front</p></li>
</ul>
@@ -6228,15 +6200,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="id149">
-<h4>Arguments<a class="headerlink" href="#id149" 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>
</ul>
</section>
-<section id="id150">
-<h4>Example<a class="headerlink" href="#id150" 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_pop_back([1, 2, 3]);
+-------------------------------+
| array_pop_back(List([1,2,3])) |
@@ -6246,8 +6218,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id151">
-<h4>Aliases<a class="headerlink" href="#id151" title="Link to this
heading">¶</a></h4>
+<section id="id150">
+<h4>Aliases<a class="headerlink" href="#id150" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_pop_back</p></li>
</ul>
@@ -6260,8 +6232,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="id152">
-<h4>Arguments<a class="headerlink" href="#id152" 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>
@@ -6269,8 +6241,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="id153">
-<h4>Example<a class="headerlink" href="#id153" 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_position([1, 2, 2, 3, 1, 4],
2);
+----------------------------------------------+
| array_position(List([1,2,2,3,1,4]),Int64(2)) |
@@ -6280,8 +6252,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id154">
-<h4>Aliases<a class="headerlink" href="#id154" title="Link to this
heading">¶</a></h4>
+<section id="id153">
+<h4>Aliases<a class="headerlink" href="#id153" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_indexof</p></li>
<li><p>list_indexof</p></li>
@@ -6295,16 +6267,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="id155">
-<h4>Arguments<a class="headerlink" href="#id155" 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>
<li><p><strong>element</strong>: Element to search for positions in the
array.</p></li>
</ul>
</section>
-<section id="id156">
-<h4>Example<a class="headerlink" href="#id156" title="Link to this
heading">¶</a></h4>
+<section id="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_positions([1, 2, 2, 3, 1,
4], 2);
+-----------------------------------------------+
| array_positions(List([1,2,2,3,1,4]),Int64(2)) |
@@ -6314,8 +6286,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id157">
-<h4>Aliases<a class="headerlink" href="#id157" title="Link to this
heading">¶</a></h4>
+<section id="id156">
+<h4>Aliases<a class="headerlink" href="#id156" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_positions</p></li>
</ul>
@@ -6335,16 +6307,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="id158">
-<h4>Arguments<a class="headerlink" href="#id158" 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>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="id159">
-<h4>Example<a class="headerlink" href="#id159" title="Link to this
heading">¶</a></h4>
+<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_repeat(1, 3);
+---------------------------------+
| array_repeat(Int64(1),Int64(3)) |
@@ -6362,8 +6334,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id160">
-<h4>Aliases<a class="headerlink" href="#id160" title="Link to this
heading">¶</a></h4>
+<section id="id159">
+<h4>Aliases<a class="headerlink" href="#id159" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_repeat</p></li>
</ul>
@@ -6375,16 +6347,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="id161">
-<h4>Arguments<a class="headerlink" href="#id161" 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>element</strong>: Element to be removed from the array.</p></li>
</ul>
</section>
-<section id="id162">
-<h4>Example<a class="headerlink" href="#id162" title="Link to this
heading">¶</a></h4>
+<section id="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_remove([1, 2, 2, 3, 2, 1,
4], 2);
+----------------------------------------------+
| array_remove(List([1,2,2,3,2,1,4]),Int64(2)) |
@@ -6394,8 +6366,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id163">
-<h4>Aliases<a class="headerlink" href="#id163" title="Link to this
heading">¶</a></h4>
+<section id="id162">
+<h4>Aliases<a class="headerlink" href="#id162" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove</p></li>
</ul>
@@ -6407,8 +6379,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="id164">
-<h4>Arguments<a class="headerlink" href="#id164" 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>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -6416,8 +6388,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="id165">
-<h4>Example<a class="headerlink" href="#id165" 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_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)) |
@@ -6427,8 +6399,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id166">
-<h4>Aliases<a class="headerlink" href="#id166" title="Link to this
heading">¶</a></h4>
+<section id="id165">
+<h4>Aliases<a class="headerlink" href="#id165" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove_n</p></li>
</ul>
@@ -6440,16 +6412,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="id167">
-<h4>Arguments<a class="headerlink" href="#id167" 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>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="id168">
-<h4>Example<a class="headerlink" href="#id168" 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_remove_all([1, 2, 2, 3, 2,
1, 4], 2);
+--------------------------------------------------+
| array_remove_all(List([1,2,2,3,2,1,4]),Int64(2)) |
@@ -6459,8 +6431,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id169">
-<h4>Aliases<a class="headerlink" href="#id169" title="Link to this
heading">¶</a></h4>
+<section id="id168">
+<h4>Aliases<a class="headerlink" href="#id168" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove_all</p></li>
</ul>
@@ -6472,8 +6444,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="id170">
-<h4>Arguments<a class="headerlink" href="#id170" 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>
@@ -6481,8 +6453,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<li><p><strong>to</strong>: Final element.</p></li>
</ul>
</section>
-<section id="id171">
-<h4>Example<a class="headerlink" href="#id171" title="Link to this
heading">¶</a></h4>
+<section id="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 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)) |
@@ -6492,8 +6464,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id172">
-<h4>Aliases<a class="headerlink" href="#id172" title="Link to this
heading">¶</a></h4>
+<section id="id171">
+<h4>Aliases<a class="headerlink" href="#id171" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace</p></li>
</ul>
@@ -6505,8 +6477,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="id173">
-<h4>Arguments<a class="headerlink" href="#id173" title="Link to this
heading">¶</a></h4>
+<section id="id172">
+<h4>Arguments<a class="headerlink" href="#id172" 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>
@@ -6515,8 +6487,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="id174">
-<h4>Example<a class="headerlink" href="#id174" title="Link to this
heading">¶</a></h4>
+<section id="id173">
+<h4>Example<a class="headerlink" href="#id173" 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)) |
@@ -6526,8 +6498,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id175">
-<h4>Aliases<a class="headerlink" href="#id175" title="Link to this
heading">¶</a></h4>
+<section id="id174">
+<h4>Aliases<a class="headerlink" href="#id174" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace_n</p></li>
</ul>
@@ -6539,8 +6511,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="id176">
-<h4>Arguments<a class="headerlink" href="#id176" title="Link to this
heading">¶</a></h4>
+<section id="id175">
+<h4>Arguments<a class="headerlink" href="#id175" 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>
@@ -6548,8 +6520,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="id177">
-<h4>Example<a class="headerlink" href="#id177" title="Link to this
heading">¶</a></h4>
+<section id="id176">
+<h4>Example<a class="headerlink" href="#id176" 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)) |
@@ -6559,8 +6531,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id178">
-<h4>Aliases<a class="headerlink" href="#id178" 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>list_replace_all</p></li>
</ul>
@@ -6572,15 +6544,15 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_reverse</span><span
class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id179">
-<h4>Arguments<a class="headerlink" href="#id179" 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>
</ul>
</section>
-<section id="id180">
-<h4>Example<a class="headerlink" href="#id180" title="Link to this
heading">¶</a></h4>
+<section id="id179">
+<h4>Example<a class="headerlink" href="#id179" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_reverse([1, 2, 3, 4]);
+------------------------------------------------------------+
| array_reverse(List([1, 2, 3, 4])) |
@@ -6590,8 +6562,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id181">
-<h4>Aliases<a class="headerlink" href="#id181" title="Link to this
heading">¶</a></h4>
+<section id="id180">
+<h4>Aliases<a class="headerlink" href="#id180" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_reverse</p></li>
</ul>
@@ -6603,8 +6575,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="id182">
-<h4>Arguments<a class="headerlink" href="#id182" 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>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -6615,8 +6587,8 @@ If negative, it counts backward from the end of the
array.</p></li>
<li><p><strong>stride</strong>: Stride of the array slice. The default is
1.</p></li>
</ul>
</section>
-<section id="id183">
-<h4>Example<a class="headerlink" href="#id183" title="Link to this
heading">¶</a></h4>
+<section id="id182">
+<h4>Example<a class="headerlink" href="#id182" 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)) |
@@ -6626,8 +6598,8 @@ If negative, it counts backward from the end of the
array.</p></li>
</pre></div>
</div>
</section>
-<section id="id184">
-<h4>Aliases<a class="headerlink" href="#id184" title="Link to this
heading">¶</a></h4>
+<section id="id183">
+<h4>Aliases<a class="headerlink" href="#id183" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_slice</p></li>
</ul>
@@ -6639,16 +6611,16 @@ If negative, it counts backward from the end of the
array.</p></li>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_to_string</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">delimiter</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id185">
-<h4>Arguments<a class="headerlink" href="#id185" 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>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="id186">
-<h4>Example<a class="headerlink" href="#id186" title="Link to this
heading">¶</a></h4>
+<section id="id185">
+<h4>Example<a class="headerlink" href="#id185" 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(",")) |
@@ -6658,8 +6630,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id187">
-<h4>Aliases<a class="headerlink" href="#id187" title="Link to this
heading">¶</a></h4>
+<section id="id186">
+<h4>Aliases<a class="headerlink" href="#id186" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_join</p></li>
<li><p>list_join</p></li>
@@ -6673,8 +6645,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="id188">
-<h4>Arguments<a class="headerlink" href="#id188" 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>array1</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -6682,8 +6654,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="id189">
-<h4>Example<a class="headerlink" href="#id189" 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 array_union([1, 2, 3, 4], [5, 6,
3, 4]);
+----------------------------------------------------+
| array_union([1, 2, 3, 4], [5, 6, 3, 4]); |
@@ -6700,8 +6672,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</div>
</section>
<hr class="docutils" />
-<section id="id190">
-<h4>Aliases<a class="headerlink" href="#id190" title="Link to this
heading">¶</a></h4>
+<section id="id189">
+<h4>Aliases<a class="headerlink" href="#id189" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_union</p></li>
</ul>
@@ -6713,8 +6685,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="id191">
-<h4>Arguments<a class="headerlink" href="#id191" title="Link to this
heading">¶</a></h4>
+<section id="id190">
+<h4>Arguments<a class="headerlink" href="#id190" 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>
@@ -6722,8 +6694,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="id192">
-<h4>Example<a class="headerlink" href="#id192" title="Link to this
heading">¶</a></h4>
+<section id="id191">
+<h4>Example<a class="headerlink" href="#id191" 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]); |
@@ -6740,8 +6712,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</div>
</section>
<hr class="docutils" />
-<section id="id193">
-<h4>Aliases<a class="headerlink" href="#id193" title="Link to this
heading">¶</a></h4>
+<section id="id192">
+<h4>Aliases<a class="headerlink" href="#id192" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_except</p></li>
</ul>
@@ -6753,15 +6725,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="id194">
-<h4>Arguments<a class="headerlink" href="#id194" title="Link to this
heading">¶</a></h4>
+<section id="id193">
+<h4>Arguments<a class="headerlink" href="#id193" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id195">
-<h4>Example<a class="headerlink" href="#id195" title="Link to this
heading">¶</a></h4>
+<section id="id194">
+<h4>Example<a class="headerlink" href="#id194" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select cardinality([[1, 2, 3, 4], [5, 6,
7, 8]]);
+--------------------------------------+
| cardinality(List([1,2,3,4,5,6,7,8])) |
@@ -6778,15 +6750,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="id196">
-<h4>Arguments<a class="headerlink" href="#id196" title="Link to this
heading">¶</a></h4>
+<section id="id195">
+<h4>Arguments<a class="headerlink" href="#id195" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id197">
-<h4>Example<a class="headerlink" href="#id197" title="Link to this
heading">¶</a></h4>
+<section id="id196">
+<h4>Example<a class="headerlink" href="#id196" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select empty([1]);
+------------------+
| empty(List([1])) |
@@ -6803,16 +6775,16 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">generate_series</span><span
class="p">(</span><span class="n">start</span><span class="p">,</span> <span
class="n">stop</span><span class="p">,</span> <span class="n">step</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id198">
-<h4>Arguments<a class="headerlink" href="#id198" title="Link to this
heading">¶</a></h4>
+<section id="id197">
+<h4>Arguments<a class="headerlink" href="#id197" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>start</strong>: start of the range</p></li>
<li><p><strong>end</strong>: end of the range (included)</p></li>
<li><p><strong>step</strong>: increase by step (can not be 0)</p></li>
</ul>
</section>
-<section id="id199">
-<h4>Example<a class="headerlink" href="#id199" title="Link to this
heading">¶</a></h4>
+<section id="id198">
+<h4>Example<a class="headerlink" href="#id198" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select generate_series(1,3);
+------------------------------------+
| generate_series(Int64(1),Int64(3)) |
@@ -6973,16 +6945,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="id200">
-<h4>Arguments<a class="headerlink" href="#id200" title="Link to this
heading">¶</a></h4>
+<section id="id199">
+<h4>Arguments<a class="headerlink" href="#id199" 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="id201">
-<h4>Example<a class="headerlink" href="#id201" title="Link to this
heading">¶</a></h4>
+<section id="id200">
+<h4>Example<a class="headerlink" href="#id200" 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)) |
@@ -6992,8 +6964,8 @@ string operators.</p></li>
</pre></div>
</div>
</section>
-<section id="id202">
-<h4>Aliases<a class="headerlink" href="#id202" title="Link to this
heading">¶</a></h4>
+<section id="id201">
+<h4>Aliases<a class="headerlink" href="#id201" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>make_list</p></li>
</ul>
@@ -7010,16 +6982,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="id203">
-<h4>Arguments<a class="headerlink" href="#id203" title="Link to this
heading">¶</a></h4>
+<section id="id202">
+<h4>Arguments<a class="headerlink" href="#id202" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>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="id204">
-<h4>Aliases<a class="headerlink" href="#id204" title="Link to this
heading">¶</a></h4>
+<section id="id203">
+<h4>Aliases<a class="headerlink" href="#id203" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>string_to_list</p></li>
</ul>
@@ -7036,8 +7008,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="id205">
-<h4>Arguments<a class="headerlink" href="#id205" title="Link to this
heading">¶</a></h4>
+<section id="id204">
+<h4>Arguments<a class="headerlink" href="#id204" 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>
@@ -7069,16 +7041,16 @@ For example,</p>
</pre></div>
</div>
<p>are not allowed</p>
-<section id="id206">
-<h4>Arguments<a class="headerlink" href="#id206" title="Link to this
heading">¶</a></h4>
+<section id="id205">
+<h4>Arguments<a class="headerlink" href="#id205" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>start</strong>: start of the range</p></li>
<li><p><strong>end</strong>: end of the range (not included)</p></li>
<li><p><strong>step</strong>: increase by step (can not be 0)</p></li>
</ul>
</section>
-<section id="id207">
-<h4>Aliases<a class="headerlink" href="#id207" title="Link to this
heading">¶</a></h4>
+<section id="id206">
+<h4>Aliases<a class="headerlink" href="#id206" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>generate_series</p></li>
</ul>
@@ -7117,8 +7089,8 @@ a struct type of fields <code class="docutils literal
notranslate"><span class="
<span class="o">+-----------------+</span>
</pre></div>
</div>
-<section id="id208">
-<h4>Arguments<a class="headerlink" href="#id208" title="Link to this
heading">¶</a></h4>
+<section id="id207">
+<h4>Arguments<a class="headerlink" href="#id207" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression_n</strong>: Expression to include in the output
struct.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -7143,8 +7115,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="id209">
-<h4>Arguments<a class="headerlink" href="#id209" title="Link to this
heading">¶</a></h4>
+<section id="id208">
+<h4>Arguments<a class="headerlink" href="#id208" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -7170,8 +7142,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="id210">
-<h4>Arguments<a class="headerlink" href="#id210" title="Link to this
heading">¶</a></h4>
+<section id="id209">
+<h4>Arguments<a class="headerlink" href="#id209" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -7184,8 +7156,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="id211">
-<h4>Arguments<a class="headerlink" href="#id211" title="Link to this
heading">¶</a></h4>
+<section id="id210">
+<h4>Arguments<a class="headerlink" href="#id210" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -7198,8 +7170,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="id212">
-<h4>Arguments<a class="headerlink" href="#id212" title="Link to this
heading">¶</a></h4>
+<section id="id211">
+<h4>Arguments<a class="headerlink" href="#id211" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -7212,8 +7184,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="id213">
-<h4>Arguments<a class="headerlink" href="#id213" title="Link to this
heading">¶</a></h4>
+<section id="id212">
+<h4>Arguments<a class="headerlink" href="#id212" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -7226,8 +7198,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="id214">
-<h4>Arguments<a class="headerlink" href="#id214" title="Link to this
heading">¶</a></h4>
+<section id="id213">
+<h4>Arguments<a class="headerlink" href="#id213" 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>
@@ -7247,8 +7219,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="id215">
-<h4>Arguments<a class="headerlink" href="#id215" title="Link to this
heading">¶</a></h4>
+<section id="id214">
+<h4>Arguments<a class="headerlink" href="#id214" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to cast.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -7257,8 +7229,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="id216">
-<h4>Example<a class="headerlink" href="#id216" title="Link to this
heading">¶</a></h4>
+<section id="id215">
+<h4>Example<a class="headerlink" href="#id215" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select arrow_cast(-5, 'Int8') as
a,
arrow_cast('foo', 'Dictionary(Int32, Utf8)') as b,
arrow_cast('bar', 'LargeUtf8') as c,
@@ -7280,16 +7252,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="id217">
-<h4>Arguments<a class="headerlink" href="#id217" title="Link to this
heading">¶</a></h4>
+<section id="id216">
+<h4>Arguments<a class="headerlink" href="#id216" 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="id218">
-<h4>Example<a class="headerlink" href="#id218" title="Link to this
heading">¶</a></h4>
+<section id="id217">
+<h4>Example<a class="headerlink" href="#id217" 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)) |
