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 3d3245ea8b Publish built docs triggered by
feb9100432d453f19d40428265d2aa9a9f942d5d
3d3245ea8b is described below
commit 3d3245ea8b63d5ed7769b9531657ff0ece4e919f
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Thu Apr 11 18:55:57 2024 +0000
Publish built docs triggered by feb9100432d453f19d40428265d2aa9a9f942d5d
---
_sources/library-user-guide/adding-udfs.md.txt | 2 +-
_sources/user-guide/cli.md.txt | 20 +-
_sources/user-guide/example-usage.md.txt | 2 +-
_sources/user-guide/sql/scalar_functions.md.txt | 102 ++--
library-user-guide/adding-udfs.html | 2 +-
user-guide/cli.html | 20 +-
user-guide/example-usage.html | 2 +-
user-guide/sql/scalar_functions.html | 614 ++++++++++++------------
8 files changed, 382 insertions(+), 382 deletions(-)
diff --git a/_sources/library-user-guide/adding-udfs.md.txt
b/_sources/library-user-guide/adding-udfs.md.txt
index ad21072410..653c1f9d37 100644
--- a/_sources/library-user-guide/adding-udfs.md.txt
+++ b/_sources/library-user-guide/adding-udfs.md.txt
@@ -536,7 +536,7 @@ Because we're returning a `TableProvider`, in this example
we'll use the `MemTab
While this is a simple example for illustrative purposes, UDTFs have a lot of
potential use cases. And can be particularly useful for reading data from
external sources and interactive analysis. For example, see the [example][4]
for a working example that reads from a CSV file. As another example, you could
use the built-in UDTF `parquet_metadata` in the CLI to read the metadata from a
Parquet file.
```console
-❯ select filename, row_group_id, row_group_num_rows, row_group_bytes,
stats_min, stats_max from parquet_metadata('./benchmarks/data/hits.parquet')
where column_id = 17 limit 10;
+> select filename, row_group_id, row_group_num_rows, row_group_bytes,
stats_min, stats_max from parquet_metadata('./benchmarks/data/hits.parquet')
where column_id = 17 limit 10;
+--------------------------------+--------------+--------------------+-----------------+-----------+-----------+
| filename | row_group_id | row_group_num_rows |
row_group_bytes | stats_min | stats_max |
+--------------------------------+--------------+--------------------+-----------------+-----------+-----------+
diff --git a/_sources/user-guide/cli.md.txt b/_sources/user-guide/cli.md.txt
index da4c987054..9c3fc8bd60 100644
--- a/_sources/user-guide/cli.md.txt
+++ b/_sources/user-guide/cli.md.txt
@@ -165,7 +165,7 @@ Query that single file (the CLI also supports parquet,
compressed csv, avro, jso
```shell
$ datafusion-cli
DataFusion CLI v17.0.0
-❯ select * from 'data.csv';
+> select * from 'data.csv';
+---+---+
| a | b |
+---+---+
@@ -184,7 +184,7 @@ data.csv data2.csv
```shell
$ datafusion-cli
DataFusion CLI v16.0.0
-❯ select * from 'data_dir';
+> select * from 'data_dir';
+---+---+
| a | b |
+---+---+
@@ -335,9 +335,9 @@ $ export AWS_ACCESS_KEY_ID=******
$ datafusion-cli
DataFusion CLI v21.0.0
-❯ create external table test stored as parquet location
's3://bucket/path/file.parquet';
+> create external table test stored as parquet location
's3://bucket/path/file.parquet';
0 rows in set. Query took 0.374 seconds.
-❯ select * from test;
+> select * from test;
+----------+----------+
| column_1 | column_2 |
+----------+----------+
@@ -429,9 +429,9 @@ $ export GOOGLE_SERVICE_ACCOUNT=/tmp/gcs.json
$ datafusion-cli
DataFusion CLI v21.0.0
-❯ create external table test stored as parquet location
'gs://bucket/path/file.parquet';
+> create external table test stored as parquet location
'gs://bucket/path/file.parquet';
0 rows in set. Query took 0.374 seconds.
-❯ select * from test;
+> select * from test;
+----------+----------+
| column_1 | column_2 |
+----------+----------+
@@ -619,7 +619,7 @@ appropriately:
```shell
$ DATAFUSION_EXECUTION_BATCH_SIZE=1024 datafusion-cli
DataFusion CLI v12.0.0
-❯ show all;
+> show all;
+-------------------------------------------------+---------+
| name | value |
+-------------------------------------------------+---------+
@@ -639,7 +639,7 @@ You can change the configuration options using `SET`
statement as well
```shell
$ datafusion-cli
DataFusion CLI v13.0.0
-❯ show datafusion.execution.batch_size;
+> show datafusion.execution.batch_size;
+---------------------------------+---------+
| name | value |
+---------------------------------+---------+
@@ -647,10 +647,10 @@ DataFusion CLI v13.0.0
+---------------------------------+---------+
1 row in set. Query took 0.011 seconds.
-❯ set datafusion.execution.batch_size to 1024;
+> set datafusion.execution.batch_size to 1024;
0 rows in set. Query took 0.000 seconds.
-❯ show datafusion.execution.batch_size;
+> 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 31b599ac33..6e4bf68fa0 100644
--- a/_sources/user-guide/example-usage.md.txt
+++ b/_sources/user-guide/example-usage.md.txt
@@ -261,7 +261,7 @@ Set environment
[variables](https://doc.rust-lang.org/std/backtrace/index.html#e
```bash
RUST_BACKTRACE=1 ./target/debug/datafusion-cli
DataFusion CLI v31.0.0
-❯ select row_numer() over (partition by a order by a) from (select 1 a);
+> select row_numer() over (partition by a order by a) from (select 1 a);
Error during planning: Invalid function 'row_numer'.
Did you mean 'ROW_NUMBER'?
diff --git a/_sources/user-guide/sql/scalar_functions.md.txt
b/_sources/user-guide/sql/scalar_functions.md.txt
index 62b81ea7ea..217bd5f05a 100644
--- a/_sources/user-guide/sql/scalar_functions.md.txt
+++ b/_sources/user-guide/sql/scalar_functions.md.txt
@@ -1650,13 +1650,13 @@ make_date(year, month, day)
#### Example
```
-❯ select make_date(2023, 1, 31);
+> select make_date(2023, 1, 31);
+-------------------------------------------+
| make_date(Int64(2023),Int64(1),Int64(31)) |
+-------------------------------------------+
| 2023-01-31 |
+-------------------------------------------+
-❯ select make_date('2023', '01', '31');
+> select make_date('2023', '01', '31');
+-----------------------------------------------+
| make_date(Utf8("2023"),Utf8("01"),Utf8("31")) |
+-----------------------------------------------+
@@ -1686,7 +1686,7 @@ to_char(expression, format)
#### Example
```
-❯ ❯ select to_char('2023-03-01'::date, '%d-%m-%Y');
+> > select to_char('2023-03-01'::date, '%d-%m-%Y');
+----------------------------------------------+
| to_char(Utf8("2023-03-01"),Utf8("%d-%m-%Y")) |
+----------------------------------------------+
@@ -1731,13 +1731,13 @@ to_timestamp(expression[, ..., format_n])
#### Example
```
-❯ select to_timestamp('2023-01-31T09:26:56.123456789-05:00');
+> select to_timestamp('2023-01-31T09:26:56.123456789-05:00');
+-----------------------------------------------------------+
| to_timestamp(Utf8("2023-01-31T09:26:56.123456789-05:00")) |
+-----------------------------------------------------------+
| 2023-01-31T14:26:56.123456789 |
+-----------------------------------------------------------+
-❯ select to_timestamp('03:59:00.123456789 05-17-2023', '%c', '%+',
'%H:%M:%S%.f %m-%d-%Y');
+> select to_timestamp('03:59:00.123456789 05-17-2023', '%c', '%+',
'%H:%M:%S%.f %m-%d-%Y');
+--------------------------------------------------------------------------------------------------------+
| to_timestamp(Utf8("03:59:00.123456789
05-17-2023"),Utf8("%c"),Utf8("%+"),Utf8("%H:%M:%S%.f %m-%d-%Y")) |
+--------------------------------------------------------------------------------------------------------+
@@ -1770,13 +1770,13 @@ to_timestamp_millis(expression[, ..., format_n])
#### Example
```
-❯ select to_timestamp_millis('2023-01-31T09:26:56.123456789-05:00');
+> select to_timestamp_millis('2023-01-31T09:26:56.123456789-05:00');
+------------------------------------------------------------------+
| to_timestamp_millis(Utf8("2023-01-31T09:26:56.123456789-05:00")) |
+------------------------------------------------------------------+
| 2023-01-31T14:26:56.123 |
+------------------------------------------------------------------+
-❯ select to_timestamp_millis('03:59:00.123456789 05-17-2023', '%c', '%+',
'%H:%M:%S%.f %m-%d-%Y');
+> select to_timestamp_millis('03:59:00.123456789 05-17-2023', '%c', '%+',
'%H:%M:%S%.f %m-%d-%Y');
+---------------------------------------------------------------------------------------------------------------+
| to_timestamp_millis(Utf8("03:59:00.123456789
05-17-2023"),Utf8("%c"),Utf8("%+"),Utf8("%H:%M:%S%.f %m-%d-%Y")) |
+---------------------------------------------------------------------------------------------------------------+
@@ -1809,13 +1809,13 @@ to_timestamp_micros(expression[, ..., format_n])
#### Example
```
-❯ select to_timestamp_micros('2023-01-31T09:26:56.123456789-05:00');
+> select to_timestamp_micros('2023-01-31T09:26:56.123456789-05:00');
+------------------------------------------------------------------+
| to_timestamp_micros(Utf8("2023-01-31T09:26:56.123456789-05:00")) |
+------------------------------------------------------------------+
| 2023-01-31T14:26:56.123456 |
+------------------------------------------------------------------+
-❯ select to_timestamp_micros('03:59:00.123456789 05-17-2023', '%c', '%+',
'%H:%M:%S%.f %m-%d-%Y');
+> select to_timestamp_micros('03:59:00.123456789 05-17-2023', '%c', '%+',
'%H:%M:%S%.f %m-%d-%Y');
+---------------------------------------------------------------------------------------------------------------+
| to_timestamp_micros(Utf8("03:59:00.123456789
05-17-2023"),Utf8("%c"),Utf8("%+"),Utf8("%H:%M:%S%.f %m-%d-%Y")) |
+---------------------------------------------------------------------------------------------------------------+
@@ -1848,13 +1848,13 @@ to_timestamp_nanos(expression[, ..., format_n])
#### Example
```
-❯ select to_timestamp_nanos('2023-01-31T09:26:56.123456789-05:00');
+> select to_timestamp_nanos('2023-01-31T09:26:56.123456789-05:00');
+-----------------------------------------------------------------+
| to_timestamp_nanos(Utf8("2023-01-31T09:26:56.123456789-05:00")) |
+-----------------------------------------------------------------+
| 2023-01-31T14:26:56.123456789 |
+-----------------------------------------------------------------+
-❯ select to_timestamp_nanos('03:59:00.123456789 05-17-2023', '%c', '%+',
'%H:%M:%S%.f %m-%d-%Y');
+> select to_timestamp_nanos('03:59:00.123456789 05-17-2023', '%c', '%+',
'%H:%M:%S%.f %m-%d-%Y');
+--------------------------------------------------------------------------------------------------------------+
| to_timestamp_nanos(Utf8("03:59:00.123456789
05-17-2023"),Utf8("%c"),Utf8("%+"),Utf8("%H:%M:%S%.f %m-%d-%Y")) |
+--------------------------------------------------------------------------------------------------------------+
@@ -1887,13 +1887,13 @@ to_timestamp_seconds(expression[, ..., format_n])
#### Example
```
-❯ select to_timestamp_seconds('2023-01-31T09:26:56.123456789-05:00');
+> select to_timestamp_seconds('2023-01-31T09:26:56.123456789-05:00');
+-------------------------------------------------------------------+
| to_timestamp_seconds(Utf8("2023-01-31T09:26:56.123456789-05:00")) |
+-------------------------------------------------------------------+
| 2023-01-31T14:26:56 |
+-------------------------------------------------------------------+
-❯ select to_timestamp_seconds('03:59:00.123456789 05-17-2023', '%c', '%+',
'%H:%M:%S%.f %m-%d-%Y');
+> select to_timestamp_seconds('03:59:00.123456789 05-17-2023', '%c', '%+',
'%H:%M:%S%.f %m-%d-%Y');
+----------------------------------------------------------------------------------------------------------------+
| to_timestamp_seconds(Utf8("03:59:00.123456789
05-17-2023"),Utf8("%c"),Utf8("%+"),Utf8("%H:%M:%S%.f %m-%d-%Y")) |
+----------------------------------------------------------------------------------------------------------------+
@@ -2022,7 +2022,7 @@ array_append(array, element)
#### Example
```
-❯ select array_append([1, 2, 3], 4);
+> select array_append([1, 2, 3], 4);
+--------------------------------------+
| array_append(List([1,2,3]),Int64(4)) |
+--------------------------------------+
@@ -2054,7 +2054,7 @@ array_sort(array, desc, nulls_first)
#### Example
```
-❯ select array_sort([3, 1, 2]);
+> select array_sort([3, 1, 2]);
+-----------------------------+
| array_sort(List([3,1,2])) |
+-----------------------------+
@@ -2084,7 +2084,7 @@ array_resize(array, size, value)
#### Example
```
-❯ select array_resize([1, 2, 3], 5, 0);
+> select array_resize([1, 2, 3], 5, 0);
+-------------------------------------+
| array_resize(List([1,2,3],5,0)) |
+-------------------------------------+
@@ -2117,7 +2117,7 @@ array_concat(array[, ..., array_n])
#### Example
```
-❯ select array_concat([1, 2], [3, 4], [5, 6]);
+> select array_concat([1, 2], [3, 4], [5, 6]);
+---------------------------------------------------+
| array_concat(List([1,2]),List([3,4]),List([5,6])) |
+---------------------------------------------------+
@@ -2208,7 +2208,7 @@ array_dims(array)
#### Example
```
-❯ select array_dims([[1, 2, 3], [4, 5, 6]]);
+> select array_dims([[1, 2, 3], [4, 5, 6]]);
+---------------------------------+
| array_dims(List([1,2,3,4,5,6])) |
+---------------------------------+
@@ -2236,7 +2236,7 @@ array_distinct(array)
#### Example
```
-❯ select array_distinct([1, 3, 2, 3, 1, 2, 4]);
+> select array_distinct([1, 3, 2, 3, 1, 2, 4]);
+---------------------------------+
| array_distinct(List([1,2,3,4])) |
+---------------------------------+
@@ -2265,7 +2265,7 @@ array_element(array, index)
#### Example
```
-❯ select array_element([1, 2, 3, 4], 3);
+> select array_element([1, 2, 3, 4], 3);
+-----------------------------------------+
| array_element(List([1,2,3,4]),Int64(3)) |
+-----------------------------------------+
@@ -2339,13 +2339,13 @@ array_intersect(array1, array2)
#### Example
```
-❯ select array_intersect([1, 2, 3, 4], [5, 6, 3, 4]);
+> select array_intersect([1, 2, 3, 4], [5, 6, 3, 4]);
+----------------------------------------------------+
| array_intersect([1, 2, 3, 4], [5, 6, 3, 4]); |
+----------------------------------------------------+
| [3, 4] |
+----------------------------------------------------+
-❯ select array_intersect([1, 2, 3, 4], [5, 6, 7, 8]);
+> select array_intersect([1, 2, 3, 4], [5, 6, 7, 8]);
+----------------------------------------------------+
| array_intersect([1, 2, 3, 4], [5, 6, 7, 8]); |
+----------------------------------------------------+
@@ -2380,7 +2380,7 @@ array_length(array, dimension)
#### Example
```
-❯ select array_length([1, 2, 3, 4, 5]);
+> select array_length([1, 2, 3, 4, 5]);
+---------------------------------+
| array_length(List([1,2,3,4,5])) |
+---------------------------------+
@@ -2408,7 +2408,7 @@ array_ndims(array, element)
#### Example
```
-❯ select array_ndims([[1, 2, 3], [4, 5, 6]]);
+> select array_ndims([[1, 2, 3], [4, 5, 6]]);
+----------------------------------+
| array_ndims(List([1,2,3,4,5,6])) |
+----------------------------------+
@@ -2437,7 +2437,7 @@ array_prepend(element, array)
#### Example
```
-❯ select array_prepend(1, [2, 3, 4]);
+> select array_prepend(1, [2, 3, 4]);
+---------------------------------------+
| array_prepend(Int64(1),List([2,3,4])) |
+---------------------------------------+
@@ -2467,7 +2467,7 @@ array_pop_front(array)
#### Example
```
-❯ select array_pop_front([1, 2, 3]);
+> select array_pop_front([1, 2, 3]);
+-------------------------------+
| array_pop_front(List([1,2,3])) |
+-------------------------------+
@@ -2495,7 +2495,7 @@ array_pop_back(array)
#### Example
```
-❯ select array_pop_back([1, 2, 3]);
+> select array_pop_back([1, 2, 3]);
+-------------------------------+
| array_pop_back(List([1,2,3])) |
+-------------------------------+
@@ -2526,7 +2526,7 @@ array_position(array, element, index)
#### Example
```
-❯ select array_position([1, 2, 2, 3, 1, 4], 2);
+> select array_position([1, 2, 2, 3, 1, 4], 2);
+----------------------------------------------+
| array_position(List([1,2,2,3,1,4]),Int64(2)) |
+----------------------------------------------+
@@ -2557,7 +2557,7 @@ array_positions(array, element)
#### Example
```
-❯ select array_positions([1, 2, 2, 3, 1, 4], 2);
+> select array_positions([1, 2, 2, 3, 1, 4], 2);
+-----------------------------------------------+
| array_positions(List([1,2,2,3,1,4]),Int64(2)) |
+-----------------------------------------------+
@@ -2594,7 +2594,7 @@ array_repeat(element, count)
#### Example
```
-❯ select array_repeat(1, 3);
+> select array_repeat(1, 3);
+---------------------------------+
| array_repeat(Int64(1),Int64(3)) |
+---------------------------------+
@@ -2603,7 +2603,7 @@ array_repeat(element, count)
```
```
-❯ select array_repeat([1, 2], 2);
+> select array_repeat([1, 2], 2);
+------------------------------------+
| array_repeat(List([1,2]),Int64(2)) |
+------------------------------------+
@@ -2632,7 +2632,7 @@ array_remove(array, element)
#### Example
```
-❯ select array_remove([1, 2, 2, 3, 2, 1, 4], 2);
+> select array_remove([1, 2, 2, 3, 2, 1, 4], 2);
+----------------------------------------------+
| array_remove(List([1,2,2,3,2,1,4]),Int64(2)) |
+----------------------------------------------+
@@ -2662,7 +2662,7 @@ array_remove_n(array, element, max)
#### Example
```
-❯ select array_remove_n([1, 2, 2, 3, 2, 1, 4], 2, 2);
+> select array_remove_n([1, 2, 2, 3, 2, 1, 4], 2, 2);
+---------------------------------------------------------+
| array_remove_n(List([1,2,2,3,2,1,4]),Int64(2),Int64(2)) |
+---------------------------------------------------------+
@@ -2691,7 +2691,7 @@ array_remove_all(array, element)
#### Example
```
-❯ select array_remove_all([1, 2, 2, 3, 2, 1, 4], 2);
+> select array_remove_all([1, 2, 2, 3, 2, 1, 4], 2);
+--------------------------------------------------+
| array_remove_all(List([1,2,2,3,2,1,4]),Int64(2)) |
+--------------------------------------------------+
@@ -2721,7 +2721,7 @@ array_replace(array, from, to)
#### Example
```
-❯ select array_replace([1, 2, 2, 3, 2, 1, 4], 2, 5);
+> select array_replace([1, 2, 2, 3, 2, 1, 4], 2, 5);
+--------------------------------------------------------+
| array_replace(List([1,2,2,3,2,1,4]),Int64(2),Int64(5)) |
+--------------------------------------------------------+
@@ -2752,7 +2752,7 @@ array_replace_n(array, from, to, max)
#### Example
```
-❯ select array_replace_n([1, 2, 2, 3, 2, 1, 4], 2, 5, 2);
+> select array_replace_n([1, 2, 2, 3, 2, 1, 4], 2, 5, 2);
+-------------------------------------------------------------------+
| array_replace_n(List([1,2,2,3,2,1,4]),Int64(2),Int64(5),Int64(2)) |
+-------------------------------------------------------------------+
@@ -2782,7 +2782,7 @@ array_replace_all(array, from, to)
#### Example
```
-❯ select array_replace_all([1, 2, 2, 3, 2, 1, 4], 2, 5);
+> select array_replace_all([1, 2, 2, 3, 2, 1, 4], 2, 5);
+------------------------------------------------------------+
| array_replace_all(List([1,2,2,3,2,1,4]),Int64(2),Int64(5)) |
+------------------------------------------------------------+
@@ -2810,7 +2810,7 @@ array_reverse(array)
#### Example
```
-❯ select array_reverse([1, 2, 3, 4]);
+> select array_reverse([1, 2, 3, 4]);
+------------------------------------------------------------+
| array_reverse(List([1, 2, 3, 4])) |
+------------------------------------------------------------+
@@ -2843,7 +2843,7 @@ array_slice(array, begin, end)
#### Example
```
-❯ select array_slice([1, 2, 3, 4, 5, 6, 7, 8], 3, 6);
+> select array_slice([1, 2, 3, 4, 5, 6, 7, 8], 3, 6);
+--------------------------------------------------------+
| array_slice(List([1,2,3,4,5,6,7,8]),Int64(3),Int64(6)) |
+--------------------------------------------------------+
@@ -2872,7 +2872,7 @@ array_to_string(array, delimiter)
#### Example
```
-❯ select array_to_string([[1, 2, 3, 4], [5, 6, 7, 8]], ',');
+> select array_to_string([[1, 2, 3, 4], [5, 6, 7, 8]], ',');
+----------------------------------------------------+
| array_to_string(List([1,2,3,4,5,6,7,8]),Utf8(",")) |
+----------------------------------------------------+
@@ -2904,13 +2904,13 @@ array_union(array1, array2)
#### Example
```
-❯ select array_union([1, 2, 3, 4], [5, 6, 3, 4]);
+> select array_union([1, 2, 3, 4], [5, 6, 3, 4]);
+----------------------------------------------------+
| array_union([1, 2, 3, 4], [5, 6, 3, 4]); |
+----------------------------------------------------+
| [1, 2, 3, 4, 5, 6] |
+----------------------------------------------------+
-❯ select array_union([1, 2, 3, 4], [5, 6, 7, 8]);
+> select array_union([1, 2, 3, 4], [5, 6, 7, 8]);
+----------------------------------------------------+
| array_union([1, 2, 3, 4], [5, 6, 7, 8]); |
+----------------------------------------------------+
@@ -2942,13 +2942,13 @@ array_except(array1, array2)
#### Example
```
-❯ select array_except([1, 2, 3, 4], [5, 6, 3, 4]);
+> select array_except([1, 2, 3, 4], [5, 6, 3, 4]);
+----------------------------------------------------+
| array_except([1, 2, 3, 4], [5, 6, 3, 4]); |
+----------------------------------------------------+
| [1, 2] |
+----------------------------------------------------+
-❯ select array_except([1, 2, 3, 4], [3, 4, 5, 6]);
+> select array_except([1, 2, 3, 4], [3, 4, 5, 6]);
+----------------------------------------------------+
| array_except([1, 2, 3, 4], [3, 4, 5, 6]); |
+----------------------------------------------------+
@@ -2978,7 +2978,7 @@ cardinality(array)
#### Example
```
-❯ select cardinality([[1, 2, 3, 4], [5, 6, 7, 8]]);
+> select cardinality([[1, 2, 3, 4], [5, 6, 7, 8]]);
+--------------------------------------+
| cardinality(List([1,2,3,4,5,6,7,8])) |
+--------------------------------------+
@@ -3002,7 +3002,7 @@ empty(array)
#### Example
```
-❯ select empty([1]);
+> select empty([1]);
+------------------+
| empty(List([1])) |
+------------------+
@@ -3032,7 +3032,7 @@ generate_series(start, stop, step)
#### Example
```
-❯ select generate_series(1,3);
+> select generate_series(1,3);
+------------------------------------+
| generate_series(Int64(1),Int64(3)) |
+------------------------------------+
@@ -3209,7 +3209,7 @@ _Alias of [empty](#empty)._
#### Example
```
-❯ select make_array(1, 2, 3, 4, 5);
+> select make_array(1, 2, 3, 4, 5);
+----------------------------------------------------------+
| make_array(Int64(1),Int64(2),Int64(3),Int64(4),Int64(5)) |
+----------------------------------------------------------+
@@ -3337,7 +3337,7 @@ select * from t;
+---+---+
-- use default names `c0`, `c1`
-❯ select struct(a, b) from t;
+> select struct(a, b) from t;
+-----------------+
| struct(t.a,t.b) |
+-----------------+
@@ -3520,7 +3520,7 @@ arrow_cast(expression, datatype)
#### Example
```
-❯ select arrow_cast(-5, 'Int8') as a,
+> select arrow_cast(-5, 'Int8') as a,
arrow_cast('foo', 'Dictionary(Int32, Utf8)') as b,
arrow_cast('bar', 'LargeUtf8') as c,
arrow_cast('2023-01-02T12:53:02', 'Timestamp(Microsecond, Some("+08:00"))')
as d
@@ -3550,7 +3550,7 @@ arrow_typeof(expression)
#### Example
```
-❯ select arrow_typeof('foo'), arrow_typeof(1);
+> select arrow_typeof('foo'), arrow_typeof(1);
+---------------------------+------------------------+
| arrow_typeof(Utf8("foo")) | arrow_typeof(Int64(1)) |
+---------------------------+------------------------+
diff --git a/library-user-guide/adding-udfs.html
b/library-user-guide/adding-udfs.html
index 19dd672a72..294731de5f 100644
--- a/library-user-guide/adding-udfs.html
+++ b/library-user-guide/adding-udfs.html
@@ -972,7 +972,7 @@ There is a lower level API with more functionality but is
more complex, that is
<p>A User-Defined Table Function (UDTF) is a function that takes parameters
and returns a <code class="docutils literal notranslate"><span
class="pre">TableProvider</span></code>.</p>
<p>Because we’re returning a <code class="docutils literal notranslate"><span
class="pre">TableProvider</span></code>, in this example we’ll use the <code
class="docutils literal notranslate"><span class="pre">MemTable</span></code>
data source to represent a table. This is a simple struct that holds a set of
RecordBatches in memory and treats them as a table. In your case, this would be
replaced with your own struct that implements <code class="docutils literal
notranslate"><span class= [...]
<p>While this is a simple example for illustrative purposes, UDTFs have a lot
of potential use cases. And can be particularly useful for reading data from
external sources and interactive analysis. For example, see the <a
class="reference external"
href="https://github.com/apache/arrow-datafusion/blob/main/datafusion-examples/examples/simple_udtf.rs";>example</a>
for a working example that reads from a CSV file. As another example, you
could use the built-in UDTF <code class="docutils lit [...]
-<div class="highlight-console notranslate"><div
class="highlight"><pre><span></span><span class="go">❯ select filename,
row_group_id, row_group_num_rows, row_group_bytes, stats_min, stats_max from
parquet_metadata('./benchmarks/data/hits.parquet') where column_id =
17 limit 10;</span>
+<div class="highlight-console notranslate"><div
class="highlight"><pre><span></span><span class="go">> select filename,
row_group_id, row_group_num_rows, row_group_bytes, stats_min, stats_max from
parquet_metadata('./benchmarks/data/hits.parquet') where column_id =
17 limit 10;</span>
<span
class="go">+--------------------------------+--------------+--------------------+-----------------+-----------+-----------+</span>
<span class="go">| filename | row_group_id |
row_group_num_rows | row_group_bytes | stats_min | stats_max |</span>
<span
class="go">+--------------------------------+--------------+--------------------+-----------------+-----------+-----------+</span>
diff --git a/user-guide/cli.html b/user-guide/cli.html
index 28da8a77d9..d91ca46f74 100644
--- a/user-guide/cli.html
+++ b/user-guide/cli.html
@@ -637,7 +637,7 @@ $<span class="w"> </span><span class="nb">echo</span><span
class="w"> </span><sp
<p>Query that single file (the CLI also supports parquet, compressed csv,
avro, json and more)</p>
<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>v17.0.0
-❯<span class="w"> </span><span class="k">select</span><span class="w">
</span>*<span class="w"> </span>from<span class="w"> </span><span
class="s1">'data.csv'</span><span class="p">;</span>
+><span class="w"> </span><span class="k">select</span><span class="w">
</span>*<span class="w"> </span>from<span class="w"> </span><span
class="s1">'data.csv'</span><span class="p">;</span>
+---+---+
<span class="p">|</span><span class="w"> </span>a<span class="w"> </span><span
class="p">|</span><span class="w"> </span>b<span class="w"> </span><span
class="p">|</span>
+---+---+
@@ -653,7 +653,7 @@ data.csv<span class="w"> </span>data2.csv
</div>
<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>v16.0.0
-❯<span class="w"> </span><span class="k">select</span><span class="w">
</span>*<span class="w"> </span>from<span class="w"> </span><span
class="s1">'data_dir'</span><span class="p">;</span>
+><span class="w"> </span><span class="k">select</span><span class="w">
</span>*<span class="w"> </span>from<span class="w"> </span><span
class="s1">'data_dir'</span><span class="p">;</span>
+---+---+
<span class="p">|</span><span class="w"> </span>a<span class="w"> </span><span
class="p">|</span><span class="w"> </span>b<span class="w"> </span><span
class="p">|</span>
+---+---+
@@ -786,9 +786,9 @@ $<span class="w"> </span><span
class="nb">export</span><span class="w"> </span><
$<span class="w"> </span>datafusion-cli
DataFusion<span class="w"> </span>CLI<span class="w"> </span>v21.0.0
-❯<span class="w"> </span>create<span class="w"> </span>external<span
class="w"> </span>table<span class="w"> </span><span
class="nb">test</span><span class="w"> </span>stored<span class="w">
</span>as<span class="w"> </span>parquet<span class="w"> </span>location<span
class="w"> </span><span
class="s1">'s3://bucket/path/file.parquet'</span><span
class="p">;</span>
+><span class="w"> </span>create<span class="w"> </span>external<span
class="w"> </span>table<span class="w"> </span><span
class="nb">test</span><span class="w"> </span>stored<span class="w">
</span>as<span class="w"> </span>parquet<span class="w"> </span>location<span
class="w"> </span><span
class="s1">'s3://bucket/path/file.parquet'</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>.374<span class="w"> </span>seconds.
-❯<span class="w"> </span><span class="k">select</span><span class="w">
</span>*<span class="w"> </span>from<span class="w"> </span>test<span
class="p">;</span>
+><span class="w"> </span><span class="k">select</span><span class="w">
</span>*<span class="w"> </span>from<span class="w"> </span>test<span
class="p">;</span>
+----------+----------+
<span class="p">|</span><span class="w"> </span>column_1<span class="w">
</span><span class="p">|</span><span class="w"> </span>column_2<span class="w">
</span><span class="p">|</span>
+----------+----------+
@@ -873,9 +873,9 @@ DataFusion<span class="w"> </span>CLI<span class="w">
</span>v21.0.0
$<span class="w"> </span>datafusion-cli
DataFusion<span class="w"> </span>CLI<span class="w"> </span>v21.0.0
-❯<span class="w"> </span>create<span class="w"> </span>external<span
class="w"> </span>table<span class="w"> </span><span
class="nb">test</span><span class="w"> </span>stored<span class="w">
</span>as<span class="w"> </span>parquet<span class="w"> </span>location<span
class="w"> </span><span
class="s1">'gs://bucket/path/file.parquet'</span><span
class="p">;</span>
+><span class="w"> </span>create<span class="w"> </span>external<span
class="w"> </span>table<span class="w"> </span><span
class="nb">test</span><span class="w"> </span>stored<span class="w">
</span>as<span class="w"> </span>parquet<span class="w"> </span>location<span
class="w"> </span><span
class="s1">'gs://bucket/path/file.parquet'</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>.374<span class="w"> </span>seconds.
-❯<span class="w"> </span><span class="k">select</span><span class="w">
</span>*<span class="w"> </span>from<span class="w"> </span>test<span
class="p">;</span>
+><span class="w"> </span><span class="k">select</span><span class="w">
</span>*<span class="w"> </span>from<span class="w"> </span>test<span
class="p">;</span>
+----------+----------+
<span class="p">|</span><span class="w"> </span>column_1<span class="w">
</span><span class="p">|</span><span class="w"> </span>column_2<span class="w">
</span><span class="p">|</span>
+----------+----------+
@@ -1122,7 +1122,7 @@ would set the <code class="docutils literal
notranslate"><span class="pre">DATAF
appropriately:</p>
<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="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>
+-------------------------------------------------+---------+
@@ -1140,7 +1140,7 @@ DataFusion<span class="w"> </span>CLI<span class="w">
</span>v12.0.0
<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-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="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>
+---------------------------------+---------+
@@ -1148,10 +1148,10 @@ DataFusion<span class="w"> </span>CLI<span class="w">
</span>v13.0.0
+---------------------------------+---------+
<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="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="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="w"> </span>show<span class="w">
</span>datafusion.execution.batch_size<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>
+---------------------------------+---------+
diff --git a/user-guide/example-usage.html b/user-guide/example-usage.html
index ad301302c4..6f9c6ab5ca 100644
--- a/user-guide/example-usage.html
+++ b/user-guide/example-usage.html
@@ -684,7 +684,7 @@ like error backtrace. To enable a backtrace you need to add
Datafusion <code cla
<p>Set environment <a class="reference external"
href="https://doc.rust-lang.org/std/backtrace/index.html#environment-variables";>variables</a></p>
<div class="highlight-bash notranslate"><div
class="highlight"><pre><span></span><span class="nv">RUST_BACKTRACE</span><span
class="o">=</span><span class="m">1</span><span class="w">
</span>./target/debug/datafusion-cli
DataFusion<span class="w"> </span>CLI<span class="w"> </span>v31.0.0
-❯<span class="w"> </span><span class="k">select</span><span class="w">
</span>row_numer<span class="o">()</span><span class="w"> </span>over<span
class="w"> </span><span class="o">(</span>partition<span class="w">
</span>by<span class="w"> </span>a<span class="w"> </span>order<span class="w">
</span>by<span class="w"> </span>a<span class="o">)</span><span class="w">
</span>from<span class="w"> </span><span class="o">(</span><span
class="k">select</span><span class="w"> </span><span class [...]
+><span class="w"> </span><span class="k">select</span><span class="w">
</span>row_numer<span class="o">()</span><span class="w"> </span>over<span
class="w"> </span><span class="o">(</span>partition<span class="w">
</span>by<span class="w"> </span>a<span class="w"> </span>order<span class="w">
</span>by<span class="w"> </span>a<span class="o">)</span><span class="w">
</span>from<span class="w"> </span><span class="o">(</span><span
class="k">select</span><span class="w"> </span><span cl [...]
Error<span class="w"> </span>during<span class="w"> </span>planning:<span
class="w"> </span>Invalid<span class="w"> </span><span
class="k">function</span><span class="w"> </span><span
class="s1">'row_numer'</span>.
Did<span class="w"> </span>you<span class="w"> </span>mean<span class="w">
</span><span class="s1">'ROW_NUMBER'</span>?
diff --git a/user-guide/sql/scalar_functions.html
b/user-guide/sql/scalar_functions.html
index 070e90f38b..096734bdb4 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -5344,18 +5344,18 @@ Can be a constant, column or function, and any
combination of arithmetic operato
</section>
<section id="id88">
<h4>Example<a class="headerlink" href="#id88" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select make_date(2023, 1, 31);
-+-------------------------------------------+
-| make_date(Int64(2023),Int64(1),Int64(31)) |
-+-------------------------------------------+
-| 2023-01-31 |
-+-------------------------------------------+
-❯ select make_date('2023', '01', '31');
-+-----------------------------------------------+
-| make_date(Utf8("2023"),Utf8("01"),Utf8("31")) |
-+-----------------------------------------------+
-| 2023-01-31 |
-+-----------------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">make_date</span><span
class="p">(</span><span class="mi">2023</span><span class="p">,</span> <span
class="mi">1</span><span class="p">,</span> <span class="mi">31</span><span
class="p">);</span>
+<span class="o">+-------------------------------------------+</span>
+<span class="o">|</span> <span class="n">make_date</span><span
class="p">(</span><span class="n">Int64</span><span class="p">(</span><span
class="mi">2023</span><span class="p">),</span><span
class="n">Int64</span><span class="p">(</span><span class="mi">1</span><span
class="p">),</span><span class="n">Int64</span><span class="p">(</span><span
class="mi">31</span><span class="p">))</span> <span class="o">|</span>
+<span class="o">+-------------------------------------------+</span>
+<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">01</span><span class="o">-</span><span
class="mi">31</span> <span class="o">|</span>
+<span class="o">+-------------------------------------------+</span>
+<span class="o">></span> <span class="n">select</span> <span
class="n">make_date</span><span class="p">(</span><span
class="s1">'2023'</span><span class="p">,</span> <span
class="s1">'01'</span><span class="p">,</span> <span
class="s1">'31'</span><span class="p">);</span>
+<span class="o">+-----------------------------------------------+</span>
+<span class="o">|</span> <span class="n">make_date</span><span
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"2023"</span><span class="p">),</span><span
class="n">Utf8</span><span class="p">(</span><span
class="s2">"01"</span><span class="p">),</span><span
class="n">Utf8</span><span class="p">(</span><span
class="s2">"31"</span><span class="p">))</span> <span
class="o">|</span>
+<span class="o">+-----------------------------------------------+</span>
+<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">01</span><span class="o">-</span><span
class="mi">31</span> <span class="o">|</span>
+<span class="o">+-----------------------------------------------+</span>
</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/make_date.rs";>here</a></p>
@@ -5380,12 +5380,12 @@ date, time, timestamp or duration.</p></li>
</section>
<section id="id90">
<h4>Example<a class="headerlink" href="#id90" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ ❯ select
to_char('2023-03-01'::date, '%d-%m-%Y');
-+----------------------------------------------+
-| to_char(Utf8("2023-03-01"),Utf8("%d-%m-%Y")) |
-+----------------------------------------------+
-| 01-03-2023 |
-+----------------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="o">></span> <span class="n">select</span> <span
class="n">to_char</span><span class="p">(</span><span
class="s1">'2023-03-01'</span><span class="p">::</span><span
class="n">date</span><span class="p">,</span> <span
class="s1">'</span><span class="si">%d</span><span
class="s1">-%m-%Y'</span><span class="p">);</span>
+<span class="o">+----------------------------------------------+</span>
+<span class="o">|</span> <span class="n">to_char</span><span
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"2023-03-01"</span><span class="p">),</span><span
class="n">Utf8</span><span class="p">(</span><span
class="s2">"</span><span class="si">%d</span><span
class="s2">-%m-%Y"</span><span class="p">))</span> <span class="o">|</span>
+<span class="o">+----------------------------------------------+</span>
+<span class="o">|</span> <span class="mi">01</span><span
class="o">-</span><span class="mi">03</span><span class="o">-</span><span
class="mi">2023</span> <span
class="o">|</span>
+<span class="o">+----------------------------------------------+</span>
</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/to_char.rs";>here</a></p>
@@ -5422,18 +5422,18 @@ an error will be returned.</p></li>
</section>
<section id="id93">
<h4>Example<a class="headerlink" href="#id93" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select
to_timestamp('2023-01-31T09:26:56.123456789-05:00');
-+-----------------------------------------------------------+
-| to_timestamp(Utf8("2023-01-31T09:26:56.123456789-05:00")) |
-+-----------------------------------------------------------+
-| 2023-01-31T14:26:56.123456789 |
-+-----------------------------------------------------------+
-❯ select to_timestamp('03:59:00.123456789 05-17-2023', '%c',
'%+', '%H:%M:%S%.f %m-%d-%Y');
-+--------------------------------------------------------------------------------------------------------+
-| to_timestamp(Utf8("03:59:00.123456789
05-17-2023"),Utf8("%c"),Utf8("%+"),Utf8("%H:%M:%S%.f
%m-%d-%Y")) |
-+--------------------------------------------------------------------------------------------------------+
-| 2023-05-17T03:59:00.123456789
|
-+--------------------------------------------------------------------------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">to_timestamp</span><span
class="p">(</span><span
class="s1">'2023-01-31T09:26:56.123456789-05:00'</span><span
class="p">);</span>
+<span
class="o">+-----------------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">to_timestamp</span><span
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"2023-01-31T09:26:56.123456789-05:00"</span><span
class="p">))</span> <span class="o">|</span>
+<span
class="o">+-----------------------------------------------------------+</span>
+<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">01</span><span class="o">-</span><span
class="mi">31</span><span class="n">T14</span><span class="p">:</span><span
class="mi">26</span><span class="p">:</span><span
class="mf">56.123456789</span> <span
class="o">|</span>
+<span
class="o">+-----------------------------------------------------------+</span>
+<span class="o">></span> <span class="n">select</span> <span
class="n">to_timestamp</span><span class="p">(</span><span
class="s1">'03:59:00.123456789 05-17-2023'</span><span
class="p">,</span> <span class="s1">'</span><span class="si">%c</span><span
class="s1">'</span><span class="p">,</span> <span
class="s1">'%+'</span><span class="p">,</span> <span
class="s1">'%H:%M:%S%.f %m-</span><span class="si">%d</span><span
class="s1">-%Y'</span><span class="p" [...]
+<span
class="o">+--------------------------------------------------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">to_timestamp</span><span
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"03:59:00.123456789 05-17-2023"</span><span
class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"</span><span class="si">%c</span><span
class="s2">"</span><span class="p">),</span><span
class="n">Utf8</span><span class="p">(</span><span
class="s2">"%+"</span><span class="p"> [...]
+<span
class="o">+--------------------------------------------------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">05</span><span class="o">-</span><span
class="mi">17</span><span class="n">T03</span><span class="p">:</span><span
class="mi">59</span><span class="p">:</span><span
class="mf">00.123456789</span>
<span class="o">|</span>
+<span
class="o">+--------------------------------------------------------------------------------------------------------+</span>
</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/to_timestamp.rs";>here</a></p>
@@ -5461,18 +5461,18 @@ an error will be returned.</p></li>
</section>
<section id="id95">
<h4>Example<a class="headerlink" href="#id95" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select
to_timestamp_millis('2023-01-31T09:26:56.123456789-05:00');
-+------------------------------------------------------------------+
-| to_timestamp_millis(Utf8("2023-01-31T09:26:56.123456789-05:00")) |
-+------------------------------------------------------------------+
-| 2023-01-31T14:26:56.123 |
-+------------------------------------------------------------------+
-❯ select to_timestamp_millis('03:59:00.123456789 05-17-2023',
'%c', '%+', '%H:%M:%S%.f %m-%d-%Y');
-+---------------------------------------------------------------------------------------------------------------+
-| to_timestamp_millis(Utf8("03:59:00.123456789
05-17-2023"),Utf8("%c"),Utf8("%+"),Utf8("%H:%M:%S%.f
%m-%d-%Y")) |
-+---------------------------------------------------------------------------------------------------------------+
-| 2023-05-17T03:59:00.123
|
-+---------------------------------------------------------------------------------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">to_timestamp_millis</span><span
class="p">(</span><span
class="s1">'2023-01-31T09:26:56.123456789-05:00'</span><span
class="p">);</span>
+<span
class="o">+------------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">to_timestamp_millis</span><span
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"2023-01-31T09:26:56.123456789-05:00"</span><span
class="p">))</span> <span class="o">|</span>
+<span
class="o">+------------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">01</span><span class="o">-</span><span
class="mi">31</span><span class="n">T14</span><span class="p">:</span><span
class="mi">26</span><span class="p">:</span><span class="mf">56.123</span>
<span class="o">|</span>
+<span
class="o">+------------------------------------------------------------------+</span>
+<span class="o">></span> <span class="n">select</span> <span
class="n">to_timestamp_millis</span><span class="p">(</span><span
class="s1">'03:59:00.123456789 05-17-2023'</span><span
class="p">,</span> <span class="s1">'</span><span class="si">%c</span><span
class="s1">'</span><span class="p">,</span> <span
class="s1">'%+'</span><span class="p">,</span> <span
class="s1">'%H:%M:%S%.f %m-</span><span class="si">%d</span><span
class="s1">-%Y'</span><span cl [...]
+<span
class="o">+---------------------------------------------------------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">to_timestamp_millis</span><span
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"03:59:00.123456789 05-17-2023"</span><span
class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"</span><span class="si">%c</span><span
class="s2">"</span><span class="p">),</span><span
class="n">Utf8</span><span class="p">(</span><span
class="s2">"%+"</span><span cla [...]
+<span
class="o">+---------------------------------------------------------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">05</span><span class="o">-</span><span
class="mi">17</span><span class="n">T03</span><span class="p">:</span><span
class="mi">59</span><span class="p">:</span><span class="mf">00.123</span>
<span class="o">|</span>
+<span
class="o">+---------------------------------------------------------------------------------------------------------------+</span>
</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/to_timestamp.rs";>here</a></p>
@@ -5500,18 +5500,18 @@ an error will be returned.</p></li>
</section>
<section id="id97">
<h4>Example<a class="headerlink" href="#id97" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select
to_timestamp_micros('2023-01-31T09:26:56.123456789-05:00');
-+------------------------------------------------------------------+
-| to_timestamp_micros(Utf8("2023-01-31T09:26:56.123456789-05:00")) |
-+------------------------------------------------------------------+
-| 2023-01-31T14:26:56.123456 |
-+------------------------------------------------------------------+
-❯ select to_timestamp_micros('03:59:00.123456789 05-17-2023',
'%c', '%+', '%H:%M:%S%.f %m-%d-%Y');
-+---------------------------------------------------------------------------------------------------------------+
-| to_timestamp_micros(Utf8("03:59:00.123456789
05-17-2023"),Utf8("%c"),Utf8("%+"),Utf8("%H:%M:%S%.f
%m-%d-%Y")) |
-+---------------------------------------------------------------------------------------------------------------+
-| 2023-05-17T03:59:00.123456
|
-+---------------------------------------------------------------------------------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">to_timestamp_micros</span><span
class="p">(</span><span
class="s1">'2023-01-31T09:26:56.123456789-05:00'</span><span
class="p">);</span>
+<span
class="o">+------------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">to_timestamp_micros</span><span
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"2023-01-31T09:26:56.123456789-05:00"</span><span
class="p">))</span> <span class="o">|</span>
+<span
class="o">+------------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">01</span><span class="o">-</span><span
class="mi">31</span><span class="n">T14</span><span class="p">:</span><span
class="mi">26</span><span class="p">:</span><span class="mf">56.123456</span>
<span class="o">|</span>
+<span
class="o">+------------------------------------------------------------------+</span>
+<span class="o">></span> <span class="n">select</span> <span
class="n">to_timestamp_micros</span><span class="p">(</span><span
class="s1">'03:59:00.123456789 05-17-2023'</span><span
class="p">,</span> <span class="s1">'</span><span class="si">%c</span><span
class="s1">'</span><span class="p">,</span> <span
class="s1">'%+'</span><span class="p">,</span> <span
class="s1">'%H:%M:%S%.f %m-</span><span class="si">%d</span><span
class="s1">-%Y'</span><span cl [...]
+<span
class="o">+---------------------------------------------------------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">to_timestamp_micros</span><span
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"03:59:00.123456789 05-17-2023"</span><span
class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"</span><span class="si">%c</span><span
class="s2">"</span><span class="p">),</span><span
class="n">Utf8</span><span class="p">(</span><span
class="s2">"%+"</span><span cla [...]
+<span
class="o">+---------------------------------------------------------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">05</span><span class="o">-</span><span
class="mi">17</span><span class="n">T03</span><span class="p">:</span><span
class="mi">59</span><span class="p">:</span><span class="mf">00.123456</span>
<span class="o">|</span>
+<span
class="o">+---------------------------------------------------------------------------------------------------------------+</span>
</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/to_timestamp.rs";>here</a></p>
@@ -5539,18 +5539,18 @@ an error will be returned.</p></li>
</section>
<section id="id99">
<h4>Example<a class="headerlink" href="#id99" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select
to_timestamp_nanos('2023-01-31T09:26:56.123456789-05:00');
-+-----------------------------------------------------------------+
-| to_timestamp_nanos(Utf8("2023-01-31T09:26:56.123456789-05:00")) |
-+-----------------------------------------------------------------+
-| 2023-01-31T14:26:56.123456789 |
-+-----------------------------------------------------------------+
-❯ select to_timestamp_nanos('03:59:00.123456789 05-17-2023',
'%c', '%+', '%H:%M:%S%.f %m-%d-%Y');
-+--------------------------------------------------------------------------------------------------------------+
-| to_timestamp_nanos(Utf8("03:59:00.123456789
05-17-2023"),Utf8("%c"),Utf8("%+"),Utf8("%H:%M:%S%.f
%m-%d-%Y")) |
-+--------------------------------------------------------------------------------------------------------------+
-| 2023-05-17T03:59:00.123456789
|
-+---------------------------------------------------------------------------------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">to_timestamp_nanos</span><span
class="p">(</span><span
class="s1">'2023-01-31T09:26:56.123456789-05:00'</span><span
class="p">);</span>
+<span
class="o">+-----------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">to_timestamp_nanos</span><span
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"2023-01-31T09:26:56.123456789-05:00"</span><span
class="p">))</span> <span class="o">|</span>
+<span
class="o">+-----------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">01</span><span class="o">-</span><span
class="mi">31</span><span class="n">T14</span><span class="p">:</span><span
class="mi">26</span><span class="p">:</span><span
class="mf">56.123456789</span> <span
class="o">|</span>
+<span
class="o">+-----------------------------------------------------------------+</span>
+<span class="o">></span> <span class="n">select</span> <span
class="n">to_timestamp_nanos</span><span class="p">(</span><span
class="s1">'03:59:00.123456789 05-17-2023'</span><span
class="p">,</span> <span class="s1">'</span><span class="si">%c</span><span
class="s1">'</span><span class="p">,</span> <span
class="s1">'%+'</span><span class="p">,</span> <span
class="s1">'%H:%M:%S%.f %m-</span><span class="si">%d</span><span
class="s1">-%Y'</span><span cla [...]
+<span
class="o">+--------------------------------------------------------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">to_timestamp_nanos</span><span
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"03:59:00.123456789 05-17-2023"</span><span
class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"</span><span class="si">%c</span><span
class="s2">"</span><span class="p">),</span><span
class="n">Utf8</span><span class="p">(</span><span
class="s2">"%+"</span><span clas [...]
+<span
class="o">+--------------------------------------------------------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">05</span><span class="o">-</span><span
class="mi">17</span><span class="n">T03</span><span class="p">:</span><span
class="mi">59</span><span class="p">:</span><span
class="mf">00.123456789</span>
<span class="o">|</span>
+<span
class="o">+---------------------------------------------------------------------------------------------------------------+</span>
</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/to_timestamp.rs";>here</a></p>
@@ -5578,18 +5578,18 @@ an error will be returned.</p></li>
</section>
<section id="id101">
<h4>Example<a class="headerlink" href="#id101" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select
to_timestamp_seconds('2023-01-31T09:26:56.123456789-05:00');
-+-------------------------------------------------------------------+
-| to_timestamp_seconds(Utf8("2023-01-31T09:26:56.123456789-05:00")) |
-+-------------------------------------------------------------------+
-| 2023-01-31T14:26:56 |
-+-------------------------------------------------------------------+
-❯ select to_timestamp_seconds('03:59:00.123456789 05-17-2023',
'%c', '%+', '%H:%M:%S%.f %m-%d-%Y');
-+----------------------------------------------------------------------------------------------------------------+
-| to_timestamp_seconds(Utf8("03:59:00.123456789
05-17-2023"),Utf8("%c"),Utf8("%+"),Utf8("%H:%M:%S%.f
%m-%d-%Y")) |
-+----------------------------------------------------------------------------------------------------------------+
-| 2023-05-17T03:59:00
|
-+----------------------------------------------------------------------------------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">to_timestamp_seconds</span><span
class="p">(</span><span
class="s1">'2023-01-31T09:26:56.123456789-05:00'</span><span
class="p">);</span>
+<span
class="o">+-------------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">to_timestamp_seconds</span><span
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"2023-01-31T09:26:56.123456789-05:00"</span><span
class="p">))</span> <span class="o">|</span>
+<span
class="o">+-------------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">01</span><span class="o">-</span><span
class="mi">31</span><span class="n">T14</span><span class="p">:</span><span
class="mi">26</span><span class="p">:</span><span class="mi">56</span>
<span class="o">|</span>
+<span
class="o">+-------------------------------------------------------------------+</span>
+<span class="o">></span> <span class="n">select</span> <span
class="n">to_timestamp_seconds</span><span class="p">(</span><span
class="s1">'03:59:00.123456789 05-17-2023'</span><span
class="p">,</span> <span class="s1">'</span><span class="si">%c</span><span
class="s1">'</span><span class="p">,</span> <span
class="s1">'%+'</span><span class="p">,</span> <span
class="s1">'%H:%M:%S%.f %m-</span><span class="si">%d</span><span
class="s1">-%Y'</span><span c [...]
+<span
class="o">+----------------------------------------------------------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">to_timestamp_seconds</span><span
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"03:59:00.123456789 05-17-2023"</span><span
class="p">),</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"</span><span class="si">%c</span><span
class="s2">"</span><span class="p">),</span><span
class="n">Utf8</span><span class="p">(</span><span
class="s2">"%+"</span><span cl [...]
+<span
class="o">+----------------------------------------------------------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="mi">2023</span><span
class="o">-</span><span class="mi">05</span><span class="o">-</span><span
class="mi">17</span><span class="n">T03</span><span class="p">:</span><span
class="mi">59</span><span class="p">:</span><span class="mi">00</span>
<span class="o">|</span>
+<span
class="o">+----------------------------------------------------------------------------------------------------------------+</span>
</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/to_timestamp.rs";>here</a></p>
@@ -5716,12 +5716,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id104">
<h4>Example<a class="headerlink" href="#id104" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_append([1, 2, 3], 4);
-+--------------------------------------+
-| array_append(List([1,2,3]),Int64(4)) |
-+--------------------------------------+
-| [1, 2, 3, 4] |
-+--------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_append</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">],</span> <span class="mi">4</span><span class="p">);</span>
+<span class="o">+--------------------------------------+</span>
+<span class="o">|</span> <span class="n">array_append</span><span
class="p">(</span><span class="n">List</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="n">Int64</span><span class="p">(</span><span class="mi">4</span><span
class="p">))</span> <span class="o">|</span>
+<span class="o">+--------------------------------------+</span>
+<span class="o">|</span> <span class="p">[</span><span
class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">4</span><span class="p">]</span> <span
class="o">|</span>
+<span class="o">+--------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -5751,12 +5751,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id107">
<h4>Example<a class="headerlink" href="#id107" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_sort([3, 1, 2]);
-+-----------------------------+
-| array_sort(List([3,1,2])) |
-+-----------------------------+
-| [1, 2, 3] |
-+-----------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_sort</span><span
class="p">([</span><span class="mi">3</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="o">+-----------------------------+</span>
+<span class="o">|</span> <span class="n">array_sort</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">3</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="o">|</span>
+<span class="o">+-----------------------------+</span>
+<span class="o">|</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="o">|</span>
+<span class="o">+-----------------------------+</span>
</pre></div>
</div>
</section>
@@ -5784,12 +5784,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id110">
<h4>Example<a class="headerlink" href="#id110" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_resize([1, 2, 3], 5, 0);
-+-------------------------------------+
-| array_resize(List([1,2,3],5,0)) |
-+-------------------------------------+
-| [1, 2, 3, 0, 0] |
-+-------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_resize</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">],</span> <span class="mi">5</span><span class="p">,</span> <span
class="mi">0</span><span class="p">);</span>
+<span class="o">+-------------------------------------+</span>
+<span class="o">|</span> <span class="n">array_resize</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">3</span><span class="p">],</span><span
class="mi">5</span><span class="p">,</span><span class="mi">0</span><span
class="p">))</span> <span class="o">|</span>
+<span class="o">+-------------------------------------+</span>
+<span class="o">|</span> <span class="p">[</span><span
class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">0</span><span class="p">,</span> <span class="mi">0</span><span
class="p">]</span> <span class="o">|</span>
+<span class="o">+-------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -5820,12 +5820,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id113">
<h4>Example<a class="headerlink" href="#id113" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_concat([1, 2], [3, 4], [5,
6]);
-+---------------------------------------------------+
-| array_concat(List([1,2]),List([3,4]),List([5,6])) |
-+---------------------------------------------------+
-| [1, 2, 3, 4, 5, 6] |
-+---------------------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_concat</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="p">[</span><span
class="mi">3</span><span class="p">,</span> <span class="mi">4</span><span
class="p">],</span> <span class="p">[</span><span class="mi">5</span><span
class="p" [...]
+<span class="o">+---------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">array_concat</span><span
class="p">(</span><span class="n">List</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="n">List</span><span class="p">([</span><span
class="mi">3</span><span class="p">,</span><span class="mi">4</span><span
class="p">]),</span><span class="n">List</span><span class="p">([</span><span
class="mi">5</span><span class="p">,</span><sp [...]
+<span class="o">+---------------------------------------------------+</span>
+<span class="o">|</span> <span class="p">[</span><span
class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">4</span><span class="p">,</span> <span class="mi">5</span><span
class="p">,</span> <span class="mi">6</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">+---------------------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -5923,12 +5923,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id122">
<h4>Example<a class="headerlink" href="#id122" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_dims([[1, 2, 3], [4, 5, 6]]);
-+---------------------------------+
-| array_dims(List([1,2,3,4,5,6])) |
-+---------------------------------+
-| [2, 3] |
-+---------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_dims</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="p">[</span><span class="mi">4</span><span
class="p">,</span> <span class="mi">5</span><span class="p">,</span> <span
class="mi" [...]
+<span class="o">+---------------------------------+</span>
+<span class="o">|</span> <span class="n">array_dims</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">3</span><span class="p">,</span><span
class="mi">4</span><span class="p">,</span><span class="mi">5</span><span
class="p">,</span><span class="mi">6</span><span class="p">]))</span> <span
class="o">|</span>
+<span class="o">+---------------------------------+</span>
+<span class="o">|</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="o">|</span>
+<span class="o">+---------------------------------+</span>
</pre></div>
</div>
</section>
@@ -5954,12 +5954,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id125">
<h4>Example<a class="headerlink" href="#id125" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_distinct([1, 3, 2, 3, 1, 2,
4]);
-+---------------------------------+
-| array_distinct(List([1,2,3,4])) |
-+---------------------------------+
-| [1, 2, 3, 4] |
-+---------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_distinct</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="mi">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span
class=" [...]
+<span class="o">+---------------------------------+</span>
+<span class="o">|</span> <span class="n">array_distinct</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">3</span><span class="p">,</span><span
class="mi">4</span><span class="p">]))</span> <span class="o">|</span>
+<span class="o">+---------------------------------+</span>
+<span class="o">|</span> <span class="p">[</span><span
class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">4</span><span class="p">]</span> <span
class="o">|</span>
+<span class="o">+---------------------------------+</span>
</pre></div>
</div>
</section>
@@ -5986,12 +5986,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id128">
<h4>Example<a class="headerlink" href="#id128" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_element([1, 2, 3, 4], 3);
-+-----------------------------------------+
-| array_element(List([1,2,3,4]),Int64(3)) |
-+-----------------------------------------+
-| 3 |
-+-----------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_element</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">],</span> <span
class="mi">3</span><span class="p">);</span>
+<span class="o">+-----------------------------------------+</span>
+<span class="o">|</span> <span class="n">array_element</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">3</span><span class="p">,</span><span
class="mi">4</span><span class="p">]),</span><span class="n">Int64</span><span
class="p">(</span><span class="mi">3</span><span class="p">))</span> <span
class="o">|</span>
+<span class="o">+-----------------------------------------+</span>
+<span class="o">|</span> <span class="mi">3</span>
<span class="o">|</span>
+<span class="o">+-----------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -6064,18 +6064,18 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id133">
<h4>Example<a class="headerlink" href="#id133" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_intersect([1, 2, 3, 4], [5,
6, 3, 4]);
-+----------------------------------------------------+
-| array_intersect([1, 2, 3, 4], [5, 6, 3, 4]); |
-+----------------------------------------------------+
-| [3, 4] |
-+----------------------------------------------------+
-❯ select array_intersect([1, 2, 3, 4], [5, 6, 7, 8]);
-+----------------------------------------------------+
-| array_intersect([1, 2, 3, 4], [5, 6, 7, 8]); |
-+----------------------------------------------------+
-| [] |
-+----------------------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_intersect</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">],</span> <span
class="p">[</span><span class="mi">5</span><span class="p">,</span> <span
class= [...]
+<span class="o">+----------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">array_intersect</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">],</span> <span
class="p">[</span><span class="mi">5</span><span class="p">,</span> <span
class="mi">6</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><spa [...]
+<span class="o">+----------------------------------------------------+</span>
+<span class="o">|</span> <span class="p">[</span><span
class="mi">3</span><span class="p">,</span> <span class="mi">4</span><span
class="p">]</span> <span
class="o">|</span>
+<span class="o">+----------------------------------------------------+</span>
+<span class="o">></span> <span class="n">select</span> <span
class="n">array_intersect</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">4</span><span class="p">],</span> <span class="p">[</span><span
class="mi">5</span><span class="p">,</span> <span class="mi">6</span><span
class="p">,</span> <span class="mi">7</span><span class="p">,</sp [...]
+<span class="o">+----------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">array_intersect</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">],</span> <span
class="p">[</span><span class="mi">5</span><span class="p">,</span> <span
class="mi">6</span><span class="p">,</span> <span class="mi">7</span><span
class="p">,</span> <span class="mi">8</span><spa [...]
+<span class="o">+----------------------------------------------------+</span>
+<span class="o">|</span> <span class="p">[]</span>
<span class="o">|</span>
+<span class="o">+----------------------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -6107,12 +6107,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id136">
<h4>Example<a class="headerlink" href="#id136" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_length([1, 2, 3, 4, 5]);
-+---------------------------------+
-| array_length(List([1,2,3,4,5])) |
-+---------------------------------+
-| 5 |
-+---------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_length</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">,</span> <span
class="mi">5</span><span class="p">]);</span>
+<span class="o">+---------------------------------+</span>
+<span class="o">|</span> <span class="n">array_length</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">3</span><span class="p">,</span><span
class="mi">4</span><span class="p">,</span><span class="mi">5</span><span
class="p">]))</span> <span class="o">|</span>
+<span class="o">+---------------------------------+</span>
+<span class="o">|</span> <span class="mi">5</span>
<span class="o">|</span>
+<span class="o">+---------------------------------+</span>
</pre></div>
</div>
</section>
@@ -6138,12 +6138,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id139">
<h4>Example<a class="headerlink" href="#id139" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_ndims([[1, 2, 3], [4, 5,
6]]);
-+----------------------------------+
-| array_ndims(List([1,2,3,4,5,6])) |
-+----------------------------------+
-| 2 |
-+----------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_ndims</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="p">[</span><span class="mi">4</span><span
class="p">,</span> <span class="mi">5</span><span class="p">,</span> <span
class="mi [...]
+<span class="o">+----------------------------------+</span>
+<span class="o">|</span> <span class="n">array_ndims</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">3</span><span class="p">,</span><span
class="mi">4</span><span class="p">,</span><span class="mi">5</span><span
class="p">,</span><span class="mi">6</span><span class="p">]))</span> <span
class="o">|</span>
+<span class="o">+----------------------------------+</span>
+<span class="o">|</span> <span class="mi">2</span>
<span class="o">|</span>
+<span class="o">+----------------------------------+</span>
</pre></div>
</div>
</section>
@@ -6170,12 +6170,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id142">
<h4>Example<a class="headerlink" href="#id142" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_prepend(1, [2, 3, 4]);
-+---------------------------------------+
-| array_prepend(Int64(1),List([2,3,4])) |
-+---------------------------------------+
-| [1, 2, 3, 4] |
-+---------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_prepend</span><span
class="p">(</span><span class="mi">1</span><span class="p">,</span> <span
class="p">[</span><span class="mi">2</span><span class="p">,</span> <span
class="mi">3</span><span class="p">,</span> <span class="mi">4</span><span
class="p">]);</span>
+<span class="o">+---------------------------------------+</span>
+<span class="o">|</span> <span class="n">array_prepend</span><span
class="p">(</span><span class="n">Int64</span><span class="p">(</span><span
class="mi">1</span><span class="p">),</span><span class="n">List</span><span
class="p">([</span><span class="mi">2</span><span class="p">,</span><span
class="mi">3</span><span class="p">,</span><span class="mi">4</span><span
class="p">]))</span> <span class="o">|</span>
+<span class="o">+---------------------------------------+</span>
+<span class="o">|</span> <span class="p">[</span><span
class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">4</span><span class="p">]</span> <span
class="o">|</span>
+<span class="o">+---------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -6203,12 +6203,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id145">
<h4>Example<a class="headerlink" href="#id145" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_pop_front([1, 2, 3]);
-+-------------------------------+
-| array_pop_front(List([1,2,3])) |
-+-------------------------------+
-| [2, 3] |
-+-------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_pop_front</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="o">+-------------------------------+</span>
+<span class="o">|</span> <span class="n">array_pop_front</span><span
class="p">(</span><span class="n">List</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="o">|</span>
+<span class="o">+-------------------------------+</span>
+<span class="o">|</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="o">|</span>
+<span class="o">+-------------------------------+</span>
</pre></div>
</div>
</section>
@@ -6234,12 +6234,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id148">
<h4>Example<a class="headerlink" href="#id148" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_pop_back([1, 2, 3]);
-+-------------------------------+
-| array_pop_back(List([1,2,3])) |
-+-------------------------------+
-| [1, 2] |
-+-------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_pop_back</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="o">+-------------------------------+</span>
+<span class="o">|</span> <span class="n">array_pop_back</span><span
class="p">(</span><span class="n">List</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="o">|</span>
+<span class="o">+-------------------------------+</span>
+<span class="o">|</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="o">|</span>
+<span class="o">+-------------------------------+</span>
</pre></div>
</div>
</section>
@@ -6268,12 +6268,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id151">
<h4>Example<a class="headerlink" href="#id151" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_position([1, 2, 2, 3, 1, 4],
2);
-+----------------------------------------------+
-| array_position(List([1,2,2,3,1,4]),Int64(2)) |
-+----------------------------------------------+
-| 2 |
-+----------------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_position</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">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">1</span><span class="p">,</span> <span class="mi">4</span><span
class=" [...]
+<span class="o">+----------------------------------------------+</span>
+<span class="o">|</span> <span class="n">array_position</span><span
class="p">(</span><span class="n">List</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">2</span><span class="p">,</span><span
class="mi">3</span><span class="p">,</span><span class="mi">1</span><span
class="p">,</span><span class="mi">4</span><span class="p">]),</span><span
class="n">Int64</span><span class="p">(</span><span [...]
+<span class="o">+----------------------------------------------+</span>
+<span class="o">|</span> <span class="mi">2</span>
<span class="o">|</span>
+<span class="o">+----------------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -6302,12 +6302,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id154">
<h4>Example<a class="headerlink" href="#id154" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_positions([1, 2, 2, 3, 1,
4], 2);
-+-----------------------------------------------+
-| array_positions(List([1,2,2,3,1,4]),Int64(2)) |
-+-----------------------------------------------+
-| [2, 3] |
-+-----------------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_positions</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">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">1</span><span class="p">,</span> <span class="mi">4</span><span
class= [...]
+<span class="o">+-----------------------------------------------+</span>
+<span class="o">|</span> <span class="n">array_positions</span><span
class="p">(</span><span class="n">List</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">2</span><span class="p">,</span><span
class="mi">3</span><span class="p">,</span><span class="mi">1</span><span
class="p">,</span><span class="mi">4</span><span class="p">]),</span><span
class="n">Int64</span><span class="p">(</span><span [...]
+<span class="o">+-----------------------------------------------+</span>
+<span class="o">|</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="o">|</span>
+<span class="o">+-----------------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -6342,20 +6342,20 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id157">
<h4>Example<a class="headerlink" href="#id157" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_repeat(1, 3);
-+---------------------------------+
-| array_repeat(Int64(1),Int64(3)) |
-+---------------------------------+
-| [1, 1, 1] |
-+---------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_repeat</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="o">+---------------------------------+</span>
+<span class="o">|</span> <span class="n">array_repeat</span><span
class="p">(</span><span class="n">Int64</span><span class="p">(</span><span
class="mi">1</span><span class="p">),</span><span class="n">Int64</span><span
class="p">(</span><span class="mi">3</span><span class="p">))</span> <span
class="o">|</span>
+<span class="o">+---------------------------------+</span>
+<span class="o">|</span> <span class="p">[</span><span
class="mi">1</span><span class="p">,</span> <span class="mi">1</span><span
class="p">,</span> <span class="mi">1</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">+---------------------------------+</span>
</pre></div>
</div>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_repeat([1, 2], 2);
-+------------------------------------+
-| array_repeat(List([1,2]),Int64(2)) |
-+------------------------------------+
-| [[1, 2], [1, 2]] |
-+------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_repeat</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">2</span><span
class="p">);</span>
+<span class="o">+------------------------------------+</span>
+<span class="o">|</span> <span class="n">array_repeat</span><span
class="p">(</span><span class="n">List</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="n">Int64</span><span class="p">(</span><span
class="mi">2</span><span class="p">))</span> <span class="o">|</span>
+<span class="o">+------------------------------------+</span>
+<span class="o">|</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="p">[</span><span class="mi">1</span><span
class="p">,</span> <span class="mi">2</span><span class="p">]]</span>
<span class="o">|</span>
+<span class="o">+------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -6382,12 +6382,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id160">
<h4>Example<a class="headerlink" href="#id160" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_remove([1, 2, 2, 3, 2, 1,
4], 2);
-+----------------------------------------------+
-| array_remove(List([1,2,2,3,2,1,4]),Int64(2)) |
-+----------------------------------------------+
-| [1, 2, 3, 2, 1, 4] |
-+----------------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_remove</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">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">1</span><span
class="p" [...]
+<span class="o">+----------------------------------------------+</span>
+<span class="o">|</span> <span class="n">array_remove</span><span
class="p">(</span><span class="n">List</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">2</span><span class="p">,</span><span
class="mi">3</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">1</span><span class="p">,</span><span
class="mi">4</span><span class="p">]),</span><span class [...]
+<span class="o">+----------------------------------------------+</span>
+<span class="o">|</span> <span class="p">[</span><span
class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">1</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>
@@ -6415,12 +6415,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id163">
<h4>Example<a class="headerlink" href="#id163" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_remove_n([1, 2, 2, 3, 2, 1,
4], 2, 2);
-+---------------------------------------------------------+
-| array_remove_n(List([1,2,2,3,2,1,4]),Int64(2),Int64(2)) |
-+---------------------------------------------------------+
-| [1, 3, 2, 1, 4] |
-+---------------------------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_remove_n</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">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">1</span><span
class=" [...]
+<span
class="o">+---------------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">array_remove_n</span><span
class="p">(</span><span class="n">List</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">2</span><span class="p">,</span><span
class="mi">3</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">1</span><span class="p">,</span><span
class="mi">4</span><span class="p">]),</span><span cla [...]
+<span
class="o">+---------------------------------------------------------+</span>
+<span class="o">|</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="mi">2</span><span class="p">,</span> <span
class="mi">1</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>
@@ -6447,12 +6447,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id166">
<h4>Example<a class="headerlink" href="#id166" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_remove_all([1, 2, 2, 3, 2,
1, 4], 2);
-+--------------------------------------------------+
-| array_remove_all(List([1,2,2,3,2,1,4]),Int64(2)) |
-+--------------------------------------------------+
-| [1, 3, 1, 4] |
-+--------------------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_remove_all</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">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">1</span><span
class [...]
+<span class="o">+--------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">array_remove_all</span><span
class="p">(</span><span class="n">List</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">2</span><span class="p">,</span><span
class="mi">3</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">1</span><span class="p">,</span><span
class="mi">4</span><span class="p">]),</span><span c [...]
+<span class="o">+--------------------------------------------------+</span>
+<span class="o">|</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="mi">1</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>
@@ -6480,12 +6480,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id169">
<h4>Example<a class="headerlink" href="#id169" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_replace([1, 2, 2, 3, 2, 1,
4], 2, 5);
-+--------------------------------------------------------+
-| array_replace(List([1,2,2,3,2,1,4]),Int64(2),Int64(5)) |
-+--------------------------------------------------------+
-| [1, 5, 2, 3, 2, 1, 4] |
-+--------------------------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_replace</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">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">1</span><span
class="p [...]
+<span
class="o">+--------------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">array_replace</span><span
class="p">(</span><span class="n">List</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">2</span><span class="p">,</span><span
class="mi">3</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">1</span><span class="p">,</span><span
class="mi">4</span><span class="p">]),</span><span clas [...]
+<span
class="o">+--------------------------------------------------------+</span>
+<span class="o">|</span> <span class="p">[</span><span
class="mi">1</span><span class="p">,</span> <span class="mi">5</span><span
class="p">,</span> <span class="mi">2</span><span class="p">,</span> <span
class="mi">3</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">1</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>
@@ -6514,12 +6514,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id172">
<h4>Example<a class="headerlink" href="#id172" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_replace_n([1, 2, 2, 3, 2, 1,
4], 2, 5, 2);
-+-------------------------------------------------------------------+
-| array_replace_n(List([1,2,2,3,2,1,4]),Int64(2),Int64(5),Int64(2)) |
-+-------------------------------------------------------------------+
-| [1, 5, 5, 3, 2, 1, 4] |
-+-------------------------------------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_replace_n</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">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">1</span><span
class= [...]
+<span
class="o">+-------------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">array_replace_n</span><span
class="p">(</span><span class="n">List</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">2</span><span class="p">,</span><span
class="mi">3</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">1</span><span class="p">,</span><span
class="mi">4</span><span class="p">]),</span><span cl [...]
+<span
class="o">+-------------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="p">[</span><span
class="mi">1</span><span class="p">,</span> <span class="mi">5</span><span
class="p">,</span> <span class="mi">5</span><span class="p">,</span> <span
class="mi">3</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">1</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>
@@ -6547,12 +6547,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id175">
<h4>Example<a class="headerlink" href="#id175" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_replace_all([1, 2, 2, 3, 2,
1, 4], 2, 5);
-+------------------------------------------------------------+
-| array_replace_all(List([1,2,2,3,2,1,4]),Int64(2),Int64(5)) |
-+------------------------------------------------------------+
-| [1, 5, 5, 3, 5, 1, 4] |
-+------------------------------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_replace_all</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">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">1</span><span clas
[...]
+<span
class="o">+------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">array_replace_all</span><span
class="p">(</span><span class="n">List</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">2</span><span class="p">,</span><span
class="mi">3</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">1</span><span class="p">,</span><span
class="mi">4</span><span class="p">]),</span><span [...]
+<span
class="o">+------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="p">[</span><span
class="mi">1</span><span class="p">,</span> <span class="mi">5</span><span
class="p">,</span> <span class="mi">5</span><span class="p">,</span> <span
class="mi">3</span><span class="p">,</span> <span class="mi">5</span><span
class="p">,</span> <span class="mi">1</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>
@@ -6578,12 +6578,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id178">
<h4>Example<a class="headerlink" href="#id178" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_reverse([1, 2, 3, 4]);
-+------------------------------------------------------------+
-| array_reverse(List([1, 2, 3, 4])) |
-+------------------------------------------------------------+
-| [4, 3, 2, 1] |
-+------------------------------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_reverse</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">]);</span>
+<span
class="o">+------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">array_reverse</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">4</span><span class="p">]))</span> <span
class="o">|</span>
+<span
class="o">+------------------------------------------------------------+</span>
+<span class="o">|</span> <span class="p">[</span><span
class="mi">4</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">2</span><span class="p">,</span> <span
class="mi">1</span><span class="p">]</span>
<span class="o">|</span>
+<span
class="o">+------------------------------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -6614,12 +6614,12 @@ If negative, it counts backward from the end of the
array.</p></li>
</section>
<section id="id181">
<h4>Example<a class="headerlink" href="#id181" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_slice([1, 2, 3, 4, 5, 6, 7,
8], 3, 6);
-+--------------------------------------------------------+
-| array_slice(List([1,2,3,4,5,6,7,8]),Int64(3),Int64(6)) |
-+--------------------------------------------------------+
-| [3, 4, 5, 6] |
-+--------------------------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_slice</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">,</span> <span
class="mi">5</span><span class="p">,</span> <span class="mi">6</span><span
class="p"> [...]
+<span
class="o">+--------------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">array_slice</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">3</span><span class="p">,</span><span
class="mi">4</span><span class="p">,</span><span class="mi">5</span><span
class="p">,</span><span class="mi">6</span><span class="p">,</span><span
class="mi">7</span><span class="p">,</span><span class="m [...]
+<span
class="o">+--------------------------------------------------------+</span>
+<span class="o">|</span> <span class="p">[</span><span
class="mi">3</span><span class="p">,</span> <span class="mi">4</span><span
class="p">,</span> <span class="mi">5</span><span class="p">,</span> <span
class="mi">6</span><span class="p">]</span>
<span class="o">|</span>
+<span
class="o">+--------------------------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -6646,12 +6646,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id184">
<h4>Example<a class="headerlink" href="#id184" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_to_string([[1, 2, 3, 4], [5,
6, 7, 8]], ',');
-+----------------------------------------------------+
-| array_to_string(List([1,2,3,4,5,6,7,8]),Utf8(",")) |
-+----------------------------------------------------+
-| 1,2,3,4,5,6,7,8 |
-+----------------------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_to_string</span><span
class="p">([[</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">],</span> <span
class="p">[</span><span class="mi">5</span><span class="p">,</span> <span class
[...]
+<span class="o">+----------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">array_to_string</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">3</span><span class="p">,</span><span
class="mi">4</span><span class="p">,</span><span class="mi">5</span><span
class="p">,</span><span class="mi">6</span><span class="p">,</span><span
class="mi">7</span><span class="p">,</span><span clas [...]
+<span class="o">+----------------------------------------------------+</span>
+<span class="o">|</span> <span class="mi">1</span><span
class="p">,</span><span class="mi">2</span><span class="p">,</span><span
class="mi">3</span><span class="p">,</span><span class="mi">4</span><span
class="p">,</span><span class="mi">5</span><span class="p">,</span><span
class="mi">6</span><span class="p">,</span><span class="mi">7</span><span
class="p">,</span><span class="mi">8</span>
<span class="o">|</span>
+<span class="o">+----------------------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -6681,18 +6681,18 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id187">
<h4>Example<a class="headerlink" href="#id187" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_union([1, 2, 3, 4], [5, 6,
3, 4]);
-+----------------------------------------------------+
-| array_union([1, 2, 3, 4], [5, 6, 3, 4]); |
-+----------------------------------------------------+
-| [1, 2, 3, 4, 5, 6] |
-+----------------------------------------------------+
-❯ select array_union([1, 2, 3, 4], [5, 6, 7, 8]);
-+----------------------------------------------------+
-| array_union([1, 2, 3, 4], [5, 6, 7, 8]); |
-+----------------------------------------------------+
-| [1, 2, 3, 4, 5, 6, 7, 8] |
-+----------------------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_union</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">],</span> <span
class="p">[</span><span class="mi">5</span><span class="p">,</span> <span
class="mi" [...]
+<span class="o">+----------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">array_union</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">],</span> <span
class="p">[</span><span class="mi">5</span><span class="p">,</span> <span
class="mi">6</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span cl [...]
+<span class="o">+----------------------------------------------------+</span>
+<span class="o">|</span> <span class="p">[</span><span
class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">4</span><span class="p">,</span> <span class="mi">5</span><span
class="p">,</span> <span class="mi">6</span><span class="p">]</span>
<span class="o">|</span>
+<span class="o">+----------------------------------------------------+</span>
+<span class="o">></span> <span class="n">select</span> <span
class="n">array_union</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">4</span><span class="p">],</span> <span class="p">[</span><span
class="mi">5</span><span class="p">,</span> <span class="mi">6</span><span
class="p">,</span> <span class="mi">7</span><span class="p">,</span> [...]
+<span class="o">+----------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">array_union</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">],</span> <span
class="p">[</span><span class="mi">5</span><span class="p">,</span> <span
class="mi">6</span><span class="p">,</span> <span class="mi">7</span><span
class="p">,</span> <span class="mi">8</span><span cl [...]
+<span class="o">+----------------------------------------------------+</span>
+<span class="o">|</span> <span class="p">[</span><span
class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">4</span><span class="p">,</span> <span class="mi">5</span><span
class="p">,</span> <span class="mi">6</span><span class="p">,</span> <span
class="mi">7</span><span class="p">,</span> <span class="mi">8</span><span
class="p">]</span> <span class="o">|</span>
+<span class="o">+----------------------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -6721,18 +6721,18 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id190">
<h4>Example<a class="headerlink" href="#id190" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select array_except([1, 2, 3, 4], [5, 6,
3, 4]);
-+----------------------------------------------------+
-| array_except([1, 2, 3, 4], [5, 6, 3, 4]); |
-+----------------------------------------------------+
-| [1, 2] |
-+----------------------------------------------------+
-❯ select array_except([1, 2, 3, 4], [3, 4, 5, 6]);
-+----------------------------------------------------+
-| array_except([1, 2, 3, 4], [3, 4, 5, 6]); |
-+----------------------------------------------------+
-| [1, 2] |
-+----------------------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">array_except</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">],</span> <span
class="p">[</span><span class="mi">5</span><span class="p">,</span> <span
class="mi [...]
+<span class="o">+----------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">array_except</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">],</span> <span
class="p">[</span><span class="mi">5</span><span class="p">,</span> <span
class="mi">6</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span c [...]
+<span class="o">+----------------------------------------------------+</span>
+<span class="o">|</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="o">|</span>
+<span class="o">+----------------------------------------------------+</span>
+<span class="o">></span> <span class="n">select</span> <span
class="n">array_except</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">4</span><span class="p">],</span> <span class="p">[</span><span
class="mi">3</span><span class="p">,</span> <span class="mi">4</span><span
class="p">,</span> <span class="mi">5</span><span class="p">,</span> [...]
+<span class="o">+----------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">array_except</span><span
class="p">([</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">],</span> <span
class="p">[</span><span class="mi">3</span><span class="p">,</span> <span
class="mi">4</span><span class="p">,</span> <span class="mi">5</span><span
class="p">,</span> <span class="mi">6</span><span c [...]
+<span class="o">+----------------------------------------------------+</span>
+<span class="o">|</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="o">|</span>
+<span class="o">+----------------------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -6759,12 +6759,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id193">
<h4>Example<a class="headerlink" href="#id193" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select cardinality([[1, 2, 3, 4], [5, 6,
7, 8]]);
-+--------------------------------------+
-| cardinality(List([1,2,3,4,5,6,7,8])) |
-+--------------------------------------+
-| 8 |
-+--------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">cardinality</span><span
class="p">([[</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">],</span> <span
class="p">[</span><span class="mi">5</span><span class="p">,</span> <span
class="mi [...]
+<span class="o">+--------------------------------------+</span>
+<span class="o">|</span> <span class="n">cardinality</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">,</span><span class="mi">2</span><span
class="p">,</span><span class="mi">3</span><span class="p">,</span><span
class="mi">4</span><span class="p">,</span><span class="mi">5</span><span
class="p">,</span><span class="mi">6</span><span class="p">,</span><span
class="mi">7</span><span class="p">,</span><span class="m [...]
+<span class="o">+--------------------------------------+</span>
+<span class="o">|</span> <span class="mi">8</span>
<span class="o">|</span>
+<span class="o">+--------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -6784,12 +6784,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id195">
<h4>Example<a class="headerlink" href="#id195" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select empty([1]);
-+------------------+
-| empty(List([1])) |
-+------------------+
-| 0 |
-+------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">empty</span><span
class="p">([</span><span class="mi">1</span><span class="p">]);</span>
+<span class="o">+------------------+</span>
+<span class="o">|</span> <span class="n">empty</span><span
class="p">(</span><span class="n">List</span><span class="p">([</span><span
class="mi">1</span><span class="p">]))</span> <span class="o">|</span>
+<span class="o">+------------------+</span>
+<span class="o">|</span> <span class="mi">0</span> <span
class="o">|</span>
+<span class="o">+------------------+</span>
</pre></div>
</div>
</section>
@@ -6817,12 +6817,12 @@ Can be a constant, column, or function, and any
combination of array operators.<
</section>
<section id="id198">
<h4>Example<a class="headerlink" href="#id198" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select generate_series(1,3);
-+------------------------------------+
-| generate_series(Int64(1),Int64(3)) |
-+------------------------------------+
-| [1, 2, 3] |
-+------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">generate_series</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="o">+------------------------------------+</span>
+<span class="o">|</span> <span class="n">generate_series</span><span
class="p">(</span><span class="n">Int64</span><span class="p">(</span><span
class="mi">1</span><span class="p">),</span><span class="n">Int64</span><span
class="p">(</span><span class="mi">3</span><span class="p">))</span> <span
class="o">|</span>
+<span class="o">+------------------------------------+</span>
+<span class="o">|</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="o">|</span>
+<span class="o">+------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -6995,12 +6995,12 @@ string operators.</p></li>
</section>
<section id="id200">
<h4>Example<a class="headerlink" href="#id200" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select make_array(1, 2, 3, 4, 5);
-+----------------------------------------------------------+
-| make_array(Int64(1),Int64(2),Int64(3),Int64(4),Int64(5)) |
-+----------------------------------------------------------+
-| [1, 2, 3, 4, 5] |
-+----------------------------------------------------------+
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">make_array</span><span
class="p">(</span><span class="mi">1</span><span class="p">,</span> <span
class="mi">2</span><span class="p">,</span> <span class="mi">3</span><span
class="p">,</span> <span class="mi">4</span><span class="p">,</span> <span
class="mi">5</span><span class="p">);</span>
+<span
class="o">+----------------------------------------------------------+</span>
+<span class="o">|</span> <span class="n">make_array</span><span
class="p">(</span><span class="n">Int64</span><span class="p">(</span><span
class="mi">1</span><span class="p">),</span><span class="n">Int64</span><span
class="p">(</span><span class="mi">2</span><span class="p">),</span><span
class="n">Int64</span><span class="p">(</span><span class="mi">3</span><span
class="p">),</span><span class="n">Int64</span><span class="p">(</span><span
class="mi">4</span><span class="p">),</span><s [...]
+<span
class="o">+----------------------------------------------------------+</span>
+<span class="o">|</span> <span class="p">[</span><span
class="mi">1</span><span class="p">,</span> <span class="mi">2</span><span
class="p">,</span> <span class="mi">3</span><span class="p">,</span> <span
class="mi">4</span><span class="p">,</span> <span class="mi">5</span><span
class="p">]</span> <span
class="o">|</span>
+<span
class="o">+----------------------------------------------------------+</span>
</pre></div>
</div>
</section>
@@ -7122,7 +7122,7 @@ a struct type of fields <code class="docutils literal
notranslate"><span class="
+---+---+
-- use default names `c0`, `c1`
-❯ select struct(a, b) from t;
+> select struct(a, b) from t;
+-----------------+
| struct(t.a,t.b) |
+-----------------+
@@ -7318,17 +7318,17 @@ to cast to, as a string. The format is the same as that
returned by [<code class
</section>
<section id="id216">
<h4>Example<a class="headerlink" href="#id216" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select arrow_cast(-5, 'Int8') as
a,
- arrow_cast('foo', 'Dictionary(Int32, Utf8)') as b,
- arrow_cast('bar', 'LargeUtf8') as c,
- arrow_cast('2023-01-02T12:53:02', 'Timestamp(Microsecond,
Some("+08:00"))') as d
- ;
-+----+-----+-----+---------------------------+
-| a | b | c | d |
-+----+-----+-----+---------------------------+
-| -5 | foo | bar | 2023-01-02T12:53:02+08:00 |
-+----+-----+-----+---------------------------+
-1 row in set. Query took 0.001 seconds.
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">arrow_cast</span><span
class="p">(</span><span class="o">-</span><span class="mi">5</span><span
class="p">,</span> <span class="s1">'Int8'</span><span
class="p">)</span> <span class="k">as</span> <span class="n">a</span><span
class="p">,</span>
+ <span class="n">arrow_cast</span><span class="p">(</span><span
class="s1">'foo'</span><span class="p">,</span> <span
class="s1">'Dictionary(Int32, Utf8)'</span><span class="p">)</span>
<span class="k">as</span> <span class="n">b</span><span class="p">,</span>
+ <span class="n">arrow_cast</span><span class="p">(</span><span
class="s1">'bar'</span><span class="p">,</span> <span
class="s1">'LargeUtf8'</span><span class="p">)</span> <span
class="k">as</span> <span class="n">c</span><span class="p">,</span>
+ <span class="n">arrow_cast</span><span class="p">(</span><span
class="s1">'2023-01-02T12:53:02'</span><span class="p">,</span> <span
class="s1">'Timestamp(Microsecond,
Some("+08:00"))'</span><span class="p">)</span> <span
class="k">as</span> <span class="n">d</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="n">c</span>
<span class="o">|</span> <span class="n">d</span> <span
class="o">|</span>
+<span class="o">+----+-----+-----+---------------------------+</span>
+<span class="o">|</span> <span class="o">-</span><span class="mi">5</span>
<span class="o">|</span> <span class="n">foo</span> <span class="o">|</span>
<span class="n">bar</span> <span class="o">|</span> <span
class="mi">2023</span><span class="o">-</span><span class="mi">01</span><span
class="o">-</span><span class="mi">02</span><span class="n">T12</span><span
class="p">:</span><span class="mi">53</span><span class="p">:</span><span
class="mi">02</span><span class="o">+</span><span clas [...]
+<span class="o">+----+-----+-----+---------------------------+</span>
+<span class="mi">1</span> <span class="n">row</span> <span
class="ow">in</span> <span class="nb">set</span><span class="o">.</span> <span
class="n">Query</span> <span class="n">took</span> <span
class="mf">0.001</span> <span class="n">seconds</span><span class="o">.</span>
</pre></div>
</div>
</section>
@@ -7349,13 +7349,13 @@ string operators.</p></li>
</section>
<section id="id218">
<h4>Example<a class="headerlink" href="#id218" title="Link to this
heading">¶</a></h4>
-<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span>❯ select arrow_typeof('foo'),
arrow_typeof(1);
-+---------------------------+------------------------+
-| arrow_typeof(Utf8("foo")) | arrow_typeof(Int64(1)) |
-+---------------------------+------------------------+
-| Utf8 | Int64 |
-+---------------------------+------------------------+
-1 row in set. Query took 0.001 seconds.
+<div class="highlight-default notranslate"><div
class="highlight"><pre><span></span><span class="o">></span> <span
class="n">select</span> <span class="n">arrow_typeof</span><span
class="p">(</span><span class="s1">'foo'</span><span
class="p">),</span> <span class="n">arrow_typeof</span><span
class="p">(</span><span class="mi">1</span><span class="p">);</span>
+<span class="o">+---------------------------+------------------------+</span>
+<span class="o">|</span> <span class="n">arrow_typeof</span><span
class="p">(</span><span class="n">Utf8</span><span class="p">(</span><span
class="s2">"foo"</span><span class="p">))</span> <span
class="o">|</span> <span class="n">arrow_typeof</span><span
class="p">(</span><span class="n">Int64</span><span class="p">(</span><span
class="mi">1</span><span class="p">))</span> <span class="o">|</span>
+<span class="o">+---------------------------+------------------------+</span>
+<span class="o">|</span> <span class="n">Utf8</span>
<span class="o">|</span> <span class="n">Int64</span> <span
class="o">|</span>
+<span class="o">+---------------------------+------------------------+</span>
+<span class="mi">1</span> <span class="n">row</span> <span
class="ow">in</span> <span class="nb">set</span><span class="o">.</span> <span
class="n">Query</span> <span class="n">took</span> <span
class="mf">0.001</span> <span class="n">seconds</span><span class="o">.</span>
</pre></div>
</div>
</section>
