(arrow-datafusion) branch asf-site updated: Publish built docs triggered by cbb2fd784655b24424cb811a5e215a522d1961b9

Mon, 13 Nov 2023 11:05:13 -0800 

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 83b6958474 Publish built docs triggered by 
cbb2fd784655b24424cb811a5e215a522d1961b9
83b6958474 is described below

commit 83b695847402098cfdd8ff8bc126294c519ce86a
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Mon Nov 13 19:03:07 2023 +0000

    Publish built docs triggered by cbb2fd784655b24424cb811a5e215a522d1961b9
---
 _sources/user-guide/expressions.md.txt          |   1 +
 _sources/user-guide/sql/scalar_functions.md.txt |  38 +++++
 searchindex.js                                  |   2 +-
 user-guide/expressions.html                     |   9 +-
 user-guide/sql/scalar_functions.html            | 192 ++++++++++++++++--------
 5 files changed, 175 insertions(+), 67 deletions(-)

diff --git a/_sources/user-guide/expressions.md.txt 
b/_sources/user-guide/expressions.md.txt
index 27384dccff..bec3ba9bb2 100644
--- a/_sources/user-guide/expressions.md.txt
+++ b/_sources/user-guide/expressions.md.txt
@@ -233,6 +233,7 @@ Unlike to some databases the math functions in Datafusion 
works the same way as
 | array_slice(array, index)             | Returns a slice of the array. 
`array_slice([1, 2, 3, 4, 5, 6, 7, 8], 3, 6) -> [3, 4, 5, 6]`                   
                                                           |
 | array_to_string(array, delimiter)     | Converts each element to its text 
representation. `array_to_string([1, 2, 3, 4], ',') -> 1,2,3,4`                 
                                                       |
 | array_intersect(array1, array2)       | Returns an array of the elements in 
the intersection of array1 and array2. `array_intersect([1, 2, 3, 4], [5, 6, 3, 
4]) -> [3, 4]`                                       |
+| array_union(array1, array2)           | Returns an array of the elements in 
the union of array1 and array2 without duplicates. `array_union([1, 2, 3, 4], 
[5, 6, 3, 4]) -> [1, 2, 3, 4, 5, 6]`                   |
 | cardinality(array)                    | Returns the total number of elements 
in the array. `cardinality([[1, 2, 3], [4, 5, 6]]) -> 6`                        
                                                    |
 | make_array(value1, [value2 [, ...]])  | Returns an Arrow array using the 
specified input expressions. `make_array(1, 2, 3) -> [1, 2, 3]`                 
                                                        |
 | trim_array(array, n)                  | Deprecated                           
                                                                                
                                                    |
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt 
b/_sources/user-guide/sql/scalar_functions.md.txt
index be05084fb2..2959e82024 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -2211,6 +2211,44 @@ array_to_string(array, delimiter)
 - list_join
 - list_to_string
 
+### `array_union`
+
+Returns an array of elements that are present in both arrays (all elements 
from both arrays) with out duplicates.
+
+```
+array_union(array1, array2)
+```
+
+#### Arguments
+
+- **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
+
+```
+❯ 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]                                 |
++----------------------------------------------------+
+```
+
+---
+
+#### Aliases
+
+- list_union
+
 ### `cardinality`
 
 Returns the total number of elements in the array.
diff --git a/searchindex.js b/searchindex.js
index 63de525e63..61627ec439 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"docnames": ["contributor-guide/architecture", 
"contributor-guide/communication", "contributor-guide/index", 
"contributor-guide/quarterly_roadmap", "contributor-guide/roadmap", 
"contributor-guide/specification/index", 
"contributor-guide/specification/invariants", 
"contributor-guide/specification/output-field-name-semantic", "index", 
"library-user-guide/adding-udfs", "library-user-guide/building-logical-plans", 
"library-user-guide/catalogs", "library-user-guide/custom-tab [...]
\ No newline at end of file
+Search.setIndex({"docnames": ["contributor-guide/architecture", 
"contributor-guide/communication", "contributor-guide/index", 
"contributor-guide/quarterly_roadmap", "contributor-guide/roadmap", 
"contributor-guide/specification/index", 
"contributor-guide/specification/invariants", 
"contributor-guide/specification/output-field-name-semantic", "index", 
"library-user-guide/adding-udfs", "library-user-guide/building-logical-plans", 
"library-user-guide/catalogs", "library-user-guide/custom-tab [...]
\ No newline at end of file
diff --git a/user-guide/expressions.html b/user-guide/expressions.html
index 9b78a170de..c1ffb6e063 100644
--- a/user-guide/expressions.html
+++ b/user-guide/expressions.html
@@ -985,13 +985,16 @@ but these operators always return a <code class="docutils 
literal notranslate"><
 <tr class="row-odd"><td><p>array_intersect(array1, array2)</p></td>
 <td><p>Returns an array of the elements in the intersection of array1 and 
array2. <code class="docutils literal notranslate"><span 
class="pre">array_intersect([1,</span> <span class="pre">2,</span> <span 
class="pre">3,</span> <span class="pre">4],</span> <span class="pre">[5,</span> 
<span class="pre">6,</span> <span class="pre">3,</span> <span 
class="pre">4])</span> <span class="pre">-&gt;</span> <span 
class="pre">[3,</span> <span class="pre">4]</span></code></p></td>
 </tr>
-<tr class="row-even"><td><p>cardinality(array)</p></td>
+<tr class="row-even"><td><p>array_union(array1, array2)</p></td>
+<td><p>Returns an array of the elements in the union of array1 and array2 
without duplicates. <code class="docutils literal notranslate"><span 
class="pre">array_union([1,</span> <span class="pre">2,</span> <span 
class="pre">3,</span> <span class="pre">4],</span> <span class="pre">[5,</span> 
<span class="pre">6,</span> <span class="pre">3,</span> <span 
class="pre">4])</span> <span class="pre">-&gt;</span> <span 
class="pre">[1,</span> <span class="pre">2,</span> <span class="pre">3,</span> 
[...]
+</tr>
+<tr class="row-odd"><td><p>cardinality(array)</p></td>
 <td><p>Returns the total number of elements in the array. <code 
class="docutils literal notranslate"><span class="pre">cardinality([[1,</span> 
<span class="pre">2,</span> <span class="pre">3],</span> <span 
class="pre">[4,</span> <span class="pre">5,</span> <span 
class="pre">6]])</span> <span class="pre">-&gt;</span> <span 
class="pre">6</span></code></p></td>
 </tr>
-<tr class="row-odd"><td><p>make_array(value1, [value2 [, …]])</p></td>
+<tr class="row-even"><td><p>make_array(value1, [value2 [, …]])</p></td>
 <td><p>Returns an Arrow array using the specified input expressions. <code 
class="docutils literal notranslate"><span class="pre">make_array(1,</span> 
<span class="pre">2,</span> <span class="pre">3)</span> <span 
class="pre">-&gt;</span> <span class="pre">[1,</span> <span 
class="pre">2,</span> <span class="pre">3]</span></code></p></td>
 </tr>
-<tr class="row-even"><td><p>trim_array(array, n)</p></td>
+<tr class="row-odd"><td><p>trim_array(array, n)</p></td>
 <td><p>Deprecated</p></td>
 </tr>
 </tbody>
diff --git a/user-guide/sql/scalar_functions.html 
b/user-guide/sql/scalar_functions.html
index cc90471aa9..39d285c2b0 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -2372,10 +2372,10 @@
     </ul>
    </li>
    <li class="toc-h3 nav-item toc-entry">
-    <a class="reference internal nav-link" href="#cardinality">
+    <a class="reference internal nav-link" href="#array-union">
      <code class="docutils literal notranslate">
       <span class="pre">
-       cardinality
+       array_union
       </span>
      </code>
     </a>
@@ -2390,6 +2390,32 @@
        Example
       </a>
      </li>
+     <li class="toc-h4 nav-item toc-entry">
+      <a class="reference internal nav-link" href="#id140">
+       Aliases
+      </a>
+     </li>
+    </ul>
+   </li>
+   <li class="toc-h3 nav-item toc-entry">
+    <a class="reference internal nav-link" href="#cardinality">
+     <code class="docutils literal notranslate">
+      <span class="pre">
+       cardinality
+      </span>
+     </code>
+    </a>
+    <ul class="nav section-nav flex-column">
+     <li class="toc-h4 nav-item toc-entry">
+      <a class="reference internal nav-link" href="#id141">
+       Arguments
+      </a>
+     </li>
+     <li class="toc-h4 nav-item toc-entry">
+      <a class="reference internal nav-link" href="#id142">
+       Example
+      </a>
+     </li>
     </ul>
    </li>
    <li class="toc-h3 nav-item toc-entry">
@@ -2402,12 +2428,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id140">
+      <a class="reference internal nav-link" href="#id143">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id141">
+      <a class="reference internal nav-link" href="#id144">
        Example
       </a>
      </li>
@@ -2639,17 +2665,17 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id142">
+      <a class="reference internal nav-link" href="#id145">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id143">
+      <a class="reference internal nav-link" href="#id146">
        Example
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id144">
+      <a class="reference internal nav-link" href="#id147">
        Aliases
       </a>
      </li>
@@ -2674,12 +2700,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id145">
+      <a class="reference internal nav-link" href="#id148">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id146">
+      <a class="reference internal nav-link" href="#id149">
        Aliases
       </a>
      </li>
@@ -2704,7 +2730,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id147">
+      <a class="reference internal nav-link" href="#id150">
        Arguments
       </a>
      </li>
@@ -2727,7 +2753,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id148">
+      <a class="reference internal nav-link" href="#id151">
        Arguments
       </a>
      </li>
@@ -2750,7 +2776,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id149">
+      <a class="reference internal nav-link" href="#id152">
        Arguments
       </a>
      </li>
@@ -2766,7 +2792,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id150">
+      <a class="reference internal nav-link" href="#id153">
        Arguments
       </a>
      </li>
@@ -2782,7 +2808,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id151">
+      <a class="reference internal nav-link" href="#id154">
        Arguments
       </a>
      </li>
@@ -2798,7 +2824,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id152">
+      <a class="reference internal nav-link" href="#id155">
        Arguments
       </a>
      </li>
@@ -2814,7 +2840,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id153">
+      <a class="reference internal nav-link" href="#id156">
        Arguments
       </a>
      </li>
@@ -2830,7 +2856,7 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id154">
+      <a class="reference internal nav-link" href="#id157">
        Arguments
       </a>
      </li>
@@ -2853,12 +2879,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id155">
+      <a class="reference internal nav-link" href="#id158">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id156">
+      <a class="reference internal nav-link" href="#id159">
        Example
       </a>
      </li>
@@ -2874,12 +2900,12 @@
     </a>
     <ul class="nav section-nav flex-column">
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id157">
+      <a class="reference internal nav-link" href="#id160">
        Arguments
       </a>
      </li>
      <li class="toc-h4 nav-item toc-entry">
-      <a class="reference internal nav-link" href="#id158">
+      <a class="reference internal nav-link" href="#id161">
        Example
       </a>
      </li>
@@ -5252,21 +5278,61 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 </ul>
 </section>
 </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 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="id138">
+<h4>Arguments<a class="headerlink" href="#id138" title="Link to this 
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>array1</strong>: Array expression.
+Can be a constant, column, or function, and any combination of array 
operators.</p></li>
+<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="id139">
+<h4>Example<a class="headerlink" href="#id139" title="Link to this 
heading">¶</a></h4>
+<div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ 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]                                 |
++----------------------------------------------------+
+</pre></div>
+</div>
+</section>
+<hr class="docutils" />
+<section id="id140">
+<h4>Aliases<a class="headerlink" href="#id140" title="Link to this 
heading">¶</a></h4>
+<ul class="simple">
+<li><p>list_union</p></li>
+</ul>
+</section>
+</section>
 <section id="cardinality">
 <h3><code class="docutils literal notranslate"><span 
class="pre">cardinality</span></code><a class="headerlink" href="#cardinality" 
title="Link to this heading">¶</a></h3>
 <p>Returns the total number of elements in the array.</p>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">cardinality</span><span 
class="p">(</span><span class="n">array</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id138">
-<h4>Arguments<a class="headerlink" href="#id138" title="Link to this 
heading">¶</a></h4>
+<section id="id141">
+<h4>Arguments<a class="headerlink" href="#id141" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 </ul>
 </section>
-<section id="id139">
-<h4>Example<a class="headerlink" href="#id139" title="Link to this 
heading">¶</a></h4>
+<section id="id142">
+<h4>Example<a class="headerlink" href="#id142" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select cardinality([[1, 2, 3, 4], [5, 6, 
7, 8]]);
 +--------------------------------------+
 | cardinality(List([1,2,3,4,5,6,7,8])) |
@@ -5283,15 +5349,15 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">empty</span><span 
class="p">(</span><span class="n">array</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id140">
-<h4>Arguments<a class="headerlink" href="#id140" title="Link to this 
heading">¶</a></h4>
+<section id="id143">
+<h4>Arguments<a class="headerlink" href="#id143" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>array</strong>: Array expression.
 Can be a constant, column, or function, and any combination of array 
operators.</p></li>
 </ul>
 </section>
-<section id="id141">
-<h4>Example<a class="headerlink" href="#id141" title="Link to this 
heading">¶</a></h4>
+<section id="id144">
+<h4>Example<a class="headerlink" href="#id144" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select empty([1]);
 +------------------+
 | empty(List([1])) |
@@ -5404,16 +5470,16 @@ Can be a constant, column, or function, and any 
combination of array operators.<
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">make_array</span><span 
class="p">(</span><span class="n">expression1</span><span class="p">[,</span> 
<span class="o">...</span><span class="p">,</span> <span 
class="n">expression_n</span><span class="p">])</span>
 </pre></div>
 </div>
-<section id="id142">
-<h4>Arguments<a class="headerlink" href="#id142" title="Link to this 
heading">¶</a></h4>
+<section id="id145">
+<h4>Arguments<a class="headerlink" href="#id145" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression_n</strong>: Expression to include in the output 
array.
 Can be a constant, column, or function, and any combination of arithmetic or
 string operators.</p></li>
 </ul>
 </section>
-<section id="id143">
-<h4>Example<a class="headerlink" href="#id143" title="Link to this 
heading">¶</a></h4>
+<section id="id146">
+<h4>Example<a class="headerlink" href="#id146" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select make_array(1, 2, 3, 4, 5);
 +----------------------------------------------------------+
 | make_array(Int64(1),Int64(2),Int64(3),Int64(4),Int64(5)) |
@@ -5423,8 +5489,8 @@ string operators.</p></li>
 </pre></div>
 </div>
 </section>
-<section id="id144">
-<h4>Aliases<a class="headerlink" href="#id144" title="Link to this 
heading">¶</a></h4>
+<section id="id147">
+<h4>Aliases<a class="headerlink" href="#id147" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>make_list</p></li>
 </ul>
@@ -5440,16 +5506,16 @@ string operators.</p></li>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">starts_with</span><span 
class="p">(</span><span class="nb">str</span><span class="p">,</span> <span 
class="n">delimiter</span><span class="p">[,</span> <span 
class="n">null_str</span><span class="p">])</span>
 </pre></div>
 </div>
-<section id="id145">
-<h4>Arguments<a class="headerlink" href="#id145" title="Link to this 
heading">¶</a></h4>
+<section id="id148">
+<h4>Arguments<a class="headerlink" href="#id148" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>str</strong>: String expression to split.</p></li>
 <li><p><strong>delimiter</strong>: Delimiter string to split on.</p></li>
 <li><p><strong>null_str</strong>: Substring values to be replaced with <code 
class="docutils literal notranslate"><span 
class="pre">NULL</span></code></p></li>
 </ul>
 </section>
-<section id="id146">
-<h4>Aliases<a class="headerlink" href="#id146" title="Link to this 
heading">¶</a></h4>
+<section id="id149">
+<h4>Aliases<a class="headerlink" href="#id149" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p>string_to_list</p></li>
 </ul>
@@ -5466,8 +5532,8 @@ string operators.</p></li>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">trim_array</span><span 
class="p">(</span><span class="n">array</span><span class="p">,</span> <span 
class="n">n</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id147">
-<h4>Arguments<a class="headerlink" href="#id147" title="Link to this 
heading">¶</a></h4>
+<section id="id150">
+<h4>Arguments<a class="headerlink" href="#id150" 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>
@@ -5508,8 +5574,8 @@ a struct type of fields <code class="docutils literal 
notranslate"><span class="
 <span class="o">+</span><span class="c1">-----------------+</span>
 </pre></div>
 </div>
-<section id="id148">
-<h4>Arguments<a class="headerlink" href="#id148" title="Link to this 
heading">¶</a></h4>
+<section id="id151">
+<h4>Arguments<a class="headerlink" href="#id151" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression_n</strong>: Expression to include in the output 
struct.
 Can be a constant, column, or function, and any combination of arithmetic or
@@ -5534,8 +5600,8 @@ string operators.</p></li>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">digest</span><span 
class="p">(</span><span class="n">expression</span><span class="p">,</span> 
<span class="n">algorithm</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id149">
-<h4>Arguments<a class="headerlink" href="#id149" title="Link to this 
heading">¶</a></h4>
+<section id="id152">
+<h4>Arguments<a class="headerlink" href="#id152" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: String expression to operate on.
 Can be a constant, column, or function, and any combination of string 
operators.</p></li>
@@ -5561,8 +5627,8 @@ Must be one of:</p>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">md5</span><span 
class="p">(</span><span class="n">expression</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id150">
-<h4>Arguments<a class="headerlink" href="#id150" title="Link to this 
heading">¶</a></h4>
+<section id="id153">
+<h4>Arguments<a class="headerlink" href="#id153" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: String expression to operate on.
 Can be a constant, column, or function, and any combination of string 
operators.</p></li>
@@ -5575,8 +5641,8 @@ Can be a constant, column, or function, and any 
combination of string operators.
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">sha224</span><span 
class="p">(</span><span class="n">expression</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id151">
-<h4>Arguments<a class="headerlink" href="#id151" title="Link to this 
heading">¶</a></h4>
+<section id="id154">
+<h4>Arguments<a class="headerlink" href="#id154" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: String expression to operate on.
 Can be a constant, column, or function, and any combination of string 
operators.</p></li>
@@ -5589,8 +5655,8 @@ Can be a constant, column, or function, and any 
combination of string operators.
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">sha256</span><span 
class="p">(</span><span class="n">expression</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id152">
-<h4>Arguments<a class="headerlink" href="#id152" title="Link to this 
heading">¶</a></h4>
+<section id="id155">
+<h4>Arguments<a class="headerlink" href="#id155" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: String expression to operate on.
 Can be a constant, column, or function, and any combination of string 
operators.</p></li>
@@ -5603,8 +5669,8 @@ Can be a constant, column, or function, and any 
combination of string operators.
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">sha384</span><span 
class="p">(</span><span class="n">expression</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id153">
-<h4>Arguments<a class="headerlink" href="#id153" title="Link to this 
heading">¶</a></h4>
+<section id="id156">
+<h4>Arguments<a class="headerlink" href="#id156" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: String expression to operate on.
 Can be a constant, column, or function, and any combination of string 
operators.</p></li>
@@ -5617,8 +5683,8 @@ Can be a constant, column, or function, and any 
combination of string operators.
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">sha512</span><span 
class="p">(</span><span class="n">expression</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id154">
-<h4>Arguments<a class="headerlink" href="#id154" title="Link to this 
heading">¶</a></h4>
+<section id="id157">
+<h4>Arguments<a class="headerlink" href="#id157" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: String expression to operate on.
 Can be a constant, column, or function, and any combination of string 
operators.</p></li>
@@ -5638,8 +5704,8 @@ Can be a constant, column, or function, and any 
combination of string operators.
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">arrow_cast</span><span 
class="p">(</span><span class="n">expression</span><span class="p">,</span> 
<span class="n">datatype</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id155">
-<h4>Arguments<a class="headerlink" href="#id155" title="Link to this 
heading">¶</a></h4>
+<section id="id158">
+<h4>Arguments<a class="headerlink" href="#id158" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: Expression to cast.
 Can be a constant, column, or function, and any combination of arithmetic or
@@ -5648,8 +5714,8 @@ string operators.</p></li>
 to cast to, as a string. The format is the same as that returned by [<code 
class="docutils literal notranslate"><span 
class="pre">arrow_typeof</span></code>]</p></li>
 </ul>
 </section>
-<section id="id156">
-<h4>Example<a class="headerlink" href="#id156" title="Link to this 
heading">¶</a></h4>
+<section id="id159">
+<h4>Example<a class="headerlink" href="#id159" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select arrow_cast(-5, &#39;Int8&#39;) as 
a,
   arrow_cast(&#39;foo&#39;, &#39;Dictionary(Int32, Utf8)&#39;) as b,
   arrow_cast(&#39;bar&#39;, &#39;LargeUtf8&#39;) as c,
@@ -5671,16 +5737,16 @@ to cast to, as a string. The format is the same as that 
returned by [<code class
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span><span class="n">arrow_typeof</span><span 
class="p">(</span><span class="n">expression</span><span class="p">)</span>
 </pre></div>
 </div>
-<section id="id157">
-<h4>Arguments<a class="headerlink" href="#id157" title="Link to this 
heading">¶</a></h4>
+<section id="id160">
+<h4>Arguments<a class="headerlink" href="#id160" title="Link to this 
heading">¶</a></h4>
 <ul class="simple">
 <li><p><strong>expression</strong>: Expression to evaluate.
 Can be a constant, column, or function, and any combination of arithmetic or
 string operators.</p></li>
 </ul>
 </section>
-<section id="id158">
-<h4>Example<a class="headerlink" href="#id158" title="Link to this 
heading">¶</a></h4>
+<section id="id161">
+<h4>Example<a class="headerlink" href="#id161" title="Link to this 
heading">¶</a></h4>
 <div class="highlight-default notranslate"><div 
class="highlight"><pre><span></span>❯ select arrow_typeof(&#39;foo&#39;), 
arrow_typeof(1);
 +---------------------------+------------------------+
 | arrow_typeof(Utf8(&quot;foo&quot;)) | arrow_typeof(Int64(1)) |

Reply via email to