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 1c049532ec Publish built docs triggered by
2b4e2003e15d372b7e6aa414e768c44cab5b8e2e
1c049532ec is described below
commit 1c049532ecf93eaf7715e788bbcbb3d9dd424deb
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Sun Dec 29 19:26:04 2024 +0000
Publish built docs triggered by 2b4e2003e15d372b7e6aa414e768c44cab5b8e2e
---
_sources/user-guide/sql/scalar_functions.md.txt | 123 +++++++++++++-----------
searchindex.js | 2 +-
user-guide/sql/scalar_functions.html | 123 +++++++++++++-----------
3 files changed, 137 insertions(+), 111 deletions(-)
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index 79fe440f37..4cf5ff4b71 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -2936,25 +2936,32 @@ _Alias of [array_position](#array_position)._
### `array_intersect`
-Returns distinct values from the array after removing duplicates.
+Returns an array of elements in the intersection of array1 and array2.
```
-array_distinct(array)
+array_intersect(array1, array2)
```
#### Arguments
-- **array**: Array expression. Can be a constant, column, or function, and any
combination of array operators.
+- **array1**: Array expression. Can be a constant, column, or function, and
any combination of array operators.
+- **array2**: Array expression. Can be a constant, column, or function, and
any combination of array operators.
#### Example
```sql
-> select array_distinct([1, 3, 2, 3, 1, 2, 4]);
-+---------------------------------+
-| array_distinct(List([1,2,3,4])) |
-+---------------------------------+
-| [1, 2, 3, 4] |
-+---------------------------------+
+> select array_intersect([1, 2, 3, 4], [5, 6, 3, 4]);
++----------------------------------------------------+
+| array_intersect([1, 2, 3, 4], [5, 6, 3, 4]); |
++----------------------------------------------------+
+| [3, 4] |
++----------------------------------------------------+
+> select array_intersect([1, 2, 3, 4], [5, 6, 7, 8]);
++----------------------------------------------------+
+| array_intersect([1, 2, 3, 4], [5, 6, 7, 8]); |
++----------------------------------------------------+
+| [] |
++----------------------------------------------------+
```
#### Aliases
@@ -3217,10 +3224,10 @@ array_remove(array, element)
### `array_remove_all`
-Removes the first element from the array equal to the given value.
+Removes all elements from the array equal to the given value.
```
-array_remove(array, element)
+array_remove_all(array, element)
```
#### Arguments
@@ -3231,12 +3238,12 @@ array_remove(array, element)
#### Example
```sql
-> select array_remove([1, 2, 2, 3, 2, 1, 4], 2);
-+----------------------------------------------+
-| array_remove(List([1,2,2,3,2,1,4]),Int64(2)) |
-+----------------------------------------------+
-| [1, 2, 3, 2, 1, 4] |
-+----------------------------------------------+
+> select array_remove_all([1, 2, 2, 3, 2, 1, 4], 2);
++--------------------------------------------------+
+| array_remove_all(List([1,2,2,3,2,1,4]),Int64(2)) |
++--------------------------------------------------+
+| [1, 3, 1, 4] |
++--------------------------------------------------+
```
#### Aliases
@@ -3245,26 +3252,27 @@ array_remove(array, element)
### `array_remove_n`
-Removes the first element from the array equal to the given value.
+Removes the first `max` elements from the array equal to the given value.
```
-array_remove(array, element)
+array_remove_n(array, element, max))
```
#### Arguments
- **array**: Array expression. Can be a constant, column, or function, and any
combination of array operators.
- **element**: Element to be removed from the array.
+- **max**: Number of first occurrences to remove.
#### Example
```sql
-> select array_remove([1, 2, 2, 3, 2, 1, 4], 2);
-+----------------------------------------------+
-| array_remove(List([1,2,2,3,2,1,4]),Int64(2)) |
-+----------------------------------------------+
-| [1, 2, 3, 2, 1, 4] |
-+----------------------------------------------+
+> select array_remove_n([1, 2, 2, 3, 2, 1, 4], 2, 2);
++---------------------------------------------------------+
+| array_remove_n(List([1,2,2,3,2,1,4]),Int64(2),Int64(2)) |
++---------------------------------------------------------+
+| [1, 3, 2, 1, 4] |
++---------------------------------------------------------+
```
#### Aliases
@@ -3307,10 +3315,10 @@ array_repeat(element, count)
### `array_replace`
-Replaces the first `max` occurrences of the specified element with another
specified element.
+Replaces the first occurrence of the specified element with another specified
element.
```
-array_replace_n(array, from, to, max)
+array_replace(array, from, to)
```
#### Arguments
@@ -3318,17 +3326,16 @@ array_replace_n(array, from, to, max)
- **array**: Array expression. Can be a constant, column, or function, and any
combination of array operators.
- **from**: Initial element.
- **to**: Final element.
-- **max**: Number of first occurrences to replace.
#### Example
```sql
-> select array_replace_n([1, 2, 2, 3, 2, 1, 4], 2, 5, 2);
-+-------------------------------------------------------------------+
-| array_replace_n(List([1,2,2,3,2,1,4]),Int64(2),Int64(5),Int64(2)) |
-+-------------------------------------------------------------------+
-| [1, 5, 5, 3, 2, 1, 4] |
-+-------------------------------------------------------------------+
+> select array_replace([1, 2, 2, 3, 2, 1, 4], 2, 5);
++--------------------------------------------------------+
+| array_replace(List([1,2,2,3,2,1,4]),Int64(2),Int64(5)) |
++--------------------------------------------------------+
+| [1, 5, 2, 3, 2, 1, 4] |
++--------------------------------------------------------+
```
#### Aliases
@@ -3337,10 +3344,10 @@ array_replace_n(array, from, to, max)
### `array_replace_all`
-Replaces the first `max` occurrences of the specified element with another
specified element.
+Replaces all occurrences of the specified element with another specified
element.
```
-array_replace_n(array, from, to, max)
+array_replace_all(array, from, to)
```
#### Arguments
@@ -3348,17 +3355,16 @@ array_replace_n(array, from, to, max)
- **array**: Array expression. Can be a constant, column, or function, and any
combination of array operators.
- **from**: Initial element.
- **to**: Final element.
-- **max**: Number of first occurrences to replace.
#### Example
```sql
-> select array_replace_n([1, 2, 2, 3, 2, 1, 4], 2, 5, 2);
-+-------------------------------------------------------------------+
-| array_replace_n(List([1,2,2,3,2,1,4]),Int64(2),Int64(5),Int64(2)) |
-+-------------------------------------------------------------------+
-| [1, 5, 5, 3, 2, 1, 4] |
-+-------------------------------------------------------------------+
+> select array_replace_all([1, 2, 2, 3, 2, 1, 4], 2, 5);
++------------------------------------------------------------+
+| array_replace_all(List([1,2,2,3,2,1,4]),Int64(2),Int64(5)) |
++------------------------------------------------------------+
+| [1, 5, 5, 3, 5, 1, 4] |
++------------------------------------------------------------+
```
#### Aliases
@@ -3543,25 +3549,32 @@ array_to_string(array, delimiter[, null_string])
### `array_union`
-Returns distinct values from the array after removing duplicates.
+Returns an array of elements that are present in both arrays (all elements
from both arrays) with out duplicates.
```
-array_distinct(array)
+array_union(array1, array2)
```
#### Arguments
-- **array**: Array expression. Can be a constant, column, or function, and any
combination of array operators.
+- **array1**: Array expression. Can be a constant, column, or function, and
any combination of array operators.
+- **array2**: Array expression. Can be a constant, column, or function, and
any combination of array operators.
#### Example
```sql
-> select array_distinct([1, 3, 2, 3, 1, 2, 4]);
-+---------------------------------+
-| array_distinct(List([1,2,3,4])) |
-+---------------------------------+
-| [1, 2, 3, 4] |
-+---------------------------------+
+> select array_union([1, 2, 3, 4], [5, 6, 3, 4]);
++----------------------------------------------------+
+| array_union([1, 2, 3, 4], [5, 6, 3, 4]); |
++----------------------------------------------------+
+| [1, 2, 3, 4, 5, 6] |
++----------------------------------------------------+
+> select array_union([1, 2, 3, 4], [5, 6, 7, 8]);
++----------------------------------------------------+
+| array_union([1, 2, 3, 4], [5, 6, 7, 8]); |
++----------------------------------------------------+
+| [1, 2, 3, 4, 5, 6, 7, 8] |
++----------------------------------------------------+
```
#### Aliases
@@ -3657,9 +3670,9 @@ generate_series(start, stop, step)
#### Arguments
-- **start**: start of the series. Ints, timestamps, dates or string types that
can be coerced to Date32 are supported.
-- **end**: end of the series (included). Type must be the same as start.
-- **step**: increase by step (can not be 0). Steps less than a day are
supported only for timestamp ranges.
+- **start**: Start of the series. Ints, timestamps, dates or string types that
can be coerced to Date32 are supported.
+- **end**: End of the series (included). Type must be the same as start.
+- **step**: Increase by step (can not be 0). Steps less than a day are
supported only for timestamp ranges.
#### Example
diff --git a/searchindex.js b/searchindex.js
index e4038acdaa..6c8d691380 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 98c4ac9a75..7a17721d06 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -7532,24 +7532,31 @@ an error will be returned.</p></li>
</section>
<section id="array-intersect">
<h3><code class="docutils literal notranslate"><span
class="pre">array_intersect</span></code><a class="headerlink"
href="#array-intersect" title="Link to this heading">¶</a></h3>
-<p>Returns distinct values from the array after removing duplicates.</p>
-<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>
+<p>Returns an array of elements in the intersection of array1 and array2.</p>
+<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="id195">
<h4>Arguments<a class="headerlink" href="#id195" title="Link to this
heading">¶</a></h4>
<ul class="simple">
-<li><p><strong>array</strong>: Array expression. Can be a constant, column, or
function, and any combination of array operators.</p></li>
+<li><p><strong>array1</strong>: Array expression. Can be a constant, column,
or function, and any combination of array operators.</p></li>
+<li><p><strong>array2</strong>: Array expression. Can be a constant, column,
or function, and any combination of array operators.</p></li>
</ul>
</section>
<section id="id196">
<h4>Example<a class="headerlink" href="#id196" 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_distinct</span><span class="p">([</span><span
class="mi">1</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 class="p">,</span><span class="w"> </span><span
class="mi">3</span><s [...]
-<span class="o">+</span><span
class="c1">---------------------------------+</span>
-<span class="o">|</span><span class="w"> </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="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_intersect</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="o">+</span><span
class="c1">----------------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">array_intersect</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="p">[</span><span class="mi">5</span><span class="p">,</span><span
class="w" [...]
+<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="o">|</span>
+<span class="o">+</span><span
class="c1">----------------------------------------------------+</span>
+<span class="o">></span><span class="w"> </span><span
class="k">select</span><span class="w"> </span><span
class="n">array_intersect</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="p">[</span><span cl [...]
+<span class="o">+</span><span
class="c1">----------------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">array_intersect</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="p">[</span><span class="mi">5</span><span class="p">,</span><span
class="w" [...]
+<span class="o">+</span><span
class="c1">----------------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </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>
@@ -7840,8 +7847,8 @@ an error will be returned.</p></li>
</section>
<section id="array-remove-all">
<h3><code class="docutils literal notranslate"><span
class="pre">array_remove_all</span></code><a class="headerlink"
href="#array-remove-all" title="Link to this heading">¶</a></h3>
-<p>Removes the first element from the array equal to the given value.</p>
-<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>
+<p>Removes all elements from the array equal to the given value.</p>
+<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="id222">
@@ -7853,12 +7860,12 @@ an error will be returned.</p></li>
</section>
<section id="id223">
<h4>Example<a class="headerlink" href="#id223" 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_remove</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">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><spa [...]
-<span class="o">+</span><span
class="c1">----------------------------------------------+</span>
-<span class="o">|</span><span class="w"> </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 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">2</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">4</span><span class="p">]</span><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_remove_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">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_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 clas
[...]
+<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">3</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">4</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>
@@ -7871,8 +7878,8 @@ an error will be returned.</p></li>
</section>
<section id="array-remove-n">
<h3><code class="docutils literal notranslate"><span
class="pre">array_remove_n</span></code><a class="headerlink"
href="#array-remove-n" title="Link to this heading">¶</a></h3>
-<p>Removes the first element from the array equal to the given value.</p>
-<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>
+<p>Removes the first <code class="docutils literal notranslate"><span
class="pre">max</span></code> elements from the array equal to the given
value.</p>
+<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="id225">
@@ -7880,16 +7887,17 @@ an error will be returned.</p></li>
<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>
+<li><p><strong>max</strong>: Number of first occurrences to remove.</p></li>
</ul>
</section>
<section id="id226">
<h4>Example<a class="headerlink" href="#id226" 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_remove</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">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><spa [...]
-<span class="o">+</span><span
class="c1">----------------------------------------------+</span>
-<span class="o">|</span><span class="w"> </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 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">2</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">4</span><span class="p">]</span><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_remove_n</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">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><s [...]
+<span class="o">+</span><span
class="c1">---------------------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </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= [...]
+<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">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="mi">1</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 class="o">+</span><span
class="c1">---------------------------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -7939,8 +7947,8 @@ an error will be returned.</p></li>
</section>
<section id="array-replace">
<h3><code class="docutils literal notranslate"><span
class="pre">array_replace</span></code><a class="headerlink"
href="#array-replace" title="Link to this heading">¶</a></h3>
-<p>Replaces the first <code class="docutils literal notranslate"><span
class="pre">max</span></code> occurrences of the specified element with another
specified element.</p>
-<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>
+<p>Replaces the first occurrence of the specified element with another
specified element.</p>
+<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="id231">
@@ -7949,17 +7957,16 @@ an error will be returned.</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>from</strong>: Initial element.</p></li>
<li><p><strong>to</strong>: Final element.</p></li>
-<li><p><strong>max</strong>: Number of first occurrences to replace.</p></li>
</ul>
</section>
<section id="id232">
<h4>Example<a class="headerlink" href="#id232" 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_replace_n</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">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_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
[...]
-<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">5</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">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="mi">1</span><span class="p">,</span><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_replace</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">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><sp [...]
+<span class="o">+</span><span
class="c1">--------------------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </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=" [...]
+<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">5</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 class="p">,</span><span class="w"> </span><span
class="mi">1</span><span class="p">,</span><span [...]
+<span class="o">+</span><span
class="c1">--------------------------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -7972,8 +7979,8 @@ an error will be returned.</p></li>
</section>
<section id="array-replace-all">
<h3><code class="docutils literal notranslate"><span
class="pre">array_replace_all</span></code><a class="headerlink"
href="#array-replace-all" title="Link to this heading">¶</a></h3>
-<p>Replaces the first <code class="docutils literal notranslate"><span
class="pre">max</span></code> occurrences of the specified element with another
specified element.</p>
-<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>
+<p>Replaces all occurrences of the specified element with another specified
element.</p>
+<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="id234">
@@ -7982,17 +7989,16 @@ an error will be returned.</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>from</strong>: Initial element.</p></li>
<li><p><strong>to</strong>: Final element.</p></li>
-<li><p><strong>max</strong>: Number of first occurrences to replace.</p></li>
</ul>
</section>
<section id="id235">
<h4>Example<a class="headerlink" href="#id235" 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_replace_n</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">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_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
[...]
-<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">5</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">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="mi">1</span><span class="p">,</span><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_replace_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">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_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 cla
[...]
+<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">5</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">3</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">1</span><span class="p">,</span><span [...]
+<span class="o">+</span><span
class="c1">------------------------------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -8199,24 +8205,31 @@ an error will be returned.</p></li>
</section>
<section id="array-union">
<h3><code class="docutils literal notranslate"><span
class="pre">array_union</span></code><a class="headerlink" href="#array-union"
title="Link to this heading">¶</a></h3>
-<p>Returns distinct values from the array after removing duplicates.</p>
-<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>
+<p>Returns an array of elements that are present in both arrays (all elements
from both arrays) with out duplicates.</p>
+<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="id255">
<h4>Arguments<a class="headerlink" href="#id255" 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>array1</strong>: Array expression. Can be a constant, column,
or function, and any combination of array operators.</p></li>
+<li><p><strong>array2</strong>: Array expression. Can be a constant, column,
or function, and any combination of array operators.</p></li>
</ul>
</section>
<section id="id256">
<h4>Example<a class="headerlink" href="#id256" 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_distinct</span><span class="p">([</span><span
class="mi">1</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 class="p">,</span><span class="w"> </span><span
class="mi">3</span><s [...]
-<span class="o">+</span><span
class="c1">---------------------------------+</span>
-<span class="o">|</span><span class="w"> </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="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_union</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_union</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="p">[</span><span class="mi">5</span><span class="p">,</span><span
class="w"> </ [...]
+<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>
+<span class="o">></span><span class="w"> </span><span
class="k">select</span><span class="w"> </span><span
class="n">array_union</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="p">[</span><span class= [...]
+<span class="o">+</span><span
class="c1">----------------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">array_union</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="p">[</span><span class="mi">5</span><span class="p">,</span><span
class="w"> </ [...]
+<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>
@@ -8320,9 +8333,9 @@ an error will be returned.</p></li>
<section id="id265">
<h4>Arguments<a class="headerlink" href="#id265" title="Link to this
heading">¶</a></h4>
<ul class="simple">
-<li><p><strong>start</strong>: start of the series. Ints, timestamps, dates or
string types that can be coerced to Date32 are supported.</p></li>
-<li><p><strong>end</strong>: end of the series (included). Type must be the
same as start.</p></li>
-<li><p><strong>step</strong>: increase by step (can not be 0). Steps less than
a day are supported only for timestamp ranges.</p></li>
+<li><p><strong>start</strong>: Start of the series. Ints, timestamps, dates or
string types that can be coerced to Date32 are supported.</p></li>
+<li><p><strong>end</strong>: End of the series (included). Type must be the
same as start.</p></li>
+<li><p><strong>step</strong>: Increase by step (can not be 0). Steps less than
a day are supported only for timestamp ranges.</p></li>
</ul>
</section>
<section id="id266">
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
