You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@arrow.apache.org by gi...@apache.org on 2024/01/31 11:34:20 UTC
(arrow-datafusion) branch asf-site updated: Publish built docs triggered by 15f59d9861082a4d5d39bddce63d81cc7b9fb299
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 d8721dd843 Publish built docs triggered by 15f59d9861082a4d5d39bddce63d81cc7b9fb299
d8721dd843 is described below
commit d8721dd843877418d11d3c74e313b6b5af8f59a1
Author: github-actions[bot] <gi...@users.noreply.github.com>
AuthorDate: Wed Jan 31 11:34:15 2024 +0000
Publish built docs triggered by 15f59d9861082a4d5d39bddce63d81cc7b9fb299
---
_sources/user-guide/sql/scalar_functions.md.txt | 33 +++
searchindex.js | 2 +-
user-guide/sql/scalar_functions.html | 267 +++++++++++++++---------
3 files changed, 203 insertions(+), 99 deletions(-)
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt b/_sources/user-guide/sql/scalar_functions.md.txt
index 7bec80b55e..ba69b53e69 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -1793,6 +1793,7 @@ from_unixtime(expression)
- [array_replace](#array_replace)
- [array_replace_n](#array_replace_n)
- [array_replace_all](#array_replace_all)
+- [array_reverse](#array_reverse)
- [array_slice](#array_slice)
- [array_to_string](#array_to_string)
- [cardinality](#cardinality)
@@ -2523,6 +2524,34 @@ array_replace_all(array, from, to)
- list_replace_all
+### `array_reverse`
+
+Returns the array with the order of the elements reversed.
+
+```
+array_reverse(array)
+```
+
+#### Arguments
+
+- **array**: Array expression.
+ Can be a constant, column, or function, and any combination of array operators.
+
+#### Example
+
+```
+❯ select array_reverse([1, 2, 3, 4]);
++------------------------------------------------------------+
+| array_reverse(List([1, 2, 3, 4])) |
++------------------------------------------------------------+
+| [4, 3, 2, 1] |
++------------------------------------------------------------+
+```
+
+#### Aliases
+
+- list_reverse
+
### `array_slice`
Returns a slice of the array based on 1-indexed start and end positions.
@@ -2823,6 +2852,10 @@ _Alias of [array_replace_n](#array_replace_n)._
_Alias of [array_replace_all](#array_replace_all)._
+### `list_reverse`
+
+_Alias of [array_reverse](#array_reverse)._
+
### `list_slice`
_Alias of [array_slice](#array_slice)._
diff --git a/searchindex.js b/searchindex.js
index cb568bca2f..773d6438e8 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/sql/scalar_functions.html b/user-guide/sql/scalar_functions.html
index e404423f29..88d2ad107f 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -2564,10 +2564,10 @@
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#array-slice">
+ <a class="reference internal nav-link" href="#array-reverse">
<code class="docutils literal notranslate">
<span class="pre">
- array_slice
+ array_reverse
</span>
</code>
</a>
@@ -2590,10 +2590,10 @@
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#array-to-string">
+ <a class="reference internal nav-link" href="#array-slice">
<code class="docutils literal notranslate">
<span class="pre">
- array_to_string
+ array_slice
</span>
</code>
</a>
@@ -2616,10 +2616,10 @@
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#array-union">
+ <a class="reference internal nav-link" href="#array-to-string">
<code class="docutils literal notranslate">
<span class="pre">
- array_union
+ array_to_string
</span>
</code>
</a>
@@ -2642,10 +2642,10 @@
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#array-except">
+ <a class="reference internal nav-link" href="#array-union">
<code class="docutils literal notranslate">
<span class="pre">
- array_except
+ array_union
</span>
</code>
</a>
@@ -2668,10 +2668,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-except">
<code class="docutils literal notranslate">
<span class="pre">
- cardinality
+ array_except
</span>
</code>
</a>
@@ -2686,6 +2686,32 @@
Example
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id173">
+ 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="#id174">
+ Arguments
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id175">
+ Example
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -2698,12 +2724,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id173">
+ <a class="reference internal nav-link" href="#id176">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id174">
+ <a class="reference internal nav-link" href="#id177">
Example
</a>
</li>
@@ -2961,6 +2987,15 @@
</code>
</a>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-reverse">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_reverse
+ </span>
+ </code>
+ </a>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#list-slice">
<code class="docutils literal notranslate">
@@ -2989,17 +3024,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id175">
+ <a class="reference internal nav-link" href="#id178">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id176">
+ <a class="reference internal nav-link" href="#id179">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id177">
+ <a class="reference internal nav-link" href="#id180">
Aliases
</a>
</li>
@@ -3024,12 +3059,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id178">
+ <a class="reference internal nav-link" href="#id181">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id179">
+ <a class="reference internal nav-link" href="#id182">
Aliases
</a>
</li>
@@ -3054,7 +3089,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id180">
+ <a class="reference internal nav-link" href="#id183">
Arguments
</a>
</li>
@@ -3070,7 +3105,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id181">
+ <a class="reference internal nav-link" href="#id184">
Arguments
</a>
</li>
@@ -3093,7 +3128,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id182">
+ <a class="reference internal nav-link" href="#id185">
Arguments
</a>
</li>
@@ -3116,7 +3151,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id183">
+ <a class="reference internal nav-link" href="#id186">
Arguments
</a>
</li>
@@ -3132,7 +3167,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id184">
+ <a class="reference internal nav-link" href="#id187">
Arguments
</a>
</li>
@@ -3148,7 +3183,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id185">
+ <a class="reference internal nav-link" href="#id188">
Arguments
</a>
</li>
@@ -3164,7 +3199,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id186">
+ <a class="reference internal nav-link" href="#id189">
Arguments
</a>
</li>
@@ -3180,7 +3215,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id187">
+ <a class="reference internal nav-link" href="#id190">
Arguments
</a>
</li>
@@ -3196,7 +3231,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id188">
+ <a class="reference internal nav-link" href="#id191">
Arguments
</a>
</li>
@@ -3219,12 +3254,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id189">
+ <a class="reference internal nav-link" href="#id192">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id190">
+ <a class="reference internal nav-link" href="#id193">
Example
</a>
</li>
@@ -3240,12 +3275,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id191">
+ <a class="reference internal nav-link" href="#id194">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id192">
+ <a class="reference internal nav-link" href="#id195">
Example
</a>
</li>
@@ -5135,6 +5170,7 @@ Can be a constant, column, or function, and any combination of arithmetic operat
<li><p><a class="reference internal" href="#array-replace">array_replace</a></p></li>
<li><p><a class="reference internal" href="#array-replace-n">array_replace_n</a></p></li>
<li><p><a class="reference internal" href="#array-replace-all">array_replace_all</a></p></li>
+<li><p><a class="reference internal" href="#array-reverse">array_reverse</a></p></li>
<li><p><a class="reference internal" href="#array-slice">array_slice</a></p></li>
<li><p><a class="reference internal" href="#array-to-string">array_to_string</a></p></li>
<li><p><a class="reference internal" href="#cardinality">cardinality</a></p></li>
@@ -5931,14 +5967,45 @@ Can be a constant, column, or function, and any combination of array operators.<
</ul>
</section>
</section>
+<section id="array-reverse">
+<h3><code class="docutils literal notranslate"><span class="pre">array_reverse</span></code><a class="headerlink" href="#array-reverse" title="Link to this heading">¶</a></h3>
+<p>Returns the array with the order of the elements reversed.</p>
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_reverse</span><span class="p">(</span><span class="n">array</span><span class="p">)</span>
+</pre></div>
+</div>
+<section id="id159">
+<h4>Arguments<a class="headerlink" href="#id159" 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="id160">
+<h4>Example<a class="headerlink" href="#id160" title="Link to this heading">¶</a></h4>
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>❯ select array_reverse([1, 2, 3, 4]);
++------------------------------------------------------------+
+| array_reverse(List([1, 2, 3, 4])) |
++------------------------------------------------------------+
+| [4, 3, 2, 1] |
++------------------------------------------------------------+
+</pre></div>
+</div>
+</section>
+<section id="id161">
+<h4>Aliases<a class="headerlink" href="#id161" title="Link to this heading">¶</a></h4>
+<ul class="simple">
+<li><p>list_reverse</p></li>
+</ul>
+</section>
+</section>
<section id="array-slice">
<h3><code class="docutils literal notranslate"><span class="pre">array_slice</span></code><a class="headerlink" href="#array-slice" title="Link to this heading">¶</a></h3>
<p>Returns a slice of the array based on 1-indexed start and end positions.</p>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">array_slice</span><span class="p">(</span><span class="n">array</span><span class="p">,</span> <span class="n">begin</span><span class="p">,</span> <span class="n">end</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id159">
-<h4>Arguments<a class="headerlink" href="#id159" title="Link to this heading">¶</a></h4>
+<section id="id162">
+<h4>Arguments<a class="headerlink" href="#id162" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>array</strong>: Array expression.
Can be a constant, column, or function, and any combination of array operators.</p></li>
@@ -5949,8 +6016,8 @@ If negative, it counts backward from the end of the array.</p></li>
<li><p><strong>stride</strong>: Stride of the array slice. The default is 1.</p></li>
</ul>
</section>
-<section id="id160">
-<h4>Example<a class="headerlink" href="#id160" title="Link to this heading">¶</a></h4>
+<section id="id163">
+<h4>Example<a class="headerlink" href="#id163" title="Link to this heading">¶</a></h4>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>❯ select array_slice([1, 2, 3, 4, 5, 6, 7, 8], 3, 6);
+--------------------------------------------------------+
| array_slice(List([1,2,3,4,5,6,7,8]),Int64(3),Int64(6)) |
@@ -5960,8 +6027,8 @@ If negative, it counts backward from the end of the array.</p></li>
</pre></div>
</div>
</section>
-<section id="id161">
-<h4>Aliases<a class="headerlink" href="#id161" title="Link to this heading">¶</a></h4>
+<section id="id164">
+<h4>Aliases<a class="headerlink" href="#id164" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_slice</p></li>
</ul>
@@ -5973,16 +6040,16 @@ If negative, it counts backward from the end of the array.</p></li>
<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>
</pre></div>
</div>
-<section id="id162">
-<h4>Arguments<a class="headerlink" href="#id162" title="Link to this heading">¶</a></h4>
+<section id="id165">
+<h4>Arguments<a class="headerlink" href="#id165" 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>
</ul>
</section>
-<section id="id163">
-<h4>Example<a class="headerlink" href="#id163" title="Link to this heading">¶</a></h4>
+<section id="id166">
+<h4>Example<a class="headerlink" href="#id166" title="Link to this heading">¶</a></h4>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>❯ 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(",")) |
@@ -5992,8 +6059,8 @@ Can be a constant, column, or function, and any combination of array operators.<
</pre></div>
</div>
</section>
-<section id="id164">
-<h4>Aliases<a class="headerlink" href="#id164" title="Link to this heading">¶</a></h4>
+<section id="id167">
+<h4>Aliases<a class="headerlink" href="#id167" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>array_join</p></li>
<li><p>list_join</p></li>
@@ -6007,8 +6074,8 @@ 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">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="id165">
-<h4>Arguments<a class="headerlink" href="#id165" title="Link to this heading">¶</a></h4>
+<section id="id168">
+<h4>Arguments<a class="headerlink" href="#id168" 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>
@@ -6016,8 +6083,8 @@ Can be a constant, column, or function, and any combination of array operators.<
Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id166">
-<h4>Example<a class="headerlink" href="#id166" title="Link to this heading">¶</a></h4>
+<section id="id169">
+<h4>Example<a class="headerlink" href="#id169" 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]); |
@@ -6034,8 +6101,8 @@ Can be a constant, column, or function, and any combination of array operators.<
</div>
</section>
<hr class="docutils" />
-<section id="id167">
-<h4>Aliases<a class="headerlink" href="#id167" title="Link to this heading">¶</a></h4>
+<section id="id170">
+<h4>Aliases<a class="headerlink" href="#id170" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_union</p></li>
</ul>
@@ -6047,8 +6114,8 @@ 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">array_except</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="id168">
-<h4>Arguments<a class="headerlink" href="#id168" title="Link to this heading">¶</a></h4>
+<section id="id171">
+<h4>Arguments<a class="headerlink" href="#id171" 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>
@@ -6056,8 +6123,8 @@ Can be a constant, column, or function, and any combination of array operators.<
Can be a constant, column, or function, and any combination of array operators.</p></li>
</ul>
</section>
-<section id="id169">
-<h4>Example<a class="headerlink" href="#id169" title="Link to this heading">¶</a></h4>
+<section id="id172">
+<h4>Example<a class="headerlink" href="#id172" title="Link to this heading">¶</a></h4>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>❯ select array_except([1, 2, 3, 4], [5, 6, 3, 4]);
+----------------------------------------------------+
| array_except([1, 2, 3, 4], [5, 6, 3, 4]); |
@@ -6074,8 +6141,8 @@ Can be a constant, column, or function, and any combination of array operators.<
</div>
</section>
<hr class="docutils" />
-<section id="id170">
-<h4>Aliases<a class="headerlink" href="#id170" title="Link to this heading">¶</a></h4>
+<section id="id173">
+<h4>Aliases<a class="headerlink" href="#id173" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>list_except</p></li>
</ul>
@@ -6087,15 +6154,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">cardinality</span><span class="p">(</span><span class="n">array</span><span class="p">)</span>
</pre></div>
</div>
-<section id="id171">
-<h4>Arguments<a class="headerlink" href="#id171" title="Link to this heading">¶</a></h4>
+<section id="id174">
+<h4>Arguments<a class="headerlink" href="#id174" 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="id172">
-<h4>Example<a class="headerlink" href="#id172" title="Link to this heading">¶</a></h4>
+<section id="id175">
+<h4>Example<a class="headerlink" href="#id175" 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])) |
@@ -6112,15 +6179,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="id173">
-<h4>Arguments<a class="headerlink" href="#id173" title="Link to this heading">¶</a></h4>
+<section id="id176">
+<h4>Arguments<a class="headerlink" href="#id176" 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="id174">
-<h4>Example<a class="headerlink" href="#id174" title="Link to this heading">¶</a></h4>
+<section id="id177">
+<h4>Example<a class="headerlink" href="#id177" title="Link to this heading">¶</a></h4>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>❯ select empty([1]);
+------------------+
| empty(List([1])) |
@@ -6243,6 +6310,10 @@ Can be a constant, column, or function, and any combination of array operators.<
<h3><code class="docutils literal notranslate"><span class="pre">list_replace_all</span></code><a class="headerlink" href="#list-replace-all" title="Link to this heading">¶</a></h3>
<p><em>Alias of <a class="reference internal" href="#array-replace-all">array_replace_all</a>.</em></p>
</section>
+<section id="list-reverse">
+<h3><code class="docutils literal notranslate"><span class="pre">list_reverse</span></code><a class="headerlink" href="#list-reverse" title="Link to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal" href="#array-reverse">array_reverse</a>.</em></p>
+</section>
<section id="list-slice">
<h3><code class="docutils literal notranslate"><span class="pre">list_slice</span></code><a class="headerlink" href="#list-slice" title="Link to this heading">¶</a></h3>
<p><em>Alias of <a class="reference internal" href="#array-slice">array_slice</a>.</em></p>
@@ -6257,16 +6328,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="id175">
-<h4>Arguments<a class="headerlink" href="#id175" title="Link to this heading">¶</a></h4>
+<section id="id178">
+<h4>Arguments<a class="headerlink" href="#id178" 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="id176">
-<h4>Example<a class="headerlink" href="#id176" title="Link to this heading">¶</a></h4>
+<section id="id179">
+<h4>Example<a class="headerlink" href="#id179" 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)) |
@@ -6276,8 +6347,8 @@ string operators.</p></li>
</pre></div>
</div>
</section>
-<section id="id177">
-<h4>Aliases<a class="headerlink" href="#id177" title="Link to this heading">¶</a></h4>
+<section id="id180">
+<h4>Aliases<a class="headerlink" href="#id180" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>make_list</p></li>
</ul>
@@ -6293,16 +6364,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="id178">
-<h4>Arguments<a class="headerlink" href="#id178" title="Link to this heading">¶</a></h4>
+<section id="id181">
+<h4>Arguments<a class="headerlink" href="#id181" 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="id179">
-<h4>Aliases<a class="headerlink" href="#id179" title="Link to this heading">¶</a></h4>
+<section id="id182">
+<h4>Aliases<a class="headerlink" href="#id182" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p>string_to_list</p></li>
</ul>
@@ -6319,8 +6390,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="id180">
-<h4>Arguments<a class="headerlink" href="#id180" title="Link to this heading">¶</a></h4>
+<section id="id183">
+<h4>Arguments<a class="headerlink" href="#id183" 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>
@@ -6333,8 +6404,8 @@ Can be a constant, column, or function, and any combination of array operators.<
<p>Returns an Arrow array between start and stop with step. <code class="docutils literal notranslate"><span class="pre">SELECT</span> <span class="pre">range(2,</span> <span class="pre">10,</span> <span class="pre">3)</span> <span class="pre">-></span> <span class="pre">[2,</span> <span class="pre">5,</span> <span class="pre">8]</span></code></p>
<p>The range start..end contains all values with start <= x < end. It is empty if start >= end.</p>
<p>Step can not be 0 (then the range will be nonsense.).</p>
-<section id="id181">
-<h4>Arguments<a class="headerlink" href="#id181" title="Link to this heading">¶</a></h4>
+<section id="id184">
+<h4>Arguments<a class="headerlink" href="#id184" title="Link to this heading">¶</a></h4>
<ul class="simple">
<li><p><strong>start</strong>: start of the range</p></li>
<li><p><strong>end</strong>: end of the range (not included)</p></li>
@@ -6375,8 +6446,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="id182">
-<h4>Arguments<a class="headerlink" href="#id182" title="Link to this heading">¶</a></h4>
+<section id="id185">
+<h4>Arguments<a class="headerlink" href="#id185" 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
@@ -6401,8 +6472,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="id183">
-<h4>Arguments<a class="headerlink" href="#id183" title="Link to this heading">¶</a></h4>
+<section id="id186">
+<h4>Arguments<a class="headerlink" href="#id186" 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>
@@ -6428,8 +6499,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="id184">
-<h4>Arguments<a class="headerlink" href="#id184" title="Link to this heading">¶</a></h4>
+<section id="id187">
+<h4>Arguments<a class="headerlink" href="#id187" 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>
@@ -6442,8 +6513,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="id185">
-<h4>Arguments<a class="headerlink" href="#id185" title="Link to this heading">¶</a></h4>
+<section id="id188">
+<h4>Arguments<a class="headerlink" href="#id188" 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>
@@ -6456,8 +6527,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="id186">
-<h4>Arguments<a class="headerlink" href="#id186" title="Link to this heading">¶</a></h4>
+<section id="id189">
+<h4>Arguments<a class="headerlink" href="#id189" 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>
@@ -6470,8 +6541,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="id187">
-<h4>Arguments<a class="headerlink" href="#id187" title="Link to this heading">¶</a></h4>
+<section id="id190">
+<h4>Arguments<a class="headerlink" href="#id190" 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>
@@ -6484,8 +6555,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="id188">
-<h4>Arguments<a class="headerlink" href="#id188" title="Link to this heading">¶</a></h4>
+<section id="id191">
+<h4>Arguments<a class="headerlink" href="#id191" 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>
@@ -6505,8 +6576,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="id189">
-<h4>Arguments<a class="headerlink" href="#id189" title="Link to this heading">¶</a></h4>
+<section id="id192">
+<h4>Arguments<a class="headerlink" href="#id192" 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
@@ -6515,8 +6586,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="id190">
-<h4>Example<a class="headerlink" href="#id190" title="Link to this heading">¶</a></h4>
+<section id="id193">
+<h4>Example<a class="headerlink" href="#id193" title="Link to this heading">¶</a></h4>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>❯ select arrow_cast(-5, 'Int8') as a,
arrow_cast('foo', 'Dictionary(Int32, Utf8)') as b,
arrow_cast('bar', 'LargeUtf8') as c,
@@ -6538,16 +6609,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="id191">
-<h4>Arguments<a class="headerlink" href="#id191" title="Link to this heading">¶</a></h4>
+<section id="id194">
+<h4>Arguments<a class="headerlink" href="#id194" 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="id192">
-<h4>Example<a class="headerlink" href="#id192" title="Link to this heading">¶</a></h4>
+<section id="id195">
+<h4>Example<a class="headerlink" href="#id195" title="Link to this heading">¶</a></h4>
<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>❯ select arrow_typeof('foo'), arrow_typeof(1);
+---------------------------+------------------------+
| arrow_typeof(Utf8("foo")) | arrow_typeof(Int64(1)) |