You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@arrow.apache.org by gi...@apache.org on 2024/02/09 21:02:02 UTC
(arrow-datafusion) branch asf-site updated: Publish built docs triggered by ae882356171513c9d6c22b3bd966898fb4e8cac0
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 4969e5f3fb Publish built docs triggered by ae882356171513c9d6c22b3bd966898fb4e8cac0
4969e5f3fb is described below
commit 4969e5f3fbc7fa4ac83fc69631dbc0aa3e00d838
Author: github-actions[bot] <gi...@users.noreply.github.com>
AuthorDate: Fri Feb 9 21:01:56 2024 +0000
Publish built docs triggered by ae882356171513c9d6c22b3bd966898fb4e8cac0
---
_sources/library-user-guide/adding-udfs.md.txt | 4 +-
_sources/user-guide/cli.md.txt | 9 +-
_sources/user-guide/example-usage.md.txt | 2 +-
_sources/user-guide/expressions.md.txt | 2 +-
_sources/user-guide/sql/data_types.md.txt | 4 +-
_sources/user-guide/sql/ddl.md.txt | 2 +-
_sources/user-guide/sql/explain.md.txt | 4 +-
_sources/user-guide/sql/information_schema.md.txt | 2 +-
_sources/user-guide/sql/operators.md.txt | 100 ++++++++---
_sources/user-guide/sql/scalar_functions.md.txt | 68 +++-----
_sources/user-guide/sql/select.md.txt | 12 +-
_sources/user-guide/sql/subqueries.md.txt | 12 +-
_sources/user-guide/sql/window_functions.md.txt | 4 +-
_sources/user-guide/sql/write_options.md.txt | 2 +-
library-user-guide/adding-udfs.html | 48 +++---
objects.inv | Bin 1121 -> 1380 bytes
searchindex.js | 2 +-
user-guide/cli.html | 71 ++++----
user-guide/example-usage.html | 14 +-
user-guide/expressions.html | 2 +-
user-guide/sql/data_types.html | 4 +-
user-guide/sql/ddl.html | 4 +-
user-guide/sql/explain.html | 58 +++----
user-guide/sql/information_schema.html | 2 +-
user-guide/sql/operators.html | 192 +++++++++++-----------
user-guide/sql/scalar_functions.html | 69 ++++----
user-guide/sql/select.html | 12 +-
user-guide/sql/subqueries.html | 12 +-
user-guide/sql/window_functions.html | 16 +-
user-guide/sql/write_options.html | 2 +-
30 files changed, 387 insertions(+), 348 deletions(-)
diff --git a/_sources/library-user-guide/adding-udfs.md.txt b/_sources/library-user-guide/adding-udfs.md.txt
index 1824b23f9f..037e99f87f 100644
--- a/_sources/library-user-guide/adding-udfs.md.txt
+++ b/_sources/library-user-guide/adding-udfs.md.txt
@@ -244,7 +244,7 @@ At this point, you can use the `smooth_it` function in your query:
For example, if we have a [`cars.csv`](https://github.com/apache/arrow-datafusion/blob/main/datafusion/core/tests/data/cars.csv) whose contents like
-```csv
+```
car,speed,time
red,20.0,1996-04-12T12:05:03.000000000
red,20.3,1996-04-12T12:05:04.000000000
@@ -279,7 +279,7 @@ df.show().await?;
the output will be like:
-```csv
+```
+-------+-------+--------------------+---------------------+
| car | speed | smooth_speed | time |
+-------+-------+--------------------+---------------------+
diff --git a/_sources/user-guide/cli.md.txt b/_sources/user-guide/cli.md.txt
index af61978a20..a8a9d6f212 100644
--- a/_sources/user-guide/cli.md.txt
+++ b/_sources/user-guide/cli.md.txt
@@ -198,7 +198,7 @@ You can also query directly from the remote location via HTTP(S) without
registering the location as a table
```sql
-❯ select count(*) from 'https://datasets.clickhouse.com/hits_compatible/athena_partitioned/hits_1.parquet'
+select count(*) from 'https://datasets.clickhouse.com/hits_compatible/athena_partitioned/hits_1.parquet'
+----------+
| COUNT(*) |
+----------+
@@ -285,7 +285,7 @@ LOCATION 'https://datasets.clickhouse.com/hits_compatible/athena_partitioned/hit
```
```sql
-❯ select count(*) from hits;
+select count(*) from hits;
+----------+
| COUNT(*) |
+----------+
@@ -583,7 +583,7 @@ For example, to set `datafusion.execution.batch_size` to `1024` you
would set the `DATAFUSION_EXECUTION_BATCH_SIZE` environment variable
appropriately:
-```SQL
+```shell
$ DATAFUSION_EXECUTION_BATCH_SIZE=1024 datafusion-cli
DataFusion CLI v12.0.0
❯ show all;
@@ -603,10 +603,9 @@ DataFusion CLI v12.0.0
You can change the configuration options using `SET` statement as well
-```SQL
+```shell
$ datafusion-cli
DataFusion CLI v13.0.0
-
❯ show datafusion.execution.batch_size;
+---------------------------------+---------+
| name | value |
diff --git a/_sources/user-guide/example-usage.md.txt b/_sources/user-guide/example-usage.md.txt
index fd525608d3..1c5c8f49a1 100644
--- a/_sources/user-guide/example-usage.md.txt
+++ b/_sources/user-guide/example-usage.md.txt
@@ -228,7 +228,7 @@ codegen-units = 1
Then, in `main.rs.` update the memory allocator with the below after your imports:
-```rust,ignore
+```rust ,ignore
use datafusion::prelude::*;
#[global_allocator]
diff --git a/_sources/user-guide/expressions.md.txt b/_sources/user-guide/expressions.md.txt
index f01750e56a..dcb599b9b3 100644
--- a/_sources/user-guide/expressions.md.txt
+++ b/_sources/user-guide/expressions.md.txt
@@ -152,7 +152,7 @@ but these operators always return a `bool` which makes them not work with the ex
Unlike to some databases the math functions in Datafusion works the same way as Rust math functions, avoiding failing on corner cases e.g
```sql
-❯ select log(-1), log(0), sqrt(-1);
+select log(-1), log(0), sqrt(-1);
+----------------+---------------+-----------------+
| log(Int64(-1)) | log(Int64(0)) | sqrt(Int64(-1)) |
+----------------+---------------+-----------------+
diff --git a/_sources/user-guide/sql/data_types.md.txt b/_sources/user-guide/sql/data_types.md.txt
index caa08b8bae..9f99d7bcb8 100644
--- a/_sources/user-guide/sql/data_types.md.txt
+++ b/_sources/user-guide/sql/data_types.md.txt
@@ -29,7 +29,7 @@ You can see the corresponding Arrow type for any SQL expression using
the `arrow_typeof` function. For example:
```sql
-❯ select arrow_typeof(interval '1 month');
+select arrow_typeof(interval '1 month');
+-------------------------------------+
| arrowtypeof(IntervalYearMonth("1")) |
+-------------------------------------+
@@ -41,7 +41,7 @@ You can cast a SQL expression to a specific Arrow type using the `arrow_cast` fu
For example, to cast the output of `now()` to a `Timestamp` with second precision:
```sql
-❯ select arrow_cast(now(), 'Timestamp(Second, None)');
+select arrow_cast(now(), 'Timestamp(Second, None)');
+---------------------+
| now() |
+---------------------+
diff --git a/_sources/user-guide/sql/ddl.md.txt b/_sources/user-guide/sql/ddl.md.txt
index 81e62efbeb..3d8b632f6e 100644
--- a/_sources/user-guide/sql/ddl.md.txt
+++ b/_sources/user-guide/sql/ddl.md.txt
@@ -188,7 +188,7 @@ LOCATION '/path/to/aggregate_test_100.csv';
Where `WITH ORDER` clause specifies the sort order:
-```sql
+```
WITH ORDER (sort_expression1 [ASC | DESC] [NULLS { FIRST | LAST }]
[, sort_expression2 [ASC | DESC] [NULLS { FIRST | LAST }] ...])
```
diff --git a/_sources/user-guide/sql/explain.md.txt b/_sources/user-guide/sql/explain.md.txt
index b240b14eb5..22f73e3d76 100644
--- a/_sources/user-guide/sql/explain.md.txt
+++ b/_sources/user-guide/sql/explain.md.txt
@@ -30,7 +30,7 @@ EXPLAIN [ANALYZE] [VERBOSE] statement
Shows the execution plan of a statement.
If you need more detailed output, use `EXPLAIN VERBOSE`.
-```sql
+```
EXPLAIN SELECT SUM(x) FROM table GROUP BY b;
+---------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+
| plan_type | plan |
@@ -54,7 +54,7 @@ EXPLAIN SELECT SUM(x) FROM table GROUP BY b;
Shows the execution plan and metrics of a statement.
If you need more information output, use `EXPLAIN ANALYZE VERBOSE`.
-```sql
+```
EXPLAIN ANALYZE SELECT SUM(x) FROM table GROUP BY b;
+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+
| plan_type | plan |
diff --git a/_sources/user-guide/sql/information_schema.md.txt b/_sources/user-guide/sql/information_schema.md.txt
index ced6117349..bf4aa00e1d 100644
--- a/_sources/user-guide/sql/information_schema.md.txt
+++ b/_sources/user-guide/sql/information_schema.md.txt
@@ -55,7 +55,7 @@ or
To show the current session configuration options, use the `SHOW ALL` command or the `information_schema.df_settings` view:
```sql
-❯ select * from information_schema.df_settings;
+select * from information_schema.df_settings;
+-------------------------------------------------+---------+
| name | setting |
diff --git a/_sources/user-guide/sql/operators.md.txt b/_sources/user-guide/sql/operators.md.txt
index 872ef55dd3..b0263ebe98 100644
--- a/_sources/user-guide/sql/operators.md.txt
+++ b/_sources/user-guide/sql/operators.md.txt
@@ -21,11 +21,13 @@
## Numerical Operators
-- [+ (plus)](#id1)
-- [- (minus)](#id2)
-- [\* (multiply)](#id3)
-- [/ (divide)](#id4)
-- [% (modulo)](#id5)
+- [+ (plus)](#op_plus)
+- [- (minus)](#op_minus)
+- [\* (multiply)](#op_multiply)
+- [/ (divide)](#op_divide)
+- [% (modulo)](#op_modulo)
+
+(op_plus)=
### `+`
@@ -40,6 +42,8 @@ Addition
+---------------------+
```
+(op_minus)=
+
### `-`
Subtraction
@@ -53,6 +57,8 @@ Subtraction
+---------------------+
```
+(op_multiply)=
+
### `*`
Multiplication
@@ -66,6 +72,8 @@ Multiplication
+---------------------+
```
+(op_divide)=
+
### `/`
Division (integer division truncates toward zero)
@@ -79,6 +87,8 @@ Division (integer division truncates toward zero)
+---------------------+
```
+(op_modulo)=
+
### `%`
Modulo (remainder)
@@ -94,18 +104,20 @@ Modulo (remainder)
## Comparison Operators
-- [= (equal)](#id6)
-- [!= (not equal)](#id7)
-- [< (less than)](#id8)
-- [<= (less than or equal to)](#id9)
-- [> (greater than)](#id10)
-- [>= (greater than or equal to)](#id11)
+- [= (equal)](#op_eq)
+- [!= (not equal)](#op_neq)
+- [< (less than)](#op_lt)
+- [<= (less than or equal to)](#op_le)
+- [> (greater than)](#op_gt)
+- [>= (greater than or equal to)](#op_ge)
- [IS DISTINCT FROM](#is-distinct-from)
- [IS NOT DISTINCT FROM](#is-not-distinct-from)
-- [~ (regex match)](#id12)
-- [~\* (regex case-insensitive match)](#id13)
-- [!~ (not regex match)](#id14)
-- [!~\* (not regex case-insensitive match)](#id15)
+- [~ (regex match)](#op_re_match)
+- [~\* (regex case-insensitive match)](#op_re_match_i)
+- [!~ (not regex match)](#op_re_not_match)
+- [!~\* (not regex case-insensitive match)](#op_re_not_match_i)
+
+(op_eq)=
### `=`
@@ -120,6 +132,8 @@ Equal
+---------------------+
```
+(op_neq)=
+
### `!=`
Not Equal
@@ -133,6 +147,8 @@ Not Equal
+----------------------+
```
+(op_lt)=
+
### `<`
Less Than
@@ -146,6 +162,8 @@ Less Than
+---------------------+
```
+(op_le)=
+
### `<=`
Less Than or Equal To
@@ -159,6 +177,8 @@ Less Than or Equal To
+----------------------+
```
+(op_gt)=
+
### `>`
Greater Than
@@ -172,6 +192,8 @@ Greater Than
+---------------------+
```
+(op_ge)=
+
### `>=`
Greater Than or Equal To
@@ -211,6 +233,8 @@ The negation of `IS DISTINCT FROM`
+--------------------------------+
```
+(op_re_match)=
+
### `~`
Regex Match
@@ -224,6 +248,8 @@ Regex Match
+-------------------------------------------------+
```
+(op_re_match_i)=
+
### `~*`
Regex Case-Insensitive Match
@@ -237,6 +263,8 @@ Regex Case-Insensitive Match
+--------------------------------------------------+
```
+(op_re_not_match)=
+
### `!~`
Not Regex Match
@@ -250,6 +278,8 @@ Not Regex Match
+--------------------------------------------------+
```
+(op_re_not_match_i)=
+
### `!~*`
Not Regex Case-Insensitive Match
@@ -268,7 +298,7 @@ Not Regex Case-Insensitive Match
Like Match
```sql
-❯ SELECT 'datafusion' ~~ 'dat_f%n';
+SELECT 'datafusion' ~~ 'dat_f%n';
+---------------------------------------+
| Utf8("datafusion") ~~ Utf8("dat_f%n") |
+---------------------------------------+
@@ -281,7 +311,7 @@ Like Match
Case-Insensitive Like Match
```sql
-❯ SELECT 'datafusion' ~~* 'Dat_F%n';
+SELECT 'datafusion' ~~* 'Dat_F%n';
+----------------------------------------+
| Utf8("datafusion") ~~* Utf8("Dat_F%n") |
+----------------------------------------+
@@ -294,7 +324,7 @@ Case-Insensitive Like Match
Not Like Match
```sql
-❯ SELECT 'datafusion' !~~ 'Dat_F%n';
+SELECT 'datafusion' !~~ 'Dat_F%n';
+----------------------------------------+
| Utf8("datafusion") !~~ Utf8("Dat_F%n") |
+----------------------------------------+
@@ -307,7 +337,7 @@ Not Like Match
Not Case-Insensitive Like Match
```sql
-❯ SELECT 'datafusion' !~~* 'Dat%F_n';
+SELECT 'datafusion' !~~* 'Dat%F_n';
+-----------------------------------------+
| Utf8("datafusion") !~~* Utf8("Dat%F_n") |
+-----------------------------------------+
@@ -348,11 +378,13 @@ Logical Or
## Bitwise Operators
-- [& (bitwise and)](#id16)
-- [| (bitwise or)](#id17)
-- [# (bitwise xor)](#id18)
-- [>> (bitwise shift right)](#id19)
-- [<< (bitwise shift left)](#id20)
+- [& (bitwise and)](#op_bit_and)
+- [| (bitwise or)](#op_bit_or)
+- [# (bitwise xor)](#op_bit_xor)
+- [>> (bitwise shift right)](#op_shift_r)
+- [<< (bitwise shift left)](#op_shift_l)
+
+(op_bit_and)=
### `&`
@@ -367,6 +399,8 @@ Bitwise And
+---------------------+
```
+(op_bit_or)=
+
### `|`
Bitwise Or
@@ -380,6 +414,8 @@ Bitwise Or
+---------------------+
```
+(op_bit_xor)=
+
### `#`
Bitwise Xor (interchangeable with `^`)
@@ -393,6 +429,8 @@ Bitwise Xor (interchangeable with `^`)
+---------------------+
```
+(op_shift_r)=
+
### `>>`
Bitwise Shift Right
@@ -406,6 +444,8 @@ Bitwise Shift Right
+----------------------+
```
+(op_shift_l)=
+
### `<<`
Bitwise Shift Left
@@ -421,9 +461,11 @@ Bitwise Shift Left
## Other Operators
-- [|| (string concatenation)](#id21)
-- [@> (array contains)](#id22)
-- [<@ (array is contained by)](#id23)
+- [|| (string concatenation)](#op_str_cat)
+- [@> (array contains)](#op_arr_contains)
+- [<@ (array is contained by)](#op_arr_contained_by)
+
+(op_str_cat)=
### `||`
@@ -438,6 +480,8 @@ String Concatenation
+----------------------------------------+
```
+(op_arr_contains)=
+
### `@>`
Array Contains
@@ -451,6 +495,8 @@ Array Contains
+-------------------------------------------------------------------------+
```
+(op_arr_contained_by)=
+
### `<@`
Array Is Contained By
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt b/_sources/user-guide/sql/scalar_functions.md.txt
index 89405f29ac..c9c32a67ce 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -722,7 +722,7 @@ concat(str[, ..., str_n])
- **str_n**: Subsequent string column or literal string to concatenate.
**Related functions**:
-[contcat_ws](#contcat_ws)
+[concat_ws](#concat_ws)
### `concat_ws`
@@ -1298,13 +1298,13 @@ regexp_like(str, regexp[, flags])
#### Example
```sql
-❯ select regexp_like('Köln', '[a-zA-Z]ö[a-zA-Z]{2}');
+select regexp_like('Köln', '[a-zA-Z]ö[a-zA-Z]{2}');
+--------------------------------------------------------+
| regexp_like(Utf8("Köln"),Utf8("[a-zA-Z]ö[a-zA-Z]{2}")) |
+--------------------------------------------------------+
| true |
+--------------------------------------------------------+
-❯ SELECT regexp_like('aBc', '(b|d)', 'i');
+SELECT regexp_like('aBc', '(b|d)', 'i');
+--------------------------------------------------+
| regexp_like(Utf8("aBc"),Utf8("(b|d)"),Utf8("i")) |
+--------------------------------------------------+
@@ -1312,15 +1312,11 @@ regexp_like(str, regexp[, flags])
+--------------------------------------------------+
```
-Additional examples can be found [here]
-
-[here]: https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/regexp.rs
+Additional examples can be found [here](https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/regexp.rs)
### `regexp_match`
-Returns a list of [regular expression] matches in a string.
-
-[regular expression]: https://docs.rs/regex/latest/regex/#syntax
+Returns a list of [regular expression](https://docs.rs/regex/latest/regex/#syntax) matches in a string.
```
regexp_match(str, regexp[, flags])
@@ -1343,13 +1339,13 @@ regexp_match(str, regexp[, flags])
#### Example
```sql
-❯ select regexp_match('Köln', '[a-zA-Z]ö[a-zA-Z]{2}');
+select regexp_match('Köln', '[a-zA-Z]ö[a-zA-Z]{2}');
+---------------------------------------------------------+
| regexp_match(Utf8("Köln"),Utf8("[a-zA-Z]ö[a-zA-Z]{2}")) |
+---------------------------------------------------------+
| [Köln] |
+---------------------------------------------------------+
-❯ SELECT regexp_match('aBc', '(b|d)', 'i');
+SELECT regexp_match('aBc', '(b|d)', 'i');
+---------------------------------------------------+
| regexp_match(Utf8("aBc"),Utf8("(b|d)"),Utf8("i")) |
+---------------------------------------------------+
@@ -1357,15 +1353,11 @@ regexp_match(str, regexp[, flags])
+---------------------------------------------------+
```
-Additional examples can be found [here]
-
-[here]: https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/regexp.rs
+Additional examples can be found [here](https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/regexp.rs)
### `regexp_replace`
-Replaces substrings in a string that match a [regular expression].
-
-[regular expression]: https://docs.rs/regex/latest/regex/#syntax
+Replaces substrings in a string that match a [regular expression](https://docs.rs/regex/latest/regex/#syntax).
```
regexp_replace(str, regexp, replacement[, flags])
@@ -1391,13 +1383,13 @@ regexp_replace(str, regexp, replacement[, flags])
#### Example
```sql
-❯ SELECT regexp_replace('foobarbaz', 'b(..)', 'X\\1Y', 'g');
+SELECT regexp_replace('foobarbaz', 'b(..)', 'X\\1Y', 'g');
+------------------------------------------------------------------------+
| regexp_replace(Utf8("foobarbaz"),Utf8("b(..)"),Utf8("X\1Y"),Utf8("g")) |
+------------------------------------------------------------------------+
| fooXarYXazY |
+------------------------------------------------------------------------+
-❯ SELECT regexp_replace('aBc', '(b|d)', 'Ab\\1a', 'i');
+SELECT regexp_replace('aBc', '(b|d)', 'Ab\\1a', 'i');
+-------------------------------------------------------------------+
| regexp_replace(Utf8("aBc"),Utf8("(b|d)"),Utf8("Ab\1a"),Utf8("i")) |
+-------------------------------------------------------------------+
@@ -1405,9 +1397,7 @@ regexp_replace(str, regexp, replacement[, flags])
+-------------------------------------------------------------------+
```
-Additional examples can be found [here]
-
-[here]: https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/regexp.rs
+Additional examples can be found [here](https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/regexp.rs)
### `position`
@@ -1657,9 +1647,7 @@ make_date(year, month, day)
+-----------------------------------------------+
```
-Additional examples can be found [here]
-
-[here]: https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/make_date.rs
+Additional examples can be found [here](https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/make_date.rs)
### `to_timestamp`
@@ -1704,9 +1692,7 @@ to_timestamp(expression[, ..., format_n])
+--------------------------------------------------------------------------------------------------------+
```
-Additional examples can be found [here]
-
-[here]: https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/to_timestamp.rs
+Additional examples can be found [here](https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/to_timestamp.rs)
### `to_timestamp_millis`
@@ -1745,9 +1731,7 @@ to_timestamp_millis(expression[, ..., format_n])
+---------------------------------------------------------------------------------------------------------------+
```
-Additional examples can be found [here]
-
-[here]: https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/to_timestamp.rs
+Additional examples can be found [here](https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/to_timestamp.rs)
### `to_timestamp_micros`
@@ -1786,9 +1770,7 @@ to_timestamp_micros(expression[, ..., format_n])
+---------------------------------------------------------------------------------------------------------------+
```
-Additional examples can be found [here]
-
-[here]: https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/to_timestamp.rs
+Additional examples can be found [here](https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/to_timestamp.rs)
### `to_timestamp_nanos`
@@ -1827,9 +1809,7 @@ to_timestamp_nanos(expression[, ..., format_n])
+---------------------------------------------------------------------------------------------------------------+
```
-Additional examples can be found [here]
-
-[here]: https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/to_timestamp.rs
+Additional examples can be found [here](https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/to_timestamp.rs)
### `to_timestamp_seconds`
@@ -1868,9 +1848,7 @@ to_timestamp_seconds(expression[, ..., format_n])
+----------------------------------------------------------------------------------------------------------------+
```
-Additional examples can be found [here]
-
-[here]: https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/to_timestamp.rs
+Additional examples can be found [here](https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/to_timestamp.rs)
### `from_unixtime`
@@ -2053,6 +2031,10 @@ array_concat(array[, ..., array_n])
- list_cat
- list_concat
+### `array_contains`
+
+_Alias of [array_has](#array_has)._
+
### `array_has`
Returns true if the array contains the element
@@ -3088,8 +3070,8 @@ struct(expression1[, ..., expression_n])
For example, this query converts two columns `a` and `b` to a single column with
a struct type of fields `c0` and `c1`:
-```sql
-❯ select * from t;
+```
+select * from t;
+---+---+
| a | b |
+---+---+
@@ -3097,7 +3079,7 @@ a struct type of fields `c0` and `c1`:
| 3 | 4 |
+---+---+
-❯ select struct(a, b) from t;
+select struct(a, b) from t;
+-----------------+
| struct(t.a,t.b) |
+-----------------+
diff --git a/_sources/user-guide/sql/select.md.txt b/_sources/user-guide/sql/select.md.txt
index 4cffd4ce91..4463b0bb08 100644
--- a/_sources/user-guide/sql/select.md.txt
+++ b/_sources/user-guide/sql/select.md.txt
@@ -102,7 +102,7 @@ select * from x;
The keywords `JOIN` or `INNER JOIN` define a join that only shows rows where there is a match in both tables.
```sql
-❯ select * from x inner join x y ON x.column_1 = y.column_1;
+select * from x inner join x y ON x.column_1 = y.column_1;
+----------+----------+----------+----------+
| column_1 | column_2 | column_1 | column_2 |
+----------+----------+----------+----------+
@@ -116,7 +116,7 @@ The keywords `LEFT JOIN` or `LEFT OUTER JOIN` define a join that includes all ro
is not a match in the right table. When there is no match, null values are produced for the right side of the join.
```sql
-❯ select * from x left join x y ON x.column_1 = y.column_2;
+select * from x left join x y ON x.column_1 = y.column_2;
+----------+----------+----------+----------+
| column_1 | column_2 | column_1 | column_2 |
+----------+----------+----------+----------+
@@ -130,7 +130,7 @@ The keywords `RIGHT JOIN` or `RIGHT OUTER JOIN` define a join that includes all
is not a match in the left table. When there is no match, null values are produced for the left side of the join.
```sql
-❯ select * from x right join x y ON x.column_1 = y.column_2;
+select * from x right join x y ON x.column_1 = y.column_2;
+----------+----------+----------+----------+
| column_1 | column_2 | column_1 | column_2 |
+----------+----------+----------+----------+
@@ -145,7 +145,7 @@ The keywords `FULL JOIN` or `FULL OUTER JOIN` define a join that is effectively
either side of the join where there is not a match.
```sql
-❯ select * from x full outer join x y ON x.column_1 = y.column_2;
+select * from x full outer join x y ON x.column_1 = y.column_2;
+----------+----------+----------+----------+
| column_1 | column_2 | column_1 | column_2 |
+----------+----------+----------+----------+
@@ -160,7 +160,7 @@ A natural join defines an inner join based on common column names found between
column names are found, it behaves like a cross join.
```sql
-❯ select * from x natural join x y;
+select * from x natural join x y;
+----------+----------+
| column_1 | column_2 |
+----------+----------+
@@ -174,7 +174,7 @@ A cross join produces a cartesian product that matches every row in the left sid
right side of the join.
```sql
-❯ select * from x cross join x y;
+select * from x cross join x y;
+----------+----------+----------+----------+
| column_1 | column_2 | column_1 | column_2 |
+----------+----------+----------+----------+
diff --git a/_sources/user-guide/sql/subqueries.md.txt b/_sources/user-guide/sql/subqueries.md.txt
index 478fab7e7c..6055b0fc5b 100644
--- a/_sources/user-guide/sql/subqueries.md.txt
+++ b/_sources/user-guide/sql/subqueries.md.txt
@@ -24,7 +24,7 @@ DataFusion supports `EXISTS`, `NOT EXISTS`, `IN`, `NOT IN` and Scalar Subqueries
The examples below are based on the following table.
```sql
-❯ select * from x;
+select * from x;
+----------+----------+
| column_1 | column_2 |
+----------+----------+
@@ -38,7 +38,7 @@ The `EXISTS` syntax can be used to find all rows in a relation where a correlate
for that row. Only correlated subqueries are supported.
```sql
-❯ select * from x y where exists (select * from x where x.column_1 = y.column_1);
+select * from x y where exists (select * from x where x.column_1 = y.column_1);
+----------+----------+
| column_1 | column_2 |
+----------+----------+
@@ -53,7 +53,7 @@ The `NOT EXISTS` syntax can be used to find all rows in a relation where a corre
for that row. Only correlated subqueries are supported.
```sql
-❯ select * from x y where not exists (select * from x where x.column_1 = y.column_1);
+select * from x y where not exists (select * from x where x.column_1 = y.column_1);
0 rows in set.
```
@@ -63,7 +63,7 @@ The `IN` syntax can be used to find all rows in a relation where a given express
results of a correlated subquery.
```sql
-❯ select * from x where column_1 in (select column_1 from x);
+select * from x where column_1 in (select column_1 from x);
+----------+----------+
| column_1 | column_2 |
+----------+----------+
@@ -78,7 +78,7 @@ The `NOT IN` syntax can be used to find all rows in a relation where a given exp
results of a correlated subquery.
```sql
-❯ select * from x where column_1 not in (select column_1 from x);
+select * from x where column_1 not in (select column_1 from x);
0 rows in set.
```
@@ -88,7 +88,7 @@ A scalar subquery can be used to produce a single value that can be used in many
is an example of a filter using a scalar subquery. Only correlated subqueries are supported.
```sql
-❯ select * from x y where column_1 < (select sum(column_2) from x where x.column_1 = y.column_1);
+select * from x y where column_1 < (select sum(column_2) from x where x.column_1 = y.column_1);
+----------+----------+
| column_1 | column_2 |
+----------+----------+
diff --git a/_sources/user-guide/sql/window_functions.md.txt b/_sources/user-guide/sql/window_functions.md.txt
index b2ae66ba6c..4d9d255724 100644
--- a/_sources/user-guide/sql/window_functions.md.txt
+++ b/_sources/user-guide/sql/window_functions.md.txt
@@ -104,7 +104,7 @@ WINDOW w AS (PARTITION BY depname ORDER BY salary DESC);
The syntax for the OVER-clause is
-```sql
+```
function([expr])
OVER(
[PARTITION BY expr[, …]]
@@ -115,7 +115,7 @@ function([expr])
where **frame_clause** is one of:
-```sql
+```
{ RANGE | ROWS | GROUPS } frame_start
{ RANGE | ROWS | GROUPS } BETWEEN frame_start AND frame_end
```
diff --git a/_sources/user-guide/sql/write_options.md.txt b/_sources/user-guide/sql/write_options.md.txt
index 150da7c53d..09d51903f4 100644
--- a/_sources/user-guide/sql/write_options.md.txt
+++ b/_sources/user-guide/sql/write_options.md.txt
@@ -29,7 +29,7 @@ Write related options can be specified in the following ways:
- `CREATE EXTERNAL TABLE` options
- `COPY` option tuples
-For a list of supported session level config defaults see [Configuration Settings](configs). These defaults apply to all write operations but have the lowest level of precedence.
+For a list of supported session level config defaults see [Configuration Settings](../configs). These defaults apply to all write operations but have the lowest level of precedence.
If inserting to an external table, table specific write options can be specified when the table is created using the `OPTIONS` clause:
diff --git a/library-user-guide/adding-udfs.html b/library-user-guide/adding-udfs.html
index ebb086caae..018180287b 100644
--- a/library-user-guide/adding-udfs.html
+++ b/library-user-guide/adding-udfs.html
@@ -666,12 +666,12 @@ There is a lower level API with more functionality but is more complex, that is
</div>
<p>At this point, you can use the <code class="docutils literal notranslate"><span class="pre">smooth_it</span></code> function in your query:</p>
<p>For example, if we have a <a class="reference external" href="https://github.com/apache/arrow-datafusion/blob/main/datafusion/core/tests/data/cars.csv"><code class="docutils literal notranslate"><span class="pre">cars.csv</span></code></a> whose contents like</p>
-<div class="highlight-csv notranslate"><div class="highlight"><pre><span></span>car,speed,time
-red,20.0,1996-04-12T12:05:03.000000000
-red,20.3,1996-04-12T12:05:04.000000000
-green,10.0,1996-04-12T12:05:03.000000000
-green,10.3,1996-04-12T12:05:04.000000000
-...
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">car</span><span class="p">,</span><span class="n">speed</span><span class="p">,</span><span class="n">time</span>
+<span class="n">red</span><span class="p">,</span><span class="mf">20.0</span><span class="p">,</span><span class="mi">1996</span><span class="o">-</span><span class="mi">04</span><span class="o">-</span><span class="mi">12</span><span class="n">T12</span><span class="p">:</span><span class="mi">05</span><span class="p">:</span><span class="mf">03.000000000</span>
+<span class="n">red</span><span class="p">,</span><span class="mf">20.3</span><span class="p">,</span><span class="mi">1996</span><span class="o">-</span><span class="mi">04</span><span class="o">-</span><span class="mi">12</span><span class="n">T12</span><span class="p">:</span><span class="mi">05</span><span class="p">:</span><span class="mf">04.000000000</span>
+<span class="n">green</span><span class="p">,</span><span class="mf">10.0</span><span class="p">,</span><span class="mi">1996</span><span class="o">-</span><span class="mi">04</span><span class="o">-</span><span class="mi">12</span><span class="n">T12</span><span class="p">:</span><span class="mi">05</span><span class="p">:</span><span class="mf">03.000000000</span>
+<span class="n">green</span><span class="p">,</span><span class="mf">10.3</span><span class="p">,</span><span class="mi">1996</span><span class="o">-</span><span class="mi">04</span><span class="o">-</span><span class="mi">12</span><span class="n">T12</span><span class="p">:</span><span class="mi">05</span><span class="p">:</span><span class="mf">04.000000000</span>
+<span class="o">...</span>
</pre></div>
</div>
<p>Then, we can query like below:</p>
@@ -697,24 +697,24 @@ green,10.3,1996-04-12T12:05:04.000000000
</pre></div>
</div>
<p>the output will be like:</p>
-<div class="highlight-csv notranslate"><div class="highlight"><pre><span></span>+-------+-------+--------------------+---------------------+
-| car | speed | smooth_speed | time |
-+-------+-------+--------------------+---------------------+
-| green | 10.0 | 10.0 | 1996-04-12T12:05:03 |
-| green | 10.3 | 10.15 | 1996-04-12T12:05:04 |
-| green | 10.4 | 10.233333333333334 | 1996-04-12T12:05:05 |
-| green | 10.5 | 10.3 | 1996-04-12T12:05:06 |
-| green | 11.0 | 10.440000000000001 | 1996-04-12T12:05:07 |
-| green | 12.0 | 10.700000000000001 | 1996-04-12T12:05:08 |
-| green | 14.0 | 11.171428571428573 | 1996-04-12T12:05:09 |
-| green | 15.0 | 11.65 | 1996-04-12T12:05:10 |
-| green | 15.1 | 12.033333333333333 | 1996-04-12T12:05:11 |
-| green | 15.2 | 12.35 | 1996-04-12T12:05:12 |
-| green | 8.0 | 11.954545454545455 | 1996-04-12T12:05:13 |
-| green | 2.0 | 11.125 | 1996-04-12T12:05:14 |
-| red | 20.0 | 20.0 | 1996-04-12T12:05:03 |
-| red | 20.3 | 20.15 | 1996-04-12T12:05:04 |
-...
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="o">+-------+-------+--------------------+---------------------+</span>
+<span class="o">|</span> <span class="n">car</span> <span class="o">|</span> <span class="n">speed</span> <span class="o">|</span> <span class="n">smooth_speed</span> <span class="o">|</span> <span class="n">time</span> <span class="o">|</span>
+<span class="o">+-------+-------+--------------------+---------------------+</span>
+<span class="o">|</span> <span class="n">green</span> <span class="o">|</span> <span class="mf">10.0</span> <span class="o">|</span> <span class="mf">10.0</span> <span class="o">|</span> <span class="mi">1996</span><span class="o">-</span><span class="mi">04</span><span class="o">-</span><span class="mi">12</span><span class="n">T12</span><span class="p">:</span><span class="mi">05</span><span class="p">:</span><span class="mi">03</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">green</span> <span class="o">|</span> <span class="mf">10.3</span> <span class="o">|</span> <span class="mf">10.15</span> <span class="o">|</span> <span class="mi">1996</span><span class="o">-</span><span class="mi">04</span><span class="o">-</span><span class="mi">12</span><span class="n">T12</span><span class="p">:</span><span class="mi">05</span><span class="p">:</span><span class="mi">04</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">green</span> <span class="o">|</span> <span class="mf">10.4</span> <span class="o">|</span> <span class="mf">10.233333333333334</span> <span class="o">|</span> <span class="mi">1996</span><span class="o">-</span><span class="mi">04</span><span class="o">-</span><span class="mi">12</span><span class="n">T12</span><span class="p">:</span><span class="mi">05</span><span class="p">:</span><span class="mi">05</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">green</span> <span class="o">|</span> <span class="mf">10.5</span> <span class="o">|</span> <span class="mf">10.3</span> <span class="o">|</span> <span class="mi">1996</span><span class="o">-</span><span class="mi">04</span><span class="o">-</span><span class="mi">12</span><span class="n">T12</span><span class="p">:</span><span class="mi">05</span><span class="p">:</span><span class="mi">06</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">green</span> <span class="o">|</span> <span class="mf">11.0</span> <span class="o">|</span> <span class="mf">10.440000000000001</span> <span class="o">|</span> <span class="mi">1996</span><span class="o">-</span><span class="mi">04</span><span class="o">-</span><span class="mi">12</span><span class="n">T12</span><span class="p">:</span><span class="mi">05</span><span class="p">:</span><span class="mi">07</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">green</span> <span class="o">|</span> <span class="mf">12.0</span> <span class="o">|</span> <span class="mf">10.700000000000001</span> <span class="o">|</span> <span class="mi">1996</span><span class="o">-</span><span class="mi">04</span><span class="o">-</span><span class="mi">12</span><span class="n">T12</span><span class="p">:</span><span class="mi">05</span><span class="p">:</span><span class="mi">08</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">green</span> <span class="o">|</span> <span class="mf">14.0</span> <span class="o">|</span> <span class="mf">11.171428571428573</span> <span class="o">|</span> <span class="mi">1996</span><span class="o">-</span><span class="mi">04</span><span class="o">-</span><span class="mi">12</span><span class="n">T12</span><span class="p">:</span><span class="mi">05</span><span class="p">:</span><span class="mi">09</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">green</span> <span class="o">|</span> <span class="mf">15.0</span> <span class="o">|</span> <span class="mf">11.65</span> <span class="o">|</span> <span class="mi">1996</span><span class="o">-</span><span class="mi">04</span><span class="o">-</span><span class="mi">12</span><span class="n">T12</span><span class="p">:</span><span class="mi">05</span><span class="p">:</span><span class="mi">10</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">green</span> <span class="o">|</span> <span class="mf">15.1</span> <span class="o">|</span> <span class="mf">12.033333333333333</span> <span class="o">|</span> <span class="mi">1996</span><span class="o">-</span><span class="mi">04</span><span class="o">-</span><span class="mi">12</span><span class="n">T12</span><span class="p">:</span><span class="mi">05</span><span class="p">:</span><span class="mi">11</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">green</span> <span class="o">|</span> <span class="mf">15.2</span> <span class="o">|</span> <span class="mf">12.35</span> <span class="o">|</span> <span class="mi">1996</span><span class="o">-</span><span class="mi">04</span><span class="o">-</span><span class="mi">12</span><span class="n">T12</span><span class="p">:</span><span class="mi">05</span><span class="p">:</span><span class="mi">12</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">green</span> <span class="o">|</span> <span class="mf">8.0</span> <span class="o">|</span> <span class="mf">11.954545454545455</span> <span class="o">|</span> <span class="mi">1996</span><span class="o">-</span><span class="mi">04</span><span class="o">-</span><span class="mi">12</span><span class="n">T12</span><span class="p">:</span><span class="mi">05</span><span class="p">:</span><span class="mi">13</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">green</span> <span class="o">|</span> <span class="mf">2.0</span> <span class="o">|</span> <span class="mf">11.125</span> <span class="o">|</span> <span class="mi">1996</span><span class="o">-</span><span class="mi">04</span><span class="o">-</span><span class="mi">12</span><span class="n">T12</span><span class="p">:</span><span class="mi">05</span><span class="p">:</span><span class="mi">14</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">red</span> <span class="o">|</span> <span class="mf">20.0</span> <span class="o">|</span> <span class="mf">20.0</span> <span class="o">|</span> <span class="mi">1996</span><span class="o">-</span><span class="mi">04</span><span class="o">-</span><span class="mi">12</span><span class="n">T12</span><span class="p">:</span><span class="mi">05</span><span class="p">:</span><span class="mi">03</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">red</span> <span class="o">|</span> <span class="mf">20.3</span> <span class="o">|</span> <span class="mf">20.15</span> <span class="o">|</span> <span class="mi">1996</span><span class="o">-</span><span class="mi">04</span><span class="o">-</span><span class="mi">12</span><span class="n">T12</span><span class="p">:</span><span class="mi">05</span><span class="p">:</span><span class="mi">04</span> <span class="o">|</span>
+<span class="o">...</span>
</pre></div>
</div>
</section>
diff --git a/objects.inv b/objects.inv
index a53c86abac..f85bda1dfd 100644
Binary files a/objects.inv and b/objects.inv differ
diff --git a/searchindex.js b/searchindex.js
index a214abc969..c453ca7cc6 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 4f0da75db3..6ff7d944ab 100644
--- a/user-guide/cli.html
+++ b/user-guide/cli.html
@@ -655,7 +655,7 @@ DataFusion<span class="w"> </span>CLI<span class="w"> </span>v16.0.0
</div>
<p>You can also query directly from the remote location via HTTP(S) without
registering the location as a table</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="k">count</span><span class="p">(</span><span class="o">*</span><span class="p">)</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="s1">'https://datasets.clickhouse.com/hits_compatible/athena_partitioned/hits_1.parquet'</span>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">select</span><span class="w"> </span><span class="k">count</span><span class="p">(</span><span class="o">*</span><span class="p">)</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="s1">'https://datasets.clickhouse.com/hits_compatible/athena_partitioned/hits_1.parquet'</span>
<span class="o">+</span><span class="c1">----------+</span>
<span class="o">|</span><span class="w"> </span><span class="k">COUNT</span><span class="p">(</span><span class="o">*</span><span class="p">)</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------+</span>
@@ -731,7 +731,7 @@ For example to read from a remote parquet file via HTTP(S) you can use the follo
<span class="k">LOCATION</span><span class="w"> </span><span class="s1">'https://datasets.clickhouse.com/hits_compatible/athena_partitioned/hits_1.parquet'</span><span class="p">;</span>
</pre></div>
</div>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="k">count</span><span class="p">(</span><span class="o">*</span><span class="p">)</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="n">hits</span><span class="p">;</span>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">select</span><span class="w"> </span><span class="k">count</span><span class="p">(</span><span class="o">*</span><span class="p">)</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="n">hits</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="p">(</span><span class="o">*</span><span class="p">)</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------+</span>
@@ -1081,45 +1081,44 @@ variable with an upper case name and all <code class="docutils literal notransla
<p>For example, to set <code class="docutils literal notranslate"><span class="pre">datafusion.execution.batch_size</span></code> to <code class="docutils literal notranslate"><span class="pre">1024</span></code> you
would set the <code class="docutils literal notranslate"><span class="pre">DATAFUSION_EXECUTION_BATCH_SIZE</span></code> environment variable
appropriately:</p>
-<div class="highlight-SQL notranslate"><div class="highlight"><pre><span></span><span class="err">$</span><span class="w"> </span><span class="n">DATAFUSION_EXECUTION_BATCH_SIZE</span><span class="o">=</span><span class="mi">1024</span><span class="w"> </span><span class="n">datafusion</span><span class="o">-</span><span class="n">cli</span>
-<span class="n">DataFusion</span><span class="w"> </span><span class="n">CLI</span><span class="w"> </span><span class="n">v12</span><span class="p">.</span><span class="mi">0</span><span class="p">.</span><span class="mi">0</span>
-<span class="err">❯</span><span class="w"> </span><span class="k">show</span><span class="w"> </span><span class="k">all</span><span class="p">;</span>
-<span class="o">+</span><span class="c1">-------------------------------------------------+---------+</span>
-<span class="o">|</span><span class="w"> </span><span class="n">name</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">value</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="n">datafusion</span><span class="p">.</span><span class="n">execution</span><span class="p">.</span><span class="n">batch_size</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">1024</span><span class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span class="n">datafusion</span><span class="p">.</span><span class="n">execution</span><span class="p">.</span><span class="n">coalesce_batches</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="k">true</span><span class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span class="n">datafusion</span><span class="p">.</span><span class="n">execution</span><span class="p">.</span><span class="n">time_zone</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">UTC</span><span class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span class="n">datafusion</span><span class="p">.</span><span class="k">explain</span><span class="p">.</span><span class="n">logical_plan_only</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="k">false</span><span class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span class="n">datafusion</span><span class="p">.</span><span class="k">explain</span><span class="p">.</span><span class="n">physical_plan_only</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="k">false</span><span class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span class="n">datafusion</span><span class="p">.</span><span class="n">optimizer</span><span class="p">.</span><span class="n">filter_null_join_keys</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="k">false</span><span class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span class="n">datafusion</span><span class="p">.</span><span class="n">optimizer</span><span class="p">.</span><span class="n">skip_failed_rules</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="k">true</span><span class="w"> </span><span class="o">|</span>
-<span class="o">+</span><span class="c1">-------------------------------------------------+---------+</span>
-<span class="mi">8</span><span class="w"> </span><span class="k">rows</span><span class="w"> </span><span class="k">in</span><span class="w"> </span><span class="k">set</span><span class="p">.</span><span class="w"> </span><span class="n">Query</span><span class="w"> </span><span class="n">took</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">002</span><span class="w"> </span><span class="n">seconds</span><span class="p">.</span>
+<div class="highlight-shell notranslate"><div class="highlight"><pre><span></span>$<span class="w"> </span><span class="nv">DATAFUSION_EXECUTION_BATCH_SIZE</span><span class="o">=</span><span class="m">1024</span><span class="w"> </span>datafusion-cli
+DataFusion<span class="w"> </span>CLI<span class="w"> </span>v12.0.0
+❯<span class="w"> </span>show<span class="w"> </span>all<span class="p">;</span>
++-------------------------------------------------+---------+
+<span class="p">|</span><span class="w"> </span>name<span class="w"> </span><span class="p">|</span><span class="w"> </span>value<span class="w"> </span><span class="p">|</span>
++-------------------------------------------------+---------+
+<span class="p">|</span><span class="w"> </span>datafusion.execution.batch_size<span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="m">1024</span><span class="w"> </span><span class="p">|</span>
+<span class="p">|</span><span class="w"> </span>datafusion.execution.coalesce_batches<span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="nb">true</span><span class="w"> </span><span class="p">|</span>
+<span class="p">|</span><span class="w"> </span>datafusion.execution.time_zone<span class="w"> </span><span class="p">|</span><span class="w"> </span>UTC<span class="w"> </span><span class="p">|</span>
+<span class="p">|</span><span class="w"> </span>datafusion.explain.logical_plan_only<span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="nb">false</span><span class="w"> </span><span class="p">|</span>
+<span class="p">|</span><span class="w"> </span>datafusion.explain.physical_plan_only<span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="nb">false</span><span class="w"> </span><span class="p">|</span>
+<span class="p">|</span><span class="w"> </span>datafusion.optimizer.filter_null_join_keys<span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="nb">false</span><span class="w"> </span><span class="p">|</span>
+<span class="p">|</span><span class="w"> </span>datafusion.optimizer.skip_failed_rules<span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="nb">true</span><span class="w"> </span><span class="p">|</span>
++-------------------------------------------------+---------+
+<span class="m">8</span><span class="w"> </span>rows<span class="w"> </span><span class="k">in</span><span class="w"> </span>set.<span class="w"> </span>Query<span class="w"> </span>took<span class="w"> </span><span class="m">0</span>.002<span class="w"> </span>seconds.
</pre></div>
</div>
<p>You can change the configuration options using <code class="docutils literal notranslate"><span class="pre">SET</span></code> statement as well</p>
-<div class="highlight-SQL notranslate"><div class="highlight"><pre><span></span><span class="err">$</span><span class="w"> </span><span class="n">datafusion</span><span class="o">-</span><span class="n">cli</span>
-<span class="n">DataFusion</span><span class="w"> </span><span class="n">CLI</span><span class="w"> </span><span class="n">v13</span><span class="p">.</span><span class="mi">0</span><span class="p">.</span><span class="mi">0</span>
-
-<span class="err">❯</span><span class="w"> </span><span class="k">show</span><span class="w"> </span><span class="n">datafusion</span><span class="p">.</span><span class="n">execution</span><span class="p">.</span><span class="n">batch_size</span><span class="p">;</span>
-<span class="o">+</span><span class="c1">---------------------------------+---------+</span>
-<span class="o">|</span><span class="w"> </span><span class="n">name</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">value</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="n">datafusion</span><span class="p">.</span><span class="n">execution</span><span class="p">.</span><span class="n">batch_size</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">8192</span><span class="w"> </span><span class="o">|</span>
-<span class="o">+</span><span class="c1">---------------------------------+---------+</span>
-<span class="mi">1</span><span class="w"> </span><span class="k">row</span><span class="w"> </span><span class="k">in</span><span class="w"> </span><span class="k">set</span><span class="p">.</span><span class="w"> </span><span class="n">Query</span><span class="w"> </span><span class="n">took</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">011</span><span class="w"> </span><span class="n">seconds</span><span class="p">.</span>
+<div class="highlight-shell notranslate"><div class="highlight"><pre><span></span>$<span class="w"> </span>datafusion-cli
+DataFusion<span class="w"> </span>CLI<span class="w"> </span>v13.0.0
+❯<span class="w"> </span>show<span class="w"> </span>datafusion.execution.batch_size<span class="p">;</span>
++---------------------------------+---------+
+<span class="p">|</span><span class="w"> </span>name<span class="w"> </span><span class="p">|</span><span class="w"> </span>value<span class="w"> </span><span class="p">|</span>
++---------------------------------+---------+
+<span class="p">|</span><span class="w"> </span>datafusion.execution.batch_size<span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="m">8192</span><span class="w"> </span><span class="p">|</span>
++---------------------------------+---------+
+<span class="m">1</span><span class="w"> </span>row<span class="w"> </span><span class="k">in</span><span class="w"> </span>set.<span class="w"> </span>Query<span class="w"> </span>took<span class="w"> </span><span class="m">0</span>.011<span class="w"> </span>seconds.
-<span class="err">❯</span><span class="w"> </span><span class="k">set</span><span class="w"> </span><span class="n">datafusion</span><span class="p">.</span><span class="n">execution</span><span class="p">.</span><span class="n">batch_size</span><span class="w"> </span><span class="k">to</span><span class="w"> </span><span class="mi">1024</span><span class="p">;</span>
-<span class="mi">0</span><span class="w"> </span><span class="k">rows</span><span class="w"> </span><span class="k">in</span><span class="w"> </span><span class="k">set</span><span class="p">.</span><span class="w"> </span><span class="n">Query</span><span class="w"> </span><span class="n">took</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">000</span><span class="w"> </span><span class="n">seconds</span><span class="p">.</span>
+❯<span class="w"> </span><span class="nb">set</span><span class="w"> </span>datafusion.execution.batch_size<span class="w"> </span>to<span class="w"> </span><span class="m">1024</span><span class="p">;</span>
+<span class="m">0</span><span class="w"> </span>rows<span class="w"> </span><span class="k">in</span><span class="w"> </span>set.<span class="w"> </span>Query<span class="w"> </span>took<span class="w"> </span><span class="m">0</span>.000<span class="w"> </span>seconds.
-<span class="err">❯</span><span class="w"> </span><span class="k">show</span><span class="w"> </span><span class="n">datafusion</span><span class="p">.</span><span class="n">execution</span><span class="p">.</span><span class="n">batch_size</span><span class="p">;</span>
-<span class="o">+</span><span class="c1">---------------------------------+---------+</span>
-<span class="o">|</span><span class="w"> </span><span class="n">name</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">value</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="n">datafusion</span><span class="p">.</span><span class="n">execution</span><span class="p">.</span><span class="n">batch_size</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">1024</span><span class="w"> </span><span class="o">|</span>
-<span class="o">+</span><span class="c1">---------------------------------+---------+</span>
-<span class="mi">1</span><span class="w"> </span><span class="k">row</span><span class="w"> </span><span class="k">in</span><span class="w"> </span><span class="k">set</span><span class="p">.</span><span class="w"> </span><span class="n">Query</span><span class="w"> </span><span class="n">took</span><span class="w"> </span><span class="mi">0</span><span class="p">.</span><span class="mi">005</span><span class="w"> </span><span class="n">seconds</span><span class="p">.</span>
+❯<span class="w"> </span>show<span class="w"> </span>datafusion.execution.batch_size<span class="p">;</span>
++---------------------------------+---------+
+<span class="p">|</span><span class="w"> </span>name<span class="w"> </span><span class="p">|</span><span class="w"> </span>value<span class="w"> </span><span class="p">|</span>
++---------------------------------+---------+
+<span class="p">|</span><span class="w"> </span>datafusion.execution.batch_size<span class="w"> </span><span class="p">|</span><span class="w"> </span><span class="m">1024</span><span class="w"> </span><span class="p">|</span>
++---------------------------------+---------+
+<span class="m">1</span><span class="w"> </span>row<span class="w"> </span><span class="k">in</span><span class="w"> </span>set.<span class="w"> </span>Query<span class="w"> </span>took<span class="w"> </span><span class="m">0</span>.005<span class="w"> </span>seconds.
</pre></div>
</div>
</section>
diff --git a/user-guide/example-usage.html b/user-guide/example-usage.html
index ff1ee30175..281677839b 100644
--- a/user-guide/example-usage.html
+++ b/user-guide/example-usage.html
@@ -652,15 +652,15 @@ worth noting that using the settings in the <code class="docutils literal notran
</pre></div>
</div>
<p>Then, in <code class="docutils literal notranslate"><span class="pre">main.rs.</span></code> update the memory allocator with the below after your imports:</p>
-<div class="highlight-rust,ignore notranslate"><div class="highlight"><pre><span></span>use datafusion::prelude::*;
+<div class="highlight-rust notranslate"><div class="highlight"><pre><span></span><span class="k">use</span><span class="w"> </span><span class="n">datafusion</span>::<span class="n">prelude</span>::<span class="o">*</span><span class="p">;</span>
-#[global_allocator]
-static ALLOC: snmalloc_rs::SnMalloc = snmalloc_rs::SnMalloc;
+<span class="cp">#[global_allocator]</span>
+<span class="k">static</span><span class="w"> </span><span class="n">ALLOC</span>: <span class="nc">snmalloc_rs</span>::<span class="n">SnMalloc</span><span class="w"> </span><span class="o">=</span><span class="w"> </span><span class="n">snmalloc_rs</span>::<span class="n">SnMalloc</span><span class="p">;</span>
-#[tokio::main]
-async fn main() -> datafusion::error::Result<()> {
- Ok(())
-}
+<span class="cp">#[tokio::main]</span>
+<span class="k">async</span><span class="w"> </span><span class="k">fn</span> <span class="nf">main</span><span class="p">()</span><span class="w"> </span>-> <span class="nc">datafusion</span>::<span class="n">error</span>::<span class="nb">Result</span><span class="o"><</span><span class="p">()</span><span class="o">></span><span class="w"> </span><span class="p">{</span>
+<span class="w"> </span><span class="nb">Ok</span><span class="p">(())</span>
+<span class="p">}</span>
</pre></div>
</div>
<p>Finally, in order to build with the <code class="docutils literal notranslate"><span class="pre">simd</span></code> optimization <code class="docutils literal notranslate"><span class="pre">cargo</span> <span class="pre">nightly</span></code> is required.</p>
diff --git a/user-guide/expressions.html b/user-guide/expressions.html
index 2af77930e8..e79bc42122 100644
--- a/user-guide/expressions.html
+++ b/user-guide/expressions.html
@@ -777,7 +777,7 @@ but these operators always return a <code class="docutils literal notranslate"><
<div class="admonition note">
<p class="admonition-title">Note</p>
<p>Unlike to some databases the math functions in Datafusion works the same way as Rust math functions, avoiding failing on corner cases e.g</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">log</span><span class="p">(</span><span class="o">-</span><span class="mi">1</span><span class="p">),</span><span class="w"> </span><span class="n">log</span><span class="p">(</span><span class="mi">0</span><span class="p">),</span><span class="w"> </span><span class="n">sqrt</span><span clas [...]
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">select</span><span class="w"> </span><span class="n">log</span><span class="p">(</span><span class="o">-</span><span class="mi">1</span><span class="p">),</span><span class="w"> </span><span class="n">log</span><span class="p">(</span><span class="mi">0</span><span class="p">),</span><span class="w"> </span><span class="n">sqrt</span><span class="p">(</span><span class="o">-</span><span class= [...]
<span class="o">+</span><span class="c1">----------------+---------------+-----------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">log</span><span class="p">(</span><span class="n">Int64</span><span class="p">(</span><span class="o">-</span><span class="mi">1</span><span class="p">))</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">log</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="w"> </span><span class="o">|</s [...]
<span class="o">+</span><span class="c1">----------------+---------------+-----------------+</span>
diff --git a/user-guide/sql/data_types.html b/user-guide/sql/data_types.html
index c4ec5a16bb..01ad95f4c7 100644
--- a/user-guide/sql/data_types.html
+++ b/user-guide/sql/data_types.html
@@ -442,7 +442,7 @@ are mapped to <a class="reference external" href="https://docs.rs/arrow/latest/a
This mapping occurs when defining the schema in a <code class="docutils literal notranslate"><span class="pre">CREATE</span> <span class="pre">EXTERNAL</span> <span class="pre">TABLE</span></code> command or when performing a SQL <code class="docutils literal notranslate"><span class="pre">CAST</span></code> operation.</p>
<p>You can see the corresponding Arrow type for any SQL expression using
the <code class="docutils literal notranslate"><span class="pre">arrow_typeof</span></code> function. For example:</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">arrow_typeof</span><span class="p">(</span><span class="nb">interval</span><span class="w"> </span><span class="s1">'1 month'</span><span class="p">);</span>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">select</span><span class="w"> </span><span class="n">arrow_typeof</span><span class="p">(</span><span class="nb">interval</span><span class="w"> </span><span class="s1">'1 month'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">arrowtypeof</span><span class="p">(</span><span class="n">IntervalYearMonth</span><span class="p">(</span><span class="ss">"1"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">-------------------------------------+</span>
@@ -452,7 +452,7 @@ the <code class="docutils literal notranslate"><span class="pre">arrow_typeof</s
</div>
<p>You can cast a SQL expression to a specific Arrow type using the <code class="docutils literal notranslate"><span class="pre">arrow_cast</span></code> function
For example, to cast the output of <code class="docutils literal notranslate"><span class="pre">now()</span></code> to a <code class="docutils literal notranslate"><span class="pre">Timestamp</span></code> with second precision:</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">arrow_cast</span><span class="p">(</span><span class="n">now</span><span class="p">(),</span><span class="w"> </span><span class="s1">'Timestamp(Second, None)'</span><span class="p">);</span>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">select</span><span class="w"> </span><span class="n">arrow_cast</span><span class="p">(</span><span class="n">now</span><span class="p">(),</span><span class="w"> </span><span class="s1">'Timestamp(Second, None)'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">---------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">now</span><span class="p">()</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">---------------------+</span>
diff --git a/user-guide/sql/ddl.html b/user-guide/sql/ddl.html
index 6c7250c05c..612e1970c4 100644
--- a/user-guide/sql/ddl.html
+++ b/user-guide/sql/ddl.html
@@ -583,8 +583,8 @@ sorting is complex, allowing for greater flexibility.</p>
</pre></div>
</div>
<p>Where <code class="docutils literal notranslate"><span class="pre">WITH</span> <span class="pre">ORDER</span></code> clause specifies the sort order:</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">WITH</span><span class="w"> </span><span class="k">ORDER</span><span class="w"> </span><span class="p">(</span><span class="n">sort_expression1</span><span class="w"> </span><span class="p">[</span><span class="k">ASC</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="k">DESC</span><span class="p">]</span><span class="w"> </span><span class="p">[</span>< [...]
-<span class="w"> </span><span class="p">[,</span><span class="w"> </span><span class="n">sort_expression2</span><span class="w"> </span><span class="p">[</span><span class="k">ASC</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="k">DESC</span><span class="p">]</span><span class="w"> </span><span class="p">[</span><span class="n">NULLS</span><span class="w"> </span><span class="err">{</span><span class="w"> </span><span class="k">FIRST</sp [...]
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">WITH</span> <span class="n">ORDER</span> <span class="p">(</span><span class="n">sort_expression1</span> <span class="p">[</span><span class="n">ASC</span> <span class="o">|</span> <span class="n">DESC</span><span class="p">]</span> <span class="p">[</span><span class="n">NULLS</span> <span class="p">{</span> <span class="n">FIRST</span> <span class="o">|</span> <span class="n">LAST</span> [...]
+ <span class="p">[,</span> <span class="n">sort_expression2</span> <span class="p">[</span><span class="n">ASC</span> <span class="o">|</span> <span class="n">DESC</span><span class="p">]</span> <span class="p">[</span><span class="n">NULLS</span> <span class="p">{</span> <span class="n">FIRST</span> <span class="o">|</span> <span class="n">LAST</span> <span class="p">}]</span> <span class="o">...</span><span class="p">])</span>
</pre></div>
</div>
<section id="cautions-when-using-the-with-order-clause">
diff --git a/user-guide/sql/explain.html b/user-guide/sql/explain.html
index 539af70cf2..a0647d97f0 100644
--- a/user-guide/sql/explain.html
+++ b/user-guide/sql/explain.html
@@ -418,22 +418,22 @@ EXPLAIN [ANALYZE] [VERBOSE] statement
<h2>EXPLAIN<a class="headerlink" href="#id1" title="Link to this heading">¶</a></h2>
<p>Shows the execution plan of a statement.
If you need more detailed output, use <code class="docutils literal notranslate"><span class="pre">EXPLAIN</span> <span class="pre">VERBOSE</span></code>.</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">EXPLAIN</span><span class="w"> </span><span class="k">SELECT</span><span class="w"> </span><span class="k">SUM</span><span class="p">(</span><span class="n">x</span><span class="p">)</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="k">table</span><span class="w"> </span><span class="k">GROUP</span><span class="w"> </span><span class="k">BY</span><sp [...]
-<span class="o">+</span><span class="c1">---------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span class="n">plan_type</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">plan</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="n">logical_plan</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">Projection</span><span class="p">:</span><span class="w"> </span><span class="o">#</span><span class="k">SUM</span><span class="p">(</span><span class="k">table</span><span class="p">.</span><span class="n">x</span><span class="p">)</span><span class="w"> [...]
-<span class="o">|</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="k">Aggregate</span><span class="p">:</span><span class="w"> </span><span class="n">groupBy</span><span class="o">=</span><span class="p">[[</span><span class="o">#</span><span class="k">table</span><span class="p">.</span><span class="n">b</span><span class="p">]],</span><span class="w"> </span><span class="n">aggr</span><span class="o">=</span><span class="p">[[</ [...]
-<span class="o">|</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">TableScan</span><span class="p">:</span><span class="w"> </span><span class="k">table</span><span class="w"> </span><span class="n">projection</span><span class="o">=</span><span class="p">[</span><span class="n">x</span><span class="p">,</span><span class="w"> </span><span class="n">b</span><span class="p">]</span><span class="w"> [...]
-<span class="o">|</span><span class="w"> </span><span class="n">physical_plan</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">ProjectionExec</span><span class="p">:</span><span class="w"> </span><span class="n">expr</span><span class="o">=</span><span class="p">[</span><span class="k">SUM</span><span class="p">(</span><span class="k">table</span><span class="p">.</span><span class="n">x</span><span class="p">)</span><span class="o">@</span><s [...]
-<span class="o">|</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">AggregateExec</span><span class="p">:</span><span class="w"> </span><span class="k">mode</span><span class="o">=</span><span class="n">FinalPartitioned</span><span class="p">,</span><span class="w"> </span><span class="n">gby</span><span class="o">=</span><span class="p">[</span><span class="n">b</span><span class="o">@</span><span class="mi">0</span><span class [...]
-<span class="o">|</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">CoalesceBatchesExec</span><span class="p">:</span><span class="w"> </span><span class="n">target_batch_size</span><span class="o">=</span><span class="mi">4096</span><span class="w"> </span><span class="o">|</span>
-<span class="o">|</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">RepartitionExec</span><span class="p">:</span><span class="w"> </span><span class="n">partitioning</span><span class="o">=</span><span class="n">Hash</span><span class="p">([</span><span class="k">Column</span><span class="w"> </span><span class="err">{</span><span class="w"> </span><span class="n">name</span><span class="p">:</span><span class="w"> </span>< [...]
-<span class="o">|</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">AggregateExec</span><span class="p">:</span><span class="w"> </span><span class="k">mode</span><span class="o">=</span><span class="k">Partial</span><span class="p">,</span><span class="w"> </span><span class="n">gby</span><span class="o">=</span><span class="p">[</span><span class="n">b</span><span class="o">@</span><span class="mi">1</span><span class="w [...]
-<span class="o">|</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">RepartitionExec</span><span class="p">:</span><span class="w"> </span><span class="n">partitioning</span><span class="o">=</span><span class="n">RoundRobinBatch</span><span class="p">(</span><span class="mi">16</span><span class="p">)</span><span class="w"> [...]
-<span class="o">|</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">CsvExec</span><span class="p">:</span><span class="w"> </span><span class="n">file_groups</span><span class="o">=</span><span class="err">{</span><span class="mi">1</span><span class="w"> </span><span class="k">group</span><span class="p">:</span><span class="w"> </span><span class="p">[[</span><span class="o">/</span><span class="n">tmp</span><span cl [...]
-<span class="o">|</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="o">|</span>
-<span class="o">+</span><span class="c1">---------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+</span>
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">EXPLAIN</span> <span class="n">SELECT</span> <span class="n">SUM</span><span class="p">(</span><span class="n">x</span><span class="p">)</span> <span class="n">FROM</span> <span class="n">table</span> <span class="n">GROUP</span> <span class="n">BY</span> <span class="n">b</span><span class="p">;</span>
+<span class="o">+---------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">plan_type</span> <span class="o">|</span> <span class="n">plan</span> <span class="o">|</span>
+<span class="o">+---------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">logical_plan</span> <span class="o">|</span> <span class="n">Projection</span><span class="p">:</span> <span class="c1">#SUM(table.x) |</span>
+<span class="o">|</span> <span class="o">|</span> <span class="n">Aggregate</span><span class="p">:</span> <span class="n">groupBy</span><span class="o">=</span><span class="p">[[</span><span class="c1">#table.b]], aggr=[[SUM(#table.x)]] |</span>
+<span class="o">|</span> <span class="o">|</span> <span class="n">TableScan</span><span class="p">:</span> <span class="n">table</span> <span class="n">projection</span><span class="o">=</span><span class="p">[</span><span class="n">x</span><span class="p">,</span> <span class="n">b</span><span class="p">]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="n">physical_plan</span> <span class="o">|</span> <span class="n">ProjectionExec</span><span class="p">:</span> <span class="n">expr</span><span class="o">=</span><span class="p">[</span><span class="n">SUM</span><span class="p">(</span><span class="n">table</span><span class="o">.</span><span class="n">x</span><span class="p">)</span><span class="o">@</span><span class="mi">1</span> <span class="k">as</span> <span class="n">SUM</span><span class="p"> [...]
+<span class="o">|</span> <span class="o">|</span> <span class="n">AggregateExec</span><span class="p">:</span> <span class="n">mode</span><span class="o">=</span><span class="n">FinalPartitioned</span><span class="p">,</span> <span class="n">gby</span><span class="o">=</span><span class="p">[</span><span class="n">b</span><span class="o">@</span><span class="mi">0</span> <span class="k">as</span> <span class="n">b</span><span class="p">],</span> <span class="n">aggr</span [...]
+<span class="o">|</span> <span class="o">|</span> <span class="n">CoalesceBatchesExec</span><span class="p">:</span> <span class="n">target_batch_size</span><span class="o">=</span><span class="mi">4096</span> <span class="o">|</span>
+<span class="o">|</span> <span class="o">|</span> <span class="n">RepartitionExec</span><span class="p">:</span> <span class="n">partitioning</span><span class="o">=</span><span class="n">Hash</span><span class="p">([</span><span class="n">Column</span> <span class="p">{</span> <span class="n">name</span><span class="p">:</span> <span class="s2">"b"</span><span class="p">,</span> <span class="n">index</span><span class="p">:</span> <span class="mi">0</span> [...]
+<span class="o">|</span> <span class="o">|</span> <span class="n">AggregateExec</span><span class="p">:</span> <span class="n">mode</span><span class="o">=</span><span class="n">Partial</span><span class="p">,</span> <span class="n">gby</span><span class="o">=</span><span class="p">[</span><span class="n">b</span><span class="o">@</span><span class="mi">1</span> <span class="k">as</span> <span class="n">b</span><span class="p">],</span> <span class="n">aggr</span><s [...]
+<span class="o">|</span> <span class="o">|</span> <span class="n">RepartitionExec</span><span class="p">:</span> <span class="n">partitioning</span><span class="o">=</span><span class="n">RoundRobinBatch</span><span class="p">(</span><span class="mi">16</span><span class="p">)</span> <span class="o">|</span>
+<span class="o">|</span> <span class="o">|</span> <span class="n">CsvExec</span><span class="p">:</span> <span class="n">file_groups</span><span class="o">=</span><span class="p">{</span><span class="mi">1</span> <span class="n">group</span><span class="p">:</span> <span class="p">[[</span><span class="o">/</span><span class="n">tmp</span><span class="o">/</span><span class="n">table</span><span class="o">.</span><span class="n">csv</span><span class="p">]]},</s [...]
+<span class="o">|</span> <span class="o">|</span> <span class="o">|</span>
+<span class="o">+---------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -441,19 +441,19 @@ If you need more detailed output, use <code class="docutils literal notranslate"
<h2>EXPLAIN ANALYZE<a class="headerlink" href="#explain-analyze" title="Link to this heading">¶</a></h2>
<p>Shows the execution plan and metrics of a statement.
If you need more information output, use <code class="docutils literal notranslate"><span class="pre">EXPLAIN</span> <span class="pre">ANALYZE</span> <span class="pre">VERBOSE</span></code>.</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">EXPLAIN</span><span class="w"> </span><span class="k">ANALYZE</span><span class="w"> </span><span class="k">SELECT</span><span class="w"> </span><span class="k">SUM</span><span class="p">(</span><span class="n">x</span><span class="p">)</span><span class="w"> </span><span class="k">FROM</span><span class="w"> </span><span class="k">table</span><span class="w"> </span><span class="k">GROUP</spa [...]
-<span class="o">+</span><span class="c1">-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+</span>
-<span class="o">|</span><span class="w"> </span><span class="n">plan_type</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">plan</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="n">Plan</span><span class="w"> </span><span class="k">with</span><span class="w"> </span><span class="n">Metrics</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">CoalescePartitionsExec</span><span class="p">,</span><span class="w"> </span><span class="n">metrics</span><span class="o">=</span><span class="p">[]</span><span class="w"> [...]
-<span class="o">|</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">ProjectionExec</span><span class="p">:</span><span class="w"> </span><span class="n">expr</span><span class="o">=</span><span class="p">[</span><span class="k">SUM</span><span class="p">(</span><span class="k">table</span><span class="p">.</span><span class="n">x</span><span class="p">)</span><span class="o">@</span><span class="mi">1</span><span class="w"> [...]
-<span class="o">|</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">HashAggregateExec</span><span class="p">:</span><span class="w"> </span><span class="k">mode</span><span class="o">=</span><span class="n">FinalPartitioned</span><span class="p">,</span><span class="w"> </span><span class="n">gby</span><span class="o">=</span><span class="p">[</span><span class="n">b</span><span class="o">@</span><span class="mi">0</span>< [...]
-<span class="o">|</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">CoalesceBatchesExec</span><span class="p">:</span><span class="w"> </span><span class="n">target_batch_size</span><span class="o">=</span><span class="mi">4096</span><span class="p">,</span><span class="w"> </span><span class="n">metrics</span><span class="o">=</span><span class="p">[]</span><span class="w"> [...]
-<span class="o">|</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">RepartitionExec</span><span class="p">:</span><span class="w"> </span><span class="n">partitioning</span><span class="o">=</span><span class="n">Hash</span><span class="p">([</span><span class="k">Column</span><span class="w"> </span><span class="err">{</span><span class="w"> </span><span class="n">name</span><span class="p">:</span><span class="w"> </ [...]
-<span class="o">|</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">HashAggregateExec</span><span class="p">:</span><span class="w"> </span><span class="k">mode</span><span class="o">=</span><span class="k">Partial</span><span class="p">,</span><span class="w"> </span><span class="n">gby</span><span class="o">=</span><span class="p">[</span><span class="n">b</span><span class="o">@</span><span class="mi">1</span><spa [...]
-<span class="o">|</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">RepartitionExec</span><span class="p">:</span><span class="w"> </span><span class="n">partitioning</span><span class="o">=</span><span class="n">RoundRobinBatch</span><span class="p">(</span><span class="mi">16</span><span class="p">),</span><span class="w"> </span><span class="n">metrics</span><span class="o">=</span><span class="p">[</span><span [...]
-<span class="o">|</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">CsvExec</span><span class="p">:</span><span class="w"> </span><span class="n">file_groups</span><span class="o">=</span><span class="err">{</span><span class="mi">1</span><span class="w"> </span><span class="k">group</span><span class="p">:</span><span class="w"> </span><span class="p">[[</span><span class="o">/</span><span class="n">tmp</span><s [...]
-<span class="o">+</span><span class="c1">-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+</span>
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">EXPLAIN</span> <span class="n">ANALYZE</span> <span class="n">SELECT</span> <span class="n">SUM</span><span class="p">(</span><span class="n">x</span><span class="p">)</span> <span class="n">FROM</span> <span class="n">table</span> <span class="n">GROUP</span> <span class="n">BY</span> <span class="n">b</span><span class="p">;</span>
+<span class="o">+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">plan_type</span> <span class="o">|</span> <span class="n">plan</span> <span class="o">|</span>
+<span class="o">+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">Plan</span> <span class="k">with</span> <span class="n">Metrics</span> <span class="o">|</span> <span class="n">CoalescePartitionsExec</span><span class="p">,</span> <span class="n">metrics</span><span class="o">=</span><span class="p">[]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="o">|</span> <span class="n">ProjectionExec</span><span class="p">:</span> <span class="n">expr</span><span class="o">=</span><span class="p">[</span><span class="n">SUM</span><span class="p">(</span><span class="n">table</span><span class="o">.</span><span class="n">x</span><span class="p">)</span><span class="o">@</span><span class="mi">1</span> <span class="k">as</span> <span class="n">SUM</span><span class="p">(</span><span cla [...]
+<span class="o">|</span> <span class="o">|</span> <span class="n">HashAggregateExec</span><span class="p">:</span> <span class="n">mode</span><span class="o">=</span><span class="n">FinalPartitioned</span><span class="p">,</span> <span class="n">gby</span><span class="o">=</span><span class="p">[</span><span class="n">b</span><span class="o">@</span><span class="mi">0</span> <span class="k">as</span> <span class="n">b</span><span class="p">],</span> <span class="n"> [...]
+<span class="o">|</span> <span class="o">|</span> <span class="n">CoalesceBatchesExec</span><span class="p">:</span> <span class="n">target_batch_size</span><span class="o">=</span><span class="mi">4096</span><span class="p">,</span> <span class="n">metrics</span><span class="o">=</span><span class="p">[]</span> <span class="o">|</span>
+<span class="o">|</span> <span class="o">|</span> <span class="n">RepartitionExec</span><span class="p">:</span> <span class="n">partitioning</span><span class="o">=</span><span class="n">Hash</span><span class="p">([</span><span class="n">Column</span> <span class="p">{</span> <span class="n">name</span><span class="p">:</span> <span class="s2">"b"</span><span class="p">,</span> <span class="n">index</span><span class="p">:</span> <span class="mi">0</ [...]
+<span class="o">|</span> <span class="o">|</span> <span class="n">HashAggregateExec</span><span class="p">:</span> <span class="n">mode</span><span class="o">=</span><span class="n">Partial</span><span class="p">,</span> <span class="n">gby</span><span class="o">=</span><span class="p">[</span><span class="n">b</span><span class="o">@</span><span class="mi">1</span> <span class="k">as</span> <span class="n">b</span><span class="p">],</span> <span class="n">agg [...]
+<span class="o">|</span> <span class="o">|</span> <span class="n">RepartitionExec</span><span class="p">:</span> <span class="n">partitioning</span><span class="o">=</span><span class="n">RoundRobinBatch</span><span class="p">(</span><span class="mi">16</span><span class="p">),</span> <span class="n">metrics</span><span class="o">=</span><span class="p">[</span><span class="n">fetchTime</span><span class="o">=</span><span class="mi">5660489</span><span class [...]
+<span class="o">|</span> <span class="o">|</span> <span class="n">CsvExec</span><span class="p">:</span> <span class="n">file_groups</span><span class="o">=</span><span class="p">{</span><span class="mi">1</span> <span class="n">group</span><span class="p">:</span> <span class="p">[[</span><span class="o">/</span><span class="n">tmp</span><span class="o">/</span><span class="n">table</span><span class="o">.</span><span class="n">csv</span><span class="p">] [...]
+<span class="o">+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+</span>
</pre></div>
</div>
</section>
diff --git a/user-guide/sql/information_schema.html b/user-guide/sql/information_schema.html
index 9b73beb071..6cd0e61fae 100644
--- a/user-guide/sql/information_schema.html
+++ b/user-guide/sql/information_schema.html
@@ -423,7 +423,7 @@ views of the ISO SQL <code class="docutils literal notranslate"><span class="pre
</pre></div>
</div>
<p>To show the current session configuration options, use the <code class="docutils literal notranslate"><span class="pre">SHOW</span> <span class="pre">ALL</span></code> command or the <code class="docutils literal notranslate"><span class="pre">information_schema.df_settings</span></code> view:</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</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">information_schema</span><span class="p">.</span><span class="n">df_settings</span><span class="p">;</span>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></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">information_schema</span><span class="p">.</span><span class="n">df_settings</span><span class="p">;</span>
<span class="o">+</span><span class="c1">-------------------------------------------------+---------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">name</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">setting</span><span class="w"> </span><span class="o">|</span>
diff --git a/user-guide/sql/operators.html b/user-guide/sql/operators.html
index b1a5fe47fe..dfcee0b097 100644
--- a/user-guide/sql/operators.html
+++ b/user-guide/sql/operators.html
@@ -358,7 +358,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id1">
+ <a class="reference internal nav-link" href="#op-plus">
<code class="docutils literal notranslate">
<span class="pre">
+
@@ -367,7 +367,7 @@
</a>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id2">
+ <a class="reference internal nav-link" href="#op-minus">
<code class="docutils literal notranslate">
<span class="pre">
-
@@ -376,7 +376,7 @@
</a>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id3">
+ <a class="reference internal nav-link" href="#op-multiply">
<code class="docutils literal notranslate">
<span class="pre">
*
@@ -385,7 +385,7 @@
</a>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id4">
+ <a class="reference internal nav-link" href="#op-divide">
<code class="docutils literal notranslate">
<span class="pre">
/
@@ -394,7 +394,7 @@
</a>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id5">
+ <a class="reference internal nav-link" href="#op-modulo">
<code class="docutils literal notranslate">
<span class="pre">
%
@@ -410,7 +410,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id6">
+ <a class="reference internal nav-link" href="#op-eq">
<code class="docutils literal notranslate">
<span class="pre">
=
@@ -419,7 +419,7 @@
</a>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id7">
+ <a class="reference internal nav-link" href="#op-neq">
<code class="docutils literal notranslate">
<span class="pre">
!=
@@ -428,7 +428,7 @@
</a>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id8">
+ <a class="reference internal nav-link" href="#op-lt">
<code class="docutils literal notranslate">
<span class="pre">
<
@@ -437,7 +437,7 @@
</a>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id9">
+ <a class="reference internal nav-link" href="#op-le">
<code class="docutils literal notranslate">
<span class="pre">
<=
@@ -446,7 +446,7 @@
</a>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id10">
+ <a class="reference internal nav-link" href="#op-gt">
<code class="docutils literal notranslate">
<span class="pre">
>
@@ -455,7 +455,7 @@
</a>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id11">
+ <a class="reference internal nav-link" href="#op-ge">
<code class="docutils literal notranslate">
<span class="pre">
>=
@@ -497,7 +497,7 @@
</a>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id12">
+ <a class="reference internal nav-link" href="#op-re-match">
<code class="docutils literal notranslate">
<span class="pre">
~
@@ -506,7 +506,7 @@
</a>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id13">
+ <a class="reference internal nav-link" href="#op-re-match-i">
<code class="docutils literal notranslate">
<span class="pre">
~*
@@ -515,7 +515,7 @@
</a>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id14">
+ <a class="reference internal nav-link" href="#op-re-not-match">
<code class="docutils literal notranslate">
<span class="pre">
!~
@@ -524,7 +524,7 @@
</a>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id15">
+ <a class="reference internal nav-link" href="#op-re-not-match-i">
<code class="docutils literal notranslate">
<span class="pre">
!~*
@@ -601,7 +601,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id20">
+ <a class="reference internal nav-link" href="#op-bit-and">
<code class="docutils literal notranslate">
<span class="pre">
&
@@ -610,7 +610,7 @@
</a>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id21">
+ <a class="reference internal nav-link" href="#op-bit-or">
<code class="docutils literal notranslate">
<span class="pre">
|
@@ -619,7 +619,7 @@
</a>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id22">
+ <a class="reference internal nav-link" href="#op-bit-xor">
<code class="docutils literal notranslate">
<span class="pre">
#
@@ -628,7 +628,7 @@
</a>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id23">
+ <a class="reference internal nav-link" href="#op-shift-r">
<code class="docutils literal notranslate">
<span class="pre">
>>
@@ -637,7 +637,7 @@
</a>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id24">
+ <a class="reference internal nav-link" href="#op-shift-l">
<code class="docutils literal notranslate">
<span class="pre">
<<
@@ -653,7 +653,7 @@
</a>
<ul class="nav section-nav flex-column">
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id25">
+ <a class="reference internal nav-link" href="#op-str-cat">
<code class="docutils literal notranslate">
<span class="pre">
||
@@ -662,7 +662,7 @@
</a>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id26">
+ <a class="reference internal nav-link" href="#op-arr-contains">
<code class="docutils literal notranslate">
<span class="pre">
@>
@@ -671,7 +671,7 @@
</a>
</li>
<li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link" href="#id27">
+ <a class="reference internal nav-link" href="#op-arr-contained-by">
<code class="docutils literal notranslate">
<span class="pre">
<@
@@ -732,14 +732,14 @@
<section id="numerical-operators">
<h2>Numerical Operators<a class="headerlink" href="#numerical-operators" title="Link to this heading">¶</a></h2>
<ul class="simple">
-<li><p><a class="reference internal" href="#id1"><span class="xref myst">+ (plus)</span></a></p></li>
-<li><p><a class="reference internal" href="#id2"><span class="xref myst">- (minus)</span></a></p></li>
-<li><p><a class="reference internal" href="#id3"><span class="xref myst">* (multiply)</span></a></p></li>
-<li><p><a class="reference internal" href="#id4"><span class="xref myst">/ (divide)</span></a></p></li>
-<li><p><a class="reference internal" href="#id5"><span class="xref myst">% (modulo)</span></a></p></li>
+<li><p><a class="reference internal" href="#op-plus">+ (plus)</a></p></li>
+<li><p><a class="reference internal" href="#op-minus">- (minus)</a></p></li>
+<li><p><a class="reference internal" href="#op-multiply">* (multiply)</a></p></li>
+<li><p><a class="reference internal" href="#op-divide">/ (divide)</a></p></li>
+<li><p><a class="reference internal" href="#op-modulo">% (modulo)</a></p></li>
</ul>
-<section id="id1">
-<h3><code class="docutils literal notranslate"><span class="pre">+</span></code><a class="headerlink" href="#id1" title="Link to this heading">¶</a></h3>
+<section id="op-plus">
+<span id="id1"></span><h3><code class="docutils literal notranslate"><span class="pre">+</span></code><a class="headerlink" href="#op-plus" title="Link to this heading">¶</a></h3>
<p>Addition</p>
<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="mi">1</span><span class="w"> </span><span class="o">+</span><span class="w"> </span><span class="mi">2</span><span class="p">;</span>
<span class="o">+</span><span class="c1">---------------------+</span>
@@ -750,8 +750,8 @@
</pre></div>
</div>
</section>
-<section id="id2">
-<h3><code class="docutils literal notranslate"><span class="pre">-</span></code><a class="headerlink" href="#id2" title="Link to this heading">¶</a></h3>
+<section id="op-minus">
+<span id="id2"></span><h3><code class="docutils literal notranslate"><span class="pre">-</span></code><a class="headerlink" href="#op-minus" title="Link to this heading">¶</a></h3>
<p>Subtraction</p>
<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="mi">4</span><span class="w"> </span><span class="o">-</span><span class="w"> </span><span class="mi">3</span><span class="p">;</span>
<span class="o">+</span><span class="c1">---------------------+</span>
@@ -762,8 +762,8 @@
</pre></div>
</div>
</section>
-<section id="id3">
-<h3><code class="docutils literal notranslate"><span class="pre">*</span></code><a class="headerlink" href="#id3" title="Link to this heading">¶</a></h3>
+<section id="op-multiply">
+<span id="id3"></span><h3><code class="docutils literal notranslate"><span class="pre">*</span></code><a class="headerlink" href="#op-multiply" title="Link to this heading">¶</a></h3>
<p>Multiplication</p>
<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="mi">2</span><span class="w"> </span><span class="o">*</span><span class="w"> </span><span class="mi">3</span><span class="p">;</span>
<span class="o">+</span><span class="c1">---------------------+</span>
@@ -774,8 +774,8 @@
</pre></div>
</div>
</section>
-<section id="id4">
-<h3><code class="docutils literal notranslate"><span class="pre">/</span></code><a class="headerlink" href="#id4" title="Link to this heading">¶</a></h3>
+<section id="op-divide">
+<span id="id4"></span><h3><code class="docutils literal notranslate"><span class="pre">/</span></code><a class="headerlink" href="#op-divide" title="Link to this heading">¶</a></h3>
<p>Division (integer division truncates toward zero)</p>
<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="mi">8</span><span class="w"> </span><span class="o">/</span><span class="w"> </span><span class="mi">4</span><span class="p">;</span>
<span class="o">+</span><span class="c1">---------------------+</span>
@@ -786,8 +786,8 @@
</pre></div>
</div>
</section>
-<section id="id5">
-<h3><code class="docutils literal notranslate"><span class="pre">%</span></code><a class="headerlink" href="#id5" title="Link to this heading">¶</a></h3>
+<section id="op-modulo">
+<span id="id5"></span><h3><code class="docutils literal notranslate"><span class="pre">%</span></code><a class="headerlink" href="#op-modulo" title="Link to this heading">¶</a></h3>
<p>Modulo (remainder)</p>
<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="mi">7</span><span class="w"> </span><span class="o">%</span><span class="w"> </span><span class="mi">3</span><span class="p">;</span>
<span class="o">+</span><span class="c1">---------------------+</span>
@@ -802,21 +802,21 @@
<section id="comparison-operators">
<h2>Comparison Operators<a class="headerlink" href="#comparison-operators" title="Link to this heading">¶</a></h2>
<ul class="simple">
-<li><p><a class="reference internal" href="#id6"><span class="xref myst">= (equal)</span></a></p></li>
-<li><p><a class="reference internal" href="#id7"><span class="xref myst">!= (not equal)</span></a></p></li>
-<li><p><a class="reference internal" href="#id8"><span class="xref myst">< (less than)</span></a></p></li>
-<li><p><a class="reference internal" href="#id9"><span class="xref myst"><= (less than or equal to)</span></a></p></li>
-<li><p><a class="reference internal" href="#id10"><span class="xref myst">> (greater than)</span></a></p></li>
-<li><p><a class="reference internal" href="#id11"><span class="xref myst">>= (greater than or equal to)</span></a></p></li>
+<li><p><a class="reference internal" href="#op-eq">= (equal)</a></p></li>
+<li><p><a class="reference internal" href="#op-neq">!= (not equal)</a></p></li>
+<li><p><a class="reference internal" href="#op-lt">< (less than)</a></p></li>
+<li><p><a class="reference internal" href="#op-le"><= (less than or equal to)</a></p></li>
+<li><p><a class="reference internal" href="#op-gt">> (greater than)</a></p></li>
+<li><p><a class="reference internal" href="#op-ge">>= (greater than or equal to)</a></p></li>
<li><p><a class="reference internal" href="#is-distinct-from">IS DISTINCT FROM</a></p></li>
<li><p><a class="reference internal" href="#is-not-distinct-from">IS NOT DISTINCT FROM</a></p></li>
-<li><p><a class="reference internal" href="#id12"><span class="xref myst">~ (regex match)</span></a></p></li>
-<li><p><a class="reference internal" href="#id13"><span class="xref myst">~* (regex case-insensitive match)</span></a></p></li>
-<li><p><a class="reference internal" href="#id14"><span class="xref myst">!~ (not regex match)</span></a></p></li>
-<li><p><a class="reference internal" href="#id15"><span class="xref myst">!~* (not regex case-insensitive match)</span></a></p></li>
+<li><p><a class="reference internal" href="#op-re-match">~ (regex match)</a></p></li>
+<li><p><a class="reference internal" href="#op-re-match-i">~* (regex case-insensitive match)</a></p></li>
+<li><p><a class="reference internal" href="#op-re-not-match">!~ (not regex match)</a></p></li>
+<li><p><a class="reference internal" href="#op-re-not-match-i">!~* (not regex case-insensitive match)</a></p></li>
</ul>
-<section id="id6">
-<h3><code class="docutils literal notranslate"><span class="pre">=</span></code><a class="headerlink" href="#id6" title="Link to this heading">¶</a></h3>
+<section id="op-eq">
+<span id="id6"></span><h3><code class="docutils literal notranslate"><span class="pre">=</span></code><a class="headerlink" href="#op-eq" title="Link to this heading">¶</a></h3>
<p>Equal</p>
<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="mi">1</span><span class="w"> </span><span class="o">=</span><span class="w"> </span><span class="mi">1</span><span class="p">;</span>
<span class="o">+</span><span class="c1">---------------------+</span>
@@ -827,8 +827,8 @@
</pre></div>
</div>
</section>
-<section id="id7">
-<h3><code class="docutils literal notranslate"><span class="pre">!=</span></code><a class="headerlink" href="#id7" title="Link to this heading">¶</a></h3>
+<section id="op-neq">
+<span id="id7"></span><h3><code class="docutils literal notranslate"><span class="pre">!=</span></code><a class="headerlink" href="#op-neq" title="Link to this heading">¶</a></h3>
<p>Not Equal</p>
<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="mi">1</span><span class="w"> </span><span class="o">!=</span><span class="w"> </span><span class="mi">2</span><span class="p">;</span>
<span class="o">+</span><span class="c1">----------------------+</span>
@@ -839,8 +839,8 @@
</pre></div>
</div>
</section>
-<section id="id8">
-<h3><code class="docutils literal notranslate"><span class="pre"><</span></code><a class="headerlink" href="#id8" title="Link to this heading">¶</a></h3>
+<section id="op-lt">
+<span id="id8"></span><h3><code class="docutils literal notranslate"><span class="pre"><</span></code><a class="headerlink" href="#op-lt" title="Link to this heading">¶</a></h3>
<p>Less Than</p>
<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="mi">3</span><span class="w"> </span><span class="o"><</span><span class="w"> </span><span class="mi">4</span><span class="p">;</span>
<span class="o">+</span><span class="c1">---------------------+</span>
@@ -851,8 +851,8 @@
</pre></div>
</div>
</section>
-<section id="id9">
-<h3><code class="docutils literal notranslate"><span class="pre"><=</span></code><a class="headerlink" href="#id9" title="Link to this heading">¶</a></h3>
+<section id="op-le">
+<span id="id9"></span><h3><code class="docutils literal notranslate"><span class="pre"><=</span></code><a class="headerlink" href="#op-le" title="Link to this heading">¶</a></h3>
<p>Less Than or Equal To</p>
<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="mi">3</span><span class="w"> </span><span class="o"><=</span><span class="w"> </span><span class="mi">3</span><span class="p">;</span>
<span class="o">+</span><span class="c1">----------------------+</span>
@@ -863,8 +863,8 @@
</pre></div>
</div>
</section>
-<section id="id10">
-<h3><code class="docutils literal notranslate"><span class="pre">></span></code><a class="headerlink" href="#id10" title="Link to this heading">¶</a></h3>
+<section id="op-gt">
+<span id="id10"></span><h3><code class="docutils literal notranslate"><span class="pre">></span></code><a class="headerlink" href="#op-gt" title="Link to this heading">¶</a></h3>
<p>Greater Than</p>
<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="mi">6</span><span class="w"> </span><span class="o">></span><span class="w"> </span><span class="mi">5</span><span class="p">;</span>
<span class="o">+</span><span class="c1">---------------------+</span>
@@ -875,8 +875,8 @@
</pre></div>
</div>
</section>
-<section id="id11">
-<h3><code class="docutils literal notranslate"><span class="pre">>=</span></code><a class="headerlink" href="#id11" title="Link to this heading">¶</a></h3>
+<section id="op-ge">
+<span id="id11"></span><h3><code class="docutils literal notranslate"><span class="pre">>=</span></code><a class="headerlink" href="#op-ge" title="Link to this heading">¶</a></h3>
<p>Greater Than or Equal To</p>
<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="mi">5</span><span class="w"> </span><span class="o">>=</span><span class="w"> </span><span class="mi">5</span><span class="p">;</span>
<span class="o">+</span><span class="c1">----------------------+</span>
@@ -911,8 +911,8 @@
</pre></div>
</div>
</section>
-<section id="id12">
-<h3><code class="docutils literal notranslate"><span class="pre">~</span></code><a class="headerlink" href="#id12" title="Link to this heading">¶</a></h3>
+<section id="op-re-match">
+<span id="id12"></span><h3><code class="docutils literal notranslate"><span class="pre">~</span></code><a class="headerlink" href="#op-re-match" title="Link to this heading">¶</a></h3>
<p>Regex Match</p>
<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="s1">'datafusion'</span><span class="w"> </span><span class="o">~</span><span class="w"> </span><span class="s1">'^datafusion(-cli)*'</span><span class="p">;</span>
<span class="o">+</span><span class="c1">-------------------------------------------------+</span>
@@ -923,8 +923,8 @@
</pre></div>
</div>
</section>
-<section id="id13">
-<h3><code class="docutils literal notranslate"><span class="pre">~*</span></code><a class="headerlink" href="#id13" title="Link to this heading">¶</a></h3>
+<section id="op-re-match-i">
+<span id="id13"></span><h3><code class="docutils literal notranslate"><span class="pre">~*</span></code><a class="headerlink" href="#op-re-match-i" title="Link to this heading">¶</a></h3>
<p>Regex Case-Insensitive Match</p>
<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="s1">'datafusion'</span><span class="w"> </span><span class="o">~*</span><span class="w"> </span><span class="s1">'^DATAFUSION(-cli)*'</span><span class="p">;</span>
<span class="o">+</span><span class="c1">--------------------------------------------------+</span>
@@ -935,8 +935,8 @@
</pre></div>
</div>
</section>
-<section id="id14">
-<h3><code class="docutils literal notranslate"><span class="pre">!~</span></code><a class="headerlink" href="#id14" title="Link to this heading">¶</a></h3>
+<section id="op-re-not-match">
+<span id="id14"></span><h3><code class="docutils literal notranslate"><span class="pre">!~</span></code><a class="headerlink" href="#op-re-not-match" title="Link to this heading">¶</a></h3>
<p>Not Regex Match</p>
<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="s1">'datafusion'</span><span class="w"> </span><span class="o">!~</span><span class="w"> </span><span class="s1">'^DATAFUSION(-cli)*'</span><span class="p">;</span>
<span class="o">+</span><span class="c1">--------------------------------------------------+</span>
@@ -947,8 +947,8 @@
</pre></div>
</div>
</section>
-<section id="id15">
-<h3><code class="docutils literal notranslate"><span class="pre">!~*</span></code><a class="headerlink" href="#id15" title="Link to this heading">¶</a></h3>
+<section id="op-re-not-match-i">
+<span id="id15"></span><h3><code class="docutils literal notranslate"><span class="pre">!~*</span></code><a class="headerlink" href="#op-re-not-match-i" title="Link to this heading">¶</a></h3>
<p>Not Regex Case-Insensitive Match</p>
<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="s1">'datafusion'</span><span class="w"> </span><span class="o">!~*</span><span class="w"> </span><span class="s1">'^DATAFUSION(-cli)+'</span><span class="p">;</span>
<span class="o">+</span><span class="c1">---------------------------------------------------+</span>
@@ -962,7 +962,7 @@
<section id="id16">
<h3><code class="docutils literal notranslate"><span class="pre">~~</span></code><a class="headerlink" href="#id16" title="Link to this heading">¶</a></h3>
<p>Like Match</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</span><span class="w"> </span><span class="k">SELECT</span><span class="w"> </span><span class="s1">'datafusion'</span><span class="w"> </span><span class="o">~~</span><span class="w"> </span><span class="s1">'dat_f%n'</span><span class="p">;</span>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">SELECT</span><span class="w"> </span><span class="s1">'datafusion'</span><span class="w"> </span><span class="o">~~</span><span class="w"> </span><span class="s1">'dat_f%n'</span><span class="p">;</span>
<span class="o">+</span><span class="c1">---------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"datafusion"</span><span class="p">)</span><span class="w"> </span><span class="o">~~</span><span class="w"> </span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"dat_f%n"</span><span class="p">)</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">---------------------------------------+</span>
@@ -974,7 +974,7 @@
<section id="id17">
<h3><code class="docutils literal notranslate"><span class="pre">~~*</span></code><a class="headerlink" href="#id17" title="Link to this heading">¶</a></h3>
<p>Case-Insensitive Like Match</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</span><span class="w"> </span><span class="k">SELECT</span><span class="w"> </span><span class="s1">'datafusion'</span><span class="w"> </span><span class="o">~~*</span><span class="w"> </span><span class="s1">'Dat_F%n'</span><span class="p">;</span>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">SELECT</span><span class="w"> </span><span class="s1">'datafusion'</span><span class="w"> </span><span class="o">~~*</span><span class="w"> </span><span class="s1">'Dat_F%n'</span><span class="p">;</span>
<span class="o">+</span><span class="c1">----------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"datafusion"</span><span class="p">)</span><span class="w"> </span><span class="o">~~*</span><span class="w"> </span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"Dat_F%n"</span><span class="p">)</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------------------------------------+</span>
@@ -986,7 +986,7 @@
<section id="id18">
<h3><code class="docutils literal notranslate"><span class="pre">!~~</span></code><a class="headerlink" href="#id18" title="Link to this heading">¶</a></h3>
<p>Not Like Match</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</span><span class="w"> </span><span class="k">SELECT</span><span class="w"> </span><span class="s1">'datafusion'</span><span class="w"> </span><span class="o">!~~</span><span class="w"> </span><span class="s1">'Dat_F%n'</span><span class="p">;</span>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">SELECT</span><span class="w"> </span><span class="s1">'datafusion'</span><span class="w"> </span><span class="o">!~~</span><span class="w"> </span><span class="s1">'Dat_F%n'</span><span class="p">;</span>
<span class="o">+</span><span class="c1">----------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"datafusion"</span><span class="p">)</span><span class="w"> </span><span class="o">!~~</span><span class="w"> </span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"Dat_F%n"</span><span class="p">)</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------------------------------------+</span>
@@ -998,7 +998,7 @@
<section id="id19">
<h3><code class="docutils literal notranslate"><span class="pre">!~~*</span></code><a class="headerlink" href="#id19" title="Link to this heading">¶</a></h3>
<p>Not Case-Insensitive Like Match</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</span><span class="w"> </span><span class="k">SELECT</span><span class="w"> </span><span class="s1">'datafusion'</span><span class="w"> </span><span class="o">!~~*</span><span class="w"> </span><span class="s1">'Dat%F_n'</span><span class="p">;</span>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">SELECT</span><span class="w"> </span><span class="s1">'datafusion'</span><span class="w"> </span><span class="o">!~~*</span><span class="w"> </span><span class="s1">'Dat%F_n'</span><span class="p">;</span>
<span class="o">+</span><span class="c1">-----------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"datafusion"</span><span class="p">)</span><span class="w"> </span><span class="o">!~~*</span><span class="w"> </span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"Dat%F_n"</span><span class="p">)</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">-----------------------------------------+</span>
@@ -1042,14 +1042,14 @@
<section id="bitwise-operators">
<h2>Bitwise Operators<a class="headerlink" href="#bitwise-operators" title="Link to this heading">¶</a></h2>
<ul class="simple">
-<li><p><a class="reference internal" href="#id16"><span class="xref myst">& (bitwise and)</span></a></p></li>
-<li><p><a class="reference internal" href="#id17"><span class="xref myst">| (bitwise or)</span></a></p></li>
-<li><p><a class="reference internal" href="#id18"><span class="xref myst"># (bitwise xor)</span></a></p></li>
-<li><p><a class="reference internal" href="#id19"><span class="xref myst">>> (bitwise shift right)</span></a></p></li>
-<li><p><a class="reference internal" href="#id20"><span class="xref myst"><< (bitwise shift left)</span></a></p></li>
+<li><p><a class="reference internal" href="#op-bit-and">& (bitwise and)</a></p></li>
+<li><p><a class="reference internal" href="#op-bit-or">| (bitwise or)</a></p></li>
+<li><p><a class="reference internal" href="#op-bit-xor"># (bitwise xor)</a></p></li>
+<li><p><a class="reference internal" href="#op-shift-r">>> (bitwise shift right)</a></p></li>
+<li><p><a class="reference internal" href="#op-shift-l"><< (bitwise shift left)</a></p></li>
</ul>
-<section id="id20">
-<h3><code class="docutils literal notranslate"><span class="pre">&</span></code><a class="headerlink" href="#id20" title="Link to this heading">¶</a></h3>
+<section id="op-bit-and">
+<span id="id20"></span><h3><code class="docutils literal notranslate"><span class="pre">&</span></code><a class="headerlink" href="#op-bit-and" title="Link to this heading">¶</a></h3>
<p>Bitwise And</p>
<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="mi">5</span><span class="w"> </span><span class="o">&</span><span class="w"> </span><span class="mi">3</span><span class="p">;</span>
<span class="o">+</span><span class="c1">---------------------+</span>
@@ -1060,8 +1060,8 @@
</pre></div>
</div>
</section>
-<section id="id21">
-<h3><code class="docutils literal notranslate"><span class="pre">|</span></code><a class="headerlink" href="#id21" title="Link to this heading">¶</a></h3>
+<section id="op-bit-or">
+<span id="id21"></span><h3><code class="docutils literal notranslate"><span class="pre">|</span></code><a class="headerlink" href="#op-bit-or" title="Link to this heading">¶</a></h3>
<p>Bitwise Or</p>
<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="mi">5</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="mi">3</span><span class="p">;</span>
<span class="o">+</span><span class="c1">---------------------+</span>
@@ -1072,8 +1072,8 @@
</pre></div>
</div>
</section>
-<section id="id22">
-<h3><code class="docutils literal notranslate"><span class="pre">#</span></code><a class="headerlink" href="#id22" title="Link to this heading">¶</a></h3>
+<section id="op-bit-xor">
+<span id="id22"></span><h3><code class="docutils literal notranslate"><span class="pre">#</span></code><a class="headerlink" href="#op-bit-xor" title="Link to this heading">¶</a></h3>
<p>Bitwise Xor (interchangeable with <code class="docutils literal notranslate"><span class="pre">^</span></code>)</p>
<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="mi">5</span><span class="w"> </span><span class="o">#</span><span class="w"> </span><span class="mi">3</span><span class="p">;</span>
<span class="o">+</span><span class="c1">---------------------+</span>
@@ -1084,8 +1084,8 @@
</pre></div>
</div>
</section>
-<section id="id23">
-<h3><code class="docutils literal notranslate"><span class="pre">>></span></code><a class="headerlink" href="#id23" title="Link to this heading">¶</a></h3>
+<section id="op-shift-r">
+<span id="id23"></span><h3><code class="docutils literal notranslate"><span class="pre">>></span></code><a class="headerlink" href="#op-shift-r" title="Link to this heading">¶</a></h3>
<p>Bitwise Shift Right</p>
<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="mi">5</span><span class="w"> </span><span class="o">>></span><span class="w"> </span><span class="mi">3</span><span class="p">;</span>
<span class="o">+</span><span class="c1">----------------------+</span>
@@ -1096,8 +1096,8 @@
</pre></div>
</div>
</section>
-<section id="id24">
-<h3><code class="docutils literal notranslate"><span class="pre"><<</span></code><a class="headerlink" href="#id24" title="Link to this heading">¶</a></h3>
+<section id="op-shift-l">
+<span id="id24"></span><h3><code class="docutils literal notranslate"><span class="pre"><<</span></code><a class="headerlink" href="#op-shift-l" title="Link to this heading">¶</a></h3>
<p>Bitwise Shift Left</p>
<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="mi">5</span><span class="w"> </span><span class="o"><<</span><span class="w"> </span><span class="mi">3</span><span class="p">;</span>
<span class="o">+</span><span class="c1">----------------------+</span>
@@ -1112,12 +1112,12 @@
<section id="other-operators">
<h2>Other Operators<a class="headerlink" href="#other-operators" title="Link to this heading">¶</a></h2>
<ul class="simple">
-<li><p><a class="reference internal" href="#id21"><span class="xref myst">|| (string concatenation)</span></a></p></li>
-<li><p><a class="reference internal" href="#id22"><span class="xref myst">@> (array contains)</span></a></p></li>
-<li><p><a class="reference internal" href="#id23"><span class="xref myst"><@ (array is contained by)</span></a></p></li>
+<li><p><a class="reference internal" href="#op-str-cat">|| (string concatenation)</a></p></li>
+<li><p><a class="reference internal" href="#op-arr-contains">@> (array contains)</a></p></li>
+<li><p><a class="reference internal" href="#op-arr-contained-by"><@ (array is contained by)</a></p></li>
</ul>
-<section id="id25">
-<h3><code class="docutils literal notranslate"><span class="pre">||</span></code><a class="headerlink" href="#id25" title="Link to this heading">¶</a></h3>
+<section id="op-str-cat">
+<span id="id25"></span><h3><code class="docutils literal notranslate"><span class="pre">||</span></code><a class="headerlink" href="#op-str-cat" title="Link to this heading">¶</a></h3>
<p>String Concatenation</p>
<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="s1">'Hello, '</span><span class="w"> </span><span class="o">||</span><span class="w"> </span><span class="s1">'DataFusion!'</span><span class="p">;</span>
<span class="o">+</span><span class="c1">----------------------------------------+</span>
@@ -1128,8 +1128,8 @@
</pre></div>
</div>
</section>
-<section id="id26">
-<h3><code class="docutils literal notranslate"><span class="pre">@></span></code><a class="headerlink" href="#id26" title="Link to this heading">¶</a></h3>
+<section id="op-arr-contains">
+<span id="id26"></span><h3><code class="docutils literal notranslate"><span class="pre">@></span></code><a class="headerlink" href="#op-arr-contains" title="Link to this heading">¶</a></h3>
<p>Array Contains</p>
<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="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="w"> </span><span class="o">@></span><span class="w"> </span><span class="n">make_array</ [...]
<span class="o">+</span><span class="c1">-------------------------------------------------------------------------+</span>
@@ -1140,8 +1140,8 @@
</pre></div>
</div>
</section>
-<section id="id27">
-<h3><code class="docutils literal notranslate"><span class="pre"><@</span></code><a class="headerlink" href="#id27" title="Link to this heading">¶</a></h3>
+<section id="op-arr-contained-by">
+<span id="id27"></span><h3><code class="docutils literal notranslate"><span class="pre"><@</span></code><a class="headerlink" href="#op-arr-contained-by" title="Link to this heading">¶</a></h3>
<p>Array Is Contained By</p>
<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="n">make_array</span><span class="p">(</span><span class="mi">1</span><span class="p">,</span><span class="mi">3</span><span class="p">)</span><span class="w"> </span><span class="o"><@</span><span class="w"> </span><span class="n">make_array</span><span class="p">(</span><span class="mi">1</ [...]
<span class="o">+</span><span class="c1">-------------------------------------------------------------------------+</span>
diff --git a/user-guide/sql/scalar_functions.html b/user-guide/sql/scalar_functions.html
index 1a3b8807fe..83b64fb529 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -2054,6 +2054,15 @@
</li>
</ul>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#array-contains">
+ <code class="docutils literal notranslate">
+ <span class="pre">
+ array_contains
+ </span>
+ </code>
+ </a>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link" href="#array-has">
<code class="docutils literal notranslate">
@@ -4126,7 +4135,7 @@ Can be a constant, column, or function, and any combination of string operators.
<li><p><strong>str_n</strong>: Subsequent string column or literal string to concatenate.</p></li>
</ul>
<p><strong>Related functions</strong>:
-<a class="reference internal" href="#contcat_ws"><span class="xref myst">contcat_ws</span></a></p>
+<a class="reference internal" href="#concat-ws">concat_ws</a></p>
</section>
</section>
<section id="concat-ws">
@@ -4718,13 +4727,13 @@ regular expression. The following flags are supported:</p>
</section>
<section id="example">
<h4>Example<a class="headerlink" href="#example" title="Link to this heading">¶</a></h4>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">regexp_like</span><span class="p">(</span><span class="s1">'Köln'</span><span class="p">,</span><span class="w"> </span><span class="s1">'[a-zA-Z]ö[a-zA-Z]{2}'</span><span class="p">);</span>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">select</span><span class="w"> </span><span class="n">regexp_like</span><span class="p">(</span><span class="s1">'Köln'</span><span class="p">,</span><span class="w"> </span><span class="s1">'[a-zA-Z]ö[a-zA-Z]{2}'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">--------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">regexp_like</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"Köln"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"[a-zA-Z]ö[a-zA-Z]{2}"</span><span class="p">))</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">true</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------------------------------------------------+</span>
-<span class="err">❯</span><span class="w"> </span><span class="k">SELECT</span><span class="w"> </span><span class="n">regexp_like</span><span class="p">(</span><span class="s1">'aBc'</span><span class="p">,</span><span class="w"> </span><span class="s1">'(b|d)'</span><span class="p">,</span><span class="w"> </span><span class="s1">'i'</span><span class="p">);</span>
+<span class="k">SELECT</span><span class="w"> </span><span class="n">regexp_like</span><span class="p">(</span><span class="s1">'aBc'</span><span class="p">,</span><span class="w"> </span><span class="s1">'(b|d)'</span><span class="p">,</span><span class="w"> </span><span class="s1">'i'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">--------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">regexp_like</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"aBc"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"(b|d)"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"i"</span><span class="p">))</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">--------------------------------------------------+</span>
@@ -4762,13 +4771,13 @@ regular expression. The following flags are supported:</p>
</section>
<section id="id75">
<h4>Example<a class="headerlink" href="#id75" title="Link to this heading">¶</a></h4>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">regexp_match</span><span class="p">(</span><span class="s1">'Köln'</span><span class="p">,</span><span class="w"> </span><span class="s1">'[a-zA-Z]ö[a-zA-Z]{2}'</span><span class="p">);</span>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">select</span><span class="w"> </span><span class="n">regexp_match</span><span class="p">(</span><span class="s1">'Köln'</span><span class="p">,</span><span class="w"> </span><span class="s1">'[a-zA-Z]ö[a-zA-Z]{2}'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">---------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">regexp_match</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"Köln"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"[a-zA-Z]ö[a-zA-Z]{2}"</span><span class="p">))</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="p">[</span><span class="n">Köln</span><span class="p">]</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">---------------------------------------------------------+</span>
-<span class="err">❯</span><span class="w"> </span><span class="k">SELECT</span><span class="w"> </span><span class="n">regexp_match</span><span class="p">(</span><span class="s1">'aBc'</span><span class="p">,</span><span class="w"> </span><span class="s1">'(b|d)'</span><span class="p">,</span><span class="w"> </span><span class="s1">'i'</span><span class="p">);</span>
+<span class="k">SELECT</span><span class="w"> </span><span class="n">regexp_match</span><span class="p">(</span><span class="s1">'aBc'</span><span class="p">,</span><span class="w"> </span><span class="s1">'(b|d)'</span><span class="p">,</span><span class="w"> </span><span class="s1">'i'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">---------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">regexp_match</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"aBc"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"(b|d)"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"i"</span><span class="p">))</span><span class="w"> </span><span class="o"> [...]
<span class="o">+</span><span class="c1">---------------------------------------------------+</span>
@@ -4809,13 +4818,13 @@ regular expression. The following flags are supported:</p>
</section>
<section id="id77">
<h4>Example<a class="headerlink" href="#id77" title="Link to this heading">¶</a></h4>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</span><span class="w"> </span><span class="k">SELECT</span><span class="w"> </span><span class="n">regexp_replace</span><span class="p">(</span><span class="s1">'foobarbaz'</span><span class="p">,</span><span class="w"> </span><span class="s1">'b(..)'</span><span class="p">,</span><span class="w"> </span><span class="s1">'X\\1Y'</span><span class="p">,</span><span c [...]
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">SELECT</span><span class="w"> </span><span class="n">regexp_replace</span><span class="p">(</span><span class="s1">'foobarbaz'</span><span class="p">,</span><span class="w"> </span><span class="s1">'b(..)'</span><span class="p">,</span><span class="w"> </span><span class="s1">'X\\1Y'</span><span class="p">,</span><span class="w"> </span><span class="s1">'g'</spa [...]
<span class="o">+</span><span class="c1">------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">regexp_replace</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"foobarbaz"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"b(..)"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"X\1Y"</span><span class="p">),</span><span class="n">Utf8</span><s [...]
<span class="o">+</span><span class="c1">------------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">fooXarYXazY</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">------------------------------------------------------------------------+</span>
-<span class="err">❯</span><span class="w"> </span><span class="k">SELECT</span><span class="w"> </span><span class="n">regexp_replace</span><span class="p">(</span><span class="s1">'aBc'</span><span class="p">,</span><span class="w"> </span><span class="s1">'(b|d)'</span><span class="p">,</span><span class="w"> </span><span class="s1">'Ab\\1a'</span><span class="p">,</span><span class="w"> </span><span class="s1">'i'</span><span class="p">);</span>
+<span class="k">SELECT</span><span class="w"> </span><span class="n">regexp_replace</span><span class="p">(</span><span class="s1">'aBc'</span><span class="p">,</span><span class="w"> </span><span class="s1">'(b|d)'</span><span class="p">,</span><span class="w"> </span><span class="s1">'Ab\\1a'</span><span class="p">,</span><span class="w"> </span><span class="s1">'i'</span><span class="p">);</span>
<span class="o">+</span><span class="c1">-------------------------------------------------------------------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">regexp_replace</span><span class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"aBc"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"(b|d)"</span><span class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span class="ss">"Ab\1a"</span><span class="p">),</span><span class="n">Utf8</span><span c [...]
<span class="o">+</span><span class="c1">-------------------------------------------------------------------+</span>
@@ -5082,7 +5091,7 @@ Can be a constant, column or function, and any combination of arithmetic operato
+-----------------------------------------------+
</pre></div>
</div>
-<p>Additional examples can be found <a class="reference external" href="https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/regexp.rs">here</a></p>
+<p>Additional examples can be found <a class="reference external" href="https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/make_date.rs">here</a></p>
</section>
</section>
<section id="to-timestamp">
@@ -5124,7 +5133,7 @@ an error will be returned.</p></li>
+--------------------------------------------------------------------------------------------------------+
</pre></div>
</div>
-<p>Additional examples can be found <a class="reference external" href="https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/regexp.rs">here</a></p>
+<p>Additional examples can be found <a class="reference external" href="https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/to_timestamp.rs">here</a></p>
</section>
</section>
<section id="to-timestamp-millis">
@@ -5163,7 +5172,7 @@ an error will be returned.</p></li>
+---------------------------------------------------------------------------------------------------------------+
</pre></div>
</div>
-<p>Additional examples can be found <a class="reference external" href="https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/regexp.rs">here</a></p>
+<p>Additional examples can be found <a class="reference external" href="https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/to_timestamp.rs">here</a></p>
</section>
</section>
<section id="to-timestamp-micros">
@@ -5202,7 +5211,7 @@ an error will be returned.</p></li>
+---------------------------------------------------------------------------------------------------------------+
</pre></div>
</div>
-<p>Additional examples can be found <a class="reference external" href="https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/regexp.rs">here</a></p>
+<p>Additional examples can be found <a class="reference external" href="https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/to_timestamp.rs">here</a></p>
</section>
</section>
<section id="to-timestamp-nanos">
@@ -5241,7 +5250,7 @@ an error will be returned.</p></li>
+---------------------------------------------------------------------------------------------------------------+
</pre></div>
</div>
-<p>Additional examples can be found <a class="reference external" href="https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/regexp.rs">here</a></p>
+<p>Additional examples can be found <a class="reference external" href="https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/to_timestamp.rs">here</a></p>
</section>
</section>
<section id="to-timestamp-seconds">
@@ -5280,7 +5289,7 @@ an error will be returned.</p></li>
+----------------------------------------------------------------------------------------------------------------+
</pre></div>
</div>
-<p>Additional examples can be found <a class="reference external" href="https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/regexp.rs">here</a></p>
+<p>Additional examples can be found <a class="reference external" href="https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/to_timestamp.rs">here</a></p>
</section>
</section>
<section id="from-unixtime">
@@ -5307,7 +5316,7 @@ Can be a constant, column, or function, and any combination of arithmetic operat
<li><p><a class="reference internal" href="#array-sort">array_sort</a></p></li>
<li><p><a class="reference internal" href="#array-cat">array_cat</a></p></li>
<li><p><a class="reference internal" href="#array-concat">array_concat</a></p></li>
-<li><p><a class="reference internal" href="#array_contains"><span class="xref myst">array_contains</span></a></p></li>
+<li><p><a class="reference internal" href="#array-contains">array_contains</a></p></li>
<li><p><a class="reference internal" href="#array-dims">array_dims</a></p></li>
<li><p><a class="reference internal" href="#array-element">array_element</a></p></li>
<li><p><a class="reference internal" href="#array-extract">array_extract</a></p></li>
@@ -5476,6 +5485,10 @@ Can be a constant, column, or function, and any combination of array operators.<
</ul>
</section>
</section>
+<section id="array-contains">
+<h3><code class="docutils literal notranslate"><span class="pre">array_contains</span></code><a class="headerlink" href="#array-contains" title="Link to this heading">¶</a></h3>
+<p><em>Alias of <a class="reference internal" href="#array-has">array_has</a>.</em></p>
+</section>
<section id="array-has">
<h3><code class="docutils literal notranslate"><span class="pre">array_has</span></code><a class="headerlink" href="#array-has" title="Link to this heading">¶</a></h3>
<p>Returns true if the array contains the element</p>
@@ -6588,21 +6601,21 @@ For example: <code class="docutils literal notranslate"><span class="pre">c0</sp
</div>
<p>For example, this query converts two columns <code class="docutils literal notranslate"><span class="pre">a</span></code> and <code class="docutils literal notranslate"><span class="pre">b</span></code> to a single column with
a struct type of fields <code class="docutils literal notranslate"><span class="pre">c0</span></code> and <code class="docutils literal notranslate"><span class="pre">c1</span></code>:</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</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">t</span><span class="p">;</span>
-<span class="o">+</span><span class="c1">---+---+</span>
-<span class="o">|</span><span class="w"> </span><span class="n">a</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">b</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="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="w"> </span><span class="mi">4</span><span class="w"> </span><span class="o">|</span>
-<span class="o">+</span><span class="c1">---+---+</span>
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">select</span> <span class="o">*</span> <span class="kn">from</span> <span class="nn">t</span><span class="p">;</span>
+<span class="o">+---+---+</span>
+<span class="o">|</span> <span class="n">a</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">1</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="mi">4</span> <span class="o">|</span>
+<span class="o">+---+---+</span>
-<span class="err">❯</span><span class="w"> </span><span class="k">select</span><span class="w"> </span><span class="n">struct</span><span class="p">(</span><span class="n">a</span><span class="p">,</span><span class="w"> </span><span class="n">b</span><span class="p">)</span><span class="w"> </span><span class="k">from</span><span class="w"> </span><span class="n">t</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</span><span class="p">(</span><span class="n">t</span><span class="p">.</span><span class="n">a</span><span class="p">,</span><span class="n">t</span><span class="p">.</span><span class="n">b</span><span class="p">)</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">c0</span><span class="p">:</span><span class="w"> </span><span class="mi">1</span><span class="p">,</span><span class="w"> </span><span class="n">c1</span><span class="p">:</span><span class="w"> </span><span class="mi">2</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">c0</span><span class="p">:</span><span class="w"> </span><span class="mi">3</span><span class="p">,</span><span class="w"> </span><span class="n">c1</span><span class="p">:</span><span class="w"> </span><span class="mi">4</span><span class="err">}</span><span class="w"> </span><span class="o">|</span>
-<span class="o">+</span><span class="c1">-----------------+</span>
+<span class="n">select</span> <span class="n">struct</span><span class="p">(</span><span class="n">a</span><span class="p">,</span> <span class="n">b</span><span class="p">)</span> <span class="kn">from</span> <span class="nn">t</span><span class="p">;</span>
+<span class="o">+-----------------+</span>
+<span class="o">|</span> <span class="n">struct</span><span class="p">(</span><span class="n">t</span><span class="o">.</span><span class="n">a</span><span class="p">,</span><span class="n">t</span><span class="o">.</span><span class="n">b</span><span class="p">)</span> <span class="o">|</span>
+<span class="o">+-----------------+</span>
+<span class="o">|</span> <span class="p">{</span><span class="n">c0</span><span class="p">:</span> <span class="mi">1</span><span class="p">,</span> <span class="n">c1</span><span class="p">:</span> <span class="mi">2</span><span class="p">}</span> <span class="o">|</span>
+<span class="o">|</span> <span class="p">{</span><span class="n">c0</span><span class="p">:</span> <span class="mi">3</span><span class="p">,</span> <span class="n">c1</span><span class="p">:</span> <span class="mi">4</span><span class="p">}</span> <span class="o">|</span>
+<span class="o">+-----------------+</span>
</pre></div>
</div>
<section id="id190">
diff --git a/user-guide/sql/select.html b/user-guide/sql/select.html
index 797de8d232..0bced35edb 100644
--- a/user-guide/sql/select.html
+++ b/user-guide/sql/select.html
@@ -555,7 +555,7 @@ By default <code class="docutils literal notranslate"><span class="pre">ALL</spa
<section id="inner-join">
<h3>INNER JOIN<a class="headerlink" href="#inner-join" title="Link to this heading">¶</a></h3>
<p>The keywords <code class="docutils literal notranslate"><span class="pre">JOIN</span></code> or <code class="docutils literal notranslate"><span class="pre">INNER</span> <span class="pre">JOIN</span></code> define a join that only shows rows where there is a match in both tables.</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</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">x</span><span class="w"> </span><span class="k">inner</span><span class="w"> </span><span class="k">join</span><span class="w"> </span><span class="n">x</span><span class="w"> </span><span class [...]
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></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">x</span><span class="w"> </span><span class="k">inner</span><span class="w"> </span><span class="k">join</span><span class="w"> </span><span class="n">x</span><span class="w"> </span><span class="n">y</span><span class="w"> </span><span class=" [...]
<span class="o">+</span><span class="c1">----------+----------+----------+----------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">column_1</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">column_2</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">column_1</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">column_2</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------+----------+----------+----------+</span>
@@ -568,7 +568,7 @@ By default <code class="docutils literal notranslate"><span class="pre">ALL</spa
<h3>LEFT OUTER JOIN<a class="headerlink" href="#left-outer-join" title="Link to this heading">¶</a></h3>
<p>The keywords <code class="docutils literal notranslate"><span class="pre">LEFT</span> <span class="pre">JOIN</span></code> or <code class="docutils literal notranslate"><span class="pre">LEFT</span> <span class="pre">OUTER</span> <span class="pre">JOIN</span></code> define a join that includes all rows from the left table even if there
is not a match in the right table. When there is no match, null values are produced for the right side of the join.</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</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">x</span><span class="w"> </span><span class="k">left</span><span class="w"> </span><span class="k">join</span><span class="w"> </span><span class="n">x</span><span class="w"> </span><span class= [...]
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></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">x</span><span class="w"> </span><span class="k">left</span><span class="w"> </span><span class="k">join</span><span class="w"> </span><span class="n">x</span><span class="w"> </span><span class="n">y</span><span class="w"> </span><span class="k [...]
<span class="o">+</span><span class="c1">----------+----------+----------+----------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">column_1</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">column_2</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">column_1</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">column_2</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------+----------+----------+----------+</span>
@@ -581,7 +581,7 @@ is not a match in the right table. When there is no match, null values are produ
<h3>RIGHT OUTER JOIN<a class="headerlink" href="#right-outer-join" title="Link to this heading">¶</a></h3>
<p>The keywords <code class="docutils literal notranslate"><span class="pre">RIGHT</span> <span class="pre">JOIN</span></code> or <code class="docutils literal notranslate"><span class="pre">RIGHT</span> <span class="pre">OUTER</span> <span class="pre">JOIN</span></code> define a join that includes all rows from the right table even if there
is not a match in the left table. When there is no match, null values are produced for the left side of the join.</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</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">x</span><span class="w"> </span><span class="k">right</span><span class="w"> </span><span class="k">join</span><span class="w"> </span><span class="n">x</span><span class="w"> </span><span class [...]
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></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">x</span><span class="w"> </span><span class="k">right</span><span class="w"> </span><span class="k">join</span><span class="w"> </span><span class="n">x</span><span class="w"> </span><span class="n">y</span><span class="w"> </span><span class=" [...]
<span class="o">+</span><span class="c1">----------+----------+----------+----------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">column_1</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">column_2</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">column_1</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">column_2</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------+----------+----------+----------+</span>
@@ -595,7 +595,7 @@ is not a match in the left table. When there is no match, null values are produc
<p>The keywords <code class="docutils literal notranslate"><span class="pre">FULL</span> <span class="pre">JOIN</span></code> or <code class="docutils literal notranslate"><span class="pre">FULL</span> <span class="pre">OUTER</span> <span class="pre">JOIN</span></code> define a join that is effectively a union of a <code class="docutils literal notranslate"><span class="pre">LEFT</span> <span class="pre">OUTER</span> <span class="pre">JOIN</span></code> and
<code class="docutils literal notranslate"><span class="pre">RIGHT</span> <span class="pre">OUTER</span> <span class="pre">JOIN</span></code>. It will show all rows from the left and right side of the join and will produce null values on
either side of the join where there is not a match.</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</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">x</span><span class="w"> </span><span class="k">full</span><span class="w"> </span><span class="k">outer</span><span class="w"> </span><span class="k">join</span><span class="w"> </span><span cl [...]
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></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">x</span><span class="w"> </span><span class="k">full</span><span class="w"> </span><span class="k">outer</span><span class="w"> </span><span class="k">join</span><span class="w"> </span><span class="n">x</span><span class="w"> </span><span clas [...]
<span class="o">+</span><span class="c1">----------+----------+----------+----------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">column_1</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">column_2</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">column_1</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">column_2</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------+----------+----------+----------+</span>
@@ -609,7 +609,7 @@ either side of the join where there is not a match.</p>
<h3>NATURAL JOIN<a class="headerlink" href="#natural-join" title="Link to this heading">¶</a></h3>
<p>A natural join defines an inner join based on common column names found between the input tables. When no common
column names are found, it behaves like a cross join.</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</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">x</span><span class="w"> </span><span class="k">natural</span><span class="w"> </span><span class="k">join</span><span class="w"> </span><span class="n">x</span><span class="w"> </span><span cla [...]
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></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">x</span><span class="w"> </span><span class="k">natural</span><span class="w"> </span><span class="k">join</span><span class="w"> </span><span class="n">x</span><span class="w"> </span><span class="n">y</span><span class="p">;</span>
<span class="o">+</span><span class="c1">----------+----------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">column_1</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">column_2</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------+----------+</span>
@@ -622,7 +622,7 @@ column names are found, it behaves like a cross join.</p>
<h3>CROSS JOIN<a class="headerlink" href="#cross-join" title="Link to this heading">¶</a></h3>
<p>A cross join produces a cartesian product that matches every row in the left side of the join with every row in the
right side of the join.</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</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">x</span><span class="w"> </span><span class="k">cross</span><span class="w"> </span><span class="k">join</span><span class="w"> </span><span class="n">x</span><span class="w"> </span><span class [...]
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></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">x</span><span class="w"> </span><span class="k">cross</span><span class="w"> </span><span class="k">join</span><span class="w"> </span><span class="n">x</span><span class="w"> </span><span class="n">y</span><span class="p">;</span>
<span class="o">+</span><span class="c1">----------+----------+----------+----------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">column_1</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">column_2</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">column_1</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">column_2</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------+----------+----------+----------+</span>
diff --git a/user-guide/sql/subqueries.html b/user-guide/sql/subqueries.html
index ada62b7a1a..0d413b206f 100644
--- a/user-guide/sql/subqueries.html
+++ b/user-guide/sql/subqueries.html
@@ -427,7 +427,7 @@
<h1>Subqueries<a class="headerlink" href="#subqueries" title="Link to this heading">¶</a></h1>
<p>DataFusion supports <code class="docutils literal notranslate"><span class="pre">EXISTS</span></code>, <code class="docutils literal notranslate"><span class="pre">NOT</span> <span class="pre">EXISTS</span></code>, <code class="docutils literal notranslate"><span class="pre">IN</span></code>, <code class="docutils literal notranslate"><span class="pre">NOT</span> <span class="pre">IN</span></code> and Scalar Subqueries.</p>
<p>The examples below are based on the following table.</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</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">x</span><span class="p">;</span>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></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">x</span><span class="p">;</span>
<span class="o">+</span><span class="c1">----------+----------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">column_1</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">column_2</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------+----------+</span>
@@ -439,7 +439,7 @@
<h2>EXISTS<a class="headerlink" href="#exists" title="Link to this heading">¶</a></h2>
<p>The <code class="docutils literal notranslate"><span class="pre">EXISTS</span></code> syntax can be used to find all rows in a relation where a correlated subquery produces one or more matches
for that row. Only correlated subqueries are supported.</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</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">x</span><span class="w"> </span><span class="n">y</span><span class="w"> </span><span class="k">where</span><span class="w"> </span><span class="k">exists</span><span class="w"> </span><span cla [...]
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></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">x</span><span class="w"> </span><span class="n">y</span><span class="w"> </span><span class="k">where</span><span class="w"> </span><span class="k">exists</span><span class="w"> </span><span class="p">(</span><span class="k">select</span><span [...]
<span class="o">+</span><span class="c1">----------+----------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">column_1</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">column_2</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------+----------+</span>
@@ -453,7 +453,7 @@ for that row. Only correlated subqueries are supported.</p>
<h2>NOT EXISTS<a class="headerlink" href="#not-exists" title="Link to this heading">¶</a></h2>
<p>The <code class="docutils literal notranslate"><span class="pre">NOT</span> <span class="pre">EXISTS</span></code> syntax can be used to find all rows in a relation where a correlated subquery produces zero matches
for that row. Only correlated subqueries are supported.</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</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">x</span><span class="w"> </span><span class="n">y</span><span class="w"> </span><span class="k">where</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class= [...]
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></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">x</span><span class="w"> </span><span class="n">y</span><span class="w"> </span><span class="k">where</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class="k">exists</span><span class="w"> </span><span cla [...]
<span class="mi">0</span><span class="w"> </span><span class="k">rows</span><span class="w"> </span><span class="k">in</span><span class="w"> </span><span class="k">set</span><span class="p">.</span>
</pre></div>
</div>
@@ -462,7 +462,7 @@ for that row. Only correlated subqueries are supported.</p>
<h2>IN<a class="headerlink" href="#in" title="Link to this heading">¶</a></h2>
<p>The <code class="docutils literal notranslate"><span class="pre">IN</span></code> syntax can be used to find all rows in a relation where a given expression’s value can be found in the
results of a correlated subquery.</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</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">x</span><span class="w"> </span><span class="k">where</span><span class="w"> </span><span class="n">column_1</span><span class="w"> </span><span class="k">in</span><span class="w"> </span><span [...]
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></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">x</span><span class="w"> </span><span class="k">where</span><span class="w"> </span><span class="n">column_1</span><span class="w"> </span><span class="k">in</span><span class="w"> </span><span class="p">(</span><span class="k">select</span><sp [...]
<span class="o">+</span><span class="c1">----------+----------+</span>
<span class="o">|</span><span class="w"> </span><span class="n">column_1</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">column_2</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------+----------+</span>
@@ -476,7 +476,7 @@ results of a correlated subquery.</p>
<h2>NOT IN<a class="headerlink" href="#not-in" title="Link to this heading">¶</a></h2>
<p>The <code class="docutils literal notranslate"><span class="pre">NOT</span> <span class="pre">IN</span></code> syntax can be used to find all rows in a relation where a given expression’s value can not be found in the
results of a correlated subquery.</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</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">x</span><span class="w"> </span><span class="k">where</span><span class="w"> </span><span class="n">column_1</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span [...]
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></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">x</span><span class="w"> </span><span class="k">where</span><span class="w"> </span><span class="n">column_1</span><span class="w"> </span><span class="k">not</span><span class="w"> </span><span class="k">in</span><span class="w"> </span><span [...]
<span class="mi">0</span><span class="w"> </span><span class="k">rows</span><span class="w"> </span><span class="k">in</span><span class="w"> </span><span class="k">set</span><span class="p">.</span>
</pre></div>
</div>
@@ -485,7 +485,7 @@ results of a correlated subquery.</p>
<h2>Scalar Subquery<a class="headerlink" href="#scalar-subquery" title="Link to this heading">¶</a></h2>
<p>A scalar subquery can be used to produce a single value that can be used in many different contexts in a query. Here
is an example of a filter using a scalar subquery. Only correlated subqueries are supported.</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="err">❯</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">x</span><span class="w"> </span><span class="n">y</span><span class="w"> </span><span class="k">where</span><span class="w"> </span><span class="n">column_1</span><span class="w"> </span><span c [...]
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></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">x</span><span class="w"> </span><span class="n">y</span><span class="w"> </span><span class="k">where</span><span class="w"> </span><span class="n">column_1</span><span class="w"> </span><span class="o"><</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">column_1</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">column_2</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">----------+----------+</span>
diff --git a/user-guide/sql/window_functions.html b/user-guide/sql/window_functions.html
index 889e5af0e9..23b7a2d9a6 100644
--- a/user-guide/sql/window_functions.html
+++ b/user-guide/sql/window_functions.html
@@ -639,17 +639,17 @@
<section id="syntax">
<h2>Syntax<a class="headerlink" href="#syntax" title="Link to this heading">¶</a></h2>
<p>The syntax for the OVER-clause is</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">function</span><span class="p">([</span><span class="n">expr</span><span class="p">])</span>
-<span class="w"> </span><span class="n">OVER</span><span class="p">(</span>
-<span class="w"> </span><span class="p">[</span><span class="n">PARTITION</span><span class="w"> </span><span class="k">BY</span><span class="w"> </span><span class="n">expr</span><span class="p">[,</span><span class="w"> </span><span class="err">…</span><span class="p">]]</span>
-<span class="w"> </span><span class="p">[</span><span class="k">ORDER</span><span class="w"> </span><span class="k">BY</span><span class="w"> </span><span class="n">expr</span><span class="w"> </span><span class="p">[</span><span class="w"> </span><span class="k">ASC</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="k">DESC</span><span class="w"> </span><span class="p">][,</span><span class="w"> </span><span class="err">…</span><span class="p"> [...]
-<span class="w"> </span><span class="p">[</span><span class="w"> </span><span class="n">frame_clause</span><span class="w"> </span><span class="p">]</span>
-<span class="w"> </span><span class="p">)</span>
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span>function([expr])
+ OVER(
+ [PARTITION BY expr[, …]]
+ [ORDER BY expr [ ASC | DESC ][, …]]
+ [ frame_clause ]
+ )
</pre></div>
</div>
<p>where <strong>frame_clause</strong> is one of:</p>
-<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="w"> </span><span class="err">{</span><span class="w"> </span><span class="n">RANGE</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="k">ROWS</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">GROUPS</span><span class="w"> </span><span class="err">}</span><span class="w"> </span><span class="n">frame_start</span>
-<span class="w"> </span><span class="err">{</span><span class="w"> </span><span class="n">RANGE</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="k">ROWS</span><span class="w"> </span><span class="o">|</span><span class="w"> </span><span class="n">GROUPS</span><span class="w"> </span><span class="err">}</span><span class="w"> </span><span class="k">BETWEEN</span><span class="w"> </span><span class="n">frame_start</span><span class="w"> </span><sp [...]
+<div class="highlight-default notranslate"><div class="highlight"><pre><span></span> <span class="p">{</span> <span class="n">RANGE</span> <span class="o">|</span> <span class="n">ROWS</span> <span class="o">|</span> <span class="n">GROUPS</span> <span class="p">}</span> <span class="n">frame_start</span>
+ <span class="p">{</span> <span class="n">RANGE</span> <span class="o">|</span> <span class="n">ROWS</span> <span class="o">|</span> <span class="n">GROUPS</span> <span class="p">}</span> <span class="n">BETWEEN</span> <span class="n">frame_start</span> <span class="n">AND</span> <span class="n">frame_end</span>
</pre></div>
</div>
<p>and <strong>frame_start</strong> and <strong>frame_end</strong> can be one of</p>
diff --git a/user-guide/sql/write_options.html b/user-guide/sql/write_options.html
index 55554a915e..e99ac04599 100644
--- a/user-guide/sql/write_options.html
+++ b/user-guide/sql/write_options.html
@@ -441,7 +441,7 @@
<li><p><code class="docutils literal notranslate"><span class="pre">CREATE</span> <span class="pre">EXTERNAL</span> <span class="pre">TABLE</span></code> options</p></li>
<li><p><code class="docutils literal notranslate"><span class="pre">COPY</span></code> option tuples</p></li>
</ul>
-<p>For a list of supported session level config defaults see <a class="reference internal" href="#configs"><span class="xref myst">Configuration Settings</span></a>. These defaults apply to all write operations but have the lowest level of precedence.</p>
+<p>For a list of supported session level config defaults see <a class="reference internal" href="../configs.html"><span class="doc std std-doc">Configuration Settings</span></a>. These defaults apply to all write operations but have the lowest level of precedence.</p>
<p>If inserting to an external table, table specific write options can be specified when the table is created using the <code class="docutils literal notranslate"><span class="pre">OPTIONS</span></code> clause:</p>
<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">CREATE</span><span class="w"> </span><span class="k">EXTERNAL</span><span class="w"> </span><span class="k">TABLE</span>
<span class="n">my_table</span><span class="p">(</span><span class="n">a</span><span class="w"> </span><span class="nb">bigint</span><span class="p">,</span><span class="w"> </span><span class="n">b</span><span class="w"> </span><span class="nb">bigint</span><span class="p">)</span>