This is an automated email from the ASF dual-hosted git repository.
alamb pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/arrow-datafusion.git
The following commit(s) were added to refs/heads/main by this push:
new feb9100432 fix#9501 (#10028)
feb9100432 is described below
commit feb9100432d453f19d40428265d2aa9a9f942d5d
Author: colommar <[email protected]>
AuthorDate: Fri Apr 12 02:55:25 2024 +0800
fix#9501 (#10028)
---
benchmarks/queries/clickbench/README.md | 4 +-
datafusion-cli/src/exec.rs | 2 +-
.../datasource/physical_plan/parquet/row_groups.rs | 2 +-
datafusion/expr/src/logical_plan/plan.rs | 2 +-
datafusion/optimizer/README.md | 10 +-
docs/source/library-user-guide/adding-udfs.md | 2 +-
docs/source/user-guide/cli.md | 20 ++--
docs/source/user-guide/example-usage.md | 2 +-
docs/source/user-guide/sql/scalar_functions.md | 102 ++++++++++-----------
9 files changed, 73 insertions(+), 73 deletions(-)
diff --git a/benchmarks/queries/clickbench/README.md
b/benchmarks/queries/clickbench/README.md
index ef540ccf9c..29b1a7588f 100644
--- a/benchmarks/queries/clickbench/README.md
+++ b/benchmarks/queries/clickbench/README.md
@@ -63,7 +63,7 @@ LIMIT 10;
Here are some interesting statistics about the data used in the queries
Max length of `"SearchPhrase"` is 1113 characters
```sql
-❯ select min(length("SearchPhrase")) as "SearchPhrase_len_min",
max(length("SearchPhrase")) "SearchPhrase_len_max" from 'hits.parquet' limit 10;
+> select min(length("SearchPhrase")) as "SearchPhrase_len_min",
max(length("SearchPhrase")) "SearchPhrase_len_max" from 'hits.parquet' limit 10;
+----------------------+----------------------+
| SearchPhrase_len_min | SearchPhrase_len_max |
+----------------------+----------------------+
@@ -74,7 +74,7 @@ Max length of `"SearchPhrase"` is 1113 characters
Here is the schema of the data
```sql
-❯ describe 'hits.parquet';
+> describe 'hits.parquet';
+-----------------------+-----------+-------------+
| column_name | data_type | is_nullable |
+-----------------------+-----------+-------------+
diff --git a/datafusion-cli/src/exec.rs b/datafusion-cli/src/exec.rs
index be7e5275e8..2072cc7df0 100644
--- a/datafusion-cli/src/exec.rs
+++ b/datafusion-cli/src/exec.rs
@@ -131,7 +131,7 @@ pub async fn exec_from_repl(
rl.load_history(".history").ok();
loop {
- match rl.readline("❯ ") {
+ match rl.readline("> ") {
Ok(line) if line.starts_with('\\') => {
rl.add_history_entry(line.trim_end())?;
let command =
line.split_whitespace().collect::<Vec<_>>().join(" ");
diff --git a/datafusion/core/src/datasource/physical_plan/parquet/row_groups.rs
b/datafusion/core/src/datasource/physical_plan/parquet/row_groups.rs
index 2b96659548..a4dfd9b968 100644
--- a/datafusion/core/src/datasource/physical_plan/parquet/row_groups.rs
+++ b/datafusion/core/src/datasource/physical_plan/parquet/row_groups.rs
@@ -1212,7 +1212,7 @@ mod tests {
/// Return a test for data_index_bloom_encoding_stats.parquet
/// Note the values in the `String` column are:
/// ```sql
- /// ❯ select * from
'./parquet-testing/data/data_index_bloom_encoding_stats.parquet';
+ /// > select * from
'./parquet-testing/data/data_index_bloom_encoding_stats.parquet';
/// +-----------+
/// | String |
/// +-----------+
diff --git a/datafusion/expr/src/logical_plan/plan.rs
b/datafusion/expr/src/logical_plan/plan.rs
index d16dfb1403..cb8c97c71e 100644
--- a/datafusion/expr/src/logical_plan/plan.rs
+++ b/datafusion/expr/src/logical_plan/plan.rs
@@ -2127,7 +2127,7 @@ pub struct Prepare {
/// # Example output:
///
/// ```sql
-/// ❯ describe traces;
+/// > describe traces;
/// +--------------------+-----------------------------+-------------+
/// | column_name | data_type | is_nullable |
/// +--------------------+-----------------------------+-------------+
diff --git a/datafusion/optimizer/README.md b/datafusion/optimizer/README.md
index 4f9e0fb985..b0f4c5a720 100644
--- a/datafusion/optimizer/README.md
+++ b/datafusion/optimizer/README.md
@@ -104,7 +104,7 @@ Every expression in DataFusion has a name, which is used as
the column name. For
contains a single column with the name `"COUNT(aggregate_test_100.c9)"`:
```text
-❯ select count(c9) from aggregate_test_100;
+> select count(c9) from aggregate_test_100;
+------------------------------+
| COUNT(aggregate_test_100.c9) |
+------------------------------+
@@ -116,7 +116,7 @@ These names are used to refer to the columns in both
subqueries as well as inter
to another. For example:
```text
-❯ select "COUNT(aggregate_test_100.c9)" + 1 from (select count(c9) from
aggregate_test_100) as sq;
+> select "COUNT(aggregate_test_100.c9)" + 1 from (select count(c9) from
aggregate_test_100) as sq;
+--------------------------------------------+
| sq.COUNT(aggregate_test_100.c9) + Int64(1) |
+--------------------------------------------+
@@ -134,7 +134,7 @@ Here is a simple example of such a rewrite. The expression
`1 + 2` can be intern
displayed the same as `1 + 2`:
```text
-❯ select 1 + 2;
+> select 1 + 2;
+---------------------+
| Int64(1) + Int64(2) |
+---------------------+
@@ -146,7 +146,7 @@ Looking at the `EXPLAIN` output we can see that the
optimizer has effectively re
`3 as "1 + 2"`:
```text
-❯ explain select 1 + 2;
+> explain select 1 + 2;
+---------------+-------------------------------------------------+
| plan_type | plan |
+---------------+-------------------------------------------------+
@@ -289,7 +289,7 @@ The `EXPLAIN VERBOSE` command can be used to show the
effect of each optimizatio
In the following example, the `type_coercion` and `simplify_expressions`
passes have simplified the plan so that it returns the constant `"3.2"` rather
than doing a computation at execution time.
```text
-❯ explain verbose select cast(1 + 2.2 as string) as foo;
+> explain verbose select cast(1 + 2.2 as string) as foo;
+------------------------------------------------------------+---------------------------------------------------------------------------+
| plan_type | plan
|
+------------------------------------------------------------+---------------------------------------------------------------------------+
diff --git a/docs/source/library-user-guide/adding-udfs.md
b/docs/source/library-user-guide/adding-udfs.md
index ad21072410..653c1f9d37 100644
--- a/docs/source/library-user-guide/adding-udfs.md
+++ b/docs/source/library-user-guide/adding-udfs.md
@@ -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/docs/source/user-guide/cli.md b/docs/source/user-guide/cli.md
index da4c987054..9c3fc8bd60 100644
--- a/docs/source/user-guide/cli.md
+++ b/docs/source/user-guide/cli.md
@@ -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/docs/source/user-guide/example-usage.md
b/docs/source/user-guide/example-usage.md
index 31b599ac33..6e4bf68fa0 100644
--- a/docs/source/user-guide/example-usage.md
+++ b/docs/source/user-guide/example-usage.md
@@ -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/docs/source/user-guide/sql/scalar_functions.md
b/docs/source/user-guide/sql/scalar_functions.md
index 62b81ea7ea..217bd5f05a 100644
--- a/docs/source/user-guide/sql/scalar_functions.md
+++ b/docs/source/user-guide/sql/scalar_functions.md
@@ -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)) |
+---------------------------+------------------------+
