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/datafusion.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 8f763bea36 Publish built docs triggered by
22a242c15deafc78f5e6b42eb98408181979cf00
8f763bea36 is described below
commit 8f763bea36efd2a1feae4093197f610c7ec00bbb
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Sat Oct 26 10:31:12 2024 +0000
Publish built docs triggered by 22a242c15deafc78f5e6b42eb98408181979cf00
---
_sources/user-guide/sql/index.rst.txt | 1 +
_sources/user-guide/sql/scalar_functions.md.txt | 77 -------
_sources/user-guide/sql/special_functions.md.txt | 100 +++++++++
contributor-guide/architecture.html | 5 +
contributor-guide/communication.html | 5 +
contributor-guide/getting_started.html | 5 +
contributor-guide/governance.html | 5 +
contributor-guide/howtos.html | 5 +
contributor-guide/index.html | 5 +
contributor-guide/inviting.html | 5 +
contributor-guide/roadmap.html | 5 +
contributor-guide/specification/index.html | 5 +
contributor-guide/specification/invariants.html | 5 +
.../specification/output-field-name-semantic.html | 5 +
contributor-guide/testing.html | 5 +
download.html | 5 +
genindex.html | 5 +
index.html | 5 +
library-user-guide/adding-udfs.html | 5 +
library-user-guide/api-health.html | 5 +
library-user-guide/building-logical-plans.html | 5 +
library-user-guide/catalogs.html | 5 +
library-user-guide/custom-table-providers.html | 5 +
library-user-guide/extending-operators.html | 5 +
library-user-guide/extensions.html | 5 +
library-user-guide/index.html | 5 +
library-user-guide/profiling.html | 5 +
library-user-guide/query-optimizer.html | 5 +
library-user-guide/using-the-dataframe-api.html | 5 +
library-user-guide/using-the-sql-api.html | 5 +
library-user-guide/working-with-exprs.html | 5 +
objects.inv | Bin 1731 -> 1748 bytes
search.html | 5 +
searchindex.js | 2 +-
user-guide/cli/datasources.html | 5 +
user-guide/cli/index.html | 5 +
user-guide/cli/installation.html | 5 +
user-guide/cli/overview.html | 5 +
user-guide/cli/usage.html | 5 +
user-guide/configs.html | 5 +
user-guide/crate-configuration.html | 5 +
user-guide/dataframe.html | 5 +
user-guide/example-usage.html | 5 +
user-guide/explain-usage.html | 5 +
user-guide/expressions.html | 5 +
user-guide/faq.html | 5 +
user-guide/introduction.html | 5 +
user-guide/sql/aggregate_functions.html | 5 +
user-guide/sql/aggregate_functions_new.html | 5 +
user-guide/sql/data_types.html | 5 +
user-guide/sql/ddl.html | 5 +
user-guide/sql/dml.html | 5 +
user-guide/sql/explain.html | 5 +
user-guide/sql/index.html | 10 +-
user-guide/sql/information_schema.html | 5 +
user-guide/sql/operators.html | 5 +
user-guide/sql/scalar_functions.html | 144 +-----------
user-guide/sql/scalar_functions_new.html | 11 +-
user-guide/sql/select.html | 5 +
.../sql/{dml.html => special_functions.html} | 247 +++++++++++----------
user-guide/sql/sql_status.html | 11 +-
user-guide/sql/subqueries.html | 5 +
user-guide/sql/window_functions.html | 5 +
user-guide/sql/window_functions_new.html | 5 +
user-guide/sql/write_options.html | 5 +
65 files changed, 541 insertions(+), 337 deletions(-)
diff --git a/_sources/user-guide/sql/index.rst.txt
b/_sources/user-guide/sql/index.rst.txt
index 6eb451c83b..8b8afc7b04 100644
--- a/_sources/user-guide/sql/index.rst.txt
+++ b/_sources/user-guide/sql/index.rst.txt
@@ -35,5 +35,6 @@ SQL Reference
window_functions_new
scalar_functions
scalar_functions_new
+ special_functions
sql_status
write_options
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index 2034114287..a8e25930be 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -72,51 +72,8 @@ See [date_part](#date_part).
## Array Functions
-- [unnest](#unnest)
- [range](#range)
-### `unnest`
-
-Transforms an array into rows.
-
-#### Arguments
-
-- **array**: Array expression to unnest.
- Can be a constant, column, or function, and any combination of array
operators.
-
-#### Examples
-
-```
-> select unnest(make_array(1, 2, 3, 4, 5));
-+------------------------------------------------------------------+
-| unnest(make_array(Int64(1),Int64(2),Int64(3),Int64(4),Int64(5))) |
-+------------------------------------------------------------------+
-| 1 |
-| 2 |
-| 3 |
-| 4 |
-| 5 |
-+------------------------------------------------------------------+
-```
-
-```
-> select unnest(range(0, 10));
-+-----------------------------------+
-| unnest(range(Int64(0),Int64(10))) |
-+-----------------------------------+
-| 0 |
-| 1 |
-| 2 |
-| 3 |
-| 4 |
-| 5 |
-| 6 |
-| 7 |
-| 8 |
-| 9 |
-+-----------------------------------+
-```
-
### `range`
Returns an Arrow array between start and stop with step. `SELECT range(2, 10,
3) -> [2, 5, 8]` or
@@ -165,40 +122,6 @@ are not allowed
- generate_series
-## Struct Functions
-
-- [unnest](#unnest-struct)
-
-For more struct functions see the new documentation [
-`here`](https://datafusion.apache.org/user-guide/sql/scalar_functions_new.html)
-
-### `unnest (struct)`
-
-Unwraps struct fields into columns.
-
-#### Arguments
-
-- **struct**: Object expression to unnest.
- Can be a constant, column, or function, and any combination of object
operators.
-
-#### Examples
-
-```
-> select * from foo;
-+---------------------+
-| column1 |
-+---------------------+
-| {a: 5, b: a string} |
-+---------------------+
-
-> select unnest(column1) from foo;
-+-----------------------+-----------------------+
-| unnest(foo.column1).a | unnest(foo.column1).b |
-+-----------------------+-----------------------+
-| 5 | a string |
-+-----------------------+-----------------------+
-```
-
## Other Functions
See the new documentation
[`here`](https://datafusion.apache.org/user-guide/sql/scalar_functions_new.html)
diff --git a/_sources/user-guide/sql/special_functions.md.txt
b/_sources/user-guide/sql/special_functions.md.txt
new file mode 100644
index 0000000000..7c9efbb662
--- /dev/null
+++ b/_sources/user-guide/sql/special_functions.md.txt
@@ -0,0 +1,100 @@
+<!---
+ Licensed to the Apache Software Foundation (ASF) under one
+ or more contributor license agreements. See the NOTICE file
+ distributed with this work for additional information
+ regarding copyright ownership. The ASF licenses this file
+ to you under the Apache License, Version 2.0 (the
+ "License"); you may not use this file except in compliance
+ with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing,
+ software distributed under the License is distributed on an
+ "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ KIND, either express or implied. See the License for the
+ specific language governing permissions and limitations
+ under the License.
+-->
+
+# Special Functions
+
+## Expansion Functions
+
+- [unnest](#unnest)
+- [unnest(struct)](#unnest-struct)
+
+### `unnest`
+
+Expands an array or map into rows.
+
+#### Arguments
+
+- **array**: Array expression to unnest.
+ Can be a constant, column, or function, and any combination of array
operators.
+
+#### Examples
+
+```sql
+> select unnest(make_array(1, 2, 3, 4, 5)) as unnested;
++----------+
+| unnested |
++----------+
+| 1 |
+| 2 |
+| 3 |
+| 4 |
+| 5 |
++----------+
+```
+
+```sql
+> select unnest(range(0, 10)) as unnested_range;
++----------------+
+| unnested_range |
++----------------+
+| 0 |
+| 1 |
+| 2 |
+| 3 |
+| 4 |
+| 5 |
+| 6 |
+| 7 |
+| 8 |
+| 9 |
++----------------+
+```
+
+### `unnest (struct)`
+
+Expand a struct fields into individual columns.
+
+#### Arguments
+
+- **struct**: Object expression to unnest.
+ Can be a constant, column, or function, and any combination of object
operators.
+
+#### Examples
+
+```sql
+> create table foo as values ({a: 5, b: 'a string'}), ({a:6, b: 'another
string'});
+
+> create view foov as select column1 as struct_column from foo;
+
+> select * from foov;
++---------------------------+
+| struct_column |
++---------------------------+
+| {a: 5, b: a string} |
+| {a: 6, b: another string} |
++---------------------------+
+
+> select unnest(struct_column) from foov;
++------------------------------------------+------------------------------------------+
+| unnest_placeholder(foov.struct_column).a |
unnest_placeholder(foov.struct_column).b |
++------------------------------------------+------------------------------------------+
+| 5 | a string
|
+| 6 | another string
|
++------------------------------------------+------------------------------------------+
+```
diff --git a/contributor-guide/architecture.html
b/contributor-guide/architecture.html
index a05e64f867..881ac4cf44 100644
--- a/contributor-guide/architecture.html
+++ b/contributor-guide/architecture.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/sql_status.html">
Status
diff --git a/contributor-guide/communication.html
b/contributor-guide/communication.html
index bc731ef1bc..87489b16e3 100644
--- a/contributor-guide/communication.html
+++ b/contributor-guide/communication.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/sql_status.html">
Status
diff --git a/contributor-guide/getting_started.html
b/contributor-guide/getting_started.html
index 320e7e5006..383fffbd48 100644
--- a/contributor-guide/getting_started.html
+++ b/contributor-guide/getting_started.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/sql_status.html">
Status
diff --git a/contributor-guide/governance.html
b/contributor-guide/governance.html
index bb2d9300ab..f99670a7dd 100644
--- a/contributor-guide/governance.html
+++ b/contributor-guide/governance.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/sql_status.html">
Status
diff --git a/contributor-guide/howtos.html b/contributor-guide/howtos.html
index 9ebb0bb6a9..d3a170ea03 100644
--- a/contributor-guide/howtos.html
+++ b/contributor-guide/howtos.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/sql_status.html">
Status
diff --git a/contributor-guide/index.html b/contributor-guide/index.html
index 9e0d8bcf0f..d1330f724a 100644
--- a/contributor-guide/index.html
+++ b/contributor-guide/index.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/sql_status.html">
Status
diff --git a/contributor-guide/inviting.html b/contributor-guide/inviting.html
index 6a5d532384..ed7612d751 100644
--- a/contributor-guide/inviting.html
+++ b/contributor-guide/inviting.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/sql_status.html">
Status
diff --git a/contributor-guide/roadmap.html b/contributor-guide/roadmap.html
index 9d7b6226b5..7be823a7c3 100644
--- a/contributor-guide/roadmap.html
+++ b/contributor-guide/roadmap.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/sql_status.html">
Status
diff --git a/contributor-guide/specification/index.html
b/contributor-guide/specification/index.html
index 41ae1320df..3c51d76315 100644
--- a/contributor-guide/specification/index.html
+++ b/contributor-guide/specification/index.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../../user-guide/sql/sql_status.html">
Status
diff --git a/contributor-guide/specification/invariants.html
b/contributor-guide/specification/invariants.html
index a17ce305e2..8fa6a0041e 100644
--- a/contributor-guide/specification/invariants.html
+++ b/contributor-guide/specification/invariants.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../../user-guide/sql/sql_status.html">
Status
diff --git a/contributor-guide/specification/output-field-name-semantic.html
b/contributor-guide/specification/output-field-name-semantic.html
index 3b921db062..2f2e8ab249 100644
--- a/contributor-guide/specification/output-field-name-semantic.html
+++ b/contributor-guide/specification/output-field-name-semantic.html
@@ -277,6 +277,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../../user-guide/sql/sql_status.html">
Status
diff --git a/contributor-guide/testing.html b/contributor-guide/testing.html
index f38201c38a..874ed5705a 100644
--- a/contributor-guide/testing.html
+++ b/contributor-guide/testing.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/sql_status.html">
Status
diff --git a/download.html b/download.html
index 17b14fb803..f87a185d86 100644
--- a/download.html
+++ b/download.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="user-guide/sql/sql_status.html">
Status
diff --git a/genindex.html b/genindex.html
index 45c17f6576..275bf94195 100644
--- a/genindex.html
+++ b/genindex.html
@@ -275,6 +275,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="user-guide/sql/sql_status.html">
Status
diff --git a/index.html b/index.html
index 8278a4fec5..bbd12f769c 100644
--- a/index.html
+++ b/index.html
@@ -277,6 +277,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="user-guide/sql/sql_status.html">
Status
diff --git a/library-user-guide/adding-udfs.html
b/library-user-guide/adding-udfs.html
index 4a03a9ca9c..6e437dfaf3 100644
--- a/library-user-guide/adding-udfs.html
+++ b/library-user-guide/adding-udfs.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/sql_status.html">
Status
diff --git a/library-user-guide/api-health.html
b/library-user-guide/api-health.html
index ce2d752553..04a318fdb1 100644
--- a/library-user-guide/api-health.html
+++ b/library-user-guide/api-health.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/sql_status.html">
Status
diff --git a/library-user-guide/building-logical-plans.html
b/library-user-guide/building-logical-plans.html
index b2a0487323..c7f68795af 100644
--- a/library-user-guide/building-logical-plans.html
+++ b/library-user-guide/building-logical-plans.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/sql_status.html">
Status
diff --git a/library-user-guide/catalogs.html b/library-user-guide/catalogs.html
index 8a76970560..a3ea72ca95 100644
--- a/library-user-guide/catalogs.html
+++ b/library-user-guide/catalogs.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/sql_status.html">
Status
diff --git a/library-user-guide/custom-table-providers.html
b/library-user-guide/custom-table-providers.html
index 976c840b6b..eed04ec4a9 100644
--- a/library-user-guide/custom-table-providers.html
+++ b/library-user-guide/custom-table-providers.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/sql_status.html">
Status
diff --git a/library-user-guide/extending-operators.html
b/library-user-guide/extending-operators.html
index 58926dec4d..54af52532a 100644
--- a/library-user-guide/extending-operators.html
+++ b/library-user-guide/extending-operators.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/sql_status.html">
Status
diff --git a/library-user-guide/extensions.html
b/library-user-guide/extensions.html
index 639c33ef8d..0b192151bb 100644
--- a/library-user-guide/extensions.html
+++ b/library-user-guide/extensions.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/sql_status.html">
Status
diff --git a/library-user-guide/index.html b/library-user-guide/index.html
index 655010e501..2e1143bc71 100644
--- a/library-user-guide/index.html
+++ b/library-user-guide/index.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/sql_status.html">
Status
diff --git a/library-user-guide/profiling.html
b/library-user-guide/profiling.html
index 06f5579759..8ca14ca20f 100644
--- a/library-user-guide/profiling.html
+++ b/library-user-guide/profiling.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/sql_status.html">
Status
diff --git a/library-user-guide/query-optimizer.html
b/library-user-guide/query-optimizer.html
index 1ef1859d5c..14663501f7 100644
--- a/library-user-guide/query-optimizer.html
+++ b/library-user-guide/query-optimizer.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/sql_status.html">
Status
diff --git a/library-user-guide/using-the-dataframe-api.html
b/library-user-guide/using-the-dataframe-api.html
index c0b38f81bd..2416883c89 100644
--- a/library-user-guide/using-the-dataframe-api.html
+++ b/library-user-guide/using-the-dataframe-api.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/sql_status.html">
Status
diff --git a/library-user-guide/using-the-sql-api.html
b/library-user-guide/using-the-sql-api.html
index 2605824ea1..463a79d7cc 100644
--- a/library-user-guide/using-the-sql-api.html
+++ b/library-user-guide/using-the-sql-api.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/sql_status.html">
Status
diff --git a/library-user-guide/working-with-exprs.html
b/library-user-guide/working-with-exprs.html
index f800b56f5d..7142d038f2 100644
--- a/library-user-guide/working-with-exprs.html
+++ b/library-user-guide/working-with-exprs.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal"
href="../user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/sql_status.html">
Status
diff --git a/objects.inv b/objects.inv
index eee0b7ccb6..27365f82b5 100644
Binary files a/objects.inv and b/objects.inv differ
diff --git a/search.html b/search.html
index 9a95fa1c7e..ce5fb2cd2d 100644
--- a/search.html
+++ b/search.html
@@ -282,6 +282,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="user-guide/sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="user-guide/sql/sql_status.html">
Status
diff --git a/searchindex.js b/searchindex.js
index 90fc61028b..0f2470e359 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles": {"!=": [[48, "op-neq"]], "!~": [[48,
"op-re-not-match"]], "!~*": [[48, "op-re-not-match-i"]], "!~~": [[48, "id18"]],
"!~~*": [[48, "id19"]], "#": [[48, "op-bit-xor"]], "%": [[48, "op-modulo"]],
"&": [[48, "op-bit-and"]], "(relation, name) tuples in logical fields and
logical columns are unique": [[9,
"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]], "*":
[[48, "op-multiply"]], "+": [[48, "op-plus"]], "-": [[48, "op-minus"]], "/":
[[4 [...]
\ No newline at end of file
+Search.setIndex({"alltitles": {"!=": [[48, "op-neq"]], "!~": [[48,
"op-re-not-match"]], "!~*": [[48, "op-re-not-match-i"]], "!~~": [[48, "id18"]],
"!~~*": [[48, "id19"]], "#": [[48, "op-bit-xor"]], "%": [[48, "op-modulo"]],
"&": [[48, "op-bit-and"]], "(relation, name) tuples in logical fields and
logical columns are unique": [[9,
"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]], "*":
[[48, "op-multiply"]], "+": [[48, "op-plus"]], "-": [[48, "op-minus"]], "/":
[[4 [...]
\ No newline at end of file
diff --git a/user-guide/cli/datasources.html b/user-guide/cli/datasources.html
index 577c6704e3..77149fa4ec 100644
--- a/user-guide/cli/datasources.html
+++ b/user-guide/cli/datasources.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../sql/sql_status.html">
Status
diff --git a/user-guide/cli/index.html b/user-guide/cli/index.html
index 697c1d412f..d2a7db50bd 100644
--- a/user-guide/cli/index.html
+++ b/user-guide/cli/index.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../sql/sql_status.html">
Status
diff --git a/user-guide/cli/installation.html b/user-guide/cli/installation.html
index bc7585db88..a214aa3b06 100644
--- a/user-guide/cli/installation.html
+++ b/user-guide/cli/installation.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../sql/sql_status.html">
Status
diff --git a/user-guide/cli/overview.html b/user-guide/cli/overview.html
index f1b09ef515..d2327ebecc 100644
--- a/user-guide/cli/overview.html
+++ b/user-guide/cli/overview.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../sql/sql_status.html">
Status
diff --git a/user-guide/cli/usage.html b/user-guide/cli/usage.html
index 04ce2663c0..fa457b2ab7 100644
--- a/user-guide/cli/usage.html
+++ b/user-guide/cli/usage.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../sql/sql_status.html">
Status
diff --git a/user-guide/configs.html b/user-guide/configs.html
index 9d089c9a73..53b1993926 100644
--- a/user-guide/configs.html
+++ b/user-guide/configs.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql/sql_status.html">
Status
diff --git a/user-guide/crate-configuration.html
b/user-guide/crate-configuration.html
index ca1a198aed..e422ba83d0 100644
--- a/user-guide/crate-configuration.html
+++ b/user-guide/crate-configuration.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql/sql_status.html">
Status
diff --git a/user-guide/dataframe.html b/user-guide/dataframe.html
index 0c6977bb84..119fe30128 100644
--- a/user-guide/dataframe.html
+++ b/user-guide/dataframe.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql/sql_status.html">
Status
diff --git a/user-guide/example-usage.html b/user-guide/example-usage.html
index 3b59525b48..4def09e983 100644
--- a/user-guide/example-usage.html
+++ b/user-guide/example-usage.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql/sql_status.html">
Status
diff --git a/user-guide/explain-usage.html b/user-guide/explain-usage.html
index 3cc02f386e..6a98153ffd 100644
--- a/user-guide/explain-usage.html
+++ b/user-guide/explain-usage.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql/sql_status.html">
Status
diff --git a/user-guide/expressions.html b/user-guide/expressions.html
index 347c1879af..6a27f68f22 100644
--- a/user-guide/expressions.html
+++ b/user-guide/expressions.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql/sql_status.html">
Status
diff --git a/user-guide/faq.html b/user-guide/faq.html
index 6fd1a3b50e..22dc764296 100644
--- a/user-guide/faq.html
+++ b/user-guide/faq.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql/sql_status.html">
Status
diff --git a/user-guide/introduction.html b/user-guide/introduction.html
index 44792e44c5..73e322c990 100644
--- a/user-guide/introduction.html
+++ b/user-guide/introduction.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="sql/special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql/sql_status.html">
Status
diff --git a/user-guide/sql/aggregate_functions.html
b/user-guide/sql/aggregate_functions.html
index 3787a11140..196bef5a16 100644
--- a/user-guide/sql/aggregate_functions.html
+++ b/user-guide/sql/aggregate_functions.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql_status.html">
Status
diff --git a/user-guide/sql/aggregate_functions_new.html
b/user-guide/sql/aggregate_functions_new.html
index d984c059cb..ae5e1d73ba 100644
--- a/user-guide/sql/aggregate_functions_new.html
+++ b/user-guide/sql/aggregate_functions_new.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql_status.html">
Status
diff --git a/user-guide/sql/data_types.html b/user-guide/sql/data_types.html
index 40ca22b101..de36e08839 100644
--- a/user-guide/sql/data_types.html
+++ b/user-guide/sql/data_types.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql_status.html">
Status
diff --git a/user-guide/sql/ddl.html b/user-guide/sql/ddl.html
index c7eccda3dc..1b8cd5e0f7 100644
--- a/user-guide/sql/ddl.html
+++ b/user-guide/sql/ddl.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql_status.html">
Status
diff --git a/user-guide/sql/dml.html b/user-guide/sql/dml.html
index 4a19d707af..7fa81ded30 100644
--- a/user-guide/sql/dml.html
+++ b/user-guide/sql/dml.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql_status.html">
Status
diff --git a/user-guide/sql/explain.html b/user-guide/sql/explain.html
index 9003345b37..ffdc7b153b 100644
--- a/user-guide/sql/explain.html
+++ b/user-guide/sql/explain.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql_status.html">
Status
diff --git a/user-guide/sql/index.html b/user-guide/sql/index.html
index cbdc8582d3..8be1c25fc9 100644
--- a/user-guide/sql/index.html
+++ b/user-guide/sql/index.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql_status.html">
Status
@@ -622,7 +627,6 @@
<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#string-functions">String Functions</a></li>
<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#time-and-date-functions">Time and Date
Functions</a></li>
<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#array-functions">Array Functions</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#struct-functions">Struct Functions</a></li>
<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#other-functions">Other Functions</a></li>
</ul>
</li>
@@ -640,6 +644,10 @@
<li class="toctree-l2"><a class="reference internal"
href="scalar_functions_new.html#other-functions">Other Functions</a></li>
</ul>
</li>
+<li class="toctree-l1"><a class="reference internal"
href="special_functions.html">Special Functions</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="special_functions.html#expansion-functions">Expansion Functions</a></li>
+</ul>
+</li>
<li class="toctree-l1"><a class="reference internal"
href="sql_status.html">Status</a><ul>
<li class="toctree-l2"><a class="reference internal"
href="sql_status.html#general">General</a></li>
<li class="toctree-l2"><a class="reference internal"
href="sql_status.html#sql-support">SQL Support</a></li>
diff --git a/user-guide/sql/information_schema.html
b/user-guide/sql/information_schema.html
index a8f6e8397e..984d7e3385 100644
--- a/user-guide/sql/information_schema.html
+++ b/user-guide/sql/information_schema.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql_status.html">
Status
diff --git a/user-guide/sql/operators.html b/user-guide/sql/operators.html
index 7c311ac69b..b742538497 100644
--- a/user-guide/sql/operators.html
+++ b/user-guide/sql/operators.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql_status.html">
Status
diff --git a/user-guide/sql/scalar_functions.html
b/user-guide/sql/scalar_functions.html
index 7c63ca3161..b471b7f352 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql_status.html">
Status
@@ -557,27 +562,6 @@
Array Functions
</a>
<ul class="nav section-nav flex-column">
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#unnest">
- <code class="docutils literal notranslate">
- <span class="pre">
- unnest
- </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="#id1">
- Arguments
- </a>
- </li>
- <li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#examples">
- Examples
- </a>
- </li>
- </ul>
- </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#range">
<code class="docutils literal notranslate">
@@ -588,7 +572,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id2">
+ <a class="reference internal nav-link" href="#id1">
Arguments
</a>
</li>
@@ -601,37 +585,6 @@
</li>
</ul>
</li>
- <li class="toc-h2 nav-item toc-entry">
- <a class="reference internal nav-link" href="#struct-functions">
- Struct Functions
- </a>
- <ul class="nav section-nav flex-column">
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#unnest-struct">
- <code class="docutils literal notranslate">
- <span class="pre">
- unnest
- </span>
- <span class="pre">
- (struct)
- </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="#id3">
- Arguments
- </a>
- </li>
- <li class="toc-h4 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id4">
- Examples
- </a>
- </li>
- </ul>
- </li>
- </ul>
- </li>
<li class="toc-h2 nav-item toc-entry">
<a class="reference internal nav-link" href="#other-functions">
Other Functions
@@ -734,52 +687,8 @@ not appear in <code class="docutils literal
notranslate"><span class="pre">origs
<section id="array-functions">
<h2>Array Functions<a class="headerlink" href="#array-functions" title="Link
to this heading">¶</a></h2>
<ul class="simple">
-<li><p><a class="reference internal" href="#unnest">unnest</a></p></li>
<li><p><a class="reference internal" href="#range">range</a></p></li>
</ul>
-<section id="unnest">
-<h3><code class="docutils literal notranslate"><span
class="pre">unnest</span></code><a class="headerlink" href="#unnest"
title="Link to this heading">¶</a></h3>
-<p>Transforms an array into rows.</p>
-<section id="id1">
-<h4>Arguments<a class="headerlink" href="#id1" title="Link to this
heading">¶</a></h4>
-<ul class="simple">
-<li><p><strong>array</strong>: Array expression to unnest.
-Can be a constant, column, or function, and any combination of array
operators.</p></li>
-</ul>
-</section>
-<section id="examples">
-<h4>Examples<a class="headerlink" href="#examples" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">unnest</span><span
class="p">(</span><span class="n">make_array</span><span
class="p">(</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">,</span> <span
class="mi">5</span><span class="p" [...]
-<span
class="o">+------------------------------------------------------------------+</span>
-<span class="o">|</span> <span class="n">unnest</span><span
class="p">(</span><span class="n">make_array</span><span
class="p">(</span><span class="n">Int64</span><span class="p">(</span><span
class="mi">1</span><span class="p">),</span><span class="n">Int64</span><span
class="p">(</span><span class="mi">2</span><span class="p">),</span><span
class="n">Int64</span><span class="p">(</span><span class="mi">3</span><span
class="p">),</span><span class="n">Int64</span><span class="p">(</span [...]
-<span
class="o">+------------------------------------------------------------------+</span>
-<span class="o">|</span> <span class="mi">1</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="mi">2</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="mi">3</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="mi">4</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="mi">5</span>
<span class="o">|</span>
-<span
class="o">+------------------------------------------------------------------+</span>
-</pre></div>
-</div>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">unnest</span><span
class="p">(</span><span class="nb">range</span><span class="p">(</span><span
class="mi">0</span><span class="p">,</span> <span class="mi">10</span><span
class="p">));</span>
-<span class="o">+-----------------------------------+</span>
-<span class="o">|</span> <span class="n">unnest</span><span
class="p">(</span><span class="nb">range</span><span class="p">(</span><span
class="n">Int64</span><span class="p">(</span><span class="mi">0</span><span
class="p">),</span><span class="n">Int64</span><span class="p">(</span><span
class="mi">10</span><span class="p">)))</span> <span class="o">|</span>
-<span class="o">+-----------------------------------+</span>
-<span class="o">|</span> <span class="mi">0</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="mi">1</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="mi">2</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="mi">3</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="mi">4</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="mi">5</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="mi">6</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="mi">7</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="mi">8</span>
<span class="o">|</span>
-<span class="o">|</span> <span class="mi">9</span>
<span class="o">|</span>
-<span class="o">+-----------------------------------+</span>
-</pre></div>
-</div>
-</section>
-</section>
<section id="range">
<h3><code class="docutils literal notranslate"><span
class="pre">range</span></code><a class="headerlink" href="#range" title="Link
to this heading">¶</a></h3>
<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> or
@@ -807,8 +716,8 @@ For example,</p>
</pre></div>
</div>
<p>are not allowed</p>
-<section id="id2">
-<h4>Arguments<a class="headerlink" href="#id2" title="Link to this
heading">¶</a></h4>
+<section id="id1">
+<h4>Arguments<a class="headerlink" href="#id1" title="Link to this
heading">¶</a></h4>
<ul class="simple">
<li><p><strong>start</strong>: start of the range. Ints, timestamps, dates or
string types that can be coerced to Date32 are supported.</p></li>
<li><p><strong>end</strong>: end of the range (not included). Type must be the
same as start.</p></li>
@@ -823,43 +732,6 @@ For example,</p>
</section>
</section>
</section>
-<section id="struct-functions">
-<h2>Struct Functions<a class="headerlink" href="#struct-functions" title="Link
to this heading">¶</a></h2>
-<ul class="simple">
-<li><p><a class="reference internal" href="#unnest-struct">unnest</a></p></li>
-</ul>
-<p>For more struct functions see the new documentation <a class="reference
external"
href="https://datafusion.apache.org/user-guide/sql/scalar_functions_new.html";>
-<code class="docutils literal notranslate"><span
class="pre">here</span></code></a></p>
-<section id="unnest-struct">
-<h3><code class="docutils literal notranslate"><span class="pre">unnest</span>
<span class="pre">(struct)</span></code><a class="headerlink"
href="#unnest-struct" title="Link to this heading">¶</a></h3>
-<p>Unwraps struct fields into columns.</p>
-<section id="id3">
-<h4>Arguments<a class="headerlink" href="#id3" title="Link to this
heading">¶</a></h4>
-<ul class="simple">
-<li><p><strong>struct</strong>: Object expression to unnest.
-Can be a constant, column, or function, and any combination of object
operators.</p></li>
-</ul>
-</section>
-<section id="id4">
-<h4>Examples<a class="headerlink" href="#id4" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="o">*</span> <span class="kn">from</span>
<span class="nn">foo</span><span class="p">;</span>
-<span class="o">+---------------------+</span>
-<span class="o">|</span> <span class="n">column1</span> <span
class="o">|</span>
-<span class="o">+---------------------+</span>
-<span class="o">|</span> <span class="p">{</span><span class="n">a</span><span
class="p">:</span> <span class="mi">5</span><span class="p">,</span> <span
class="n">b</span><span class="p">:</span> <span class="n">a</span> <span
class="n">string</span><span class="p">}</span> <span class="o">|</span>
-<span class="o">+---------------------+</span>
-
-<span class="o">></span> <span class="n">select</span> <span
class="n">unnest</span><span class="p">(</span><span
class="n">column1</span><span class="p">)</span> <span class="kn">from</span>
<span class="nn">foo</span><span class="p">;</span>
-<span class="o">+-----------------------+-----------------------+</span>
-<span class="o">|</span> <span class="n">unnest</span><span
class="p">(</span><span class="n">foo</span><span class="o">.</span><span
class="n">column1</span><span class="p">)</span><span class="o">.</span><span
class="n">a</span> <span class="o">|</span> <span class="n">unnest</span><span
class="p">(</span><span class="n">foo</span><span class="o">.</span><span
class="n">column1</span><span class="p">)</span><span class="o">.</span><span
class="n">b</span> <span class="o">|</span>
-<span class="o">+-----------------------+-----------------------+</span>
-<span class="o">|</span> <span class="mi">5</span> <span
class="o">|</span> <span class="n">a</span> <span class="n">string</span>
<span class="o">|</span>
-<span class="o">+-----------------------+-----------------------+</span>
-</pre></div>
-</div>
-</section>
-</section>
-</section>
<section id="other-functions">
<h2>Other Functions<a class="headerlink" href="#other-functions" title="Link
to this heading">¶</a></h2>
<p>See the new documentation <a class="reference external"
href="https://datafusion.apache.org/user-guide/sql/scalar_functions_new.html";><code
class="docutils literal notranslate"><span
class="pre">here</span></code></a></p>
diff --git a/user-guide/sql/scalar_functions_new.html
b/user-guide/sql/scalar_functions_new.html
index 944dfdbfa0..d15413af83 100644
--- a/user-guide/sql/scalar_functions_new.html
+++ b/user-guide/sql/scalar_functions_new.html
@@ -34,7 +34,7 @@
<script async="true" defer="true"
src="https://buttons.github.io/buttons.js";></script>
<link rel="index" title="Index" href="../../genindex.html" />
<link rel="search" title="Search" href="../../search.html" />
- <link rel="next" title="Status" href="sql_status.html" />
+ <link rel="next" title="Special Functions" href="special_functions.html" />
<link rel="prev" title="Scalar Functions" href="scalar_functions.html" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<meta name="docsearch:language" content="en">
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql_status.html">
Status
@@ -8927,10 +8932,10 @@ syntax such as <code class="docutils literal
notranslate"><span class="pre">my_s
<p class="prev-next-title">Scalar Functions</p>
</div>
</a>
- <a class='right-next' id="next-link" href="sql_status.html" title="next
page">
+ <a class='right-next' id="next-link" href="special_functions.html"
title="next page">
<div class="prev-next-info">
<p class="prev-next-subtitle">next</p>
- <p class="prev-next-title">Status</p>
+ <p class="prev-next-title">Special Functions</p>
</div>
<i class="fas fa-angle-right"></i>
</a>
diff --git a/user-guide/sql/select.html b/user-guide/sql/select.html
index 4f58e24f1e..ca0d75b6d5 100644
--- a/user-guide/sql/select.html
+++ b/user-guide/sql/select.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql_status.html">
Status
diff --git a/user-guide/sql/dml.html b/user-guide/sql/special_functions.html
similarity index 59%
copy from user-guide/sql/dml.html
copy to user-guide/sql/special_functions.html
index 4a19d707af..e564f84dc2 100644
--- a/user-guide/sql/dml.html
+++ b/user-guide/sql/special_functions.html
@@ -5,7 +5,7 @@
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0"
/><meta name="viewport" content="width=device-width, initial-scale=1" />
- <title>DML — Apache DataFusion documentation</title>
+ <title>Special Functions — Apache DataFusion documentation</title>
<link href="../../_static/styles/theme.css?digest=1999514e3f237ded88cf"
rel="stylesheet">
<link
href="../../_static/styles/pydata-sphinx-theme.css?digest=1999514e3f237ded88cf"
rel="stylesheet">
@@ -34,8 +34,8 @@
<script async="true" defer="true"
src="https://buttons.github.io/buttons.js";></script>
<link rel="index" title="Index" href="../../genindex.html" />
<link rel="search" title="Search" href="../../search.html" />
- <link rel="next" title="EXPLAIN" href="explain.html" />
- <link rel="prev" title="DDL" href="ddl.html" />
+ <link rel="next" title="Status" href="sql_status.html" />
+ <link rel="prev" title="Scalar Functions (NEW)"
href="scalar_functions_new.html" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<meta name="docsearch:language" content="en">
@@ -228,8 +228,8 @@
DDL
</a>
</li>
- <li class="toctree-l2 current active">
- <a class="current reference internal" href="#">
+ <li class="toctree-l2">
+ <a class="reference internal" href="dml.html">
DML
</a>
</li>
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2 current active">
+ <a class="current reference internal" href="#">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql_status.html">
Status
@@ -509,26 +514,54 @@
<nav id="bd-toc-nav">
<ul class="visible nav section-nav flex-column">
<li class="toc-h2 nav-item toc-entry">
- <a class="reference internal nav-link" href="#copy">
- COPY
+ <a class="reference internal nav-link" href="#expansion-functions">
+ Expansion Functions
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#examples">
- Examples
+ <a class="reference internal nav-link" href="#unnest">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ unnest
+ </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="#arguments">
+ Arguments
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#examples">
+ Examples
+ </a>
+ </li>
+ </ul>
</li>
- </ul>
- </li>
- <li class="toc-h2 nav-item toc-entry">
- <a class="reference internal nav-link" href="#insert">
- INSERT
- </a>
- <ul class="nav section-nav flex-column">
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id1">
- Examples
+ <a class="reference internal nav-link" href="#unnest-struct">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ unnest
+ </span>
+ <span class="pre">
+ (struct)
+ </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="#id1">
+ Arguments
+ </a>
+ </li>
+ <li class="toc-h4 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#id2">
+ Examples
+ </a>
+ </li>
+ </ul>
</li>
</ul>
</li>
@@ -541,7 +574,7 @@
<div class="tocsection editthispage">
- <a
href="https://github.com/apache/arrow-datafusion/edit/main/docs/source/user-guide/sql/dml.md";>
+ <a
href="https://github.com/apache/arrow-datafusion/edit/main/docs/source/user-guide/sql/special_functions.md";>
<i class="fas fa-pencil-alt"></i> Edit this page
</a>
</div>
@@ -578,111 +611,93 @@
specific language governing permissions and limitations
under the License.
-->
-<section id="dml">
-<h1>DML<a class="headerlink" href="#dml" title="Link to this
heading">¶</a></h1>
-<p>DML stands for “Data Manipulation Language” and relates to inserting
-and modifying data in tables.</p>
-<section id="copy">
-<h2>COPY<a class="headerlink" href="#copy" title="Link to this
heading">¶</a></h2>
-<p>Copies the contents of a table or query to file(s). Supported file
-formats are <code class="docutils literal notranslate"><span
class="pre">parquet</span></code>, <code class="docutils literal
notranslate"><span class="pre">csv</span></code>, <code class="docutils literal
notranslate"><span class="pre">json</span></code>, and <code class="docutils
literal notranslate"><span class="pre">arrow</span></code>.</p>
-<pre>
-COPY { <i><b>table_name</i></b> | <i><b>query</i></b> }
-TO '<i><b>file_name</i></b>'
-[ STORED AS <i><b>format</i></b> ]
-[ PARTITIONED BY <i><b>column_name</i></b> [, ...] ]
-[ OPTIONS( <i><b>option</i></b> [, ... ] ) ]
-</pre>
-<p><code class="docutils literal notranslate"><span class="pre">STORED</span>
<span class="pre">AS</span></code> specifies the file format the <code
class="docutils literal notranslate"><span class="pre">COPY</span></code>
command will write. If this
-clause is not specified, it will be inferred from the file extension if
possible.</p>
-<p><code class="docutils literal notranslate"><span
class="pre">PARTITIONED</span> <span class="pre">BY</span></code> specifies the
columns to use for partitioning the output files into
-separate hive-style directories. By default, columns used in <code
class="docutils literal notranslate"><span class="pre">PARTITIONED</span> <span
class="pre">BY</span></code> will be removed
-from the output format. If you want to keep the columns, you should provide
the option
-<code class="docutils literal notranslate"><span
class="pre">execution.keep_partition_by_columns</span> <span
class="pre">true</span></code>. <code class="docutils literal
notranslate"><span
class="pre">execution.keep_partition_by_columns</span></code> flag can also
-be enabled through <code class="docutils literal notranslate"><span
class="pre">ExecutionOptions</span></code> within <code class="docutils literal
notranslate"><span class="pre">SessionConfig</span></code>.</p>
-<p>The output format is determined by the first match of the following
rules:</p>
-<ol class="arabic simple">
-<li><p>Value of <code class="docutils literal notranslate"><span
class="pre">STORED</span> <span class="pre">AS</span></code></p></li>
-<li><p>Filename extension (e.g. <code class="docutils literal
notranslate"><span class="pre">foo.parquet</span></code> implies <code
class="docutils literal notranslate"><span class="pre">PARQUET</span></code>
format)</p></li>
-</ol>
-<p>For a detailed list of valid OPTIONS, see <a class="reference internal"
href="write_options.html"><span class="doc std std-doc">Write
Options</span></a>.</p>
+<section id="special-functions">
+<h1>Special Functions<a class="headerlink" href="#special-functions"
title="Link to this heading">¶</a></h1>
+<section id="expansion-functions">
+<h2>Expansion Functions<a class="headerlink" href="#expansion-functions"
title="Link to this heading">¶</a></h2>
+<ul class="simple">
+<li><p><a class="reference internal" href="#unnest">unnest</a></p></li>
+<li><p><a class="reference internal"
href="#unnest-struct">unnest(struct)</a></p></li>
+</ul>
+<section id="unnest">
+<h3><code class="docutils literal notranslate"><span
class="pre">unnest</span></code><a class="headerlink" href="#unnest"
title="Link to this heading">¶</a></h3>
+<p>Expands an array or map into rows.</p>
+<section id="arguments">
+<h4>Arguments<a class="headerlink" href="#arguments" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>array</strong>: Array expression to unnest.
+Can be a constant, column, or function, and any combination of array
operators.</p></li>
+</ul>
+</section>
<section id="examples">
-<h3>Examples<a class="headerlink" href="#examples" title="Link to this
heading">¶</a></h3>
-<p>Copy the contents of <code class="docutils literal notranslate"><span
class="pre">source_table</span></code> to <code class="docutils literal
notranslate"><span class="pre">file_name.json</span></code> in JSON format:</p>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">COPY</span><span class="w"> </span><span
class="n">source_table</span><span class="w"> </span><span
class="k">TO</span><span class="w"> </span><span
class="s1">'file_name.json'</span><span class="p">;</span>
-<span class="o">+</span><span class="c1">-------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="k">count</span><span class="w"> </span><span class="o">|</span>
-<span class="o">+</span><span class="c1">-------+</span>
-<span class="o">|</span><span class="w"> </span><span class="mi">2</span><span
class="w"> </span><span class="o">|</span>
-<span class="o">+</span><span class="c1">-------+</span>
-</pre></div>
-</div>
-<p>Copy the contents of <code class="docutils literal notranslate"><span
class="pre">source_table</span></code> to one or more Parquet formatted
-files in the <code class="docutils literal notranslate"><span
class="pre">dir_name</span></code> directory:</p>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">COPY</span><span class="w"> </span><span
class="n">source_table</span><span class="w"> </span><span
class="k">TO</span><span class="w"> </span><span
class="s1">'dir_name'</span><span class="w"> </span><span
class="n">STORED</span><span class="w"> </span><span class="k">AS</span><span
class="w"> </span><span class="n">PARQUET</span><spa [...]
-<span class="o">+</span><span class="c1">-------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="k">count</span><span class="w"> </span><span class="o">|</span>
-<span class="o">+</span><span class="c1">-------+</span>
-<span class="o">|</span><span class="w"> </span><span class="mi">2</span><span
class="w"> </span><span class="o">|</span>
-<span class="o">+</span><span class="c1">-------+</span>
-</pre></div>
-</div>
-<p>Copy the contents of <code class="docutils literal notranslate"><span
class="pre">source_table</span></code> to multiple directories
-of hive-style partitioned parquet files:</p>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">COPY</span><span class="w"> </span><span
class="n">source_table</span><span class="w"> </span><span
class="k">TO</span><span class="w"> </span><span
class="s1">'dir_name'</span><span class="w"> </span><span
class="n">STORED</span><span class="w"> </span><span class="k">AS</span><span
class="w"> </span><span class="n">parquet</span><spa [...]
-<span class="o">+</span><span class="c1">-------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="k">count</span><span class="w"> </span><span class="o">|</span>
-<span class="o">+</span><span class="c1">-------+</span>
-<span class="o">|</span><span class="w"> </span><span class="mi">2</span><span
class="w"> </span><span class="o">|</span>
-<span class="o">+</span><span class="c1">-------+</span>
-</pre></div>
-</div>
-<p>If the the data contains values of <code class="docutils literal
notranslate"><span class="pre">x</span></code> and <code class="docutils
literal notranslate"><span class="pre">y</span></code> in column1 and only
<code class="docutils literal notranslate"><span class="pre">a</span></code> in
-column2, output files will appear in the following directory structure:</p>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="n">dir_name</span><span
class="o">/</span>
- <span class="n">column1</span><span class="o">=</span><span
class="n">x</span><span class="o">/</span>
- <span class="n">column2</span><span class="o">=</span><span
class="n">a</span><span class="o">/</span>
- <span class="o"><</span><span class="n">file</span><span
class="o">>.</span><span class="n">parquet</span>
- <span class="o"><</span><span class="n">file</span><span
class="o">>.</span><span class="n">parquet</span>
- <span class="o">...</span>
- <span class="n">column1</span><span class="o">=</span><span
class="n">y</span><span class="o">/</span>
- <span class="n">column2</span><span class="o">=</span><span
class="n">a</span><span class="o">/</span>
- <span class="o"><</span><span class="n">file</span><span
class="o">>.</span><span class="n">parquet</span>
- <span class="o"><</span><span class="n">file</span><span
class="o">>.</span><span class="n">parquet</span>
- <span class="o">...</span>
+<h4>Examples<a class="headerlink" href="#examples" title="Link to this
heading">¶</a></h4>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="k">unnest</span><span class="p">(</span><span
class="n">make_array</span><span class="p">(</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="mi">2</span><span class="p">,</span><span class="w"> </span><span
class="mi">3</span><span class="p">,</span><sp [...]
+<span class="o">+</span><span class="c1">----------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">unnested</span><span class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">----------+</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">1</span><span
class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">2</span><span
class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">3</span><span
class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">4</span><span
class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">5</span><span
class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">----------+</span>
</pre></div>
</div>
-<p>Run the query <code class="docutils literal notranslate"><span
class="pre">SELECT</span> <span class="pre">*</span> <span
class="pre">from</span> <span class="pre">source</span> <span
class="pre">ORDER</span> <span class="pre">BY</span> <span
class="pre">time</span></code> and write the
-results (maintaining the order) to a parquet file named
-<code class="docutils literal notranslate"><span
class="pre">output.parquet</span></code> with a maximum parquet row group size
of 10MB:</p>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">COPY</span><span class="w"> </span><span
class="p">(</span><span class="k">SELECT</span><span class="w"> </span><span
class="o">*</span><span class="w"> </span><span class="k">from</span><span
class="w"> </span><span class="k">source</span><span class="w"> </span><span
class="k">ORDER</span><span class="w"> </span><span class="k">BY</span><spa
[...]
-<span class="o">+</span><span class="c1">-------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="k">count</span><span class="w"> </span><span class="o">|</span>
-<span class="o">+</span><span class="c1">-------+</span>
-<span class="o">|</span><span class="w"> </span><span class="mi">2</span><span
class="w"> </span><span class="o">|</span>
-<span class="o">+</span><span class="c1">-------+</span>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="k">unnest</span><span class="p">(</span><span
class="n">range</span><span class="p">(</span><span class="mi">0</span><span
class="p">,</span><span class="w"> </span><span class="mi">10</span><span
class="p">))</span><span class="w"> </span><span class="k">as</span><span
class="w"> </span><span [...]
+<span class="o">+</span><span class="c1">----------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">unnested_range</span><span class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">----------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">0</span><span
class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">1</span><span
class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">2</span><span
class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">3</span><span
class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">4</span><span
class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">5</span><span
class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">6</span><span
class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">7</span><span
class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">8</span><span
class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">9</span><span
class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">----------------+</span>
</pre></div>
</div>
</section>
</section>
-<section id="insert">
-<h2>INSERT<a class="headerlink" href="#insert" title="Link to this
heading">¶</a></h2>
+<section id="unnest-struct">
+<h3><code class="docutils literal notranslate"><span class="pre">unnest</span>
<span class="pre">(struct)</span></code><a class="headerlink"
href="#unnest-struct" title="Link to this heading">¶</a></h3>
+<p>Expand a struct fields into individual columns.</p>
<section id="id1">
-<h3>Examples<a class="headerlink" href="#id1" title="Link to this
heading">¶</a></h3>
-<p>Insert values into a table.</p>
-<pre>
-INSERT INTO <i><b>table_name</i></b> { VALUES ( <i><b>expression</i></b> [,
...] ) [, ...] | <i><b>query</i></b> }
-</pre>
-<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">INSERT</span><span class="w"> </span><span
class="k">INTO</span><span class="w"> </span><span
class="n">target_table</span><span class="w"> </span><span
class="k">VALUES</span><span class="w"> </span><span class="p">(</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="s1">'Foo'</span><span class [...]
-<span class="o">+</span><span class="c1">-------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="k">count</span><span class="w"> </span><span class="o">|</span>
-<span class="o">+</span><span class="c1">-------+</span>
-<span class="o">|</span><span class="w"> </span><span class="mi">2</span><span
class="w"> </span><span class="o">|</span>
-<span class="o">+</span><span class="c1">-------+</span>
+<h4>Arguments<a class="headerlink" href="#id1" title="Link to this
heading">¶</a></h4>
+<ul class="simple">
+<li><p><strong>struct</strong>: Object expression to unnest.
+Can be a constant, column, or function, and any combination of object
operators.</p></li>
+</ul>
+</section>
+<section id="id2">
+<h4>Examples<a class="headerlink" href="#id2" title="Link to this
heading">¶</a></h4>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">create</span><span class="w"> </span><span
class="k">table</span><span class="w"> </span><span class="n">foo</span><span
class="w"> </span><span class="k">as</span><span class="w"> </span><span
class="k">values</span><span class="w"> </span><span class="p">(</span><span
class="err">{</span><span class="n">a</span><span class="p">:</span><span [...]
+
+<span class="o">></span><span class="w"> </span><span
class="k">create</span><span class="w"> </span><span class="k">view</span><span
class="w"> </span><span class="n">foov</span><span class="w"> </span><span
class="k">as</span><span class="w"> </span><span class="k">select</span><span
class="w"> </span><span class="n">column1</span><span class="w"> </span><span
class="k">as</span><span class="w"> </span><span
class="n">struct_column</span><span class="w"> </span><span class="k">from<
[...]
+
+<span class="o">></span><span class="w"> </span><span
class="k">select</span><span class="w"> </span><span class="o">*</span><span
class="w"> </span><span class="k">from</span><span class="w"> </span><span
class="n">foov</span><span class="p">;</span>
+<span class="o">+</span><span class="c1">---------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">struct_column</span><span class="w"> </span><span
class="o">|</span>
+<span class="o">+</span><span class="c1">---------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="err">{</span><span class="n">a</span><span class="p">:</span><span
class="w"> </span><span class="mi">5</span><span class="p">,</span><span
class="w"> </span><span class="n">b</span><span class="p">:</span><span
class="w"> </span><span class="n">a</span><span class="w"> </span><span
class="n">string</span><span class="err">}</span><span class="w">
</span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span
class="err">{</span><span class="n">a</span><span class="p">:</span><span
class="w"> </span><span class="mi">6</span><span class="p">,</span><span
class="w"> </span><span class="n">b</span><span class="p">:</span><span
class="w"> </span><span class="n">another</span><span class="w"> </span><span
class="n">string</span><span class="err">}</span><span class="w"> </span><span
class="o">|</span>
+<span class="o">+</span><span class="c1">---------------------------+</span>
+
+<span class="o">></span><span class="w"> </span><span
class="k">select</span><span class="w"> </span><span
class="k">unnest</span><span class="p">(</span><span
class="n">struct_column</span><span class="p">)</span><span class="w">
</span><span class="k">from</span><span class="w"> </span><span
class="n">foov</span><span class="p">;</span>
+<span class="o">+</span><span
class="c1">------------------------------------------+------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">unnest_placeholder</span><span class="p">(</span><span
class="n">foov</span><span class="p">.</span><span
class="n">struct_column</span><span class="p">).</span><span
class="n">a</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="n">unnest_placeholder</span><span
class="p">(</span><span class="n">foov</span><span class="p">.</span><span
class="n">struct_column</span><span class="p">).< [...]
+<span class="o">+</span><span
class="c1">------------------------------------------+------------------------------------------+</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">5</span><span
class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="n">a</span><span
class="w"> </span><span class="n">string</span><span class="w">
</span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span class="mi">6</span><span
class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="n">another</span><span
class="w"> </span><span class="n">string</span><span class="w">
</span><span class="o">|</span>
+<span class="o">+</span><span
class="c1">------------------------------------------+------------------------------------------+</span>
</pre></div>
</div>
</section>
</section>
+</section>
</section>
@@ -691,17 +706,17 @@ INSERT INTO <i><b>table_name</i></b> { VALUES (
<i><b>expression</i></b> [, ...]
<!-- Previous / next buttons -->
<div class='prev-next-area'>
- <a class='left-prev' id="prev-link" href="ddl.html" title="previous page">
+ <a class='left-prev' id="prev-link" href="scalar_functions_new.html"
title="previous page">
<i class="fas fa-angle-left"></i>
<div class="prev-next-info">
<p class="prev-next-subtitle">previous</p>
- <p class="prev-next-title">DDL</p>
+ <p class="prev-next-title">Scalar Functions (NEW)</p>
</div>
</a>
- <a class='right-next' id="next-link" href="explain.html" title="next page">
+ <a class='right-next' id="next-link" href="sql_status.html" title="next
page">
<div class="prev-next-info">
<p class="prev-next-subtitle">next</p>
- <p class="prev-next-title">EXPLAIN</p>
+ <p class="prev-next-title">Status</p>
</div>
<i class="fas fa-angle-right"></i>
</a>
diff --git a/user-guide/sql/sql_status.html b/user-guide/sql/sql_status.html
index db58d94da5..5336b76cab 100644
--- a/user-guide/sql/sql_status.html
+++ b/user-guide/sql/sql_status.html
@@ -35,7 +35,7 @@
<link rel="index" title="Index" href="../../genindex.html" />
<link rel="search" title="Search" href="../../search.html" />
<link rel="next" title="Write Options" href="write_options.html" />
- <link rel="prev" title="Scalar Functions (NEW)"
href="scalar_functions_new.html" />
+ <link rel="prev" title="Special Functions" href="special_functions.html" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<meta name="docsearch:language" content="en">
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2 current active">
<a class="current reference internal" href="#">
Status
@@ -691,11 +696,11 @@ trait, DataFusion includes built in support for the
following formats:</p>
<!-- Previous / next buttons -->
<div class='prev-next-area'>
- <a class='left-prev' id="prev-link" href="scalar_functions_new.html"
title="previous page">
+ <a class='left-prev' id="prev-link" href="special_functions.html"
title="previous page">
<i class="fas fa-angle-left"></i>
<div class="prev-next-info">
<p class="prev-next-subtitle">previous</p>
- <p class="prev-next-title">Scalar Functions (NEW)</p>
+ <p class="prev-next-title">Special Functions</p>
</div>
</a>
<a class='right-next' id="next-link" href="write_options.html" title="next
page">
diff --git a/user-guide/sql/subqueries.html b/user-guide/sql/subqueries.html
index 0a2a062997..4cf869cd7e 100644
--- a/user-guide/sql/subqueries.html
+++ b/user-guide/sql/subqueries.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql_status.html">
Status
diff --git a/user-guide/sql/window_functions.html
b/user-guide/sql/window_functions.html
index 0cfb264924..8d79d17f97 100644
--- a/user-guide/sql/window_functions.html
+++ b/user-guide/sql/window_functions.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql_status.html">
Status
diff --git a/user-guide/sql/window_functions_new.html
b/user-guide/sql/window_functions_new.html
index 2c846bb12c..1c7840b838 100644
--- a/user-guide/sql/window_functions_new.html
+++ b/user-guide/sql/window_functions_new.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql_status.html">
Status
diff --git a/user-guide/sql/write_options.html
b/user-guide/sql/write_options.html
index 8a513239be..873835aa89 100644
--- a/user-guide/sql/write_options.html
+++ b/user-guide/sql/write_options.html
@@ -278,6 +278,11 @@
Scalar Functions (NEW)
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="special_functions.html">
+ Special Functions
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql_status.html">
Status
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
