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 2952cf92a0 Publish built docs triggered by
6a9287048535d88e58c6e302e8083c67d6f3648c
2952cf92a0 is described below
commit 2952cf92a01e19775ce36dca9800561b4530196f
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Sun Dec 29 13:14:51 2024 +0000
Publish built docs triggered by 6a9287048535d88e58c6e302e8083c67d6f3648c
---
_sources/user-guide/sql/scalar_functions.md.txt | 144 ++++++++++++------------
searchindex.js | 2 +-
user-guide/sql/scalar_functions.html | 144 ++++++++++++------------
3 files changed, 145 insertions(+), 145 deletions(-)
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index 56cc8e10fb..79fe440f37 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -2597,26 +2597,25 @@ _Alias of [current_date](#current_date)._
### `array_any_value`
-Extracts the element with the index n from the array.
+Returns the first non-null element in the array.
```
-array_element(array, index)
+array_any_value(array)
```
#### Arguments
- **array**: Array expression. Can be a constant, column, or function, and any
combination of array operators.
-- **index**: Index to extract the element from the array.
#### Example
```sql
-> select array_element([1, 2, 3, 4], 3);
-+-----------------------------------------+
-| array_element(List([1,2,3,4]),Int64(3)) |
-+-----------------------------------------+
-| 3 |
-+-----------------------------------------+
+> select array_any_value([NULL, 1, 2, 3]);
++-------------------------------+
+| array_any_value(List([NULL,1,2,3])) |
++-------------------------------------+
+| 1 |
++-------------------------------------+
```
#### Aliases
@@ -2659,26 +2658,26 @@ _Alias of [array_concat](#array_concat)._
### `array_concat`
-Appends an element to the end of an array.
+Concatenates arrays.
```
-array_append(array, element)
+array_concat(array[, ..., array_n])
```
#### Arguments
- **array**: Array expression. Can be a constant, column, or function, and any
combination of array operators.
-- **element**: Element to append to the array.
+- **array_n**: Subsequent array column or literal array to concatenate.
#### Example
```sql
-> select array_append([1, 2, 3], 4);
-+--------------------------------------+
-| array_append(List([1,2,3]),Int64(4)) |
-+--------------------------------------+
-| [1, 2, 3, 4] |
-+--------------------------------------+
+> select array_concat([1, 2], [3, 4], [5, 6]);
++---------------------------------------------------+
+| array_concat(List([1,2]),List([3,4]),List([5,6])) |
++---------------------------------------------------+
+| [1, 2, 3, 4, 5, 6] |
++---------------------------------------------------+
```
#### Aliases
@@ -2877,26 +2876,26 @@ array_has(array, element)
### `array_has_all`
-Returns true if the array contains the element.
+Returns true if all elements of sub-array exist in array.
```
-array_has(array, element)
+array_has_all(array, sub-array)
```
#### Arguments
- **array**: Array expression. Can be a constant, column, or function, and any
combination of array operators.
-- **element**: Scalar or Array expression. Can be a constant, column, or
function, and any combination of array operators.
+- **sub-array**: Array expression. Can be a constant, column, or function, and
any combination of array operators.
#### Example
```sql
-> select array_has([1, 2, 3], 2);
-+-----------------------------+
-| array_has(List([1,2,3]), 2) |
-+-----------------------------+
-| true |
-+-----------------------------+
+> select array_has_all([1, 2, 3, 4], [2, 3]);
++--------------------------------------------+
+| array_has_all(List([1,2,3,4]), List([2,3])) |
++--------------------------------------------+
+| true |
++--------------------------------------------+
```
#### Aliases
@@ -2905,26 +2904,26 @@ array_has(array, element)
### `array_has_any`
-Returns true if the array contains the element.
+Returns true if any elements exist in both arrays.
```
-array_has(array, element)
+array_has_any(array, sub-array)
```
#### Arguments
- **array**: Array expression. Can be a constant, column, or function, and any
combination of array operators.
-- **element**: Scalar or Array expression. Can be a constant, column, or
function, and any combination of array operators.
+- **sub-array**: Array expression. Can be a constant, column, or function, and
any combination of array operators.
#### Example
```sql
-> select array_has([1, 2, 3], 2);
-+-----------------------------+
-| array_has(List([1,2,3]), 2) |
-+-----------------------------+
-| true |
-+-----------------------------+
+> select array_has_any([1, 2, 3], [3, 4]);
++------------------------------------------+
+| array_has_any(List([1,2,3]), List([3,4])) |
++------------------------------------------+
+| true |
++------------------------------------------+
```
#### Aliases
@@ -2996,25 +2995,26 @@ array_length(array, dimension)
### `array_ndims`
-Returns an array of the array's dimensions.
+Returns the number of dimensions of the array.
```
-array_dims(array)
+array_ndims(array, element)
```
#### Arguments
- **array**: Array expression. Can be a constant, column, or function, and any
combination of array operators.
+- **element**: Array element.
#### Example
```sql
-> select array_dims([[1, 2, 3], [4, 5, 6]]);
-+---------------------------------+
-| array_dims(List([1,2,3,4,5,6])) |
-+---------------------------------+
-| [2, 3] |
-+---------------------------------+
+> select array_ndims([[1, 2, 3], [4, 5, 6]]);
++----------------------------------+
+| array_ndims(List([1,2,3,4,5,6])) |
++----------------------------------+
+| 2 |
++----------------------------------+
```
#### Aliases
@@ -3023,26 +3023,25 @@ array_dims(array)
### `array_pop_back`
-Extracts the element with the index n from the array.
+Returns the array without the last element.
```
-array_element(array, index)
+array_pop_back(array)
```
#### Arguments
- **array**: Array expression. Can be a constant, column, or function, and any
combination of array operators.
-- **index**: Index to extract the element from the array.
#### Example
```sql
-> select array_element([1, 2, 3, 4], 3);
-+-----------------------------------------+
-| array_element(List([1,2,3,4]),Int64(3)) |
-+-----------------------------------------+
-| 3 |
-+-----------------------------------------+
+> select array_pop_back([1, 2, 3]);
++-------------------------------+
+| array_pop_back(List([1,2,3])) |
++-------------------------------+
+| [1, 2] |
++-------------------------------+
```
#### Aliases
@@ -3051,26 +3050,25 @@ array_element(array, index)
### `array_pop_front`
-Extracts the element with the index n from the array.
+Returns the array without the first element.
```
-array_element(array, index)
+array_pop_front(array)
```
#### Arguments
- **array**: Array expression. Can be a constant, column, or function, and any
combination of array operators.
-- **index**: Index to extract the element from the array.
#### Example
```sql
-> select array_element([1, 2, 3, 4], 3);
-+-----------------------------------------+
-| array_element(List([1,2,3,4]),Int64(3)) |
-+-----------------------------------------+
-| 3 |
-+-----------------------------------------+
+> select array_pop_front([1, 2, 3]);
++-------------------------------+
+| array_pop_front(List([1,2,3])) |
++-------------------------------+
+| [2, 3] |
++-------------------------------+
```
#### Aliases
@@ -3161,8 +3159,8 @@ array_prepend(element, array)
#### Arguments
-- **element**: Element to prepend to the array.
- **array**: Array expression. Can be a constant, column, or function, and any
combination of array operators.
+- **element**: Element to prepend to the array.
#### Example
@@ -3455,26 +3453,28 @@ array_reverse(array)
### `array_slice`
-Extracts the element with the index n from the array.
+Returns a slice of the array based on 1-indexed start and end positions.
```
-array_element(array, index)
+array_slice(array, begin, end)
```
#### Arguments
- **array**: Array expression. Can be a constant, column, or function, and any
combination of array operators.
-- **index**: Index to extract the element from the array.
+- **begin**: Index of the first element. If negative, it counts backward from
the end of the array.
+- **end**: Index of the last element. If negative, it counts backward from the
end of the array.
+- **stride**: Stride of the array slice. The default is 1.
#### Example
```sql
-> select array_element([1, 2, 3, 4], 3);
-+-----------------------------------------+
-| array_element(List([1,2,3,4]),Int64(3)) |
-+-----------------------------------------+
-| 3 |
-+-----------------------------------------+
+> select array_slice([1, 2, 3, 4, 5, 6, 7, 8], 3, 6);
++--------------------------------------------------------+
+| array_slice(List([1,2,3,4,5,6,7,8]),Int64(3),Int64(6)) |
++--------------------------------------------------------+
+| [3, 4, 5, 6] |
++--------------------------------------------------------+
```
#### Aliases
diff --git a/searchindex.js b/searchindex.js
index d27e3f591d..e4038acdaa 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"!=": [[48, "op-neq"]], "!~": [[48,
"op-re-not-match"]], "!~*": [[48, "op-re-not-match-i"]], "!~~": [[48, "id18"]],
"!~~*": [[48, "id19"]], "#": [[48, "op-bit-xor"]], "%": [[48, "op-modulo"]],
"&": [[48, "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"]], "*":
[[48, "op-multiply"]], "+": [[48, "op-plus"]], "-": [[48, "op-minus"]], "/":
[[4 [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"!=": [[48, "op-neq"]], "!~": [[48,
"op-re-not-match"]], "!~*": [[48, "op-re-not-match-i"]], "!~~": [[48, "id18"]],
"!~~*": [[48, "id19"]], "#": [[48, "op-bit-xor"]], "%": [[48, "op-modulo"]],
"&": [[48, "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"]], "*":
[[48, "op-multiply"]], "+": [[48, "op-plus"]], "-": [[48, "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 331e5d7f0e..98c4ac9a75 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -7160,25 +7160,24 @@ an error will be returned.</p></li>
</ul>
<section id="array-any-value">
<h3><code class="docutils literal notranslate"><span
class="pre">array_any_value</span></code><a class="headerlink"
href="#array-any-value" title="Link to this heading">¶</a></h3>
-<p>Extracts the element with the index n from the array.</p>
-<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>
+<p>Returns the first non-null element in the array.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_any_value</span><span
class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
<section id="id162">
<h4>Arguments<a class="headerlink" href="#id162" title="Link to this
heading">¶</a></h4>
<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="id163">
<h4>Example<a class="headerlink" href="#id163" title="Link to this
heading">¶</a></h4>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">array_element</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><span class="p">,</span><span class="w"> </span><span
class="mi">4</span><sp [...]
-<span class="o">+</span><span
class="c1">-----------------------------------------+</span>
-<span class="o">|</span><span class="w"> </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="w"> </span><span cl
[...]
-<span class="o">+</span><span
class="c1">-----------------------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span class="mi">3</span><span
class="w"> </span><span class="o">|</span>
-<span class="o">+</span><span
class="c1">-----------------------------------------+</span>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">array_any_value</span><span class="p">([</span><span
class="k">NULL</span><span class="p">,</span><span class="w"> </span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span [...]
+<span class="o">+</span><span
class="c1">-------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">array_any_value</span><span class="p">(</span><span
class="n">List</span><span class="p">([</span><span class="k">NULL</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="w"> </span><span class="o">|</span>
+<span class="o">+</span><span
class="c1">-------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">1</span><span
class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span
class="c1">-------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -7228,25 +7227,25 @@ an error will be returned.</p></li>
</section>
<section id="array-concat">
<h3><code class="docutils literal notranslate"><span
class="pre">array_concat</span></code><a class="headerlink"
href="#array-concat" title="Link to this heading">¶</a></h3>
-<p>Appends an element to the end of an array.</p>
-<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>
+<p>Concatenates arrays.</p>
+<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="id168">
<h4>Arguments<a class="headerlink" href="#id168" 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>
+<li><p><strong>array_n</strong>: Subsequent array column or literal array to
concatenate.</p></li>
</ul>
</section>
<section id="id169">
<h4>Example<a class="headerlink" href="#id169" title="Link to this
heading">¶</a></h4>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">array_append</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><span class="p">],</span><span class="w"> </span><span
class="mi">4</span><sp [...]
-<span class="o">+</span><span
class="c1">--------------------------------------+</span>
-<span class="o">|</span><span class="w"> </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="w"> </span><span class="o">|</span>
-<span class="o">+</span><span
class="c1">--------------------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span class="p">[</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><span class="p">,</span><span class="w"> </span><span
class="mi">4</span><span class="p">]</span><span class="w">
</span><span class="o">|</span>
-<span class="o">+</span><span
class="c1">--------------------------------------+</span>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">array_concat</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">],</span><span class="w"> </span><span
class="p">[</span><span class="mi">3</span><span class="p">,</span><span
class="w"> </span><spa [...]
+<span class="o">+</span><span
class="c1">---------------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </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><spa
[...]
+<span class="o">+</span><span
class="c1">---------------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="p">[</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><span class="p">,</span><span class="w"> </span><span
class="mi">4</span><span class="p">,</span><span class="w"> </span><span
class="mi">5</span><span class="p">,</span><span class="w"> </span><span
class="mi">6</span><span class="p">]</span><span [...]
+<span class="o">+</span><span
class="c1">---------------------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -7467,25 +7466,25 @@ an error will be returned.</p></li>
</section>
<section id="array-has-all">
<h3><code class="docutils literal notranslate"><span
class="pre">array_has_all</span></code><a class="headerlink"
href="#array-has-all" title="Link to this heading">¶</a></h3>
-<p>Returns true if the array contains the element.</p>
-<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>
+<p>Returns true if all elements of sub-array exist in array.</p>
+<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="id189">
<h4>Arguments<a class="headerlink" href="#id189" 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>: Scalar or Array expression. Can be a
constant, column, or function, and any combination of array operators.</p></li>
+<li><p><strong>sub-array</strong>: Array expression. 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>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">array_has</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><span class="p">],</span><span class="w"> </span><span
class="mi">2</span><span [...]
-<span class="o">+</span><span class="c1">-----------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">array_has</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="w"> </span><span
class="mi">2</span><span class="p">)</span><span class="w"> </span><span
class="o">|</span>
-<span class="o">+</span><span class="c1">-----------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="k">true</span><span class="w"> </span><span
class="o">|</span>
-<span class="o">+</span><span class="c1">-----------------------------+</span>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">array_has_all</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><span class="p">,</span><span class="w"> </span><span
class="mi">4</span><sp [...]
+<span class="o">+</span><span
class="c1">--------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">array_has_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">3</span><span class="p">,</span><span class="mi">4</span><span
class="p">]),</span><span class="w"> </span><span class="n">List</span><span
class="p">([</span><span class="mi">2</span><span class="p">,</span><span cla
[...]
+<span class="o">+</span><span
class="c1">--------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="k">true</span><span class="w">
</span><span class="o">|</span>
+<span class="o">+</span><span
class="c1">--------------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -7498,25 +7497,25 @@ an error will be returned.</p></li>
</section>
<section id="array-has-any">
<h3><code class="docutils literal notranslate"><span
class="pre">array_has_any</span></code><a class="headerlink"
href="#array-has-any" title="Link to this heading">¶</a></h3>
-<p>Returns true if the array contains the element.</p>
-<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>
+<p>Returns true if any elements exist in both arrays.</p>
+<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="id192">
<h4>Arguments<a class="headerlink" href="#id192" 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>: Scalar or Array expression. Can be a
constant, column, or function, and any combination of array operators.</p></li>
+<li><p><strong>sub-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>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">array_has</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><span class="p">],</span><span class="w"> </span><span
class="mi">2</span><span [...]
-<span class="o">+</span><span class="c1">-----------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">array_has</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="w"> </span><span
class="mi">2</span><span class="p">)</span><span class="w"> </span><span
class="o">|</span>
-<span class="o">+</span><span class="c1">-----------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="k">true</span><span class="w"> </span><span
class="o">|</span>
-<span class="o">+</span><span class="c1">-----------------------------+</span>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">array_has_any</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><span class="p">],</span><span class="w"> </span><span
class="p">[</span><sp [...]
+<span class="o">+</span><span
class="c1">------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">array_has_any</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="w"> </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 c
[...]
+<span class="o">+</span><span
class="c1">------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="k">true</span><span class="w">
</span><span class="o">|</span>
+<span class="o">+</span><span
class="c1">------------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -7598,24 +7597,25 @@ an error will be returned.</p></li>
</section>
<section id="array-ndims">
<h3><code class="docutils literal notranslate"><span
class="pre">array_ndims</span></code><a class="headerlink" href="#array-ndims"
title="Link to this heading">¶</a></h3>
-<p>Returns an array of the array’s dimensions.</p>
-<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>
+<p>Returns the number of dimensions of the array.</p>
+<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="id201">
<h4>Arguments<a class="headerlink" href="#id201" 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>: Array element.</p></li>
</ul>
</section>
<section id="id202">
<h4>Example<a class="headerlink" href="#id202" title="Link to this
heading">¶</a></h4>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">array_dims</span><span class="p">([[</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><span class="p">],</span><span class="w"> </span><span
class="p">[</span><span [...]
-<span class="o">+</span><span
class="c1">---------------------------------+</span>
-<span class="o">|</span><span class="w"> </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="w"> </span><span
class="o" [...]
-<span class="o">+</span><span
class="c1">---------------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span class="p">[</span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><span class="p">]</span><span class="w">
</span><span class="o">|</span>
-<span class="o">+</span><span
class="c1">---------------------------------+</span>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">array_ndims</span><span class="p">([[</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><span class="p">],</span><span class="w"> </span><span
class="p">[</span><spa [...]
+<span class="o">+</span><span
class="c1">----------------------------------+</span>
+<span class="o">|</span><span class="w"> </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="w"> </span><span
class="o [...]
+<span class="o">+</span><span
class="c1">----------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">2</span><span
class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span
class="c1">----------------------------------+</span>
</pre></div>
</div>
</section>
@@ -7628,25 +7628,24 @@ an error will be returned.</p></li>
</section>
<section id="array-pop-back">
<h3><code class="docutils literal notranslate"><span
class="pre">array_pop_back</span></code><a class="headerlink"
href="#array-pop-back" title="Link to this heading">¶</a></h3>
-<p>Extracts the element with the index n from the array.</p>
-<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>
+<p>Returns the array without the last element.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_pop_back</span><span
class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
<section id="id204">
<h4>Arguments<a class="headerlink" href="#id204" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression. Can be a constant, column, or
function, and any combination of array operators.</p></li>
-<li><p><strong>index</strong>: Index to extract the element from the
array.</p></li>
</ul>
</section>
<section id="id205">
<h4>Example<a class="headerlink" href="#id205" title="Link to this
heading">¶</a></h4>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">array_element</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><span class="p">,</span><span class="w"> </span><span
class="mi">4</span><sp [...]
-<span class="o">+</span><span
class="c1">-----------------------------------------+</span>
-<span class="o">|</span><span class="w"> </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="w"> </span><span cl
[...]
-<span class="o">+</span><span
class="c1">-----------------------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span class="mi">3</span><span
class="w"> </span><span class="o">|</span>
-<span class="o">+</span><span
class="c1">-----------------------------------------+</span>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">array_pop_back</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><span class="p">]);</span>
+<span class="o">+</span><span
class="c1">-------------------------------+</span>
+<span class="o">|</span><span class="w"> </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="w"> </span><span
class="o">|</span>
+<span class="o">+</span><span
class="c1">-------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="p">[</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">]</span><span class="w">
</span><span class="o">|</span>
+<span class="o">+</span><span
class="c1">-------------------------------+</span>
</pre></div>
</div>
</section>
@@ -7659,25 +7658,24 @@ an error will be returned.</p></li>
</section>
<section id="array-pop-front">
<h3><code class="docutils literal notranslate"><span
class="pre">array_pop_front</span></code><a class="headerlink"
href="#array-pop-front" title="Link to this heading">¶</a></h3>
-<p>Extracts the element with the index n from the array.</p>
-<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>
+<p>Returns the array without the first element.</p>
+<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="id207">
<h4>Arguments<a class="headerlink" href="#id207" 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="id208">
<h4>Example<a class="headerlink" href="#id208" title="Link to this
heading">¶</a></h4>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">array_element</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><span class="p">,</span><span class="w"> </span><span
class="mi">4</span><sp [...]
-<span class="o">+</span><span
class="c1">-----------------------------------------+</span>
-<span class="o">|</span><span class="w"> </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="w"> </span><span cl
[...]
-<span class="o">+</span><span
class="c1">-----------------------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span class="mi">3</span><span
class="w"> </span><span class="o">|</span>
-<span class="o">+</span><span
class="c1">-----------------------------------------+</span>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">array_pop_front</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><span class="p">]);</span>
+<span class="o">+</span><span
class="c1">-------------------------------+</span>
+<span class="o">|</span><span class="w"> </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="w"> </span><span
class="o">|</span>
+<span class="o">+</span><span
class="c1">-------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="p">[</span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><span class="p">]</span><span class="w">
</span><span class="o">|</span>
+<span class="o">+</span><span
class="c1">-------------------------------+</span>
</pre></div>
</div>
</section>
@@ -7777,8 +7775,8 @@ an error will be returned.</p></li>
<section id="id216">
<h4>Arguments<a class="headerlink" href="#id216" 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>
+<li><p><strong>element</strong>: Element to prepend to the array.</p></li>
</ul>
</section>
<section id="id217">
@@ -8102,25 +8100,27 @@ an error will be returned.</p></li>
</section>
<section id="array-slice">
<h3><code class="docutils literal notranslate"><span
class="pre">array_slice</span></code><a class="headerlink" href="#array-slice"
title="Link to this heading">¶</a></h3>
-<p>Extracts the element with the index n from the array.</p>
-<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>
+<p>Returns a slice of the array based on 1-indexed start and end positions.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_slice</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">begin</span><span class="p">,</span> <span class="n">end</span><span
class="p">)</span>
</pre></div>
</div>
<section id="id246">
<h4>Arguments<a class="headerlink" href="#id246" 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>
+<li><p><strong>begin</strong>: Index of the first element. If negative, it
counts backward from the end of the array.</p></li>
+<li><p><strong>end</strong>: Index of the last element. If negative, it counts
backward from the end of the array.</p></li>
+<li><p><strong>stride</strong>: Stride of the array slice. The default is
1.</p></li>
</ul>
</section>
<section id="id247">
<h4>Example<a class="headerlink" href="#id247" title="Link to this
heading">¶</a></h4>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">array_element</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><span class="p">,</span><span class="w"> </span><span
class="mi">4</span><sp [...]
-<span class="o">+</span><span
class="c1">-----------------------------------------+</span>
-<span class="o">|</span><span class="w"> </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="w"> </span><span cl
[...]
-<span class="o">+</span><span
class="c1">-----------------------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span class="mi">3</span><span
class="w"> </span><span class="o">|</span>
-<span class="o">+</span><span
class="c1">-----------------------------------------+</span>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="n">array_slice</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><span class="p">,</span><span class="w"> </span><span
class="mi">4</span><span [...]
+<span class="o">+</span><span
class="c1">--------------------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </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 class="o">+</span><span
class="c1">--------------------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="p">[</span><span
class="mi">3</span><span class="p">,</span><span class="w"> </span><span
class="mi">4</span><span class="p">,</span><span class="w"> </span><span
class="mi">5</span><span class="p">,</span><span class="w"> </span><span
class="mi">6</span><span class="p">]</span><span class="w">
</span><span class="o">|</span>
+<span class="o">+</span><span
class="c1">--------------------------------------------------------+</span>
</pre></div>
</div>
</section>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
