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 c6f7fffb4c Publish built docs triggered by
2d86725d294d7f8bd832cff036b794808086400a
c6f7fffb4c is described below
commit c6f7fffb4cb9cd4fb476603855be652feb8f22d2
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Thu Nov 14 00:03:23 2024 +0000
Publish built docs triggered by 2d86725d294d7f8bd832cff036b794808086400a
---
_sources/user-guide/sql/scalar_functions.md.txt | 30 ++++++++++++++++---------
searchindex.js | 2 +-
user-guide/sql/scalar_functions.html | 30 ++++++++++++++++---------
3 files changed, 39 insertions(+), 23 deletions(-)
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index 74e7285b76..a379dfc9ec 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -3469,13 +3469,14 @@ array_sort(array, desc, nulls_first)
Converts each element to its text representation.
```
-array_to_string(array, delimiter)
+array_to_string(array, delimiter[, null_string])
```
#### Arguments
- **array**: Array expression. Can be a constant, column, or function, and any
combination of array operators.
- **delimiter**: Array element separator.
+- **null_string**: Optional. String to replace null values in the array. If
not provided, nulls will be handled by default behavior.
#### Example
@@ -3850,26 +3851,33 @@ range(start, stop, step)
### `string_to_array`
-Converts each element to its text representation.
+Splits a string into an array of substrings based on a delimiter. Any
substrings matching the optional `null_str` argument are replaced with NULL.
```
-array_to_string(array, delimiter)
+string_to_array(str, delimiter[, null_str])
```
#### Arguments
-- **array**: Array expression. Can be a constant, column, or function, and any
combination of array operators.
-- **delimiter**: Array element separator.
+- **str**: String expression to split.
+- **delimiter**: Delimiter string to split on.
+- **null_str**: Substring values to be replaced with `NULL`.
#### Example
```sql
-> select array_to_string([[1, 2, 3, 4], [5, 6, 7, 8]], ',');
-+----------------------------------------------------+
-| array_to_string(List([1,2,3,4,5,6,7,8]),Utf8(",")) |
-+----------------------------------------------------+
-| 1,2,3,4,5,6,7,8 |
-+----------------------------------------------------+
+> select string_to_array('abc##def', '##');
++-----------------------------------+
+| string_to_array(Utf8('abc##def')) |
++-----------------------------------+
+| ['abc', 'def'] |
++-----------------------------------+
+> select string_to_array('abc def', ' ', 'def');
++---------------------------------------------+
+| string_to_array(Utf8('abc def'), Utf8(' '), Utf8('def')) |
++---------------------------------------------+
+| ['abc', NULL] |
++---------------------------------------------+
```
#### Aliases
diff --git a/searchindex.js b/searchindex.js
index e39cf8b5ec..06dc4ffa56 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 010a2c4e82..64e1c4e3a8 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -8074,7 +8074,7 @@ an error will be returned.</p></li>
<section id="array-to-string">
<h3><code class="docutils literal notranslate"><span
class="pre">array_to_string</span></code><a class="headerlink"
href="#array-to-string" title="Link to this heading">¶</a></h3>
<p>Converts each element to its text representation.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_to_string</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">delimiter</span><span class="p">)</span>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_to_string</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">delimiter</span><span class="p">[,</span> <span
class="n">null_string</span><span class="p">])</span>
</pre></div>
</div>
<section id="id248">
@@ -8082,6 +8082,7 @@ 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>delimiter</strong>: Array element separator.</p></li>
+<li><p><strong>null_string</strong>: Optional. String to replace null values
in the array. If not provided, nulls will be handled by default
behavior.</p></li>
</ul>
</section>
<section id="id249">
@@ -8473,25 +8474,32 @@ an error will be returned.</p></li>
</section>
<section id="string-to-array">
<h3><code class="docutils literal notranslate"><span
class="pre">string_to_array</span></code><a class="headerlink"
href="#string-to-array" title="Link to this heading">¶</a></h3>
-<p>Converts each element to its text representation.</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">array_to_string</span><span
class="p">(</span><span class="n">array</span><span class="p">,</span> <span
class="n">delimiter</span><span class="p">)</span>
+<p>Splits a string into an array of substrings based on a delimiter. Any
substrings matching the optional <code class="docutils literal
notranslate"><span class="pre">null_str</span></code> argument are replaced
with NULL.</p>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">string_to_array</span><span
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span
class="n">delimiter</span><span class="p">[,</span> <span
class="n">null_str</span><span class="p">])</span>
</pre></div>
</div>
<section id="id268">
<h4>Arguments<a class="headerlink" href="#id268" title="Link to this
heading">¶</a></h4>
<ul class="simple">
-<li><p><strong>array</strong>: Array expression. Can be a constant, column, or
function, and any combination of array operators.</p></li>
-<li><p><strong>delimiter</strong>: Array element separator.</p></li>
+<li><p><strong>str</strong>: String expression to split.</p></li>
+<li><p><strong>delimiter</strong>: Delimiter string to split on.</p></li>
+<li><p><strong>null_str</strong>: Substring values to be replaced with <code
class="docutils literal notranslate"><span
class="pre">NULL</span></code>.</p></li>
</ul>
</section>
<section id="id269">
<h4>Example<a class="headerlink" href="#id269" 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_to_string</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_to_string</span><span class="p">(</span><span
class="n">List</span><span class="p">([</span><span class="mi">1</span><span
class="p">,</span><span class="mi">2</span><span class="p">,</span><span
class="mi">3</span><span class="p">,</span><span class="mi">4</span><span
class="p">,</span><span class="mi">5</span><span class="p">,</span><span
class="mi">6</span><span class="p">,</span><span class="mi">7</span><span class
[...]
-<span class="o">+</span><span
class="c1">----------------------------------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span class="mi">1</span><span
class="p">,</span><span class="mi">2</span><span class="p">,</span><span
class="mi">3</span><span class="p">,</span><span class="mi">4</span><span
class="p">,</span><span class="mi">5</span><span class="p">,</span><span
class="mi">6</span><span class="p">,</span><span class="mi">7</span><span
class="p">,</span><span class="mi">8</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">string_to_array</span><span class="p">(</span><span
class="s1">'abc##def'</span><span class="p">,</span><span class="w">
</span><span class="s1">'##'</span><span class="p">);</span>
+<span class="o">+</span><span
class="c1">-----------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">string_to_array</span><span class="p">(</span><span
class="n">Utf8</span><span class="p">(</span><span
class="s1">'abc##def'</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="s1">'abc'</span><span class="p">,</span><span class="w">
</span><span class="s1">'def'</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">string_to_array</span><span class="p">(</span><span
class="s1">'abc def'</span><span class="p">,</span><span class="w">
</span><span class="s1">' '</span><span class="p">,</span><span
class="w"> </span><span class="s1">'def'</span><span class="p">);</span>
+<span class="o">+</span><span
class="c1">---------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">string_to_array</span><span class="p">(</span><span
class="n">Utf8</span><span class="p">(</span><span class="s1">'abc
def'</span><span class="p">),</span><span class="w"> </span><span
class="n">Utf8</span><span class="p">(</span><span class="s1">'
'</span><span class="p">),</span><span class="w"> </span><span
class="n">Utf8</span><span class="p">(</span><span
class="s1">'def'</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="s1">'abc'</span><span class="p">,</span><span class="w">
</span><span class="k">NULL</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]
