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/datafusion.git
The following commit(s) were added to refs/heads/asf-site by this push:
new edf8487635 Publish built docs triggered by
a59a98090e3de6d8a3fc6bdce0bc0b5dadac9311
edf8487635 is described below
commit edf848763529953c313906857e7ddb442c3fb411
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Tue May 21 19:27:37 2024 +0000
Publish built docs triggered by a59a98090e3de6d8a3fc6bdce0bc0b5dadac9311
---
_sources/user-guide/sql/scalar_functions.md.txt | 46 ++
searchindex.js | 2 +-
user-guide/sql/scalar_functions.html | 826 +++++++++++++-----------
3 files changed, 492 insertions(+), 382 deletions(-)
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index 624e86db35..f0feb9ec21 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -1457,6 +1457,7 @@ position(substr in origstr)
- [today](#today)
- [make_date](#make_date)
- [to_char](#to_char)
+- [to_date](#to_date)
- [to_timestamp](#to_timestamp)
- [to_timestamp_millis](#to_timestamp_millis)
- [to_timestamp_micros](#to_timestamp_micros)
@@ -1702,6 +1703,51 @@ Additional examples can be found [here]
- date_format
+### `to_date`
+
+Converts a value to a date (`YYYY-MM-DD`).
+Supports strings, integer and double types as input.
+Strings are parsed as YYYY-MM-DD (e.g. '2023-07-20') if no [Chrono format]s
are provided.
+Integers and doubles are interpreted as days since the unix epoch
(`1970-01-01T00:00:00Z`).
+Returns the corresponding date.
+
+Note: `to_date` returns Date32. The supported range for integer input is
between `-96465293` and `95026237`.
+Supported range for string input is between `1677-09-21` and `2262-04-11`
exclusive. To parse dates outside of
+that range use a [Chrono format].
+
+```
+to_date(expression[, ..., format_n])
+```
+
+#### Arguments
+
+- **expression**: Expression to operate on.
+ Can be a constant, column, or function, and any combination of arithmetic
operators.
+- **format_n**: Optional [Chrono format] 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.
+
+[chrono format]:
https://docs.rs/chrono/latest/chrono/format/strftime/index.html
+
+#### Example
+
+```
+> select to_date('2023-01-31');
++-----------------------------+
+| to_date(Utf8("2023-01-31")) |
++-----------------------------+
+| 2023-01-31 |
++-----------------------------+
+> select to_date('2023/01/31', '%Y-%m-%d', '%Y/%m/%d');
++---------------------------------------------------------------+
+| to_date(Utf8("2023/01/31"),Utf8("%Y-%m-%d"),Utf8("%Y/%m/%d")) |
++---------------------------------------------------------------+
+| 2023-01-31 |
++---------------------------------------------------------------+
+```
+
+Additional examples can be found
[here](https://github.com/apache/datafusion/blob/main/datafusion-examples/examples/to_date.rs)
+
### `to_timestamp`
Converts a value to a timestamp (`YYYY-MM-DDT00:00:00Z`).
diff --git a/searchindex.js b/searchindex.js
index 1bb7aa4c67..57300bfd61 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"!=": [[42, "op-neq"]], "!~": [[42,
"op-re-not-match"]], "!~*": [[42, "op-re-not-match-i"]], "!~~": [[42, "id18"]],
"!~~*": [[42, "id19"]], "#": [[42, "op-bit-xor"]], "%": [[42, "op-modulo"]],
"&": [[42, "op-bit-and"]], "(relation, name) tuples in logical fields and
logical columns are unique": [[9,
"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]], "*":
[[42, "op-multiply"]], "+": [[42, "op-plus"]], "-": [[42, "op-minus"]], "/":
[[4 [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"!=": [[42, "op-neq"]], "!~": [[42,
"op-re-not-match"]], "!~*": [[42, "op-re-not-match-i"]], "!~~": [[42, "id18"]],
"!~~*": [[42, "id19"]], "#": [[42, "op-bit-xor"]], "%": [[42, "op-modulo"]],
"&": [[42, "op-bit-and"]], "(relation, name) tuples in logical fields and
logical columns are unique": [[9,
"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]], "*":
[[42, "op-multiply"]], "+": [[42, "op-plus"]], "-": [[42, "op-minus"]], "/":
[[4 [...]
\ No newline at end of file
diff --git a/user-guide/sql/scalar_functions.html
b/user-guide/sql/scalar_functions.html
index 902a87e72f..78b2dfdfbd 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -2009,10 +2009,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-date">
<code class="docutils literal notranslate">
<span class="pre">
- to_timestamp
+ to_date
</span>
</code>
</a>
@@ -2030,10 +2030,10 @@
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#to-timestamp-millis">
+ <a class="reference internal nav-link" href="#to-timestamp">
<code class="docutils literal notranslate">
<span class="pre">
- to_timestamp_millis
+ to_timestamp
</span>
</code>
</a>
@@ -2051,10 +2051,10 @@
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#to-timestamp-micros">
+ <a class="reference internal nav-link" href="#to-timestamp-millis">
<code class="docutils literal notranslate">
<span class="pre">
- to_timestamp_micros
+ to_timestamp_millis
</span>
</code>
</a>
@@ -2072,10 +2072,10 @@
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#to-timestamp-nanos">
+ <a class="reference internal nav-link" href="#to-timestamp-micros">
<code class="docutils literal notranslate">
<span class="pre">
- to_timestamp_nanos
+ to_timestamp_micros
</span>
</code>
</a>
@@ -2093,10 +2093,10 @@
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#to-timestamp-seconds">
+ <a class="reference internal nav-link" href="#to-timestamp-nanos">
<code class="docutils literal notranslate">
<span class="pre">
- to_timestamp_seconds
+ to_timestamp_nanos
</span>
</code>
</a>
@@ -2113,6 +2113,27 @@
</li>
</ul>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#to-timestamp-seconds">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ to_timestamp_seconds
+ </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="#id102">
+ Arguments
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id103">
+ Example
+ </a>
+ </li>
+ </ul>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#from-unixtime">
<code class="docutils literal notranslate">
@@ -2123,7 +2144,7 @@
</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="#id104">
Arguments
</a>
</li>
@@ -2146,17 +2167,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id103">
+ <a class="reference internal nav-link" href="#id105">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id104">
+ <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="#id105">
+ <a class="reference internal nav-link" href="#id107">
Aliases
</a>
</li>
@@ -2172,17 +2193,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id106">
+ <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="#id107">
+ <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="#id108">
+ <a class="reference internal nav-link" href="#id110">
Aliases
</a>
</li>
@@ -2198,17 +2219,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id109">
+ <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="#id110">
+ <a class="reference internal nav-link" href="#id112">
Example
</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="#id113">
Aliases
</a>
</li>
@@ -2233,17 +2254,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id112">
+ <a class="reference internal nav-link" href="#id114">
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="#id115">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id114">
+ <a class="reference internal nav-link" href="#id116">
Aliases
</a>
</li>
@@ -2268,12 +2289,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id115">
+ <a class="reference internal nav-link" href="#id117">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id116">
+ <a class="reference internal nav-link" href="#id118">
Aliases
</a>
</li>
@@ -2289,12 +2310,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id117">
+ <a class="reference internal nav-link" href="#id119">
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="#id120">
Aliases
</a>
</li>
@@ -2310,12 +2331,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id119">
+ <a class="reference internal nav-link" href="#id121">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id120">
+ <a class="reference internal nav-link" href="#id122">
Aliases
</a>
</li>
@@ -2331,17 +2352,17 @@
</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="#id123">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id122">
+ <a class="reference internal nav-link" href="#id124">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id123">
+ <a class="reference internal nav-link" href="#id125">
Aliases
</a>
</li>
@@ -2357,17 +2378,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id124">
+ <a class="reference internal nav-link" href="#id126">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id125">
+ <a class="reference internal nav-link" href="#id127">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id126">
+ <a class="reference internal nav-link" href="#id128">
Aliases
</a>
</li>
@@ -2383,17 +2404,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id127">
+ <a class="reference internal nav-link" href="#id129">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id128">
+ <a class="reference internal nav-link" href="#id130">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id129">
+ <a class="reference internal nav-link" href="#id131">
Aliases
</a>
</li>
@@ -2418,7 +2439,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id130">
+ <a class="reference internal nav-link" href="#id132">
Arguments
</a>
</li>
@@ -2434,7 +2455,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id131">
+ <a class="reference internal nav-link" href="#id133">
Arguments
</a>
</li>
@@ -2459,17 +2480,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id132">
+ <a class="reference internal nav-link" href="#id134">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id133">
+ <a class="reference internal nav-link" href="#id135">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id134">
+ <a class="reference internal nav-link" href="#id136">
Aliases
</a>
</li>
@@ -2494,17 +2515,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id135">
+ <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="#id136">
+ <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="#id137">
+ <a class="reference internal nav-link" href="#id139">
Aliases
</a>
</li>
@@ -2520,17 +2541,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id138">
+ <a class="reference internal nav-link" href="#id140">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id139">
+ <a class="reference internal nav-link" href="#id141">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id140">
+ <a class="reference internal nav-link" href="#id142">
Aliases
</a>
</li>
@@ -2546,17 +2567,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id141">
+ <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="#id142">
+ <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="#id143">
+ <a class="reference internal nav-link" href="#id145">
Aliases
</a>
</li>
@@ -2572,17 +2593,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id144">
+ <a class="reference internal nav-link" href="#id146">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id145">
+ <a class="reference internal nav-link" href="#id147">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id146">
+ <a class="reference internal nav-link" href="#id148">
Aliases
</a>
</li>
@@ -2598,17 +2619,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id147">
+ <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="#id148">
+ <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="#id149">
+ <a class="reference internal nav-link" href="#id151">
Aliases
</a>
</li>
@@ -2624,17 +2645,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id150">
+ <a class="reference internal nav-link" href="#id152">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id151">
+ <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="#id152">
+ <a class="reference internal nav-link" href="#id154">
Aliases
</a>
</li>
@@ -2650,17 +2671,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id153">
+ <a class="reference internal nav-link" href="#id155">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id154">
+ <a class="reference internal nav-link" href="#id156">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id155">
+ <a class="reference internal nav-link" href="#id157">
Aliases
</a>
</li>
@@ -2694,17 +2715,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id156">
+ <a class="reference internal nav-link" href="#id158">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id157">
+ <a class="reference internal nav-link" href="#id159">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id158">
+ <a class="reference internal nav-link" href="#id160">
Aliases
</a>
</li>
@@ -2720,17 +2741,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id159">
+ <a class="reference internal nav-link" href="#id161">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id160">
+ <a class="reference internal nav-link" href="#id162">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id161">
+ <a class="reference internal nav-link" href="#id163">
Aliases
</a>
</li>
@@ -2746,17 +2767,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id162">
+ <a class="reference internal nav-link" href="#id164">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id163">
+ <a class="reference internal nav-link" href="#id165">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id164">
+ <a class="reference internal nav-link" href="#id166">
Aliases
</a>
</li>
@@ -2772,17 +2793,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id165">
+ <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="#id166">
+ <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="#id167">
+ <a class="reference internal nav-link" href="#id169">
Aliases
</a>
</li>
@@ -2798,17 +2819,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id168">
+ <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="#id169">
+ <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="#id170">
+ <a class="reference internal nav-link" href="#id172">
Aliases
</a>
</li>
@@ -2824,17 +2845,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id171">
+ <a class="reference internal nav-link" href="#id173">
Arguments
</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="#id174">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id173">
+ <a class="reference internal nav-link" href="#id175">
Aliases
</a>
</li>
@@ -2850,17 +2871,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id174">
+ <a class="reference internal nav-link" href="#id176">
Arguments
</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="#id177">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id176">
+ <a class="reference internal nav-link" href="#id178">
Aliases
</a>
</li>
@@ -2876,17 +2897,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id177">
+ <a class="reference internal nav-link" href="#id179">
Arguments
</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="#id180">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id179">
+ <a class="reference internal nav-link" href="#id181">
Aliases
</a>
</li>
@@ -2902,17 +2923,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id180">
+ <a class="reference internal nav-link" href="#id182">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id181">
+ <a class="reference internal nav-link" href="#id183">
Example
</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="#id184">
Aliases
</a>
</li>
@@ -2928,17 +2949,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="#id185">
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="#id186">
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="#id187">
Aliases
</a>
</li>
@@ -2954,17 +2975,17 @@
</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="#id188">
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="#id189">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id188">
+ <a class="reference internal nav-link" href="#id190">
Aliases
</a>
</li>
@@ -2980,17 +3001,17 @@
</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="#id191">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id190">
+ <a class="reference internal nav-link" href="#id192">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id191">
+ <a class="reference internal nav-link" href="#id193">
Aliases
</a>
</li>
@@ -3006,12 +3027,12 @@
</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="#id194">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id193">
+ <a class="reference internal nav-link" href="#id195">
Example
</a>
</li>
@@ -3027,17 +3048,17 @@
</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="#id196">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id195">
+ <a class="reference internal nav-link" href="#id197">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id196">
+ <a class="reference internal nav-link" href="#id198">
Aliases
</a>
</li>
@@ -3053,12 +3074,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="#id199">
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="#id200">
Example
</a>
</li>
@@ -3416,17 +3437,17 @@
</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="#id201">
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="#id202">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id201">
+ <a class="reference internal nav-link" href="#id203">
Aliases
</a>
</li>
@@ -3451,12 +3472,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id202">
+ <a class="reference internal nav-link" href="#id204">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id203">
+ <a class="reference internal nav-link" href="#id205">
Aliases
</a>
</li>
@@ -3481,7 +3502,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id204">
+ <a class="reference internal nav-link" href="#id206">
Arguments
</a>
</li>
@@ -3497,12 +3518,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id205">
+ <a class="reference internal nav-link" href="#id207">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id206">
+ <a class="reference internal nav-link" href="#id208">
Aliases
</a>
</li>
@@ -3525,7 +3546,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id207">
+ <a class="reference internal nav-link" href="#id209">
Arguments
</a>
</li>
@@ -3541,7 +3562,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id208">
+ <a class="reference internal nav-link" href="#id210">
Arguments
</a>
</li>
@@ -3564,7 +3585,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id209">
+ <a class="reference internal nav-link" href="#id211">
Arguments
</a>
</li>
@@ -3580,7 +3601,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id210">
+ <a class="reference internal nav-link" href="#id212">
Arguments
</a>
</li>
@@ -3596,7 +3617,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id211">
+ <a class="reference internal nav-link" href="#id213">
Arguments
</a>
</li>
@@ -3612,7 +3633,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id212">
+ <a class="reference internal nav-link" href="#id214">
Arguments
</a>
</li>
@@ -3628,7 +3649,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id213">
+ <a class="reference internal nav-link" href="#id215">
Arguments
</a>
</li>
@@ -3644,7 +3665,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id214">
+ <a class="reference internal nav-link" href="#id216">
Arguments
</a>
</li>
@@ -3667,12 +3688,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id215">
+ <a class="reference internal nav-link" href="#id217">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id216">
+ <a class="reference internal nav-link" href="#id218">
Example
</a>
</li>
@@ -3688,12 +3709,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id217">
+ <a class="reference internal nav-link" href="#id219">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id218">
+ <a class="reference internal nav-link" href="#id220">
Example
</a>
</li>
@@ -5258,6 +5279,7 @@ not appear in <code class="docutils literal
notranslate"><span class="pre">origs
<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-date">to_date</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>
@@ -5503,6 +5525,48 @@ date, time, timestamp or duration.</p></li>
</ul>
</section>
</section>
+<section id="to-date">
+<h3><code class="docutils literal notranslate"><span
class="pre">to_date</span></code><a class="headerlink" href="#to-date"
title="Link to this heading">¶</a></h3>
+<p>Converts a value to a date (<code class="docutils literal
notranslate"><span class="pre">YYYY-MM-DD</span></code>).
+Supports strings, integer and double types as input.
+Strings are parsed as YYYY-MM-DD (e.g. ‘2023-07-20’) if no <a class="reference
external"
href="https://docs.rs/chrono/latest/chrono/format/strftime/index.html";>Chrono
format</a>s are provided.
+Integers and doubles are interpreted as days since the unix epoch (<code
class="docutils literal notranslate"><span
class="pre">1970-01-01T00:00:00Z</span></code>).
+Returns the corresponding date.</p>
+<p>Note: <code class="docutils literal notranslate"><span
class="pre">to_date</span></code> returns Date32. The supported range for
integer input is between <code class="docutils literal notranslate"><span
class="pre">-96465293</span></code> and <code class="docutils literal
notranslate"><span class="pre">95026237</span></code>.
+Supported range for string input is between <code class="docutils literal
notranslate"><span class="pre">1677-09-21</span></code> and <code
class="docutils literal notranslate"><span class="pre">2262-04-11</span></code>
exclusive. To parse dates outside of
+that range use a <a class="reference external"
href="https://docs.rs/chrono/latest/chrono/format/strftime/index.html";>Chrono
format</a>.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">to_date</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>
+<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="id93">
+<h4>Example<a class="headerlink" href="#id93" title="Link to this
heading">¶</a></h4>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">to_date</span><span
class="p">(</span><span class="s1">'2023-01-31'</span><span
class="p">);</span>
+<span class="o">+-----------------------------+</span>
+<span class="o">|</span> <span class="n">to_date</span><span
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"2023-01-31"</span><span class="p">))</span> <span
class="o">|</span>
+<span class="o">+-----------------------------+</span>
+<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">01</span><span class="o">-</span><span
class="mi">31</span> <span class="o">|</span>
+<span class="o">+-----------------------------+</span>
+<span class="o">></span> <span class="n">select</span> <span
class="n">to_date</span><span class="p">(</span><span
class="s1">'2023/01/31'</span><span class="p">,</span> <span
class="s1">'%Y-%m-</span><span class="si">%d</span><span
class="s1">'</span><span class="p">,</span> <span
class="s1">'%Y/%m/</span><span class="si">%d</span><span
class="s1">'</span><span class="p">);</span>
+<span
class="o">+---------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">to_date</span><span
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"2023/01/31"</span><span class="p">),</span><span
class="n">Utf8</span><span class="p">(</span><span
class="s2">"%Y-%m-</span><span class="si">%d</span><span
class="s2">"</span><span class="p">),</span><span
class="n">Utf8</span><span class="p">(</span><span
class="s2">"%Y/%m/</span><span class="si">%d</span><span clas [...]
+<span
class="o">+---------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">01</span><span class="o">-</span><span
class="mi">31</span> <span
class="o">|</span>
+<span
class="o">+---------------------------------------------------------------+</span>
+</pre></div>
+</div>
+<p>Additional examples can be found <a class="reference external"
href="https://github.com/apache/datafusion/blob/main/datafusion-examples/examples/to_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>).
@@ -5516,8 +5580,8 @@ for the input outside of supported bounds.</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">to_timestamp</span><span
class="p">(</span><span class="n">expression</span><span class="p">[,</span>
<span class="o">...</span><span class="p">,</span> <span
class="n">format_n</span><span class="p">])</span>
</pre></div>
</div>
-<section id="id92">
-<h4>Arguments<a class="headerlink" href="#id92" title="Link to this
heading">¶</a></h4>
+<section id="id94">
+<h4>Arguments<a class="headerlink" href="#id94" 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>
@@ -5526,8 +5590,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="id95">
+<h4>Example<a class="headerlink" href="#id95" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">to_timestamp</span><span
class="p">(</span><span
class="s1">'2023-01-31T09:26:56.123456789-05:00'</span><span
class="p">);</span>
<span
class="o">+-----------------------------------------------------------+</span>
<span class="o">|</span> <span class="n">to_timestamp</span><span
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"2023-01-31T09:26:56.123456789-05:00"</span><span
class="p">))</span> <span class="o">|</span>
@@ -5555,8 +5619,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="id94">
-<h4>Arguments<a class="headerlink" href="#id94" title="Link to this
heading">¶</a></h4>
+<section id="id96">
+<h4>Arguments<a class="headerlink" href="#id96" 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>
@@ -5565,8 +5629,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="id97">
+<h4>Example<a class="headerlink" href="#id97" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">to_timestamp_millis</span><span
class="p">(</span><span
class="s1">'2023-01-31T09:26:56.123456789-05:00'</span><span
class="p">);</span>
<span
class="o">+------------------------------------------------------------------+</span>
<span class="o">|</span> <span class="n">to_timestamp_millis</span><span
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"2023-01-31T09:26:56.123456789-05:00"</span><span
class="p">))</span> <span class="o">|</span>
@@ -5594,8 +5658,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="id96">
-<h4>Arguments<a class="headerlink" href="#id96" title="Link to this
heading">¶</a></h4>
+<section id="id98">
+<h4>Arguments<a class="headerlink" href="#id98" 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>
@@ -5604,8 +5668,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="id99">
+<h4>Example<a class="headerlink" href="#id99" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">to_timestamp_micros</span><span
class="p">(</span><span
class="s1">'2023-01-31T09:26:56.123456789-05:00'</span><span
class="p">);</span>
<span
class="o">+------------------------------------------------------------------+</span>
<span class="o">|</span> <span class="n">to_timestamp_micros</span><span
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"2023-01-31T09:26:56.123456789-05:00"</span><span
class="p">))</span> <span class="o">|</span>
@@ -5633,8 +5697,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="id98">
-<h4>Arguments<a class="headerlink" href="#id98" title="Link to this
heading">¶</a></h4>
+<section id="id100">
+<h4>Arguments<a class="headerlink" href="#id100" 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>
@@ -5643,8 +5707,8 @@ they appear with the first successful one being returned.
If none of the formats
an error will be returned.</p></li>
</ul>
</section>
-<section id="id99">
-<h4>Example<a class="headerlink" href="#id99" title="Link to this
heading">¶</a></h4>
+<section id="id101">
+<h4>Example<a class="headerlink" href="#id101" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">to_timestamp_nanos</span><span
class="p">(</span><span
class="s1">'2023-01-31T09:26:56.123456789-05:00'</span><span
class="p">);</span>
<span
class="o">+-----------------------------------------------------------------+</span>
<span class="o">|</span> <span class="n">to_timestamp_nanos</span><span
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"2023-01-31T09:26:56.123456789-05:00"</span><span
class="p">))</span> <span class="o">|</span>
@@ -5672,8 +5736,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="id100">
-<h4>Arguments<a class="headerlink" href="#id100" 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>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -5682,8 +5746,8 @@ they appear with the first successful one being returned.
If none of the formats
an error will be returned.</p></li>
</ul>
</section>
-<section id="id101">
-<h4>Example<a class="headerlink" href="#id101" title="Link to this
heading">¶</a></h4>
+<section id="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><span class="o">></span> <span
class="n">select</span> <span class="n">to_timestamp_seconds</span><span
class="p">(</span><span
class="s1">'2023-01-31T09:26:56.123456789-05:00'</span><span
class="p">);</span>
<span
class="o">+-------------------------------------------------------------------+</span>
<span class="o">|</span> <span class="n">to_timestamp_seconds</span><span
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"2023-01-31T09:26:56.123456789-05:00"</span><span
class="p">))</span> <span class="o">|</span>
@@ -5709,8 +5773,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="id102">
-<h4>Arguments<a class="headerlink" href="#id102" title="Link to this
heading">¶</a></h4>
+<section id="id104">
+<h4>Arguments<a class="headerlink" href="#id104" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to operate on.
Can be a constant, column, or function, and any combination of arithmetic
operators.</p></li>
@@ -5812,16 +5876,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="id103">
-<h4>Arguments<a class="headerlink" href="#id103" title="Link to this
heading">¶</a></h4>
+<section id="id105">
+<h4>Arguments<a class="headerlink" href="#id105" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
<li><p><strong>element</strong>: Element to append to the array.</p></li>
</ul>
</section>
-<section id="id104">
-<h4>Example<a class="headerlink" href="#id104" 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><span class="o">></span> <span
class="n">select</span> <span class="n">array_append</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">],</span> <span class="mi">4</span><span class="p">);</span>
<span class="o">+--------------------------------------+</span>
<span class="o">|</span> <span class="n">array_append</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">3</span><span class="p">]),</span><span
class="n">Int64</span><span class="p">(</span><span class="mi">4</span><span
class="p">))</span> <span class="o">|</span>
@@ -5831,8 +5895,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id105">
-<h4>Aliases<a class="headerlink" href="#id105" 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>array_push_back</p></li>
<li><p>list_append</p></li>
@@ -5846,8 +5910,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="id106">
-<h4>Arguments<a class="headerlink" href="#id106" 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.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -5855,8 +5919,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="id107">
-<h4>Example<a class="headerlink" href="#id107" 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><span class="o">></span> <span
class="n">select</span> <span class="n">array_sort</span><span
class="p">([</span><span class="mi">3</span><span class="p">,</span> <span
class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span
class="p">]);</span>
<span class="o">+-----------------------------+</span>
<span class="o">|</span> <span class="n">array_sort</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">3</span><span class="p">,</span><span class="mi">1</span><span
class="p">,</span><span class="mi">2</span><span class="p">]))</span> <span
class="o">|</span>
@@ -5866,8 +5930,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id108">
-<h4>Aliases<a class="headerlink" href="#id108" 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>list_sort</p></li>
</ul>
@@ -5879,8 +5943,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_resize</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">size</span><span class="p">,</span> <span class="n">value</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id109">
-<h4>Arguments<a class="headerlink" href="#id109" 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>
@@ -5888,8 +5952,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<li><p><strong>value</strong>: Defines new elements’ value or empty if value
is not set.</p></li>
</ul>
</section>
-<section id="id110">
-<h4>Example<a class="headerlink" href="#id110" title="Link to this
heading">¶</a></h4>
+<section id="id112">
+<h4>Example<a class="headerlink" href="#id112" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_resize</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">],</span> <span class="mi">5</span><span class="p">,</span> <span
class="mi">0</span><span class="p">);</span>
<span class="o">+-------------------------------------+</span>
<span class="o">|</span> <span class="n">array_resize</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">3</span><span class="p">],</span><span
class="mi">5</span><span class="p">,</span><span class="mi">0</span><span
class="p">))</span> <span class="o">|</span>
@@ -5899,8 +5963,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id111">
-<h4>Aliases<a class="headerlink" href="#id111" title="Link to this
heading">¶</a></h4>
+<section id="id113">
+<h4>Aliases<a class="headerlink" href="#id113" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_resize</p></li>
</ul>
@@ -5916,16 +5980,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="id112">
-<h4>Arguments<a class="headerlink" href="#id112" title="Link to this
heading">¶</a></h4>
+<section id="id114">
+<h4>Arguments<a class="headerlink" href="#id114" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression 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="id113">
-<h4>Example<a class="headerlink" href="#id113" title="Link to this
heading">¶</a></h4>
+<section id="id115">
+<h4>Example<a class="headerlink" href="#id115" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_concat</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">],</span> <span class="p">[</span><span
class="mi">3</span><span class="p">,</span> <span class="mi">4</span><span
class="p">],</span> <span class="p">[</span><span class="mi">5</span><span
class="p" [...]
<span class="o">+---------------------------------------------------+</span>
<span class="o">|</span> <span class="n">array_concat</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">]),</span><span class="n">List</span><span class="p">([</span><span
class="mi">3</span><span class="p">,</span><span class="mi">4</span><span
class="p">]),</span><span class="n">List</span><span class="p">([</span><span
class="mi">5</span><span class="p">,</span><sp [...]
@@ -5935,8 +5999,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id114">
-<h4>Aliases<a class="headerlink" href="#id114" title="Link to this
heading">¶</a></h4>
+<section id="id116">
+<h4>Aliases<a class="headerlink" href="#id116" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_cat</p></li>
<li><p>list_cat</p></li>
@@ -5954,8 +6018,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="id115">
-<h4>Arguments<a class="headerlink" href="#id115" 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>
@@ -5963,8 +6027,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="id116">
-<h4>Aliases<a class="headerlink" href="#id116" title="Link to this
heading">¶</a></h4>
+<section id="id118">
+<h4>Aliases<a class="headerlink" href="#id118" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_has</p></li>
</ul>
@@ -5976,8 +6040,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="id117">
-<h4>Arguments<a class="headerlink" href="#id117" title="Link to this
heading">¶</a></h4>
+<section id="id119">
+<h4>Arguments<a class="headerlink" href="#id119" 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>
@@ -5985,8 +6049,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id118">
-<h4>Aliases<a class="headerlink" href="#id118" title="Link to this
heading">¶</a></h4>
+<section id="id120">
+<h4>Aliases<a class="headerlink" href="#id120" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_has_all</p></li>
</ul>
@@ -5998,8 +6062,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="id119">
-<h4>Arguments<a class="headerlink" href="#id119" title="Link to this
heading">¶</a></h4>
+<section id="id121">
+<h4>Arguments<a class="headerlink" href="#id121" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -6007,8 +6071,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id120">
-<h4>Aliases<a class="headerlink" href="#id120" title="Link to this
heading">¶</a></h4>
+<section id="id122">
+<h4>Aliases<a class="headerlink" href="#id122" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_has_any</p></li>
</ul>
@@ -6020,15 +6084,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="id121">
-<h4>Arguments<a class="headerlink" href="#id121" 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>
</ul>
</section>
-<section id="id122">
-<h4>Example<a class="headerlink" href="#id122" title="Link to this
heading">¶</a></h4>
+<section id="id124">
+<h4>Example<a class="headerlink" href="#id124" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_dims</span><span
class="p">([[</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">],</span> <span class="p">[</span><span class="mi">4</span><span
class="p">,</span> <span class="mi">5</span><span class="p">,</span> <span
class="mi" [...]
<span class="o">+---------------------------------+</span>
<span class="o">|</span> <span class="n">array_dims</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">3</span><span class="p">,</span><span
class="mi">4</span><span class="p">,</span><span class="mi">5</span><span
class="p">,</span><span class="mi">6</span><span class="p">]))</span> <span
class="o">|</span>
@@ -6038,8 +6102,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id123">
-<h4>Aliases<a class="headerlink" href="#id123" title="Link to this
heading">¶</a></h4>
+<section id="id125">
+<h4>Aliases<a class="headerlink" href="#id125" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_dims</p></li>
</ul>
@@ -6051,15 +6115,15 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_distinct</span><span
class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id124">
-<h4>Arguments<a class="headerlink" href="#id124" title="Link to this
heading">¶</a></h4>
+<section id="id126">
+<h4>Arguments<a class="headerlink" href="#id126" 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="id125">
-<h4>Example<a class="headerlink" href="#id125" title="Link to this
heading">¶</a></h4>
+<section id="id127">
+<h4>Example<a class="headerlink" href="#id127" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_distinct</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">3</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span
class=" [...]
<span class="o">+---------------------------------+</span>
<span class="o">|</span> <span class="n">array_distinct</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">3</span><span class="p">,</span><span
class="mi">4</span><span class="p">]))</span> <span class="o">|</span>
@@ -6069,8 +6133,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id126">
-<h4>Aliases<a class="headerlink" href="#id126" title="Link to this
heading">¶</a></h4>
+<section id="id128">
+<h4>Aliases<a class="headerlink" href="#id128" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_distinct</p></li>
</ul>
@@ -6082,16 +6146,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="id127">
-<h4>Arguments<a class="headerlink" href="#id127" title="Link to this
heading">¶</a></h4>
+<section id="id129">
+<h4>Arguments<a class="headerlink" href="#id129" 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="id128">
-<h4>Example<a class="headerlink" href="#id128" title="Link to this
heading">¶</a></h4>
+<section id="id130">
+<h4>Example<a class="headerlink" href="#id130" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_element</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">],</span> <span
class="mi">3</span><span class="p">);</span>
<span class="o">+-----------------------------------------+</span>
<span class="o">|</span> <span class="n">array_element</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">3</span><span class="p">,</span><span
class="mi">4</span><span class="p">]),</span><span class="n">Int64</span><span
class="p">(</span><span class="mi">3</span><span class="p">))</span> <span
class="o">|</span>
@@ -6101,8 +6165,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id129">
-<h4>Aliases<a class="headerlink" href="#id129" title="Link to this
heading">¶</a></h4>
+<section id="id131">
+<h4>Aliases<a class="headerlink" href="#id131" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_extract</p></li>
<li><p>list_element</p></li>
@@ -6121,8 +6185,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="id130">
-<h4>Arguments<a class="headerlink" href="#id130" title="Link to this
heading">¶</a></h4>
+<section id="id132">
+<h4>Arguments<a class="headerlink" href="#id132" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -6138,8 +6202,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="id131">
-<h4>Arguments<a class="headerlink" href="#id131" title="Link to this
heading">¶</a></h4>
+<section id="id133">
+<h4>Arguments<a class="headerlink" href="#id133" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -6159,8 +6223,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_intersect</span><span
class="p">(</span><span class="n">array1</span><span class="p">,</span> <span
class="n">array2</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id132">
-<h4>Arguments<a class="headerlink" href="#id132" 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>array1</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -6168,8 +6232,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="id133">
-<h4>Example<a class="headerlink" href="#id133" 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><span class="o">></span> <span
class="n">select</span> <span class="n">array_intersect</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">],</span> <span
class="p">[</span><span class="mi">5</span><span class="p">,</span> <span
class= [...]
<span class="o">+----------------------------------------------------+</span>
<span class="o">|</span> <span class="n">array_intersect</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">],</span> <span
class="p">[</span><span class="mi">5</span><span class="p">,</span> <span
class="mi">6</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><spa [...]
@@ -6186,8 +6250,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</div>
</section>
<hr class="docutils" />
-<section id="id134">
-<h4>Aliases<a class="headerlink" href="#id134" 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_intersect</p></li>
</ul>
@@ -6203,16 +6267,16 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_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="id135">
-<h4>Arguments<a class="headerlink" href="#id135" 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>
<li><p><strong>dimension</strong>: Array dimension.</p></li>
</ul>
</section>
-<section id="id136">
-<h4>Example<a class="headerlink" href="#id136" 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><span class="o">></span> <span
class="n">select</span> <span class="n">array_length</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">,</span> <span
class="mi">5</span><span class="p">]);</span>
<span class="o">+---------------------------------+</span>
<span class="o">|</span> <span class="n">array_length</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">3</span><span class="p">,</span><span
class="mi">4</span><span class="p">,</span><span class="mi">5</span><span
class="p">]))</span> <span class="o">|</span>
@@ -6222,8 +6286,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id137">
-<h4>Aliases<a class="headerlink" href="#id137" 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_length</p></li>
</ul>
@@ -6235,15 +6299,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="id138">
-<h4>Arguments<a class="headerlink" href="#id138" title="Link to this
heading">¶</a></h4>
+<section id="id140">
+<h4>Arguments<a class="headerlink" href="#id140" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id139">
-<h4>Example<a class="headerlink" href="#id139" title="Link to this
heading">¶</a></h4>
+<section id="id141">
+<h4>Example<a class="headerlink" href="#id141" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_ndims</span><span
class="p">([[</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">],</span> <span class="p">[</span><span class="mi">4</span><span
class="p">,</span> <span class="mi">5</span><span class="p">,</span> <span
class="mi [...]
<span class="o">+----------------------------------+</span>
<span class="o">|</span> <span class="n">array_ndims</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">3</span><span class="p">,</span><span
class="mi">4</span><span class="p">,</span><span class="mi">5</span><span
class="p">,</span><span class="mi">6</span><span class="p">]))</span> <span
class="o">|</span>
@@ -6253,8 +6317,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id140">
-<h4>Aliases<a class="headerlink" href="#id140" 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>list_ndims</p></li>
</ul>
@@ -6266,16 +6330,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="id141">
-<h4>Arguments<a class="headerlink" href="#id141" 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>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="id142">
-<h4>Example<a class="headerlink" href="#id142" 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><span class="o">></span> <span
class="n">select</span> <span class="n">array_prepend</span><span
class="p">(</span><span class="mi">1</span><span class="p">,</span> <span
class="p">[</span><span class="mi">2</span><span class="p">,</span> <span
class="mi">3</span><span class="p">,</span> <span class="mi">4</span><span
class="p">]);</span>
<span class="o">+---------------------------------------+</span>
<span class="o">|</span> <span class="n">array_prepend</span><span
class="p">(</span><span class="n">Int64</span><span class="p">(</span><span
class="mi">1</span><span class="p">),</span><span class="n">List</span><span
class="p">([</span><span class="mi">2</span><span class="p">,</span><span
class="mi">3</span><span class="p">,</span><span class="mi">4</span><span
class="p">]))</span> <span class="o">|</span>
@@ -6285,8 +6349,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id143">
-<h4>Aliases<a class="headerlink" href="#id143" 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>array_push_front</p></li>
<li><p>list_prepend</p></li>
@@ -6300,15 +6364,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="id144">
-<h4>Arguments<a class="headerlink" href="#id144" title="Link to this
heading">¶</a></h4>
+<section id="id146">
+<h4>Arguments<a class="headerlink" href="#id146" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id145">
-<h4>Example<a class="headerlink" href="#id145" title="Link to this
heading">¶</a></h4>
+<section id="id147">
+<h4>Example<a class="headerlink" href="#id147" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_pop_front</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">]);</span>
<span class="o">+-------------------------------+</span>
<span class="o">|</span> <span class="n">array_pop_front</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">3</span><span class="p">]))</span> <span
class="o">|</span>
@@ -6318,8 +6382,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id146">
-<h4>Aliases<a class="headerlink" href="#id146" 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_pop_front</p></li>
</ul>
@@ -6331,15 +6395,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="id147">
-<h4>Arguments<a class="headerlink" href="#id147" title="Link to this
heading">¶</a></h4>
+<section id="id149">
+<h4>Arguments<a class="headerlink" href="#id149" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id148">
-<h4>Example<a class="headerlink" href="#id148" 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><span class="o">></span> <span
class="n">select</span> <span class="n">array_pop_back</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">]);</span>
<span class="o">+-------------------------------+</span>
<span class="o">|</span> <span class="n">array_pop_back</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">3</span><span class="p">]))</span> <span
class="o">|</span>
@@ -6349,8 +6413,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id149">
-<h4>Aliases<a class="headerlink" href="#id149" 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_pop_back</p></li>
</ul>
@@ -6363,8 +6427,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="id150">
-<h4>Arguments<a class="headerlink" href="#id150" title="Link to this
heading">¶</a></h4>
+<section id="id152">
+<h4>Arguments<a class="headerlink" href="#id152" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -6372,8 +6436,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="id151">
-<h4>Example<a class="headerlink" href="#id151" 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><span class="o">></span> <span
class="n">select</span> <span class="n">array_position</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">1</span><span class="p">,</span> <span class="mi">4</span><span
class=" [...]
<span class="o">+----------------------------------------------+</span>
<span class="o">|</span> <span class="n">array_position</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">2</span><span class="p">,</span><span
class="mi">3</span><span class="p">,</span><span class="mi">1</span><span
class="p">,</span><span class="mi">4</span><span class="p">]),</span><span
class="n">Int64</span><span class="p">(</span><span [...]
@@ -6383,8 +6447,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id152">
-<h4>Aliases<a class="headerlink" href="#id152" title="Link to this
heading">¶</a></h4>
+<section id="id154">
+<h4>Aliases<a class="headerlink" href="#id154" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_indexof</p></li>
<li><p>list_indexof</p></li>
@@ -6398,16 +6462,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="id153">
-<h4>Arguments<a class="headerlink" href="#id153" title="Link to this
heading">¶</a></h4>
+<section id="id155">
+<h4>Arguments<a class="headerlink" href="#id155" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>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="id154">
-<h4>Example<a class="headerlink" href="#id154" 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><span class="o">></span> <span
class="n">select</span> <span class="n">array_positions</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">1</span><span class="p">,</span> <span class="mi">4</span><span
class= [...]
<span class="o">+-----------------------------------------------+</span>
<span class="o">|</span> <span class="n">array_positions</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">2</span><span class="p">,</span><span
class="mi">3</span><span class="p">,</span><span class="mi">1</span><span
class="p">,</span><span class="mi">4</span><span class="p">]),</span><span
class="n">Int64</span><span class="p">(</span><span [...]
@@ -6417,8 +6481,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id155">
-<h4>Aliases<a class="headerlink" href="#id155" title="Link to this
heading">¶</a></h4>
+<section id="id157">
+<h4>Aliases<a class="headerlink" href="#id157" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_positions</p></li>
</ul>
@@ -6438,16 +6502,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="id156">
-<h4>Arguments<a class="headerlink" href="#id156" title="Link to this
heading">¶</a></h4>
+<section id="id158">
+<h4>Arguments<a class="headerlink" href="#id158" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>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="id157">
-<h4>Example<a class="headerlink" href="#id157" 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><span class="o">></span> <span
class="n">select</span> <span class="n">array_repeat</span><span
class="p">(</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">3</span><span class="p">);</span>
<span class="o">+---------------------------------+</span>
<span class="o">|</span> <span class="n">array_repeat</span><span
class="p">(</span><span class="n">Int64</span><span class="p">(</span><span
class="mi">1</span><span class="p">),</span><span class="n">Int64</span><span
class="p">(</span><span class="mi">3</span><span class="p">))</span> <span
class="o">|</span>
@@ -6465,8 +6529,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id158">
-<h4>Aliases<a class="headerlink" href="#id158" 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_repeat</p></li>
</ul>
@@ -6478,16 +6542,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="id159">
-<h4>Arguments<a class="headerlink" href="#id159" title="Link to this
heading">¶</a></h4>
+<section id="id161">
+<h4>Arguments<a class="headerlink" href="#id161" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>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="id160">
-<h4>Example<a class="headerlink" href="#id160" 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><span class="o">></span> <span
class="n">select</span> <span class="n">array_remove</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">1</span><span
class="p" [...]
<span class="o">+----------------------------------------------+</span>
<span class="o">|</span> <span class="n">array_remove</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">2</span><span class="p">,</span><span
class="mi">3</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">1</span><span class="p">,</span><span
class="mi">4</span><span class="p">]),</span><span class [...]
@@ -6497,8 +6561,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id161">
-<h4>Aliases<a class="headerlink" href="#id161" 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_remove</p></li>
</ul>
@@ -6510,8 +6574,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="id162">
-<h4>Arguments<a class="headerlink" href="#id162" title="Link to this
heading">¶</a></h4>
+<section id="id164">
+<h4>Arguments<a class="headerlink" href="#id164" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -6519,8 +6583,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="id163">
-<h4>Example<a class="headerlink" href="#id163" title="Link to this
heading">¶</a></h4>
+<section id="id165">
+<h4>Example<a class="headerlink" href="#id165" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_remove_n</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">1</span><span
class=" [...]
<span
class="o">+---------------------------------------------------------+</span>
<span class="o">|</span> <span class="n">array_remove_n</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">2</span><span class="p">,</span><span
class="mi">3</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">1</span><span class="p">,</span><span
class="mi">4</span><span class="p">]),</span><span cla [...]
@@ -6530,8 +6594,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id164">
-<h4>Aliases<a class="headerlink" href="#id164" 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_remove_n</p></li>
</ul>
@@ -6543,16 +6607,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="id165">
-<h4>Arguments<a class="headerlink" href="#id165" 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>
<li><p><strong>element</strong>: Element to be removed from the array.</p></li>
</ul>
</section>
-<section id="id166">
-<h4>Example<a class="headerlink" href="#id166" 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><span class="o">></span> <span
class="n">select</span> <span class="n">array_remove_all</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">1</span><span
class [...]
<span class="o">+--------------------------------------------------+</span>
<span class="o">|</span> <span class="n">array_remove_all</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">2</span><span class="p">,</span><span
class="mi">3</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">1</span><span class="p">,</span><span
class="mi">4</span><span class="p">]),</span><span c [...]
@@ -6562,8 +6626,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id167">
-<h4>Aliases<a class="headerlink" href="#id167" 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_remove_all</p></li>
</ul>
@@ -6575,8 +6639,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="id168">
-<h4>Arguments<a class="headerlink" href="#id168" 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>
@@ -6584,8 +6648,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="id169">
-<h4>Example<a class="headerlink" href="#id169" 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><span class="o">></span> <span
class="n">select</span> <span class="n">array_replace</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">1</span><span
class="p [...]
<span
class="o">+--------------------------------------------------------+</span>
<span class="o">|</span> <span class="n">array_replace</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">2</span><span class="p">,</span><span
class="mi">3</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">1</span><span class="p">,</span><span
class="mi">4</span><span class="p">]),</span><span clas [...]
@@ -6595,8 +6659,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id170">
-<h4>Aliases<a class="headerlink" href="#id170" 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_replace</p></li>
</ul>
@@ -6608,8 +6672,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="id171">
-<h4>Arguments<a class="headerlink" href="#id171" 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>
@@ -6618,8 +6682,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="id172">
-<h4>Example<a class="headerlink" href="#id172" 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><span class="o">></span> <span
class="n">select</span> <span class="n">array_replace_n</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">1</span><span
class= [...]
<span
class="o">+-------------------------------------------------------------------+</span>
<span class="o">|</span> <span class="n">array_replace_n</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">2</span><span class="p">,</span><span
class="mi">3</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">1</span><span class="p">,</span><span
class="mi">4</span><span class="p">]),</span><span cl [...]
@@ -6629,8 +6693,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id173">
-<h4>Aliases<a class="headerlink" href="#id173" 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>list_replace_n</p></li>
</ul>
@@ -6642,8 +6706,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="id174">
-<h4>Arguments<a class="headerlink" href="#id174" 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>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -6651,8 +6715,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="id175">
-<h4>Example<a class="headerlink" href="#id175" 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><span class="o">></span> <span
class="n">select</span> <span class="n">array_replace_all</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">1</span><span clas
[...]
<span
class="o">+------------------------------------------------------------+</span>
<span class="o">|</span> <span class="n">array_replace_all</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">2</span><span class="p">,</span><span
class="mi">3</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">1</span><span class="p">,</span><span
class="mi">4</span><span class="p">]),</span><span [...]
@@ -6662,8 +6726,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id176">
-<h4>Aliases<a class="headerlink" href="#id176" 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_replace_all</p></li>
</ul>
@@ -6675,15 +6739,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="id177">
-<h4>Arguments<a class="headerlink" href="#id177" 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>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id178">
-<h4>Example<a class="headerlink" href="#id178" 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><span class="o">></span> <span
class="n">select</span> <span class="n">array_reverse</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">]);</span>
<span
class="o">+------------------------------------------------------------+</span>
<span class="o">|</span> <span class="n">array_reverse</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">4</span><span class="p">]))</span> <span
class="o">|</span>
@@ -6693,8 +6757,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id179">
-<h4>Aliases<a class="headerlink" href="#id179" 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_reverse</p></li>
</ul>
@@ -6706,8 +6770,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="id180">
-<h4>Arguments<a class="headerlink" href="#id180" 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>
@@ -6718,8 +6782,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="id181">
-<h4>Example<a class="headerlink" href="#id181" 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><span class="o">></span> <span
class="n">select</span> <span class="n">array_slice</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">,</span> <span
class="mi">5</span><span class="p">,</span> <span class="mi">6</span><span
class="p"> [...]
<span
class="o">+--------------------------------------------------------+</span>
<span class="o">|</span> <span class="n">array_slice</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">3</span><span class="p">,</span><span
class="mi">4</span><span class="p">,</span><span class="mi">5</span><span
class="p">,</span><span class="mi">6</span><span class="p">,</span><span
class="mi">7</span><span class="p">,</span><span class="m [...]
@@ -6729,8 +6793,8 @@ If negative, it counts backward from the end of the
array.</p></li>
</pre></div>
</div>
</section>
-<section id="id182">
-<h4>Aliases<a class="headerlink" href="#id182" title="Link to this
heading">¶</a></h4>
+<section id="id184">
+<h4>Aliases<a class="headerlink" href="#id184" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_slice</p></li>
</ul>
@@ -6742,16 +6806,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="id183">
-<h4>Arguments<a class="headerlink" href="#id183" title="Link to this
heading">¶</a></h4>
+<section id="id185">
+<h4>Arguments<a class="headerlink" href="#id185" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>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="id184">
-<h4>Example<a class="headerlink" href="#id184" title="Link to this
heading">¶</a></h4>
+<section id="id186">
+<h4>Example<a class="headerlink" href="#id186" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_to_string</span><span
class="p">([[</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">],</span> <span
class="p">[</span><span class="mi">5</span><span class="p">,</span> <span class
[...]
<span class="o">+----------------------------------------------------+</span>
<span class="o">|</span> <span class="n">array_to_string</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">3</span><span class="p">,</span><span
class="mi">4</span><span class="p">,</span><span class="mi">5</span><span
class="p">,</span><span class="mi">6</span><span class="p">,</span><span
class="mi">7</span><span class="p">,</span><span clas [...]
@@ -6761,8 +6825,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id185">
-<h4>Aliases<a class="headerlink" href="#id185" title="Link to this
heading">¶</a></h4>
+<section id="id187">
+<h4>Aliases<a class="headerlink" href="#id187" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_join</p></li>
<li><p>list_join</p></li>
@@ -6776,8 +6840,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="id186">
-<h4>Arguments<a class="headerlink" href="#id186" title="Link to this
heading">¶</a></h4>
+<section id="id188">
+<h4>Arguments<a class="headerlink" href="#id188" 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>
@@ -6785,8 +6849,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="id187">
-<h4>Example<a class="headerlink" href="#id187" title="Link to this
heading">¶</a></h4>
+<section id="id189">
+<h4>Example<a class="headerlink" href="#id189" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_union</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">],</span> <span
class="p">[</span><span class="mi">5</span><span class="p">,</span> <span
class="mi" [...]
<span class="o">+----------------------------------------------------+</span>
<span class="o">|</span> <span class="n">array_union</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">],</span> <span
class="p">[</span><span class="mi">5</span><span class="p">,</span> <span
class="mi">6</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span cl [...]
@@ -6803,8 +6867,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</div>
</section>
<hr class="docutils" />
-<section id="id188">
-<h4>Aliases<a class="headerlink" href="#id188" 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>list_union</p></li>
</ul>
@@ -6816,8 +6880,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="id189">
-<h4>Arguments<a class="headerlink" href="#id189" 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>array1</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
@@ -6825,8 +6889,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="id190">
-<h4>Example<a class="headerlink" href="#id190" title="Link to this
heading">¶</a></h4>
+<section id="id192">
+<h4>Example<a class="headerlink" href="#id192" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_except</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">],</span> <span
class="p">[</span><span class="mi">5</span><span class="p">,</span> <span
class="mi [...]
<span class="o">+----------------------------------------------------+</span>
<span class="o">|</span> <span class="n">array_except</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">],</span> <span
class="p">[</span><span class="mi">5</span><span class="p">,</span> <span
class="mi">6</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span c [...]
@@ -6843,8 +6907,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</div>
</section>
<hr class="docutils" />
-<section id="id191">
-<h4>Aliases<a class="headerlink" href="#id191" title="Link to this
heading">¶</a></h4>
+<section id="id193">
+<h4>Aliases<a class="headerlink" href="#id193" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>list_except</p></li>
</ul>
@@ -6856,15 +6920,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="id192">
-<h4>Arguments<a class="headerlink" href="#id192" 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>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id193">
-<h4>Example<a class="headerlink" href="#id193" title="Link to this
heading">¶</a></h4>
+<section id="id195">
+<h4>Example<a class="headerlink" href="#id195" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">cardinality</span><span
class="p">([[</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">],</span> <span
class="p">[</span><span class="mi">5</span><span class="p">,</span> <span
class="mi [...]
<span class="o">+--------------------------------------+</span>
<span class="o">|</span> <span class="n">cardinality</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">3</span><span class="p">,</span><span
class="mi">4</span><span class="p">,</span><span class="mi">5</span><span
class="p">,</span><span class="mi">6</span><span class="p">,</span><span
class="mi">7</span><span class="p">,</span><span class="m [...]
@@ -6881,15 +6945,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="id194">
-<h4>Arguments<a class="headerlink" href="#id194" 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>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array
operators.</p></li>
</ul>
</section>
-<section id="id195">
-<h4>Example<a class="headerlink" href="#id195" title="Link to this
heading">¶</a></h4>
+<section id="id197">
+<h4>Example<a class="headerlink" href="#id197" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">empty</span><span
class="p">([</span><span class="mi">1</span><span class="p">]);</span>
<span class="o">+------------------+</span>
<span class="o">|</span> <span class="n">empty</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">]))</span> <span class="o">|</span>
@@ -6899,8 +6963,8 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id196">
-<h4>Aliases<a class="headerlink" href="#id196" title="Link to this
heading">¶</a></h4>
+<section id="id198">
+<h4>Aliases<a class="headerlink" href="#id198" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>array_empty,</p></li>
<li><p>list_empty</p></li>
@@ -6913,16 +6977,16 @@ Can be a constant, column, or function, and any
combination of array operators.<
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">generate_series</span><span
class="p">(</span><span class="n">start</span><span class="p">,</span> <span
class="n">stop</span><span class="p">,</span> <span class="n">step</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id197">
-<h4>Arguments<a class="headerlink" href="#id197" 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>start</strong>: start of the range</p></li>
<li><p><strong>end</strong>: end of the range (included)</p></li>
<li><p><strong>step</strong>: increase by step (can not be 0)</p></li>
</ul>
</section>
-<section id="id198">
-<h4>Example<a class="headerlink" href="#id198" title="Link to this
heading">¶</a></h4>
+<section id="id200">
+<h4>Example<a class="headerlink" href="#id200" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">generate_series</span><span
class="p">(</span><span class="mi">1</span><span class="p">,</span><span
class="mi">3</span><span class="p">);</span>
<span class="o">+------------------------------------+</span>
<span class="o">|</span> <span class="n">generate_series</span><span
class="p">(</span><span class="n">Int64</span><span class="p">(</span><span
class="mi">1</span><span class="p">),</span><span class="n">Int64</span><span
class="p">(</span><span class="mi">3</span><span class="p">))</span> <span
class="o">|</span>
@@ -7091,16 +7155,16 @@ Can be a constant, column, or function, and any
combination of array operators.<
<section id="array-empty">
<h3><code class="docutils literal notranslate"><span
class="pre">array_empty</span></code><a class="headerlink" href="#array-empty"
title="Link to this heading">¶</a></h3>
<p><em>Alias of <a class="reference internal" href="#empty">empty</a>.</em></p>
-<section id="id199">
-<h4>Arguments<a class="headerlink" href="#id199" title="Link to this
heading">¶</a></h4>
+<section id="id201">
+<h4>Arguments<a class="headerlink" href="#id201" 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="id200">
-<h4>Example<a class="headerlink" href="#id200" title="Link to this
heading">¶</a></h4>
+<section id="id202">
+<h4>Example<a class="headerlink" href="#id202" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">make_array</span><span
class="p">(</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">,</span> <span
class="mi">5</span><span class="p">);</span>
<span
class="o">+----------------------------------------------------------+</span>
<span class="o">|</span> <span class="n">make_array</span><span
class="p">(</span><span class="n">Int64</span><span class="p">(</span><span
class="mi">1</span><span class="p">),</span><span class="n">Int64</span><span
class="p">(</span><span class="mi">2</span><span class="p">),</span><span
class="n">Int64</span><span class="p">(</span><span class="mi">3</span><span
class="p">),</span><span class="n">Int64</span><span class="p">(</span><span
class="mi">4</span><span class="p">),</span><s [...]
@@ -7110,8 +7174,8 @@ string operators.</p></li>
</pre></div>
</div>
</section>
-<section id="id201">
-<h4>Aliases<a class="headerlink" href="#id201" title="Link to this
heading">¶</a></h4>
+<section id="id203">
+<h4>Aliases<a class="headerlink" href="#id203" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>make_list</p></li>
</ul>
@@ -7128,16 +7192,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="id202">
-<h4>Arguments<a class="headerlink" href="#id202" title="Link to this
heading">¶</a></h4>
+<section id="id204">
+<h4>Arguments<a class="headerlink" href="#id204" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>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="id203">
-<h4>Aliases<a class="headerlink" href="#id203" title="Link to this
heading">¶</a></h4>
+<section id="id205">
+<h4>Aliases<a class="headerlink" href="#id205" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>string_to_list</p></li>
</ul>
@@ -7154,8 +7218,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="id204">
-<h4>Arguments<a class="headerlink" href="#id204" title="Link to this
heading">¶</a></h4>
+<section id="id206">
+<h4>Arguments<a class="headerlink" href="#id206" 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>
@@ -7187,16 +7251,16 @@ For example,</p>
</pre></div>
</div>
<p>are not allowed</p>
-<section id="id205">
-<h4>Arguments<a class="headerlink" href="#id205" title="Link to this
heading">¶</a></h4>
+<section id="id207">
+<h4>Arguments<a class="headerlink" href="#id207" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>start</strong>: start of the range</p></li>
<li><p><strong>end</strong>: end of the range (not included)</p></li>
<li><p><strong>step</strong>: increase by step (can not be 0)</p></li>
</ul>
</section>
-<section id="id206">
-<h4>Aliases<a class="headerlink" href="#id206" title="Link to this
heading">¶</a></h4>
+<section id="id208">
+<h4>Aliases<a class="headerlink" href="#id208" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>generate_series</p></li>
</ul>
@@ -7246,8 +7310,8 @@ select struct(a as field_a, b) from t;
+--------------------------------------------------+
</pre></div>
</div>
-<section id="id207">
-<h4>Arguments<a class="headerlink" href="#id207" title="Link to this
heading">¶</a></h4>
+<section id="id209">
+<h4>Arguments<a class="headerlink" href="#id209" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression_n</strong>: Expression to include in the output
struct.
Can be a constant, column, or function, any combination of arithmetic or
@@ -7280,8 +7344,8 @@ a struct type of fields <code class="docutils literal
notranslate"><span class="
<span
class="o">+-------------------------------------------------------+</span>
</pre></div>
</div>
-<section id="id208">
-<h4>Arguments<a class="headerlink" href="#id208" title="Link to this
heading">¶</a></h4>
+<section id="id210">
+<h4>Arguments<a class="headerlink" href="#id210" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression_n_name</strong>: Name of the column field.
Must be a constant string.</p></li>
@@ -7308,8 +7372,8 @@ string operators.</p></li>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">digest</span><span
class="p">(</span><span class="n">expression</span><span class="p">,</span>
<span class="n">algorithm</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id209">
-<h4>Arguments<a class="headerlink" href="#id209" title="Link to this
heading">¶</a></h4>
+<section id="id211">
+<h4>Arguments<a class="headerlink" href="#id211" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -7335,8 +7399,8 @@ Must be one of:</p>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">md5</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id210">
-<h4>Arguments<a class="headerlink" href="#id210" title="Link to this
heading">¶</a></h4>
+<section id="id212">
+<h4>Arguments<a class="headerlink" href="#id212" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -7349,8 +7413,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">sha224</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id211">
-<h4>Arguments<a class="headerlink" href="#id211" title="Link to this
heading">¶</a></h4>
+<section id="id213">
+<h4>Arguments<a class="headerlink" href="#id213" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -7363,8 +7427,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">sha256</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id212">
-<h4>Arguments<a class="headerlink" href="#id212" title="Link to this
heading">¶</a></h4>
+<section id="id214">
+<h4>Arguments<a class="headerlink" href="#id214" 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>
@@ -7377,8 +7441,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">sha384</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id213">
-<h4>Arguments<a class="headerlink" href="#id213" title="Link to this
heading">¶</a></h4>
+<section id="id215">
+<h4>Arguments<a class="headerlink" href="#id215" 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>
@@ -7391,8 +7455,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">sha512</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id214">
-<h4>Arguments<a class="headerlink" href="#id214" title="Link to this
heading">¶</a></h4>
+<section id="id216">
+<h4>Arguments<a class="headerlink" href="#id216" 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>
@@ -7412,8 +7476,8 @@ Can be a constant, column, or function, and any
combination of string operators.
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">arrow_cast</span><span
class="p">(</span><span class="n">expression</span><span class="p">,</span>
<span class="n">datatype</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id215">
-<h4>Arguments<a class="headerlink" href="#id215" title="Link to this
heading">¶</a></h4>
+<section id="id217">
+<h4>Arguments<a class="headerlink" href="#id217" 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
@@ -7422,8 +7486,8 @@ string operators.</p></li>
to cast to, as a string. The format is the same as that returned by [<code
class="docutils literal notranslate"><span
class="pre">arrow_typeof</span></code>]</p></li>
</ul>
</section>
-<section id="id216">
-<h4>Example<a class="headerlink" href="#id216" title="Link to this
heading">¶</a></h4>
+<section id="id218">
+<h4>Example<a class="headerlink" href="#id218" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">arrow_cast</span><span
class="p">(</span><span class="o">-</span><span class="mi">5</span><span
class="p">,</span> <span class="s1">'Int8'</span><span
class="p">)</span> <span class="k">as</span> <span class="n">a</span><span
class="p">,</span>
<span class="n">arrow_cast</span><span class="p">(</span><span
class="s1">'foo'</span><span class="p">,</span> <span
class="s1">'Dictionary(Int32, Utf8)'</span><span class="p">)</span>
<span class="k">as</span> <span class="n">b</span><span class="p">,</span>
<span class="n">arrow_cast</span><span class="p">(</span><span
class="s1">'bar'</span><span class="p">,</span> <span
class="s1">'LargeUtf8'</span><span class="p">)</span> <span
class="k">as</span> <span class="n">c</span><span class="p">,</span>
@@ -7445,16 +7509,16 @@ to cast to, as a string. The format is the same as that
returned by [<code class
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">arrow_typeof</span><span
class="p">(</span><span class="n">expression</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id217">
-<h4>Arguments<a class="headerlink" href="#id217" title="Link to this
heading">¶</a></h4>
+<section id="id219">
+<h4>Arguments<a class="headerlink" href="#id219" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>expression</strong>: Expression to evaluate.
Can be a constant, column, or function, and any combination of arithmetic or
string operators.</p></li>
</ul>
</section>
-<section id="id218">
-<h4>Example<a class="headerlink" href="#id218" title="Link to this
heading">¶</a></h4>
+<section id="id220">
+<h4>Example<a class="headerlink" href="#id220" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">arrow_typeof</span><span
class="p">(</span><span class="s1">'foo'</span><span
class="p">),</span> <span class="n">arrow_typeof</span><span
class="p">(</span><span class="mi">1</span><span class="p">);</span>
<span class="o">+---------------------------+------------------------+</span>
<span class="o">|</span> <span class="n">arrow_typeof</span><span
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"foo"</span><span class="p">))</span> <span
class="o">|</span> <span class="n">arrow_typeof</span><span
class="p">(</span><span class="n">Int64</span><span class="p">(</span><span
class="mi">1</span><span class="p">))</span> <span class="o">|</span>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
