This is an automated email from the ASF dual-hosted git repository.

github-bot pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/arrow-datafusion.git


The following commit(s) were added to refs/heads/asf-site by this push:
     new ac5d40f5c1 Publish built docs triggered by 
a6ff1fe6a323d24e36e6845525ed7c7d5e9cec3e
ac5d40f5c1 is described below

commit ac5d40f5c16e4a9329c09afe5b89fcc770595bed
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Tue Apr 2 21:21:37 2024 +0000

    Publish built docs triggered by a6ff1fe6a323d24e36e6845525ed7c7d5e9cec3e
---
 _sources/user-guide/sql/scalar_functions.md.txt | 10 +++++++
 user-guide/sql/scalar_functions.html            | 38 ++++++++++++++++---------
 2 files changed, 34 insertions(+), 14 deletions(-)

diff --git a/_sources/user-guide/sql/scalar_functions.md.txt 
b/_sources/user-guide/sql/scalar_functions.md.txt
index e2e129a2e2..62b81ea7ea 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -3336,6 +3336,16 @@ select * from t;
 | 3 | 4 |
 +---+---+
 
+-- use default names `c0`, `c1`
+❯ select struct(a, b) from t;
++-----------------+
+| struct(t.a,t.b) |
++-----------------+
+| {c0: 1, c1: 2}  |
+| {c0: 3, c1: 4}  |
++-----------------+
+
+-- name the first field `field_a`
 select struct(a as field_a, b) from t;
 +--------------------------------------------------+
 | named_struct(Utf8("field_a"),t.a,Utf8("c1"),t.b) |
diff --git a/user-guide/sql/scalar_functions.html 
b/user-guide/sql/scalar_functions.html
index 3ffbb5eb97..070e90f38b 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -7113,21 +7113,31 @@ For example: <code class="docutils literal 
notranslate"><span class="pre">c0</sp
 </div>
 <p>For example, this query converts two columns <code class="docutils literal 
notranslate"><span class="pre">a</span></code> and <code class="docutils 
literal notranslate"><span class="pre">b</span></code> to a single column with
 a struct type of fields <code class="docutils literal notranslate"><span 
class="pre">field_a</span></code> and <code class="docutils literal 
notranslate"><span class="pre">c1</span></code>:</p>
-<div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">select</span> <span 
class="o">*</span> <span class="kn">from</span> <span class="nn">t</span><span 
class="p">;</span>
-<span class="o">+---+---+</span>
-<span class="o">|</span> <span class="n">a</span> <span class="o">|</span> 
<span class="n">b</span> <span class="o">|</span>
-<span class="o">+---+---+</span>
-<span class="o">|</span> <span class="mi">1</span> <span class="o">|</span> 
<span class="mi">2</span> <span class="o">|</span>
-<span class="o">|</span> <span class="mi">3</span> <span class="o">|</span> 
<span class="mi">4</span> <span class="o">|</span>
-<span class="o">+---+---+</span>
+<div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>select * from t;
++---+---+
+| a | b |
++---+---+
+| 1 | 2 |
+| 3 | 4 |
++---+---+
+
+-- use default names `c0`, `c1`
+❯ select struct(a, b) from t;
++-----------------+
+| struct(t.a,t.b) |
++-----------------+
+| {c0: 1, c1: 2}  |
+| {c0: 3, c1: 4}  |
++-----------------+
 
-<span class="n">select</span> <span class="n">struct</span><span 
class="p">(</span><span class="n">a</span> <span class="k">as</span> <span 
class="n">field_a</span><span class="p">,</span> <span class="n">b</span><span 
class="p">)</span> <span class="kn">from</span> <span class="nn">t</span><span 
class="p">;</span>
-<span class="o">+--------------------------------------------------+</span>
-<span class="o">|</span> <span class="n">named_struct</span><span 
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span 
class="s2">&quot;field_a&quot;</span><span class="p">),</span><span 
class="n">t</span><span class="o">.</span><span class="n">a</span><span 
class="p">,</span><span class="n">Utf8</span><span class="p">(</span><span 
class="s2">&quot;c1&quot;</span><span class="p">),</span><span 
class="n">t</span><span class="o">.</span><span class="n">b</span><span c [...]
-<span class="o">+--------------------------------------------------+</span>
-<span class="o">|</span> <span class="p">{</span><span 
class="n">field_a</span><span class="p">:</span> <span class="mi">1</span><span 
class="p">,</span> <span class="n">c1</span><span class="p">:</span> <span 
class="mi">2</span><span class="p">}</span>                              <span 
class="o">|</span>
-<span class="o">|</span> <span class="p">{</span><span 
class="n">field_a</span><span class="p">:</span> <span class="mi">3</span><span 
class="p">,</span> <span class="n">c1</span><span class="p">:</span> <span 
class="mi">4</span><span class="p">}</span>                              <span 
class="o">|</span>
-<span class="o">+--------------------------------------------------+</span>
+-- name the first field `field_a`
+select struct(a as field_a, b) from t;
++--------------------------------------------------+
+| named_struct(Utf8(&quot;field_a&quot;),t.a,Utf8(&quot;c1&quot;),t.b) |
++--------------------------------------------------+
+| {field_a: 1, c1: 2}                              |
+| {field_a: 3, c1: 4}                              |
++--------------------------------------------------+
 </pre></div>
 </div>
 <section id="id207">

Reply via email to