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 7cef876c5a Publish built docs triggered by
196b71823c417615dd90350f4e77d8acc5b3ed60
7cef876c5a is described below
commit 7cef876c5af58c012556a2feab5e1dca0b0040f9
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Tue Feb 13 14:40:50 2024 +0000
Publish built docs triggered by 196b71823c417615dd90350f4e77d8acc5b3ed60
---
_sources/user-guide/sql/scalar_functions.md.txt | 37 ++
searchindex.js | 2 +-
user-guide/sql/scalar_functions.html | 759 +++++++++++++-----------
3 files changed, 449 insertions(+), 349 deletions(-)
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index c9c32a67ce..a6e872cab4 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -1425,6 +1425,7 @@ position(substr in origstr)
- [extract](#extract)
- [today](#today)
- [make_date](#make_date)
+- [to_char](#to_char)
- [to_timestamp](#to_timestamp)
- [to_timestamp_millis](#to_timestamp_millis)
- [to_timestamp_micros](#to_timestamp_micros)
@@ -1649,6 +1650,42 @@ make_date(year, month, day)
Additional examples can be found
[here](https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/make_date.rs)
+### `to_char`
+
+Returns a string representation of a date, time, timestamp or duration based
+on a [Chrono format]. Unlike the PostgreSQL equivalent of this function
+numerical formatting is not supported.
+
+```
+to_char(expression, format)
+```
+
+#### Arguments
+
+- **expression**: Expression to operate on.
+ Can be a constant, column, or function that results in a
+ date, time, timestamp or duration.
+- **format**: A [Chrono format] string to use to convert the expression.
+
+#### Example
+
+```
+❯ ❯ select to_char('2023-03-01'::date, '%d-%m-%Y');
++----------------------------------------------+
+| to_char(Utf8("2023-03-01"),Utf8("%d-%m-%Y")) |
++----------------------------------------------+
+| 01-03-2023 |
++----------------------------------------------+
+```
+
+Additional examples can be found [here]
+
+[here]:
https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/to_char.rs
+
+#### Aliases
+
+- date_format
+
### `to_timestamp`
Converts a value to a timestamp (`YYYY-MM-DDT00:00:00Z`).
diff --git a/searchindex.js b/searchindex.js
index b1e3cbc8ae..0f845b8a46 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 83b64fb529..8966605c9e 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -1840,10 +1840,10 @@
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#to-timestamp">
+ <a class="reference internal nav-link" href="#to-char">
<code class="docutils literal notranslate">
<span class="pre">
- to_timestamp
+ to_char
</span>
</code>
</a>
@@ -1858,6 +1858,32 @@
Example
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id90">
+ Aliases
+ </a>
+ </li>
+ </ul>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#to-timestamp">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ to_timestamp
+ </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="#id91">
+ Arguments
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id92">
+ Example
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -1870,12 +1896,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id90">
+ <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="#id91">
+ <a class="reference internal nav-link" href="#id94">
Example
</a>
</li>
@@ -1891,12 +1917,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id92">
+ <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="#id93">
+ <a class="reference internal nav-link" href="#id96">
Example
</a>
</li>
@@ -1912,12 +1938,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="#id97">
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="#id98">
Example
</a>
</li>
@@ -1933,12 +1959,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="#id99">
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="#id100">
Example
</a>
</li>
@@ -1954,7 +1980,7 @@
</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="#id101">
Arguments
</a>
</li>
@@ -1977,17 +2003,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id99">
+ <a class="reference internal nav-link" href="#id102">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id100">
+ <a class="reference internal nav-link" href="#id103">
Example
</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="#id104">
Aliases
</a>
</li>
@@ -2003,17 +2029,17 @@
</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="#id105">
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="#id106">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id104">
+ <a class="reference internal nav-link" href="#id107">
Aliases
</a>
</li>
@@ -2038,17 +2064,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="#id108">
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="#id109">
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="#id110">
Aliases
</a>
</li>
@@ -2073,12 +2099,12 @@
</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="#id111">
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="#id112">
Aliases
</a>
</li>
@@ -2094,12 +2120,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id110">
+ <a class="reference internal nav-link" href="#id113">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id111">
+ <a class="reference internal nav-link" href="#id114">
Aliases
</a>
</li>
@@ -2115,12 +2141,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id112">
+ <a class="reference internal nav-link" href="#id115">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id113">
+ <a class="reference internal nav-link" href="#id116">
Aliases
</a>
</li>
@@ -2136,17 +2162,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="#id117">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id115">
+ <a class="reference internal nav-link" href="#id118">
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="#id119">
Aliases
</a>
</li>
@@ -2162,17 +2188,17 @@
</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="#id120">
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="#id121">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id119">
+ <a class="reference internal nav-link" href="#id122">
Aliases
</a>
</li>
@@ -2197,7 +2223,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id120">
+ <a class="reference internal nav-link" href="#id123">
Arguments
</a>
</li>
@@ -2213,7 +2239,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id121">
+ <a class="reference internal nav-link" href="#id124">
Arguments
</a>
</li>
@@ -2247,17 +2273,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id122">
+ <a class="reference internal nav-link" href="#id125">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id123">
+ <a class="reference internal nav-link" href="#id126">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id124">
+ <a class="reference internal nav-link" href="#id127">
Aliases
</a>
</li>
@@ -2273,17 +2299,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id125">
+ <a class="reference internal nav-link" href="#id128">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id126">
+ <a class="reference internal nav-link" href="#id129">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id127">
+ <a class="reference internal nav-link" href="#id130">
Aliases
</a>
</li>
@@ -2299,17 +2325,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id128">
+ <a class="reference internal nav-link" href="#id131">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id129">
+ <a class="reference internal nav-link" href="#id132">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id130">
+ <a class="reference internal nav-link" href="#id133">
Aliases
</a>
</li>
@@ -2325,17 +2351,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id131">
+ <a class="reference internal nav-link" href="#id134">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id132">
+ <a class="reference internal nav-link" href="#id135">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id133">
+ <a class="reference internal nav-link" href="#id136">
Aliases
</a>
</li>
@@ -2351,17 +2377,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id134">
+ <a class="reference internal nav-link" href="#id137">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id135">
+ <a class="reference internal nav-link" href="#id138">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id136">
+ <a class="reference internal nav-link" href="#id139">
Aliases
</a>
</li>
@@ -2377,17 +2403,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id137">
+ <a class="reference internal nav-link" href="#id140">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id138">
+ <a class="reference internal nav-link" href="#id141">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id139">
+ <a class="reference internal nav-link" href="#id142">
Aliases
</a>
</li>
@@ -2403,17 +2429,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id140">
+ <a class="reference internal nav-link" href="#id143">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id141">
+ <a class="reference internal nav-link" href="#id144">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id142">
+ <a class="reference internal nav-link" href="#id145">
Aliases
</a>
</li>
@@ -2447,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="#id143">
+ <a class="reference internal nav-link" href="#id146">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id144">
+ <a class="reference internal nav-link" href="#id147">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id145">
+ <a class="reference internal nav-link" href="#id148">
Aliases
</a>
</li>
@@ -2473,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="#id146">
+ <a class="reference internal nav-link" href="#id149">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id147">
+ <a class="reference internal nav-link" href="#id150">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id148">
+ <a class="reference internal nav-link" href="#id151">
Aliases
</a>
</li>
@@ -2499,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="#id149">
+ <a class="reference internal nav-link" href="#id152">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id150">
+ <a class="reference internal nav-link" href="#id153">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id151">
+ <a class="reference internal nav-link" href="#id154">
Aliases
</a>
</li>
@@ -2525,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="#id152">
+ <a class="reference internal nav-link" href="#id155">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id153">
+ <a class="reference internal nav-link" href="#id156">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id154">
+ <a class="reference internal nav-link" href="#id157">
Aliases
</a>
</li>
@@ -2551,17 +2577,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id155">
+ <a class="reference internal nav-link" href="#id158">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id156">
+ <a class="reference internal nav-link" href="#id159">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id157">
+ <a class="reference internal nav-link" href="#id160">
Aliases
</a>
</li>
@@ -2577,17 +2603,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id158">
+ <a class="reference internal nav-link" href="#id161">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id159">
+ <a class="reference internal nav-link" href="#id162">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id160">
+ <a class="reference internal nav-link" href="#id163">
Aliases
</a>
</li>
@@ -2603,17 +2629,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id161">
+ <a class="reference internal nav-link" href="#id164">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id162">
+ <a class="reference internal nav-link" href="#id165">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id163">
+ <a class="reference internal nav-link" href="#id166">
Aliases
</a>
</li>
@@ -2629,17 +2655,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id164">
+ <a class="reference internal nav-link" href="#id167">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id165">
+ <a class="reference internal nav-link" href="#id168">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id166">
+ <a class="reference internal nav-link" href="#id169">
Aliases
</a>
</li>
@@ -2655,17 +2681,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id167">
+ <a class="reference internal nav-link" href="#id170">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id168">
+ <a class="reference internal nav-link" href="#id171">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id169">
+ <a class="reference internal nav-link" href="#id172">
Aliases
</a>
</li>
@@ -2681,17 +2707,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id170">
+ <a class="reference internal nav-link" href="#id173">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id171">
+ <a class="reference internal nav-link" href="#id174">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id172">
+ <a class="reference internal nav-link" href="#id175">
Aliases
</a>
</li>
@@ -2707,17 +2733,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id173">
+ <a class="reference internal nav-link" href="#id176">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id174">
+ <a class="reference internal nav-link" href="#id177">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id175">
+ <a class="reference internal nav-link" href="#id178">
Aliases
</a>
</li>
@@ -2733,17 +2759,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id176">
+ <a class="reference internal nav-link" href="#id179">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id177">
+ <a class="reference internal nav-link" href="#id180">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id178">
+ <a class="reference internal nav-link" href="#id181">
Aliases
</a>
</li>
@@ -2759,12 +2785,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id179">
+ <a class="reference internal nav-link" href="#id182">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id180">
+ <a class="reference internal nav-link" href="#id183">
Example
</a>
</li>
@@ -2780,12 +2806,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id181">
+ <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="#id182">
+ <a class="reference internal nav-link" href="#id185">
Example
</a>
</li>
@@ -3080,17 +3106,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id183">
+ <a class="reference internal nav-link" href="#id186">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id184">
+ <a class="reference internal nav-link" href="#id187">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id185">
+ <a class="reference internal nav-link" href="#id188">
Aliases
</a>
</li>
@@ -3115,12 +3141,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id186">
+ <a class="reference internal nav-link" href="#id189">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id187">
+ <a class="reference internal nav-link" href="#id190">
Aliases
</a>
</li>
@@ -3145,7 +3171,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id188">
+ <a class="reference internal nav-link" href="#id191">
Arguments
</a>
</li>
@@ -3161,7 +3187,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id189">
+ <a class="reference internal nav-link" href="#id192">
Arguments
</a>
</li>
@@ -3184,7 +3210,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id190">
+ <a class="reference internal nav-link" href="#id193">
Arguments
</a>
</li>
@@ -3207,7 +3233,7 @@
</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="#id194">
Arguments
</a>
</li>
@@ -3223,7 +3249,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id192">
+ <a class="reference internal nav-link" href="#id195">
Arguments
</a>
</li>
@@ -3239,7 +3265,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id193">
+ <a class="reference internal nav-link" href="#id196">
Arguments
</a>
</li>
@@ -3255,7 +3281,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id194">
+ <a class="reference internal nav-link" href="#id197">
Arguments
</a>
</li>
@@ -3271,7 +3297,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id195">
+ <a class="reference internal nav-link" href="#id198">
Arguments
</a>
</li>
@@ -3287,7 +3313,7 @@
</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="#id199">
Arguments
</a>
</li>
@@ -3310,12 +3336,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id197">
+ <a class="reference internal nav-link" href="#id200">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id198">
+ <a class="reference internal nav-link" href="#id201">
Example
</a>
</li>
@@ -3331,12 +3357,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id199">
+ <a class="reference internal nav-link" href="#id202">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id200">
+ <a class="reference internal nav-link" href="#id203">
Example
</a>
</li>
@@ -4864,6 +4890,7 @@ regular expression. The following flags are supported:</p>
<li><p><a class="reference internal" href="#extract">extract</a></p></li>
<li><p><a class="reference internal" href="#today">today</a></p></li>
<li><p><a class="reference internal" href="#make-date">make_date</a></p></li>
+<li><p><a class="reference internal" href="#to-char">to_char</a></p></li>
<li><p><a class="reference internal"
href="#to-timestamp">to_timestamp</a></p></li>
<li><p><a class="reference internal"
href="#to-timestamp-millis">to_timestamp_millis</a></p></li>
<li><p><a class="reference internal"
href="#to-timestamp-micros">to_timestamp_micros</a></p></li>
@@ -5094,31 +5121,67 @@ Can be a constant, column or function, and any
combination of arithmetic operato
<p>Additional examples can be found <a class="reference external"
href="https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/make_date.rs";>here</a></p>
</section>
</section>
-<section id="to-timestamp">
-<h3><code class="docutils literal notranslate"><span
class="pre">to_timestamp</span></code><a class="headerlink"
href="#to-timestamp" title="Link to this heading">¶</a></h3>
-<p>Converts a value to a timestamp (<code class="docutils literal
notranslate"><span class="pre">YYYY-MM-DDT00:00:00Z</span></code>).
-Supports strings, integer, unsigned integer, and double types as input.
-Strings are parsed as RFC3339 (e.g. ‘2023-07-20T05:44:00’) if no [Chrono
formats] are provided.
-Integers, unsigned integers, and doubles are interpreted as seconds since the
unix epoch (<code class="docutils literal notranslate"><span
class="pre">1970-01-01T00:00:00Z</span></code>).
-Returns the corresponding timestamp.</p>
-<p>Note: <code class="docutils literal notranslate"><span
class="pre">to_timestamp</span></code> returns <code class="docutils literal
notranslate"><span class="pre">Timestamp(Nanosecond)</span></code>. The
supported range for integer input is between <code class="docutils literal
notranslate"><span class="pre">-9223372037</span></code> and <code
class="docutils literal notranslate"><span class="pre">9223372036</span></code>.
-Supported range for string input is between <code class="docutils literal
notranslate"><span class="pre">1677-09-21T00:12:44.0</span></code> and <code
class="docutils literal notranslate"><span
class="pre">2262-04-11T23:47:16.0</span></code>. Please use <code
class="docutils literal notranslate"><span
class="pre">to_timestamp_seconds</span></code>
-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>
+<section id="to-char">
+<h3><code class="docutils literal notranslate"><span
class="pre">to_char</span></code><a class="headerlink" href="#to-char"
title="Link to this heading">¶</a></h3>
+<p>Returns a string representation of a date, time, timestamp or duration based
+on a <a class="reference external"
href="https://docs.rs/chrono/latest/chrono/format/strftime/index.html";>Chrono
format</a>. Unlike the PostgreSQL equivalent of this function
+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="id88">
<h4>Arguments<a class="headerlink" href="#id88" 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
+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="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
to_char('2023-03-01'::date, '%d-%m-%Y');
++----------------------------------------------+
+| to_char(Utf8("2023-03-01"),Utf8("%d-%m-%Y")) |
++----------------------------------------------+
+| 01-03-2023 |
++----------------------------------------------+
+</pre></div>
+</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="id90">
+<h4>Aliases<a class="headerlink" href="#id90" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>date_format</p></li>
+</ul>
+</section>
+</section>
+<section id="to-timestamp">
+<h3><code class="docutils literal notranslate"><span
class="pre">to_timestamp</span></code><a class="headerlink"
href="#to-timestamp" title="Link to this heading">¶</a></h3>
+<p>Converts a value to a timestamp (<code class="docutils literal
notranslate"><span class="pre">YYYY-MM-DDT00:00:00Z</span></code>).
+Supports strings, integer, unsigned integer, and double types as input.
+Strings are parsed as RFC3339 (e.g. ‘2023-07-20T05:44:00’) if no [Chrono
formats] are provided.
+Integers, unsigned integers, and doubles are interpreted as seconds since the
unix epoch (<code class="docutils literal notranslate"><span
class="pre">1970-01-01T00:00:00Z</span></code>).
+Returns the corresponding timestamp.</p>
+<p>Note: <code class="docutils literal notranslate"><span
class="pre">to_timestamp</span></code> returns <code class="docutils literal
notranslate"><span class="pre">Timestamp(Nanosecond)</span></code>. The
supported range for integer input is between <code class="docutils literal
notranslate"><span class="pre">-9223372037</span></code> and <code
class="docutils literal notranslate"><span class="pre">9223372036</span></code>.
+Supported range for string input is between <code class="docutils literal
notranslate"><span class="pre">1677-09-21T00:12:44.0</span></code> and <code
class="docutils literal notranslate"><span
class="pre">2262-04-11T23:47:16.0</span></code>. Please use <code
class="docutils literal notranslate"><span
class="pre">to_timestamp_seconds</span></code>
+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="id91">
+<h4>Arguments<a class="headerlink" href="#id91" 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>
<li><p><strong>format_n</strong>: Optional <a class="reference external"
href="https://docs.rs/chrono/latest/chrono/format/strftime/index.html";>Chrono
format</a> strings to use to parse the expression. Formats will be tried in the
order
they appear with the first successful one being returned. If none of the
formats successfully parse the expression
an error will be returned.</p></li>
</ul>
</section>
-<section id="id89">
-<h4>Example<a class="headerlink" href="#id89" title="Link to this
heading">¶</a></h4>
+<section id="id92">
+<h4>Example<a class="headerlink" href="#id92" 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")) |
@@ -5146,8 +5209,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="id90">
-<h4>Arguments<a class="headerlink" href="#id90" 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>
@@ -5156,8 +5219,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="id91">
-<h4>Example<a class="headerlink" href="#id91" 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_millis('2023-01-31T09:26:56.123456789-05:00');
+------------------------------------------------------------------+
| to_timestamp_millis(Utf8("2023-01-31T09:26:56.123456789-05:00")) |
@@ -5185,8 +5248,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="id92">
-<h4>Arguments<a class="headerlink" href="#id92" 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>
@@ -5195,8 +5258,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="id93">
-<h4>Example<a class="headerlink" href="#id93" 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_micros('2023-01-31T09:26:56.123456789-05:00');
+------------------------------------------------------------------+
| to_timestamp_micros(Utf8("2023-01-31T09:26:56.123456789-05:00")) |
@@ -5224,8 +5287,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="id94">
-<h4>Arguments<a class="headerlink" href="#id94" 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>
@@ -5234,8 +5297,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="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_nanos('2023-01-31T09:26:56.123456789-05:00');
+-----------------------------------------------------------------+
| to_timestamp_nanos(Utf8("2023-01-31T09:26:56.123456789-05:00")) |
@@ -5263,8 +5326,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="id96">
-<h4>Arguments<a class="headerlink" href="#id96" 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>
@@ -5273,8 +5336,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="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_seconds('2023-01-31T09:26:56.123456789-05:00');
+-------------------------------------------------------------------+
| to_timestamp_seconds(Utf8("2023-01-31T09:26:56.123456789-05:00")) |
@@ -5300,8 +5363,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="id98">
-<h4>Arguments<a class="headerlink" href="#id98" 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>
@@ -5386,16 +5449,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="id99">
-<h4>Arguments<a class="headerlink" href="#id99" title="Link to this
heading">¶</a></h4>
+<section id="id102">
+<h4>Arguments<a class="headerlink" href="#id102" 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="id100">
-<h4>Example<a class="headerlink" href="#id100" title="Link to this
heading">¶</a></h4>
+<section id="id103">
+<h4>Example<a class="headerlink" href="#id103" 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)) |
@@ -5405,8 +5468,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id101">
-<h4>Aliases<a class="headerlink" href="#id101" title="Link to this
heading">¶</a></h4>
+<section id="id104">
+<h4>Aliases<a class="headerlink" href="#id104" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_push_back</p></li>
<li><p>list_append</p></li>
@@ -5420,8 +5483,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="id102">
-<h4>Arguments<a class="headerlink" href="#id102" title="Link to this
heading">¶</a></h4>
+<section id="id105">
+<h4>Arguments<a class="headerlink" href="#id105" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5429,8 +5492,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="id103">
-<h4>Example<a class="headerlink" href="#id103" title="Link to this
heading">¶</a></h4>
+<section id="id106">
+<h4>Example<a class="headerlink" href="#id106" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_sort([3, 1, 2]);
+-----------------------------+
| array_sort(List([3,1,2])) |
@@ -5440,8 +5503,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id104">
-<h4>Aliases<a class="headerlink" href="#id104" title="Link to this
heading">¶</a></h4>
+<section id="id107">
+<h4>Aliases<a class="headerlink" href="#id107" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_sort</p></li>
</ul>
@@ -5457,16 +5520,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="id105">
-<h4>Arguments<a class="headerlink" href="#id105" title="Link to this
heading">¶</a></h4>
+<section id="id108">
+<h4>Arguments<a class="headerlink" href="#id108" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression 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="id106">
-<h4>Example<a class="headerlink" href="#id106" title="Link to this
heading">¶</a></h4>
+<section id="id109">
+<h4>Example<a class="headerlink" href="#id109" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_concat([1, 2], [3, 4], [5,
6]);
+---------------------------------------------------+
| array_concat(List([1,2]),List([3,4]),List([5,6])) |
@@ -5476,8 +5539,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="id110">
+<h4>Aliases<a class="headerlink" href="#id110" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_cat</p></li>
<li><p>list_cat</p></li>
@@ -5495,8 +5558,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="id108">
-<h4>Arguments<a class="headerlink" href="#id108" title="Link to this
heading">¶</a></h4>
+<section id="id111">
+<h4>Arguments<a class="headerlink" href="#id111" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5504,8 +5567,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="id109">
-<h4>Aliases<a class="headerlink" href="#id109" title="Link to this
heading">¶</a></h4>
+<section id="id112">
+<h4>Aliases<a class="headerlink" href="#id112" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_has</p></li>
</ul>
@@ -5517,8 +5580,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="id110">
-<h4>Arguments<a class="headerlink" href="#id110" title="Link to this
heading">¶</a></h4>
+<section id="id113">
+<h4>Arguments<a class="headerlink" href="#id113" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5526,8 +5589,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="id111">
-<h4>Aliases<a class="headerlink" href="#id111" title="Link to this
heading">¶</a></h4>
+<section id="id114">
+<h4>Aliases<a class="headerlink" href="#id114" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_has_all</p></li>
</ul>
@@ -5539,8 +5602,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="id112">
-<h4>Arguments<a class="headerlink" href="#id112" title="Link to this
heading">¶</a></h4>
+<section id="id115">
+<h4>Arguments<a class="headerlink" href="#id115" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5548,8 +5611,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="id113">
-<h4>Aliases<a class="headerlink" href="#id113" title="Link to this
heading">¶</a></h4>
+<section id="id116">
+<h4>Aliases<a class="headerlink" href="#id116" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_has_any</p></li>
</ul>
@@ -5561,15 +5624,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="id114">
-<h4>Arguments<a class="headerlink" href="#id114" title="Link to this
heading">¶</a></h4>
+<section id="id117">
+<h4>Arguments<a class="headerlink" href="#id117" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id115">
-<h4>Example<a class="headerlink" href="#id115" title="Link to this
heading">¶</a></h4>
+<section id="id118">
+<h4>Example<a class="headerlink" href="#id118" 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])) |
@@ -5579,8 +5642,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="id119">
+<h4>Aliases<a class="headerlink" href="#id119" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_dims</p></li>
</ul>
@@ -5592,16 +5655,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="id117">
-<h4>Arguments<a class="headerlink" href="#id117" 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>
<li><p><strong>index</strong>: Index to extract the element from the
array.</p></li>
</ul>
</section>
-<section id="id118">
-<h4>Example<a class="headerlink" href="#id118" title="Link to this
heading">¶</a></h4>
+<section id="id121">
+<h4>Example<a class="headerlink" href="#id121" 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)) |
@@ -5611,8 +5674,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id119">
-<h4>Aliases<a class="headerlink" href="#id119" title="Link to this
heading">¶</a></h4>
+<section id="id122">
+<h4>Aliases<a class="headerlink" href="#id122" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_extract</p></li>
<li><p>list_element</p></li>
@@ -5631,8 +5694,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="id120">
-<h4>Arguments<a class="headerlink" href="#id120" title="Link to this
heading">¶</a></h4>
+<section id="id123">
+<h4>Arguments<a class="headerlink" href="#id123" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5648,8 +5711,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="id121">
-<h4>Arguments<a class="headerlink" href="#id121" title="Link to this
heading">¶</a></h4>
+<section id="id124">
+<h4>Arguments<a class="headerlink" href="#id124" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5673,16 +5736,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="id122">
-<h4>Arguments<a class="headerlink" href="#id122" 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>
<li><p><strong>dimension</strong>: Array dimension.</p></li>
</ul>
</section>
-<section id="id123">
-<h4>Example<a class="headerlink" href="#id123" 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_length([1, 2, 3, 4, 5]);
+---------------------------------+
| array_length(List([1,2,3,4,5])) |
@@ -5692,8 +5755,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id124">
-<h4>Aliases<a class="headerlink" href="#id124" title="Link to this
heading">¶</a></h4>
+<section id="id127">
+<h4>Aliases<a class="headerlink" href="#id127" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_length</p></li>
</ul>
@@ -5705,15 +5768,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="id125">
-<h4>Arguments<a class="headerlink" href="#id125" 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>
</ul>
</section>
-<section id="id126">
-<h4>Example<a class="headerlink" href="#id126" 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_ndims([[1, 2, 3], [4, 5,
6]]);
+----------------------------------+
| array_ndims(List([1,2,3,4,5,6])) |
@@ -5723,8 +5786,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id127">
-<h4>Aliases<a class="headerlink" href="#id127" title="Link to this
heading">¶</a></h4>
+<section id="id130">
+<h4>Aliases<a class="headerlink" href="#id130" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_ndims</p></li>
</ul>
@@ -5736,16 +5799,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="id128">
-<h4>Arguments<a class="headerlink" href="#id128" 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>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="id129">
-<h4>Example<a class="headerlink" href="#id129" title="Link to this
heading">¶</a></h4>
+<section id="id132">
+<h4>Example<a class="headerlink" href="#id132" 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])) |
@@ -5755,8 +5818,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id130">
-<h4>Aliases<a class="headerlink" href="#id130" title="Link to this
heading">¶</a></h4>
+<section id="id133">
+<h4>Aliases<a class="headerlink" href="#id133" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_push_front</p></li>
<li><p>list_prepend</p></li>
@@ -5770,15 +5833,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="id131">
-<h4>Arguments<a class="headerlink" href="#id131" title="Link to this
heading">¶</a></h4>
+<section id="id134">
+<h4>Arguments<a class="headerlink" href="#id134" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id132">
-<h4>Example<a class="headerlink" href="#id132" title="Link to this
heading">¶</a></h4>
+<section id="id135">
+<h4>Example<a class="headerlink" href="#id135" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_pop_front([1, 2, 3]);
+-------------------------------+
| array_pop_front(List([1,2,3])) |
@@ -5788,8 +5851,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id133">
-<h4>Aliases<a class="headerlink" href="#id133" title="Link to this
heading">¶</a></h4>
+<section id="id136">
+<h4>Aliases<a class="headerlink" href="#id136" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_pop_front</p></li>
</ul>
@@ -5801,15 +5864,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="id134">
-<h4>Arguments<a class="headerlink" href="#id134" title="Link to this
heading">¶</a></h4>
+<section id="id137">
+<h4>Arguments<a class="headerlink" href="#id137" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id135">
-<h4>Example<a class="headerlink" href="#id135" title="Link to this
heading">¶</a></h4>
+<section id="id138">
+<h4>Example<a class="headerlink" href="#id138" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_pop_back([1, 2, 3]);
+-------------------------------+
| array_pop_back(List([1,2,3])) |
@@ -5819,8 +5882,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id136">
-<h4>Aliases<a class="headerlink" href="#id136" title="Link to this
heading">¶</a></h4>
+<section id="id139">
+<h4>Aliases<a class="headerlink" href="#id139" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_pop_back</p></li>
</ul>
@@ -5833,8 +5896,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="id137">
-<h4>Arguments<a class="headerlink" href="#id137" title="Link to this
heading">¶</a></h4>
+<section id="id140">
+<h4>Arguments<a class="headerlink" href="#id140" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5842,8 +5905,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="id138">
-<h4>Example<a class="headerlink" href="#id138" title="Link to this
heading">¶</a></h4>
+<section id="id141">
+<h4>Example<a class="headerlink" href="#id141" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_position([1, 2, 2, 3, 1, 4],
2);
+----------------------------------------------+
| array_position(List([1,2,2,3,1,4]),Int64(2)) |
@@ -5853,8 +5916,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id139">
-<h4>Aliases<a class="headerlink" href="#id139" title="Link to this
heading">¶</a></h4>
+<section id="id142">
+<h4>Aliases<a class="headerlink" href="#id142" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_indexof</p></li>
<li><p>list_indexof</p></li>
@@ -5868,16 +5931,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="id140">
-<h4>Arguments<a class="headerlink" href="#id140" title="Link to this
heading">¶</a></h4>
+<section id="id143">
+<h4>Arguments<a class="headerlink" href="#id143" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
<li><p><strong>element</strong>: Element to search for positions in the
array.</p></li>
</ul>
</section>
-<section id="id141">
-<h4>Example<a class="headerlink" href="#id141" title="Link to this
heading">¶</a></h4>
+<section id="id144">
+<h4>Example<a class="headerlink" href="#id144" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_positions([1, 2, 2, 3, 1,
4], 2);
+-----------------------------------------------+
| array_positions(List([1,2,2,3,1,4]),Int64(2)) |
@@ -5887,8 +5950,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id142">
-<h4>Aliases<a class="headerlink" href="#id142" title="Link to this
heading">¶</a></h4>
+<section id="id145">
+<h4>Aliases<a class="headerlink" href="#id145" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_positions</p></li>
</ul>
@@ -5908,16 +5971,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="id143">
-<h4>Arguments<a class="headerlink" href="#id143" title="Link to this
heading">¶</a></h4>
+<section id="id146">
+<h4>Arguments<a class="headerlink" href="#id146" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>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="id144">
-<h4>Example<a class="headerlink" href="#id144" title="Link to this
heading">¶</a></h4>
+<section id="id147">
+<h4>Example<a class="headerlink" href="#id147" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_repeat(1, 3);
+---------------------------------+
| array_repeat(Int64(1),Int64(3)) |
@@ -5935,8 +5998,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id145">
-<h4>Aliases<a class="headerlink" href="#id145" title="Link to this
heading">¶</a></h4>
+<section id="id148">
+<h4>Aliases<a class="headerlink" href="#id148" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_repeat</p></li>
</ul>
@@ -5948,16 +6011,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="id146">
-<h4>Arguments<a class="headerlink" href="#id146" title="Link to this
heading">¶</a></h4>
+<section id="id149">
+<h4>Arguments<a class="headerlink" href="#id149" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
<li><p><strong>element</strong>: Element to be removed from the array.</p></li>
</ul>
</section>
-<section id="id147">
-<h4>Example<a class="headerlink" href="#id147" title="Link to this
heading">¶</a></h4>
+<section id="id150">
+<h4>Example<a class="headerlink" href="#id150" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_remove([1, 2, 2, 3, 2, 1,
4], 2);
+----------------------------------------------+
| array_remove(List([1,2,2,3,2,1,4]),Int64(2)) |
@@ -5967,8 +6030,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id148">
-<h4>Aliases<a class="headerlink" href="#id148" title="Link to this
heading">¶</a></h4>
+<section id="id151">
+<h4>Aliases<a class="headerlink" href="#id151" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove</p></li>
</ul>
@@ -5980,8 +6043,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="id149">
-<h4>Arguments<a class="headerlink" href="#id149" title="Link to this
heading">¶</a></h4>
+<section id="id152">
+<h4>Arguments<a class="headerlink" href="#id152" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5989,8 +6052,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="id150">
-<h4>Example<a class="headerlink" href="#id150" title="Link to this
heading">¶</a></h4>
+<section id="id153">
+<h4>Example<a class="headerlink" href="#id153" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_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)) |
@@ -6000,8 +6063,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id151">
-<h4>Aliases<a class="headerlink" href="#id151" title="Link to this
heading">¶</a></h4>
+<section id="id154">
+<h4>Aliases<a class="headerlink" href="#id154" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove_n</p></li>
</ul>
@@ -6013,16 +6076,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="id152">
-<h4>Arguments<a class="headerlink" href="#id152" title="Link to this
heading">¶</a></h4>
+<section id="id155">
+<h4>Arguments<a class="headerlink" href="#id155" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>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="id153">
-<h4>Example<a class="headerlink" href="#id153" title="Link to this
heading">¶</a></h4>
+<section id="id156">
+<h4>Example<a class="headerlink" href="#id156" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_remove_all([1, 2, 2, 3, 2,
1, 4], 2);
+--------------------------------------------------+
| array_remove_all(List([1,2,2,3,2,1,4]),Int64(2)) |
@@ -6032,8 +6095,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id154">
-<h4>Aliases<a class="headerlink" href="#id154" title="Link to this
heading">¶</a></h4>
+<section id="id157">
+<h4>Aliases<a class="headerlink" href="#id157" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_remove_all</p></li>
</ul>
@@ -6045,8 +6108,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="id155">
-<h4>Arguments<a class="headerlink" href="#id155" title="Link to this
heading">¶</a></h4>
+<section id="id158">
+<h4>Arguments<a class="headerlink" href="#id158" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -6054,8 +6117,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="id156">
-<h4>Example<a class="headerlink" href="#id156" title="Link to this
heading">¶</a></h4>
+<section id="id159">
+<h4>Example<a class="headerlink" href="#id159" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_replace([1, 2, 2, 3, 2, 1,
4], 2, 5);
+--------------------------------------------------------+
| array_replace(List([1,2,2,3,2,1,4]),Int64(2),Int64(5)) |
@@ -6065,8 +6128,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id157">
-<h4>Aliases<a class="headerlink" href="#id157" title="Link to this
heading">¶</a></h4>
+<section id="id160">
+<h4>Aliases<a class="headerlink" href="#id160" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace</p></li>
</ul>
@@ -6078,8 +6141,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="id158">
-<h4>Arguments<a class="headerlink" href="#id158" title="Link to this
heading">¶</a></h4>
+<section id="id161">
+<h4>Arguments<a class="headerlink" href="#id161" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -6088,8 +6151,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="id159">
-<h4>Example<a class="headerlink" href="#id159" title="Link to this
heading">¶</a></h4>
+<section id="id162">
+<h4>Example<a class="headerlink" href="#id162" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_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)) |
@@ -6099,8 +6162,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id160">
-<h4>Aliases<a class="headerlink" href="#id160" title="Link to this
heading">¶</a></h4>
+<section id="id163">
+<h4>Aliases<a class="headerlink" href="#id163" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace_n</p></li>
</ul>
@@ -6112,8 +6175,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="id161">
-<h4>Arguments<a class="headerlink" href="#id161" title="Link to this
heading">¶</a></h4>
+<section id="id164">
+<h4>Arguments<a class="headerlink" href="#id164" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -6121,8 +6184,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="id162">
-<h4>Example<a class="headerlink" href="#id162" title="Link to this
heading">¶</a></h4>
+<section id="id165">
+<h4>Example<a class="headerlink" href="#id165" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_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)) |
@@ -6132,8 +6195,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id163">
-<h4>Aliases<a class="headerlink" href="#id163" title="Link to this
heading">¶</a></h4>
+<section id="id166">
+<h4>Aliases<a class="headerlink" href="#id166" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_replace_all</p></li>
</ul>
@@ -6145,15 +6208,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="id164">
-<h4>Arguments<a class="headerlink" href="#id164" title="Link to this
heading">¶</a></h4>
+<section id="id167">
+<h4>Arguments<a class="headerlink" href="#id167" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id165">
-<h4>Example<a class="headerlink" href="#id165" title="Link to this
heading">¶</a></h4>
+<section id="id168">
+<h4>Example<a class="headerlink" href="#id168" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_reverse([1, 2, 3, 4]);
+------------------------------------------------------------+
| array_reverse(List([1, 2, 3, 4])) |
@@ -6163,8 +6226,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id166">
-<h4>Aliases<a class="headerlink" href="#id166" title="Link to this
heading">¶</a></h4>
+<section id="id169">
+<h4>Aliases<a class="headerlink" href="#id169" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_reverse</p></li>
</ul>
@@ -6176,8 +6239,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="id167">
-<h4>Arguments<a class="headerlink" href="#id167" title="Link to this
heading">¶</a></h4>
+<section id="id170">
+<h4>Arguments<a class="headerlink" href="#id170" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -6188,8 +6251,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="id168">
-<h4>Example<a class="headerlink" href="#id168" title="Link to this
heading">¶</a></h4>
+<section id="id171">
+<h4>Example<a class="headerlink" href="#id171" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_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)) |
@@ -6199,8 +6262,8 @@ If negative, it counts backward from the end of the
array.</p></li>
</pre></div>
</div>
</section>
-<section id="id169">
-<h4>Aliases<a class="headerlink" href="#id169" title="Link to this
heading">¶</a></h4>
+<section id="id172">
+<h4>Aliases<a class="headerlink" href="#id172" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_slice</p></li>
</ul>
@@ -6212,16 +6275,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="id170">
-<h4>Arguments<a class="headerlink" href="#id170" title="Link to this
heading">¶</a></h4>
+<section id="id173">
+<h4>Arguments<a class="headerlink" href="#id173" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
<li><p><strong>delimiter</strong>: Array element separator.</p></li>
</ul>
</section>
-<section id="id171">
-<h4>Example<a class="headerlink" href="#id171" title="Link to this
heading">¶</a></h4>
+<section id="id174">
+<h4>Example<a class="headerlink" href="#id174" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_to_string([[1, 2, 3, 4], [5,
6, 7, 8]], ',');
+----------------------------------------------------+
| array_to_string(List([1,2,3,4,5,6,7,8]),Utf8(",")) |
@@ -6231,8 +6294,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id172">
-<h4>Aliases<a class="headerlink" href="#id172" title="Link to this
heading">¶</a></h4>
+<section id="id175">
+<h4>Aliases<a class="headerlink" href="#id175" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_join</p></li>
<li><p>list_join</p></li>
@@ -6246,8 +6309,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="id173">
-<h4>Arguments<a class="headerlink" href="#id173" title="Link to this
heading">¶</a></h4>
+<section id="id176">
+<h4>Arguments<a class="headerlink" href="#id176" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array1</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -6255,8 +6318,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="id174">
-<h4>Example<a class="headerlink" href="#id174" title="Link to this
heading">¶</a></h4>
+<section id="id177">
+<h4>Example<a class="headerlink" href="#id177" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_union([1, 2, 3, 4], [5, 6,
3, 4]);
+----------------------------------------------------+
| array_union([1, 2, 3, 4], [5, 6, 3, 4]); |
@@ -6273,8 +6336,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</div>
</section>
<hr class="docutils" />
-<section id="id175">
-<h4>Aliases<a class="headerlink" href="#id175" title="Link to this
heading">¶</a></h4>
+<section id="id178">
+<h4>Aliases<a class="headerlink" href="#id178" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_union</p></li>
</ul>
@@ -6286,8 +6349,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="id176">
-<h4>Arguments<a class="headerlink" href="#id176" title="Link to this
heading">¶</a></h4>
+<section id="id179">
+<h4>Arguments<a class="headerlink" href="#id179" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array1</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -6295,8 +6358,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="id177">
-<h4>Example<a class="headerlink" href="#id177" title="Link to this
heading">¶</a></h4>
+<section id="id180">
+<h4>Example<a class="headerlink" href="#id180" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_except([1, 2, 3, 4], [5, 6,
3, 4]);
+----------------------------------------------------+
| array_except([1, 2, 3, 4], [5, 6, 3, 4]); |
@@ -6313,8 +6376,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</div>
</section>
<hr class="docutils" />
-<section id="id178">
-<h4>Aliases<a class="headerlink" href="#id178" title="Link to this
heading">¶</a></h4>
+<section id="id181">
+<h4>Aliases<a class="headerlink" href="#id181" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_except</p></li>
</ul>
@@ -6326,15 +6389,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="id179">
-<h4>Arguments<a class="headerlink" href="#id179" title="Link to this
heading">¶</a></h4>
+<section id="id182">
+<h4>Arguments<a class="headerlink" href="#id182" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id180">
-<h4>Example<a class="headerlink" href="#id180" title="Link to this
heading">¶</a></h4>
+<section id="id183">
+<h4>Example<a class="headerlink" href="#id183" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select cardinality([[1, 2, 3, 4], [5, 6,
7, 8]]);
+--------------------------------------+
| cardinality(List([1,2,3,4,5,6,7,8])) |
@@ -6351,15 +6414,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="id181">
-<h4>Arguments<a class="headerlink" href="#id181" 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>
</ul>
</section>
-<section id="id182">
-<h4>Example<a class="headerlink" href="#id182" 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 empty([1]);
+------------------+
| empty(List([1])) |
@@ -6500,16 +6563,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="id183">
-<h4>Arguments<a class="headerlink" href="#id183" title="Link to this
heading">¶</a></h4>
+<section id="id186">
+<h4>Arguments<a class="headerlink" href="#id186" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression_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="id184">
-<h4>Example<a class="headerlink" href="#id184" title="Link to this
heading">¶</a></h4>
+<section id="id187">
+<h4>Example<a class="headerlink" href="#id187" 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)) |
@@ -6519,8 +6582,8 @@ string operators.</p></li>
</pre></div>
</div>
</section>
-<section id="id185">
-<h4>Aliases<a class="headerlink" href="#id185" title="Link to this
heading">¶</a></h4>
+<section id="id188">
+<h4>Aliases<a class="headerlink" href="#id188" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>make_list</p></li>
</ul>
@@ -6536,16 +6599,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="id186">
-<h4>Arguments<a class="headerlink" href="#id186" title="Link to this
heading">¶</a></h4>
+<section id="id189">
+<h4>Arguments<a class="headerlink" href="#id189" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>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="id187">
-<h4>Aliases<a class="headerlink" href="#id187" title="Link to this
heading">¶</a></h4>
+<section id="id190">
+<h4>Aliases<a class="headerlink" href="#id190" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>string_to_list</p></li>
</ul>
@@ -6562,8 +6625,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="id188">
-<h4>Arguments<a class="headerlink" href="#id188" title="Link to this
heading">¶</a></h4>
+<section id="id191">
+<h4>Arguments<a class="headerlink" href="#id191" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -6576,8 +6639,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<p>Returns an Arrow array between start and stop with step. <code
class="docutils literal notranslate"><span class="pre">SELECT</span> <span
class="pre">range(2,</span> <span class="pre">10,</span> <span
class="pre">3)</span> <span class="pre">-></span> <span
class="pre">[2,</span> <span class="pre">5,</span> <span
class="pre">8]</span></code></p>
<p>The range start..end contains all values with start <= x < end. It is
empty if start >= end.</p>
<p>Step can not be 0 (then the range will be nonsense.).</p>
-<section id="id189">
-<h4>Arguments<a class="headerlink" href="#id189" title="Link to this
heading">¶</a></h4>
+<section id="id192">
+<h4>Arguments<a class="headerlink" href="#id192" 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>
@@ -6618,8 +6681,8 @@ a struct type of fields <code class="docutils literal
notranslate"><span class="
<span class="o">+-----------------+</span>
</pre></div>
</div>
-<section id="id190">
-<h4>Arguments<a class="headerlink" href="#id190" title="Link to this
heading">¶</a></h4>
+<section id="id193">
+<h4>Arguments<a class="headerlink" href="#id193" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression_n</strong>: Expression to include in the output
struct.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -6644,8 +6707,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="id191">
-<h4>Arguments<a class="headerlink" href="#id191" title="Link to this
heading">¶</a></h4>
+<section id="id194">
+<h4>Arguments<a class="headerlink" href="#id194" 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>
@@ -6671,8 +6734,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="id192">
-<h4>Arguments<a class="headerlink" href="#id192" title="Link to this
heading">¶</a></h4>
+<section id="id195">
+<h4>Arguments<a class="headerlink" href="#id195" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -6685,8 +6748,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="id193">
-<h4>Arguments<a class="headerlink" href="#id193" title="Link to this
heading">¶</a></h4>
+<section id="id196">
+<h4>Arguments<a class="headerlink" href="#id196" 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>
@@ -6699,8 +6762,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="id194">
-<h4>Arguments<a class="headerlink" href="#id194" title="Link to this
heading">¶</a></h4>
+<section id="id197">
+<h4>Arguments<a class="headerlink" href="#id197" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -6713,8 +6776,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="id195">
-<h4>Arguments<a class="headerlink" href="#id195" title="Link to this
heading">¶</a></h4>
+<section id="id198">
+<h4>Arguments<a class="headerlink" href="#id198" 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>
@@ -6727,8 +6790,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="id196">
-<h4>Arguments<a class="headerlink" href="#id196" 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</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -6748,8 +6811,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="id197">
-<h4>Arguments<a class="headerlink" href="#id197" title="Link to this
heading">¶</a></h4>
+<section id="id200">
+<h4>Arguments<a class="headerlink" href="#id200" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to cast.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -6758,8 +6821,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="id198">
-<h4>Example<a class="headerlink" href="#id198" title="Link to this
heading">¶</a></h4>
+<section id="id201">
+<h4>Example<a class="headerlink" href="#id201" 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,
@@ -6781,16 +6844,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="id199">
-<h4>Arguments<a class="headerlink" href="#id199" title="Link to this
heading">¶</a></h4>
+<section id="id202">
+<h4>Arguments<a class="headerlink" href="#id202" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>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="id200">
-<h4>Example<a class="headerlink" href="#id200" title="Link to this
heading">¶</a></h4>
+<section id="id203">
+<h4>Example<a class="headerlink" href="#id203" 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)) |
