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 43b7c56c24 Publish built docs triggered by
e337832946fc69f6ceccd14b96a071cc2cd4693d
43b7c56c24 is described below
commit 43b7c56c247e8b4140e36b18198cf4999eb7928b
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Tue Mar 26 23:38:23 2024 +0000
Publish built docs triggered by e337832946fc69f6ceccd14b96a071cc2cd4693d
---
_sources/user-guide/expressions.md.txt | 1 +
_sources/user-guide/sql/scalar_functions.md.txt | 24 ++-
searchindex.js | 2 +-
user-guide/expressions.html | 59 ++++----
user-guide/sql/scalar_functions.html | 193 ++++++++++++++----------
5 files changed, 168 insertions(+), 111 deletions(-)
diff --git a/_sources/user-guide/expressions.md.txt
b/_sources/user-guide/expressions.md.txt
index 005d2ec942..a5fc134916 100644
--- a/_sources/user-guide/expressions.md.txt
+++ b/_sources/user-guide/expressions.md.txt
@@ -217,6 +217,7 @@ select log(-1), log(0), sqrt(-1);
| array_dims(array) | Returns an array of the
array's dimensions. `array_dims([[1, 2, 3], [4, 5, 6]]) -> [2, 3]`
|
| array_distinct(array) | Returns distinct values
from the array after removing duplicates. `array_distinct([1, 3, 2, 3, 1, 2,
4]) -> [1, 2, 3, 4]`
|
| array_element(array, index) | Extracts the element with
the index n from the array `array_element([1, 2, 3, 4], 3) -> 3`
|
+| empty(array) | Returns true for an empty
array or false for a non-empty array. `empty([1]) -> false`
|
| flatten(array) | Converts an array of arrays
to a flat array `flatten([[1], [2, 3], [4, 5, 6]]) -> [1, 2, 3, 4, 5, 6]`
|
| array_length(array, dimension) | Returns the length of the
array dimension. `array_length([1, 2, 3, 4, 5]) -> 5`
|
| array_ndims(array) | Returns the number of
dimensions of the array. `array_ndims([[1, 2, 3], [4, 5, 6]]) -> 2`
|
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index 5eb3436b42..52edf4bb72 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -1931,6 +1931,7 @@ from_unixtime(expression)
- [array_has_all](#array_has_all)
- [array_has_any](#array_has_any)
- [array_element](#array_element)
+- [array_empty](#array_empty)
- [array_except](#array_except)
- [array_extract](#array_extract)
- [array_fill](#array_fill)
@@ -3009,6 +3010,11 @@ empty(array)
+------------------+
```
+#### Aliases
+
+- array_empty,
+- list_empty
+
### `generate_series`
Similar to the range function, but it includes the upper bound.
@@ -3038,10 +3044,6 @@ generate_series(start, stop, step)
_Alias of [array_append](#array_append)._
-### `list_sort`
-
-_Alias of [array_sort](#array_sort)._
-
### `list_cat`
_Alias of [array_concat](#array_concat)._
@@ -3062,6 +3064,10 @@ _Alias of [array_dims](#array_distinct)._
_Alias of [array_element](#array_element)._
+### `list_empty`
+
+_Alias of [empty](#empty)._
+
### `list_except`
_Alias of [array_element](#array_except)._
@@ -3170,13 +3176,17 @@ _Alias of [array_reverse](#array_reverse)._
_Alias of [array_slice](#array_slice)._
+### `list_sort`
+
+_Alias of [array_sort](#array_sort)._
+
### `list_to_string`
_Alias of [array_to_string](#array_to_string)._
### `list_union`
-_Alias of [array_to_string](#array_union)._
+_Alias of [array_union](#array_union)._
### `make_array`
@@ -3186,6 +3196,10 @@ Returns an Arrow array using the specified input
expressions.
make_array(expression1[, ..., expression_n])
```
+### `array_empty`
+
+_Alias of [empty](#empty)._
+
#### Arguments
- **expression_n**: Expression to include in the output array.
diff --git a/searchindex.js b/searchindex.js
index 52624c6a4b..3723ec2615 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 2f3bc9d484..6f08fbbece 100644
--- a/user-guide/expressions.html
+++ b/user-guide/expressions.html
@@ -948,88 +948,91 @@ but these operators always return a <code class="docutils
literal notranslate"><
<tr class="row-odd"><td><p>array_element(array, index)</p></td>
<td><p>Extracts the element with the index n from the array <code
class="docutils literal notranslate"><span class="pre">array_element([1,</span>
<span class="pre">2,</span> <span class="pre">3,</span> <span
class="pre">4],</span> <span class="pre">3)</span> <span
class="pre">-></span> <span class="pre">3</span></code></p></td>
</tr>
-<tr class="row-even"><td><p>flatten(array)</p></td>
+<tr class="row-even"><td><p>empty(array)</p></td>
+<td><p>Returns true for an empty array or false for a non-empty array. <code
class="docutils literal notranslate"><span class="pre">empty([1])</span> <span
class="pre">-></span> <span class="pre">false</span></code></p></td>
+</tr>
+<tr class="row-odd"><td><p>flatten(array)</p></td>
<td><p>Converts an array of arrays to a flat array <code class="docutils
literal notranslate"><span class="pre">flatten([[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">-></span> <span
class="pre">[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></code></p></td>
</tr>
-<tr class="row-odd"><td><p>array_length(array, dimension)</p></td>
+<tr class="row-even"><td><p>array_length(array, dimension)</p></td>
<td><p>Returns the length of the array dimension. <code class="docutils
literal notranslate"><span class="pre">array_length([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">-></span> <span
class="pre">5</span></code></p></td>
</tr>
-<tr class="row-even"><td><p>array_ndims(array)</p></td>
+<tr class="row-odd"><td><p>array_ndims(array)</p></td>
<td><p>Returns the number of dimensions of the array. <code class="docutils
literal notranslate"><span class="pre">array_ndims([[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">-></span> <span class="pre">2</span></code></p></td>
</tr>
-<tr class="row-odd"><td><p>array_pop_front(array)</p></td>
+<tr class="row-even"><td><p>array_pop_front(array)</p></td>
<td><p>Returns the array without the first element. <code class="docutils
literal notranslate"><span class="pre">array_pop_front([1,</span> <span
class="pre">2,</span> <span class="pre">3])</span> <span
class="pre">-></span> <span class="pre">[2,</span> <span
class="pre">3]</span></code></p></td>
</tr>
-<tr class="row-even"><td><p>array_pop_back(array)</p></td>
+<tr class="row-odd"><td><p>array_pop_back(array)</p></td>
<td><p>Returns the array without the last element. <code class="docutils
literal notranslate"><span class="pre">array_pop_back([1,</span> <span
class="pre">2,</span> <span class="pre">3])</span> <span
class="pre">-></span> <span class="pre">[1,</span> <span
class="pre">2]</span></code></p></td>
</tr>
-<tr class="row-odd"><td><p>array_position(array, element)</p></td>
+<tr class="row-even"><td><p>array_position(array, element)</p></td>
<td><p>Searches for an element in the array, returns first occurrence. <code
class="docutils literal notranslate"><span
class="pre">array_position([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">4],</span>
<span class="pre">2)</span> <span class="pre">-></span> <span
class="pre">2</span></code></p></td>
</tr>
-<tr class="row-even"><td><p>array_positions(array, element)</p></td>
+<tr class="row-odd"><td><p>array_positions(array, element)</p></td>
<td><p>Searches for an element in the array, returns all occurrences. <code
class="docutils literal notranslate"><span
class="pre">array_positions([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">4],</span>
<span class="pre">2)</span> <span class="pre">-></span> <span
class="pre">[2,</span> <span class="pre">3]</span></code></p></td>
</tr>
-<tr class="row-odd"><td><p>array_prepend(array, element)</p></td>
+<tr class="row-even"><td><p>array_prepend(array, element)</p></td>
<td><p>Prepends an element to the beginning of an array. <code class="docutils
literal notranslate"><span class="pre">array_prepend(1,</span> <span
class="pre">[2,</span> <span class="pre">3,</span> <span class="pre">4])</span>
<span class="pre">-></span> <span class="pre">[1,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span
class="pre">4]</span></code></p></td>
</tr>
-<tr class="row-even"><td><p>array_repeat(element, count)</p></td>
+<tr class="row-odd"><td><p>array_repeat(element, count)</p></td>
<td><p>Returns an array containing element <code class="docutils literal
notranslate"><span class="pre">count</span></code> times. <code class="docutils
literal notranslate"><span class="pre">array_repeat(1,</span> <span
class="pre">3)</span> <span class="pre">-></span> <span
class="pre">[1,</span> <span class="pre">1,</span> <span
class="pre">1]</span></code></p></td>
</tr>
-<tr class="row-odd"><td><p>array_remove(array, element)</p></td>
+<tr class="row-even"><td><p>array_remove(array, element)</p></td>
<td><p>Removes the first element from the array equal to the given value.
<code class="docutils literal notranslate"><span
class="pre">array_remove([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">2,</span>
<span class="pre">1,</span> <span class="pre">4],</span> <span
class="pre">2)</span> <span class="pre">-></span> <span
class="pre">[1,</span> <span class="pre">2,</span> <span class="pre">3,</span>
<span class="pre">2, [...]
</tr>
-<tr class="row-even"><td><p>array_remove_n(array, element, max)</p></td>
+<tr class="row-odd"><td><p>array_remove_n(array, element, max)</p></td>
<td><p>Removes the first <code class="docutils literal notranslate"><span
class="pre">max</span></code> elements from the array equal to the given value.
<code class="docutils literal notranslate"><span
class="pre">array_remove_n([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">2,</span>
<span class="pre">1,</span> <span class="pre">4],</span> <span
class="pre">2,</span> <span class="pre">2)</span> <span class="pre">-></s
[...]
</tr>
-<tr class="row-odd"><td><p>array_remove_all(array, element)</p></td>
+<tr class="row-even"><td><p>array_remove_all(array, element)</p></td>
<td><p>Removes all elements from the array equal to the given value. <code
class="docutils literal notranslate"><span
class="pre">array_remove_all([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">2,</span>
<span class="pre">1,</span> <span class="pre">4],</span> <span
class="pre">2)</span> <span class="pre">-></span> <span
class="pre">[1,</span> <span class="pre">3,</span> <span class="pre">1,</span>
<span class="pre">4]< [...]
</tr>
-<tr class="row-even"><td><p>array_replace(array, from, to)</p></td>
+<tr class="row-odd"><td><p>array_replace(array, from, to)</p></td>
<td><p>Replaces the first occurrence of the specified element with another
specified element. <code class="docutils literal notranslate"><span
class="pre">array_replace([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">2,</span>
<span class="pre">1,</span> <span class="pre">4],</span> <span
class="pre">2,</span> <span class="pre">5)</span> <span
class="pre">-></span> <span class="pre">[1,</span> <span
class="pre">5,</span> [...]
</tr>
-<tr class="row-odd"><td><p>array_replace_n(array, from, to, max)</p></td>
+<tr class="row-even"><td><p>array_replace_n(array, from, to, max)</p></td>
<td><p>Replaces the first <code class="docutils literal notranslate"><span
class="pre">max</span></code> occurrences of the specified element with another
specified element. <code class="docutils literal notranslate"><span
class="pre">array_replace_n([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">2,</span>
<span class="pre">1,</span> <span class="pre">4],</span> <span
class="pre">2,</span> <span class="pre">5,</span> <span [...]
</tr>
-<tr class="row-even"><td><p>array_replace_all(array, from, to)</p></td>
+<tr class="row-odd"><td><p>array_replace_all(array, from, to)</p></td>
<td><p>Replaces all occurrences of the specified element with another
specified element. <code class="docutils literal notranslate"><span
class="pre">array_replace_all([1,</span> <span class="pre">2,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">2,</span>
<span class="pre">1,</span> <span class="pre">4],</span> <span
class="pre">2,</span> <span class="pre">5)</span> <span
class="pre">-></span> <span class="pre">[1,</span> <span
class="pre">5,</span> [...]
</tr>
-<tr class="row-odd"><td><p>array_slice(array, begin,end)</p></td>
+<tr class="row-even"><td><p>array_slice(array, begin,end)</p></td>
<td><p>Returns a slice of the array. <code class="docutils literal
notranslate"><span class="pre">array_slice([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">7,</span> <span class="pre">8],</span> <span class="pre">3,</span>
<span class="pre">6)</span> <span class="pre">-></span> <span
class="pre">[3,</span> <span class="pre">4,</span> <span class="pre">5,</span>
<s [...]
</tr>
-<tr class="row-even"><td><p>array_slice(array, begin, end, stride)</p></td>
+<tr class="row-odd"><td><p>array_slice(array, begin, end, stride)</p></td>
<td><p>Returns a slice of the array with added stride feature. <code
class="docutils literal notranslate"><span class="pre">array_slice([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">7,</span> <span class="pre">8],</span> <span
class="pre">3,</span> <span class="pre">6,</span> <span class="pre">2)</span>
<span class="pre">-></span> <span class="pre">[3,</span> <spa [...]
</tr>
-<tr class="row-odd"><td><p>array_to_string(array, delimiter)</p></td>
+<tr class="row-even"><td><p>array_to_string(array, delimiter)</p></td>
<td><p>Converts each element to its text representation. <code class="docutils
literal notranslate"><span class="pre">array_to_string([1,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">4],</span>
<span class="pre">',')</span> <span class="pre">-></span> <span
class="pre">1,2,3,4</span></code></p></td>
</tr>
-<tr class="row-even"><td><p>array_intersect(array1, array2)</p></td>
+<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">-></span> <span
class="pre">[3,</span> <span class="pre">4]</span></code></p></td>
</tr>
-<tr class="row-odd"><td><p>array_union(array1, array2)</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">-></span> <span
class="pre">[1,</span> <span class="pre">2,</span> <span class="pre">3,</span>
[...]
</tr>
-<tr class="row-even"><td><p>array_except(array1, array2)</p></td>
+<tr class="row-odd"><td><p>array_except(array1, array2)</p></td>
<td><p>Returns an array of the elements that appear in the first array but not
in the second. <code class="docutils literal notranslate"><span
class="pre">array_except([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">-></span> <span
class="pre">[1,</span> <span class="pre">2]</span></code></p></td>
</tr>
-<tr class="row-odd"><td><p>array_resize(array, size, value)</p></td>
+<tr class="row-even"><td><p>array_resize(array, size, value)</p></td>
<td><p>Resizes the list to contain size elements. Initializes new elements
with value or empty if value is not set. <code class="docutils literal
notranslate"><span class="pre">array_resize([1,</span> <span
class="pre">2,</span> <span class="pre">3],</span> <span class="pre">5,</span>
<span class="pre">0)</span> <span class="pre">-></span> <span
class="pre">[1,</span> <span class="pre">2,</span> <span class="pre">3,</span>
<span class="pre">0,</span> <span class="pre">0]</span></code> [...]
</tr>
-<tr class="row-even"><td><p>array_sort(array, desc, null_first)</p></td>
+<tr class="row-odd"><td><p>array_sort(array, desc, null_first)</p></td>
<td><p>Returns sorted array. <code class="docutils literal notranslate"><span
class="pre">array_sort([3,</span> <span class="pre">1,</span> <span
class="pre">2,</span> <span class="pre">5,</span> <span class="pre">4])</span>
<span class="pre">-></span> <span class="pre">[1,</span> <span
class="pre">2,</span> <span class="pre">3,</span> <span class="pre">4,</span>
<span class="pre">5]</span></code></p></td>
</tr>
-<tr class="row-odd"><td><p>cardinality(array)</p></td>
+<tr class="row-even"><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">-></span> <span
class="pre">6</span></code></p></td>
</tr>
-<tr class="row-even"><td><p>make_array(value1, [value2 [, …]])</p></td>
+<tr class="row-odd"><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">-></span> <span class="pre">[1,</span> <span
class="pre">2,</span> <span class="pre">3]</span></code></p></td>
</tr>
-<tr class="row-odd"><td><p>range(start [, stop, step])</p></td>
+<tr class="row-even"><td><p>range(start [, stop, step])</p></td>
<td><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></td>
</tr>
-<tr class="row-even"><td><p>string_to_array(array, delimiter,
null_string)</p></td>
+<tr class="row-odd"><td><p>string_to_array(array, delimiter,
null_string)</p></td>
<td><p>Splits a <code class="docutils literal notranslate"><span
class="pre">string</span></code> based on a <code class="docutils literal
notranslate"><span class="pre">delimiter</span></code> and returns an array of
parts. Any parts matching the optional <code class="docutils literal
notranslate"><span class="pre">null_string</span></code> will be replaced with
<code class="docutils literal notranslate"><span
class="pre">NULL</span></code>. <code class="docutils literal notranslate"><s
[...]
</tr>
-<tr class="row-odd"><td><p>trim_array(array, n)</p></td>
+<tr class="row-even"><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 3abc79849c..2500c29d92 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -2930,6 +2930,11 @@
Example
</a>
</li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id196">
+ Aliases
+ </a>
+ </li>
</ul>
</li>
<li class="toc-h3 nav-item toc-entry">
@@ -2942,12 +2947,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id196">
+ <a class="reference internal nav-link" href="#id197">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id197">
+ <a class="reference internal nav-link" href="#id198">
Example
</a>
</li>
@@ -2962,15 +2967,6 @@
</code>
</a>
</li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#list-sort">
- <code class="docutils literal notranslate">
- <span class="pre">
- list_sort
- </span>
- </code>
- </a>
- </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#list-cat">
<code class="docutils literal notranslate">
@@ -3016,6 +3012,15 @@
</code>
</a>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-empty">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_empty
+ </span>
+ </code>
+ </a>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#list-except">
<code class="docutils literal notranslate">
@@ -3259,6 +3264,15 @@
</code>
</a>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#list-sort">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ list_sort
+ </span>
+ </code>
+ </a>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#list-to-string">
<code class="docutils literal notranslate">
@@ -3285,19 +3299,28 @@
</span>
</code>
</a>
+ </li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#array-empty">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ array_empty
+ </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="#id198">
+ <a class="reference internal nav-link" href="#id199">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id199">
+ <a class="reference internal nav-link" href="#id200">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id200">
+ <a class="reference internal nav-link" href="#id201">
Aliases
</a>
</li>
@@ -3322,12 +3345,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id201">
+ <a class="reference internal nav-link" href="#id202">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id202">
+ <a class="reference internal nav-link" href="#id203">
Aliases
</a>
</li>
@@ -3352,7 +3375,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id203">
+ <a class="reference internal nav-link" href="#id204">
Arguments
</a>
</li>
@@ -3368,12 +3391,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id204">
+ <a class="reference internal nav-link" href="#id205">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id205">
+ <a class="reference internal nav-link" href="#id206">
Aliases
</a>
</li>
@@ -3396,7 +3419,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id206">
+ <a class="reference internal nav-link" href="#id207">
Arguments
</a>
</li>
@@ -3419,7 +3442,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id207">
+ <a class="reference internal nav-link" href="#id208">
Arguments
</a>
</li>
@@ -3435,7 +3458,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id208">
+ <a class="reference internal nav-link" href="#id209">
Arguments
</a>
</li>
@@ -3451,7 +3474,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id209">
+ <a class="reference internal nav-link" href="#id210">
Arguments
</a>
</li>
@@ -3467,7 +3490,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id210">
+ <a class="reference internal nav-link" href="#id211">
Arguments
</a>
</li>
@@ -3483,7 +3506,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id211">
+ <a class="reference internal nav-link" href="#id212">
Arguments
</a>
</li>
@@ -3499,7 +3522,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id212">
+ <a class="reference internal nav-link" href="#id213">
Arguments
</a>
</li>
@@ -3522,12 +3545,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id213">
+ <a class="reference internal nav-link" href="#id214">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id214">
+ <a class="reference internal nav-link" href="#id215">
Example
</a>
</li>
@@ -3543,12 +3566,12 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id215">
+ <a class="reference internal nav-link" href="#id216">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id216">
+ <a class="reference internal nav-link" href="#id217">
Example
</a>
</li>
@@ -5587,6 +5610,7 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<li><p><a class="reference internal"
href="#array-has-all">array_has_all</a></p></li>
<li><p><a class="reference internal"
href="#array-has-any">array_has_any</a></p></li>
<li><p><a class="reference internal"
href="#array-element">array_element</a></p></li>
+<li><p><a class="reference internal"
href="#array-empty">array_empty</a></p></li>
<li><p><a class="reference internal"
href="#array-except">array_except</a></p></li>
<li><p><a class="reference internal"
href="#array-extract">array_extract</a></p></li>
<li><p><a class="reference internal" href="#array-fill">array_fill</a></p></li>
@@ -6753,6 +6777,13 @@ Can be a constant, column, or function, and any
combination of array operators.<
</pre></div>
</div>
</section>
+<section id="id196">
+<h4>Aliases<a class="headerlink" href="#id196" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p>array_empty,</p></li>
+<li><p>list_empty</p></li>
+</ul>
+</section>
</section>
<section id="generate-series">
<h3><code class="docutils literal notranslate"><span
class="pre">generate_series</span></code><a class="headerlink"
href="#generate-series" title="Link to this heading">¶</a></h3>
@@ -6760,16 +6791,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">generate_series</span><span
class="p">(</span><span class="n">start</span><span class="p">,</span> <span
class="n">stop</span><span class="p">,</span> <span class="n">step</span><span
class="p">)</span>
</pre></div>
</div>
-<section id="id196">
-<h4>Arguments<a class="headerlink" href="#id196" title="Link to this
heading">¶</a></h4>
+<section id="id197">
+<h4>Arguments<a class="headerlink" href="#id197" 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 (included)</p></li>
<li><p><strong>step</strong>: increase by step (can not be 0)</p></li>
</ul>
</section>
-<section id="id197">
-<h4>Example<a class="headerlink" href="#id197" title="Link to this
heading">¶</a></h4>
+<section id="id198">
+<h4>Example<a class="headerlink" href="#id198" title="Link to this
heading">¶</a></h4>
<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select generate_series(1,3);
+------------------------------------+
| generate_series(Int64(1),Int64(3)) |
@@ -6784,10 +6815,6 @@ Can be a constant, column, or function, and any
combination of array operators.<
<h3><code class="docutils literal notranslate"><span
class="pre">list_append</span></code><a class="headerlink" href="#list-append"
title="Link to this heading">¶</a></h3>
<p><em>Alias of <a class="reference internal"
href="#array-append">array_append</a>.</em></p>
</section>
-<section id="list-sort">
-<h3><code class="docutils literal notranslate"><span
class="pre">list_sort</span></code><a class="headerlink" href="#list-sort"
title="Link to this heading">¶</a></h3>
-<p><em>Alias of <a class="reference internal"
href="#array-sort">array_sort</a>.</em></p>
-</section>
<section id="list-cat">
<h3><code class="docutils literal notranslate"><span
class="pre">list_cat</span></code><a class="headerlink" href="#list-cat"
title="Link to this heading">¶</a></h3>
<p><em>Alias of <a class="reference internal"
href="#array-concat">array_concat</a>.</em></p>
@@ -6808,6 +6835,10 @@ Can be a constant, column, or function, and any
combination of array operators.<
<h3><code class="docutils literal notranslate"><span
class="pre">list_element</span></code><a class="headerlink"
href="#list-element" title="Link to this heading">¶</a></h3>
<p><em>Alias of <a class="reference internal"
href="#array-element">array_element</a>.</em></p>
</section>
+<section id="list-empty">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_empty</span></code><a class="headerlink" href="#list-empty"
title="Link to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal" href="#empty">empty</a>.</em></p>
+</section>
<section id="list-except">
<h3><code class="docutils literal notranslate"><span
class="pre">list_except</span></code><a class="headerlink" href="#list-except"
title="Link to this heading">¶</a></h3>
<p><em>Alias of <a class="reference internal"
href="#array-except">array_element</a>.</em></p>
@@ -6916,13 +6947,17 @@ Can be a constant, column, or function, and any
combination of array operators.<
<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>
</section>
+<section id="list-sort">
+<h3><code class="docutils literal notranslate"><span
class="pre">list_sort</span></code><a class="headerlink" href="#list-sort"
title="Link to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal"
href="#array-sort">array_sort</a>.</em></p>
+</section>
<section id="list-to-string">
<h3><code class="docutils literal notranslate"><span
class="pre">list_to_string</span></code><a class="headerlink"
href="#list-to-string" title="Link to this heading">¶</a></h3>
<p><em>Alias of <a class="reference internal"
href="#array-to-string">array_to_string</a>.</em></p>
</section>
<section id="list-union">
<h3><code class="docutils literal notranslate"><span
class="pre">list_union</span></code><a class="headerlink" href="#list-union"
title="Link to this heading">¶</a></h3>
-<p><em>Alias of <a class="reference internal"
href="#array-union">array_to_string</a>.</em></p>
+<p><em>Alias of <a class="reference internal"
href="#array-union">array_union</a>.</em></p>
</section>
<section id="make-array">
<h3><code class="docutils literal notranslate"><span
class="pre">make_array</span></code><a class="headerlink" href="#make-array"
title="Link to this heading">¶</a></h3>
@@ -6930,16 +6965,20 @@ 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="id198">
-<h4>Arguments<a class="headerlink" href="#id198" title="Link to this
heading">¶</a></h4>
+</section>
+<section id="array-empty">
+<h3><code class="docutils literal notranslate"><span
class="pre">array_empty</span></code><a class="headerlink" href="#array-empty"
title="Link to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal" href="#empty">empty</a>.</em></p>
+<section id="id199">
+<h4>Arguments<a class="headerlink" href="#id199" 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="id199">
-<h4>Example<a class="headerlink" href="#id199" title="Link to this
heading">¶</a></h4>
+<section id="id200">
+<h4>Example<a class="headerlink" href="#id200" 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)) |
@@ -6949,8 +6988,8 @@ string operators.</p></li>
</pre></div>
</div>
</section>
-<section id="id200">
-<h4>Aliases<a class="headerlink" href="#id200" title="Link to this
heading">¶</a></h4>
+<section id="id201">
+<h4>Aliases<a class="headerlink" href="#id201" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>make_list</p></li>
</ul>
@@ -6967,16 +7006,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="id201">
-<h4>Arguments<a class="headerlink" href="#id201" title="Link to this
heading">¶</a></h4>
+<section id="id202">
+<h4>Arguments<a class="headerlink" href="#id202" 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="id202">
-<h4>Aliases<a class="headerlink" href="#id202" title="Link to this
heading">¶</a></h4>
+<section id="id203">
+<h4>Aliases<a class="headerlink" href="#id203" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>string_to_list</p></li>
</ul>
@@ -6993,8 +7032,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="id203">
-<h4>Arguments<a class="headerlink" href="#id203" title="Link to this
heading">¶</a></h4>
+<section id="id204">
+<h4>Arguments<a class="headerlink" href="#id204" 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>
@@ -7026,16 +7065,16 @@ For example,</p>
</pre></div>
</div>
<p>are not allowed</p>
-<section id="id204">
-<h4>Arguments<a class="headerlink" href="#id204" title="Link to this
heading">¶</a></h4>
+<section id="id205">
+<h4>Arguments<a class="headerlink" href="#id205" 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>
<li><p><strong>step</strong>: increase by step (can not be 0)</p></li>
</ul>
</section>
-<section id="id205">
-<h4>Aliases<a class="headerlink" href="#id205" title="Link to this
heading">¶</a></h4>
+<section id="id206">
+<h4>Aliases<a class="headerlink" href="#id206" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>generate_series</p></li>
</ul>
@@ -7074,8 +7113,8 @@ a struct type of fields <code class="docutils literal
notranslate"><span class="
<span class="o">+-----------------+</span>
</pre></div>
</div>
-<section id="id206">
-<h4>Arguments<a class="headerlink" href="#id206" title="Link to this
heading">¶</a></h4>
+<section id="id207">
+<h4>Arguments<a class="headerlink" href="#id207" 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
@@ -7100,8 +7139,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="id207">
-<h4>Arguments<a class="headerlink" href="#id207" title="Link to this
heading">¶</a></h4>
+<section id="id208">
+<h4>Arguments<a class="headerlink" href="#id208" 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>
@@ -7127,8 +7166,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="id208">
-<h4>Arguments<a class="headerlink" href="#id208" title="Link to this
heading">¶</a></h4>
+<section id="id209">
+<h4>Arguments<a class="headerlink" href="#id209" 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>
@@ -7141,8 +7180,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="id209">
-<h4>Arguments<a class="headerlink" href="#id209" title="Link to this
heading">¶</a></h4>
+<section id="id210">
+<h4>Arguments<a class="headerlink" href="#id210" 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>
@@ -7155,8 +7194,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="id210">
-<h4>Arguments<a class="headerlink" href="#id210" title="Link to this
heading">¶</a></h4>
+<section id="id211">
+<h4>Arguments<a class="headerlink" href="#id211" 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>
@@ -7169,8 +7208,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="id211">
-<h4>Arguments<a class="headerlink" href="#id211" title="Link to this
heading">¶</a></h4>
+<section id="id212">
+<h4>Arguments<a class="headerlink" href="#id212" 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>
@@ -7183,8 +7222,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="id212">
-<h4>Arguments<a class="headerlink" href="#id212" title="Link to this
heading">¶</a></h4>
+<section id="id213">
+<h4>Arguments<a class="headerlink" href="#id213" 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>
@@ -7204,8 +7243,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="id213">
-<h4>Arguments<a class="headerlink" href="#id213" title="Link to this
heading">¶</a></h4>
+<section id="id214">
+<h4>Arguments<a class="headerlink" href="#id214" 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
@@ -7214,8 +7253,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="id214">
-<h4>Example<a class="headerlink" href="#id214" title="Link to this
heading">¶</a></h4>
+<section id="id215">
+<h4>Example<a class="headerlink" href="#id215" 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,
@@ -7237,16 +7276,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="id215">
-<h4>Arguments<a class="headerlink" href="#id215" title="Link to this
heading">¶</a></h4>
+<section id="id216">
+<h4>Arguments<a class="headerlink" href="#id216" 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="id216">
-<h4>Example<a class="headerlink" href="#id216" title="Link to this
heading">¶</a></h4>
+<section id="id217">
+<h4>Example<a class="headerlink" href="#id217" 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)) |
