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 2563f3938b Publish built docs triggered by
62816370822cb5e16a46d5050a41f62016af917f
2563f3938b is described below
commit 2563f3938b8f2262ca080e8a20ecf189e57927c9
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Tue Aug 22 16:46:20 2023 +0000
Publish built docs triggered by 62816370822cb5e16a46d5050a41f62016af917f
---
_sources/user-guide/sql/scalar_functions.md.txt | 27 ++++
contributor-guide/architecture.html | 2 +-
contributor-guide/communication.html | 2 +-
contributor-guide/index.html | 2 +-
contributor-guide/quarterly_roadmap.html | 2 +-
contributor-guide/roadmap.html | 2 +-
contributor-guide/specification/index.html | 2 +-
contributor-guide/specification/invariants.html | 2 +-
.../specification/output-field-name-semantic.html | 2 +-
genindex.html | 2 +-
index.html | 2 +-
library-user-guide/adding-udfs.html | 2 +-
library-user-guide/building-logical-plans.html | 2 +-
library-user-guide/catalogs.html | 2 +-
library-user-guide/custom-table-providers.html | 2 +-
library-user-guide/extending-operators.html | 2 +-
library-user-guide/index.html | 2 +-
library-user-guide/using-the-dataframe-api.html | 2 +-
library-user-guide/using-the-sql-api.html | 2 +-
library-user-guide/working-with-exprs.html | 2 +-
search.html | 2 +-
searchindex.js | 2 +-
user-guide/cli.html | 2 +-
user-guide/configs.html | 2 +-
user-guide/dataframe.html | 2 +-
user-guide/example-usage.html | 2 +-
user-guide/expressions.html | 2 +-
user-guide/faq.html | 2 +-
user-guide/introduction.html | 2 +-
user-guide/sql/aggregate_functions.html | 2 +-
user-guide/sql/data_types.html | 2 +-
user-guide/sql/ddl.html | 2 +-
user-guide/sql/explain.html | 2 +-
user-guide/sql/index.html | 2 +-
user-guide/sql/information_schema.html | 2 +-
user-guide/sql/operators.html | 2 +-
user-guide/sql/scalar_functions.html | 139 +++++++++++++++------
user-guide/sql/select.html | 2 +-
user-guide/sql/sql_status.html | 2 +-
user-guide/sql/subqueries.html | 2 +-
user-guide/sql/window_functions.html | 2 +-
41 files changed, 165 insertions(+), 79 deletions(-)
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index 6dbe5c05f6..c6e2f5ddd8 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -1495,6 +1495,7 @@ from_unixtime(expression)
- [array_slice](#array_slice)
- [array_to_string](#array_to_string)
- [cardinality](#cardinality)
+- [empty](#empty)
- [list_append](#list_append)
- [list_cat](#list_cat)
- [list_concat](#list_concat)
@@ -1693,6 +1694,8 @@ array_element(array, index)
- list_element
- list_extract
+### `array_empty`
+
### `array_extract`
_Alias of [array_element](#array_element)._
@@ -2188,6 +2191,30 @@ cardinality(array)
+--------------------------------------+
```
+### `empty`
+
+Returns 1 for an empty array or 0 for a non-empty array.
+
+```
+empty(array)
+```
+
+#### Arguments
+
+- **array**: Array expression.
+ Can be a constant, column, or function, and any combination of array
operators.
+
+#### Example
+
+```
+❯ select empty([1]);
++------------------+
+| empty(List([1])) |
++------------------+
+| 0 |
++------------------+
+```
+
### `list_append`
_Alias of [array_append](#array_append)._
diff --git a/contributor-guide/architecture.html
b/contributor-guide/architecture.html
index 3882bb4886..7599d26d6a 100644
--- a/contributor-guide/architecture.html
+++ b/contributor-guide/architecture.html
@@ -423,7 +423,7 @@ possible. You can find the most up to date version in the
<a class="reference ex
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/contributor-guide/communication.html
b/contributor-guide/communication.html
index bcc60a5c8a..a72997e05f 100644
--- a/contributor-guide/communication.html
+++ b/contributor-guide/communication.html
@@ -494,7 +494,7 @@ for the video call link, add topics and to see what others
plan to discuss.</p>
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/contributor-guide/index.html b/contributor-guide/index.html
index 6f1f96e56b..2a605de1cb 100644
--- a/contributor-guide/index.html
+++ b/contributor-guide/index.html
@@ -837,7 +837,7 @@ new specifications as you see fit.</p>
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/contributor-guide/quarterly_roadmap.html
b/contributor-guide/quarterly_roadmap.html
index 26dd23880c..ce1d26937e 100644
--- a/contributor-guide/quarterly_roadmap.html
+++ b/contributor-guide/quarterly_roadmap.html
@@ -586,7 +586,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/contributor-guide/roadmap.html b/contributor-guide/roadmap.html
index 54c051fad5..20dcfa0a6d 100644
--- a/contributor-guide/roadmap.html
+++ b/contributor-guide/roadmap.html
@@ -457,7 +457,7 @@ make review efficient and avoid surprises.</p>
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/contributor-guide/specification/index.html
b/contributor-guide/specification/index.html
index a52067591f..200cdd73f3 100644
--- a/contributor-guide/specification/index.html
+++ b/contributor-guide/specification/index.html
@@ -408,7 +408,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/contributor-guide/specification/invariants.html
b/contributor-guide/specification/invariants.html
index 1095fe3c26..91b5ca5a53 100644
--- a/contributor-guide/specification/invariants.html
+++ b/contributor-guide/specification/invariants.html
@@ -925,7 +925,7 @@ schemas.</p>
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/contributor-guide/specification/output-field-name-semantic.html
b/contributor-guide/specification/output-field-name-semantic.html
index cc833c94b4..cc9b409538 100644
--- a/contributor-guide/specification/output-field-name-semantic.html
+++ b/contributor-guide/specification/output-field-name-semantic.html
@@ -843,7 +843,7 @@ DataFusion queries planned from both SQL queries and
Dataframe APIs.</p>
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/genindex.html b/genindex.html
index 37d56e78c2..881b5ed2b5 100644
--- a/genindex.html
+++ b/genindex.html
@@ -367,7 +367,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/index.html b/index.html
index 9085635a1a..495e20a889 100644
--- a/index.html
+++ b/index.html
@@ -454,7 +454,7 @@ community.</p>
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/library-user-guide/adding-udfs.html
b/library-user-guide/adding-udfs.html
index a6a3acedd2..15d674d66d 100644
--- a/library-user-guide/adding-udfs.html
+++ b/library-user-guide/adding-udfs.html
@@ -421,7 +421,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/library-user-guide/building-logical-plans.html
b/library-user-guide/building-logical-plans.html
index 8b7c776702..7d7ae3c8d3 100644
--- a/library-user-guide/building-logical-plans.html
+++ b/library-user-guide/building-logical-plans.html
@@ -421,7 +421,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/library-user-guide/catalogs.html b/library-user-guide/catalogs.html
index c3fdc1b5e0..1ad49ae433 100644
--- a/library-user-guide/catalogs.html
+++ b/library-user-guide/catalogs.html
@@ -608,7 +608,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/library-user-guide/custom-table-providers.html
b/library-user-guide/custom-table-providers.html
index 42247329cb..a9dcbb6bf9 100644
--- a/library-user-guide/custom-table-providers.html
+++ b/library-user-guide/custom-table-providers.html
@@ -590,7 +590,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/library-user-guide/extending-operators.html
b/library-user-guide/extending-operators.html
index 9b44f4ca5a..c00b64b9d2 100644
--- a/library-user-guide/extending-operators.html
+++ b/library-user-guide/extending-operators.html
@@ -421,7 +421,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/library-user-guide/index.html b/library-user-guide/index.html
index 00249b37ca..7445189f98 100644
--- a/library-user-guide/index.html
+++ b/library-user-guide/index.html
@@ -422,7 +422,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/library-user-guide/using-the-dataframe-api.html
b/library-user-guide/using-the-dataframe-api.html
index a7a0d9632f..e38a85b276 100644
--- a/library-user-guide/using-the-dataframe-api.html
+++ b/library-user-guide/using-the-dataframe-api.html
@@ -421,7 +421,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/library-user-guide/using-the-sql-api.html
b/library-user-guide/using-the-sql-api.html
index bb91d9f056..bc1b339786 100644
--- a/library-user-guide/using-the-sql-api.html
+++ b/library-user-guide/using-the-sql-api.html
@@ -421,7 +421,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/library-user-guide/working-with-exprs.html
b/library-user-guide/working-with-exprs.html
index 0f1f5809f8..85409dce55 100644
--- a/library-user-guide/working-with-exprs.html
+++ b/library-user-guide/working-with-exprs.html
@@ -421,7 +421,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/search.html b/search.html
index 2dc832d940..bcbc8c5c8b 100644
--- a/search.html
+++ b/search.html
@@ -396,7 +396,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/searchindex.js b/searchindex.js
index f5d784ba9b..1c0611f9cc 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/cli.html b/user-guide/cli.html
index 8dc50968bc..cf600791a4 100644
--- a/user-guide/cli.html
+++ b/user-guide/cli.html
@@ -878,7 +878,7 @@ DataFusion<span class="w"> </span>CLI<span class="w">
</span>v13.0.0
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/user-guide/configs.html b/user-guide/configs.html
index ac355fdc48..5cb41b5932 100644
--- a/user-guide/configs.html
+++ b/user-guide/configs.html
@@ -675,7 +675,7 @@ Environment variables are read during <code class="docutils
literal notranslate"
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/user-guide/dataframe.html b/user-guide/dataframe.html
index cd2fbd5a8e..c3e8500102 100644
--- a/user-guide/dataframe.html
+++ b/user-guide/dataframe.html
@@ -598,7 +598,7 @@ execution. The plan is evaluated (executed) when an action
method is invoked, su
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/user-guide/example-usage.html b/user-guide/example-usage.html
index 097e4e552e..9bdb2ac363 100644
--- a/user-guide/example-usage.html
+++ b/user-guide/example-usage.html
@@ -684,7 +684,7 @@ with <code class="docutils literal notranslate"><span
class="pre">native</span><
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/user-guide/expressions.html b/user-guide/expressions.html
index 0a2c6012fc..fd1444ba19 100644
--- a/user-guide/expressions.html
+++ b/user-guide/expressions.html
@@ -1202,7 +1202,7 @@ expressions such as <code class="docutils literal
notranslate"><span class="pre"
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/user-guide/faq.html b/user-guide/faq.html
index cd1ad00044..e33c1429c6 100644
--- a/user-guide/faq.html
+++ b/user-guide/faq.html
@@ -489,7 +489,7 @@ targets end-users rather than developers of other database
systems.</p></li>
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/user-guide/introduction.html b/user-guide/introduction.html
index 13ac5b9335..4cf4d2f8b0 100644
--- a/user-guide/introduction.html
+++ b/user-guide/introduction.html
@@ -596,7 +596,7 @@ provide integrations with other systems, some of which are
described below:</p>
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/user-guide/sql/aggregate_functions.html
b/user-guide/sql/aggregate_functions.html
index 46e9d21668..ae98c01c3a 100644
--- a/user-guide/sql/aggregate_functions.html
+++ b/user-guide/sql/aggregate_functions.html
@@ -1676,7 +1676,7 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/user-guide/sql/data_types.html b/user-guide/sql/data_types.html
index 2046ef31e9..1921b8f6c0 100644
--- a/user-guide/sql/data_types.html
+++ b/user-guide/sql/data_types.html
@@ -750,7 +750,7 @@ For example, to cast the output of <code class="docutils
literal notranslate"><s
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/user-guide/sql/ddl.html b/user-guide/sql/ddl.html
index 9665ffef29..41327bd40f 100644
--- a/user-guide/sql/ddl.html
+++ b/user-guide/sql/ddl.html
@@ -682,7 +682,7 @@ DROP VIEW [ IF EXISTS ] <b><i>view_name</i></b>;
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/user-guide/sql/explain.html b/user-guide/sql/explain.html
index 7625fe66df..6d24ce453f 100644
--- a/user-guide/sql/explain.html
+++ b/user-guide/sql/explain.html
@@ -482,7 +482,7 @@ If you need more information output, use <code
class="docutils literal notransla
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/user-guide/sql/index.html b/user-guide/sql/index.html
index 1727507943..a403435769 100644
--- a/user-guide/sql/index.html
+++ b/user-guide/sql/index.html
@@ -495,7 +495,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/user-guide/sql/information_schema.html
b/user-guide/sql/information_schema.html
index 3389baf9bf..4ae34984c7 100644
--- a/user-guide/sql/information_schema.html
+++ b/user-guide/sql/information_schema.html
@@ -463,7 +463,7 @@ views of the ISO SQL <code class="docutils literal
notranslate"><span class="pre
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/user-guide/sql/operators.html b/user-guide/sql/operators.html
index e8619452c7..162c3bba5c 100644
--- a/user-guide/sql/operators.html
+++ b/user-guide/sql/operators.html
@@ -1094,7 +1094,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/user-guide/sql/scalar_functions.html
b/user-guide/sql/scalar_functions.html
index 1f80c6e825..8f1d60e54c 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -1890,6 +1890,15 @@
</li>
</ul>
</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>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#array-extract">
<code class="docutils literal notranslate">
@@ -2342,6 +2351,27 @@
</li>
</ul>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#empty">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ 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="#id138">
+ Arguments
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id139">
+ Example
+ </a>
+ </li>
+ </ul>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#list-append">
<code class="docutils literal notranslate">
@@ -2568,17 +2598,17 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id138">
+ <a class="reference internal nav-link" href="#id140">
Arguments
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id139">
+ <a class="reference internal nav-link" href="#id141">
Example
</a>
</li>
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id140">
+ <a class="reference internal nav-link" href="#id142">
Aliases
</a>
</li>
@@ -2603,7 +2633,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id141">
+ <a class="reference internal nav-link" href="#id143">
Arguments
</a>
</li>
@@ -2626,7 +2656,7 @@
</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="#id144">
Arguments
</a>
</li>
@@ -2649,7 +2679,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id143">
+ <a class="reference internal nav-link" href="#id145">
Arguments
</a>
</li>
@@ -2665,7 +2695,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id144">
+ <a class="reference internal nav-link" href="#id146">
Arguments
</a>
</li>
@@ -2681,7 +2711,7 @@
</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="#id147">
Arguments
</a>
</li>
@@ -2697,7 +2727,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id146">
+ <a class="reference internal nav-link" href="#id148">
Arguments
</a>
</li>
@@ -2713,7 +2743,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="#id149">
Arguments
</a>
</li>
@@ -2729,7 +2759,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="#id150">
Arguments
</a>
</li>
@@ -2752,7 +2782,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="#id151">
Arguments
</a>
</li>
@@ -2768,7 +2798,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="#id152">
Arguments
</a>
</li>
@@ -4371,6 +4401,7 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<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>
+<li><p><a class="reference internal" href="#empty">empty</a></p></li>
<li><p><a class="reference internal"
href="#list-append">list_append</a></p></li>
<li><p><a class="reference internal" href="#list-cat">list_cat</a></p></li>
<li><p><a class="reference internal"
href="#list-concat">list_concat</a></p></li>
@@ -4584,6 +4615,9 @@ Can be a constant, column, or function, and any
combination of array operators.<
</ul>
</section>
</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>
+</section>
<section id="array-extract">
<h3><code class="docutils literal notranslate"><span
class="pre">array_extract</span></code><a class="headerlink"
href="#array-extract" title="Link to this heading">¶</a></h3>
<p><em>Alias of <a class="reference internal"
href="#array-element">array_element</a>.</em></p>
@@ -5118,6 +5152,31 @@ Can be a constant, column, or function, and any
combination of array operators.<
</div>
</section>
</section>
+<section id="empty">
+<h3><code class="docutils literal notranslate"><span
class="pre">empty</span></code><a class="headerlink" href="#empty" title="Link
to this heading">¶</a></h3>
+<p>Returns 1 for an empty array or 0 for a non-empty array.</p>
+<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="id138">
+<h4>Arguments<a class="headerlink" href="#id138" 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>
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select empty([1]);
++------------------+
+| empty(List([1])) |
++------------------+
+| 0 |
++------------------+
+</pre></div>
+</div>
+</section>
+</section>
<section id="list-append">
<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>
@@ -5220,16 +5279,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="id138">
-<h4>Arguments<a class="headerlink" href="#id138" title="Link to this
heading">¶</a></h4>
+<section id="id140">
+<h4>Arguments<a class="headerlink" href="#id140" 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="id139">
-<h4>Example<a class="headerlink" href="#id139" title="Link to this
heading">¶</a></h4>
+<section id="id141">
+<h4>Example<a class="headerlink" href="#id141" 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)) |
@@ -5239,8 +5298,8 @@ string operators.</p></li>
</pre></div>
</div>
</section>
-<section id="id140">
-<h4>Aliases<a class="headerlink" href="#id140" title="Link to this
heading">¶</a></h4>
+<section id="id142">
+<h4>Aliases<a class="headerlink" href="#id142" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p>make_list</p></li>
</ul>
@@ -5257,8 +5316,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="id141">
-<h4>Arguments<a class="headerlink" href="#id141" 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>
@@ -5299,8 +5358,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="id142">
-<h4>Arguments<a class="headerlink" href="#id142" title="Link to this
heading">¶</a></h4>
+<section id="id144">
+<h4>Arguments<a class="headerlink" href="#id144" 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
@@ -5325,8 +5384,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="id143">
-<h4>Arguments<a class="headerlink" href="#id143" 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</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -5352,8 +5411,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="id144">
-<h4>Arguments<a class="headerlink" href="#id144" title="Link to this
heading">¶</a></h4>
+<section id="id146">
+<h4>Arguments<a class="headerlink" href="#id146" 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>
@@ -5366,8 +5425,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="id145">
-<h4>Arguments<a class="headerlink" href="#id145" title="Link to this
heading">¶</a></h4>
+<section id="id147">
+<h4>Arguments<a class="headerlink" href="#id147" 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>
@@ -5380,8 +5439,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="id146">
-<h4>Arguments<a class="headerlink" href="#id146" 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>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -5394,8 +5453,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="id147">
-<h4>Arguments<a class="headerlink" href="#id147" title="Link to this
heading">¶</a></h4>
+<section id="id149">
+<h4>Arguments<a class="headerlink" href="#id149" 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>
@@ -5408,8 +5467,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="id148">
-<h4>Arguments<a class="headerlink" href="#id148" 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>expression</strong>: String expression to operate on.
Can be a constant, column, or function, and any combination of string
operators.</p></li>
@@ -5429,8 +5488,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="id149">
-<h4>Arguments<a class="headerlink" href="#id149" 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</strong>: Expression to cast.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -5446,8 +5505,8 @@ to cast to.</p></li>
<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="id150">
-<h4>Arguments<a class="headerlink" href="#id150" 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>: Expression to evaluate.
Can be a constant, column, or function, and any combination of arithmetic or
@@ -5498,7 +5557,7 @@ string operators.</p></li>
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/user-guide/sql/select.html b/user-guide/sql/select.html
index 0e2c4c6df8..0f46fb0b58 100644
--- a/user-guide/sql/select.html
+++ b/user-guide/sql/select.html
@@ -727,7 +727,7 @@ This order can be changed to descending by adding <code
class="docutils literal
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/user-guide/sql/sql_status.html b/user-guide/sql/sql_status.html
index 7f891f1f25..31e8cb7664 100644
--- a/user-guide/sql/sql_status.html
+++ b/user-guide/sql/sql_status.html
@@ -552,7 +552,7 @@ trait, DataFusion includes built in support for the
following formats:</p>
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/user-guide/sql/subqueries.html b/user-guide/sql/subqueries.html
index 4d4e99e4f8..f66a7daa49 100644
--- a/user-guide/sql/subqueries.html
+++ b/user-guide/sql/subqueries.html
@@ -520,7 +520,7 @@ is an example of a filter using a scalar subquery. Only
correlated subqueries ar
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
diff --git a/user-guide/sql/window_functions.html
b/user-guide/sql/window_functions.html
index 82b9a5ba0b..1ea06c5f87 100644
--- a/user-guide/sql/window_functions.html
+++ b/user-guide/sql/window_functions.html
@@ -831,7 +831,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.0.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
</p>
</div>
