This is an automated email from the ASF dual-hosted git repository.
jiafengzheng pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new 019e67cf21 remove array function
019e67cf21 is described below
commit 019e67cf215a75056c7ef5513036ac22a9a91bd8
Author: jiafeng.zhang <[email protected]>
AuthorDate: Thu Jul 21 10:26:50 2022 +0800
remove array function
remove array function
---
.../sql-functions/array-functions/array_avg.md | 61 ----------------
.../array-functions/array_contains.md | 65 -----------------
.../sql-functions/array-functions/array_max.md | 61 ----------------
.../sql-functions/array-functions/array_min.md | 61 ----------------
.../array-functions/array_position.md | 65 -----------------
.../sql-functions/array-functions/array_product.md | 61 ----------------
.../sql-functions/array-functions/array_sum.md | 61 ----------------
.../sql-functions/array-functions/element_at.md | 81 ----------------------
.../sql-functions/array-functions/size.md | 70 -------------------
.../sql-functions/array-functions/array_avg.md | 60 ----------------
.../array-functions/array_contains.md | 65 -----------------
.../sql-functions/array-functions/array_max.md | 60 ----------------
.../sql-functions/array-functions/array_min.md | 60 ----------------
.../array-functions/array_position.md | 65 -----------------
.../sql-functions/array-functions/array_product.md | 60 ----------------
.../sql-functions/array-functions/array_sum.md | 60 ----------------
.../sql-functions/array-functions/element_at.md | 81 ----------------------
.../sql-functions/array-functions/size.md | 70 -------------------
18 files changed, 1167 deletions(-)
diff --git a/docs/sql-manual/sql-functions/array-functions/array_avg.md
b/docs/sql-manual/sql-functions/array-functions/array_avg.md
deleted file mode 100644
index 0b47f51461..0000000000
--- a/docs/sql-manual/sql-functions/array-functions/array_avg.md
+++ /dev/null
@@ -1,61 +0,0 @@
----
-{
- "title": "ARRAY_AVG Function",
- "language": "en"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## ARRAY_AVG
-
-### Name
-
-ARRAY_AVG
-
-### description
-
-Get the average of all elements in an array (`NULL` values are skipped).
-When the array is empty or all elements in the array are `NULL` values, the
function returns `NULL`.
-
-### example
-
-```shell
-mysql> create table array_type_table(k1 INT, k2 Array<int>) duplicate key (k1)
- -> distributed by hash(k1) buckets 1 properties('replication_num' = '1');
-mysql> insert into array_type_table values (0, []), (1, [NULL]), (2, [1, 2,
3]), (3, [1, NULL, 3]);
-mysql> set enable_vectorized_engine = true; # enable vectorized engine
-mysql> select k2, array_avg(k2) from array_type_table;
-+--------------+-----------------+
-| k2 | array_avg(`k2`) |
-+--------------+-----------------+
-| [] | NULL |
-| [NULL] | NULL |
-| [1, 2, 3] | 2 |
-| [1, NULL, 3] | 2 |
-+--------------+-----------------+
-4 rows in set (0.01 sec)
-
-```
-
-### keywords
-
-ARRAY_AVG
-
diff --git a/docs/sql-manual/sql-functions/array-functions/array_contains.md
b/docs/sql-manual/sql-functions/array-functions/array_contains.md
deleted file mode 100644
index 57091a57ed..0000000000
--- a/docs/sql-manual/sql-functions/array-functions/array_contains.md
+++ /dev/null
@@ -1,65 +0,0 @@
----
-{
- "title": "array_contains",
- "language": "en"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## array_contains
-
-### description
-
-#### Syntax
-
-`BOOLEAN array_contains(ARRAY<T> arr, T value)`
-
-Check if a value presents in an array column. Return below values:
-
-```
-1 - if value presents in an array;
-0 - if value does not present in an array;
-NULL - when array is NULL;
-```
-
-### notice
-
-`Only supported in vectorized engine`
-
-### example
-
-```
-mysql> set enable_vectorized_engine=true;
-
-mysql> SELECT id,c_array,array_contains(c_array, 5) FROM `array_test`;
-+------+-----------------+------------------------------+
-| id | c_array | array_contains(`c_array`, 5) |
-+------+-----------------+------------------------------+
-| 1 | [1, 2, 3, 4, 5] | 1 |
-| 2 | [6, 7, 8] | 0 |
-| 3 | [] | 0 |
-| 4 | NULL | NULL |
-+------+-----------------+------------------------------+
-```
-
-### keywords
-
-ARRAY_CONTAINS
diff --git a/docs/sql-manual/sql-functions/array-functions/array_max.md
b/docs/sql-manual/sql-functions/array-functions/array_max.md
deleted file mode 100644
index 68dafcf2b3..0000000000
--- a/docs/sql-manual/sql-functions/array-functions/array_max.md
+++ /dev/null
@@ -1,61 +0,0 @@
----
-{
- "title": "ARRAY_MAX Function",
- "language": "en"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## ARRAY_MAX
-
-### Name
-
-ARRAY_MAX
-
-### description
-
-Get the maximum element in an array (`NULL` values are skipped).
-When the array is empty or all elements in the array are `NULL` values, the
function returns `NULL`.
-
-### example
-
-```shell
-mysql> create table array_type_table(k1 INT, k2 Array<int>) duplicate key (k1)
- -> distributed by hash(k1) buckets 1 properties('replication_num' = '1');
-mysql> insert into array_type_table values (0, []), (1, [NULL]), (2, [1, 2,
3]), (3, [1, NULL, 3]);
-mysql> set enable_vectorized_engine = true; # enable vectorized engine
-mysql> select k2, array_max(k2) from array_type_table;
-+--------------+-----------------+
-| k2 | array_max(`k2`) |
-+--------------+-----------------+
-| [] | NULL |
-| [NULL] | NULL |
-| [1, 2, 3] | 3 |
-| [1, NULL, 3] | 3 |
-+--------------+-----------------+
-4 rows in set (0.02 sec)
-
-```
-
-### keywords
-
-ARRAY_MAX
-
diff --git a/docs/sql-manual/sql-functions/array-functions/array_min.md
b/docs/sql-manual/sql-functions/array-functions/array_min.md
deleted file mode 100644
index 935992f26f..0000000000
--- a/docs/sql-manual/sql-functions/array-functions/array_min.md
+++ /dev/null
@@ -1,61 +0,0 @@
----
-{
- "title": "ARRAY_MIN Function",
- "language": "en"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## ARRAY_MIN
-
-### Name
-
-ARRAY_MIN
-
-### description
-
-Get the minimum element in an array (`NULL` values are skipped).
-When the array is empty or all elements in the array are `NULL` values, the
function returns `NULL`.
-
-### example
-
-```shell
-mysql> create table array_type_table(k1 INT, k2 Array<int>) duplicate key (k1)
- -> distributed by hash(k1) buckets 1 properties('replication_num' = '1');
-mysql> insert into array_type_table values (0, []), (1, [NULL]), (2, [1, 2,
3]), (3, [1, NULL, 3]);
-mysql> set enable_vectorized_engine = true; # enable vectorized engine
-mysql> select k2, array_min(k2) from array_type_table;
-+--------------+-----------------+
-| k2 | array_min(`k2`) |
-+--------------+-----------------+
-| [] | NULL |
-| [NULL] | NULL |
-| [1, 2, 3] | 1 |
-| [1, NULL, 3] | 1 |
-+--------------+-----------------+
-4 rows in set (0.02 sec)
-
-```
-
-### keywords
-
-ARRAY_MIN
-
diff --git a/docs/sql-manual/sql-functions/array-functions/array_position.md
b/docs/sql-manual/sql-functions/array-functions/array_position.md
deleted file mode 100644
index dd47628c27..0000000000
--- a/docs/sql-manual/sql-functions/array-functions/array_position.md
+++ /dev/null
@@ -1,65 +0,0 @@
----
-{
- "title": "array_position",
- "language": "en"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## array_position
-
-### description
-
-#### Syntax
-
-`BIGINT array_position(ARRAY<T> arr, T value)`
-
-Returns a position/index of first occurrence of the `value` in the given array.
-
-```
-position - value position in array (starts with 1);
-0 - if value does not present in the array;
-NULL - when array is NULL or value is NULL.
-```
-
-### notice
-
-`Only supported in vectorized engine`
-
-### example
-
-```
-mysql> set enable_vectorized_engine=true;
-
-mysql> SELECT id,c_array,array_position(c_array, 5) FROM `array_test`;
-+------+-----------------+------------------------------+
-| id | c_array | array_position(`c_array`, 5) |
-+------+-----------------+------------------------------+
-| 1 | [1, 2, 3, 4, 5] | 5 |
-| 2 | [6, 7, 8] | 0 |
-| 3 | [] | 0 |
-| 4 | NULL | NULL |
-+------+-----------------+------------------------------+
-```
-
-### keywords
-
-ARRAY_POSITION
diff --git a/docs/sql-manual/sql-functions/array-functions/array_product.md
b/docs/sql-manual/sql-functions/array-functions/array_product.md
deleted file mode 100644
index 18c9896dd0..0000000000
--- a/docs/sql-manual/sql-functions/array-functions/array_product.md
+++ /dev/null
@@ -1,61 +0,0 @@
----
-{
- "title": "ARRAY_PRODUCT Function",
- "language": "en"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## ARRAY_PRODUCT
-
-### Name
-
-ARRAY_PRODUCT
-
-### description
-
-Get the product of all elements in an array (`NULL` values are skipped).
-When the array is empty or all elements in the array are `NULL` values, the
function returns `NULL`.
-
-### example
-
-```shell
-mysql> create table array_type_table(k1 INT, k2 Array<int>) duplicate key (k1)
- -> distributed by hash(k1) buckets 1 properties('replication_num' = '1');
-mysql> insert into array_type_table values (0, []), (1, [NULL]), (2, [1, 2,
3]), (3, [1, NULL, 3]);
-mysql> set enable_vectorized_engine = true; # enable vectorized engine
-mysql> select k2, array_product(k2) from array_type_table;
-+--------------+---------------------+
-| k2 | array_product(`k2`) |
-+--------------+---------------------+
-| [] | NULL |
-| [NULL] | NULL |
-| [1, 2, 3] | 6 |
-| [1, NULL, 3] | 3 |
-+--------------+---------------------+
-4 rows in set (0.01 sec)
-
-```
-
-### keywords
-
-ARRAY_PRODUCT
-
diff --git a/docs/sql-manual/sql-functions/array-functions/array_sum.md
b/docs/sql-manual/sql-functions/array-functions/array_sum.md
deleted file mode 100644
index af0316bbcc..0000000000
--- a/docs/sql-manual/sql-functions/array-functions/array_sum.md
+++ /dev/null
@@ -1,61 +0,0 @@
----
-{
- "title": "ARRAY_SUM Function",
- "language": "en"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## ARRAY_SUM
-
-### Name
-
-ARRAY_SUM
-
-### description
-
-Get the sum of all elements in an array (`NULL` values are skipped).
-When the array is empty or all elements in the array are `NULL` values, the
function returns `NULL`.
-
-### example
-
-```shell
-mysql> create table array_type_table(k1 INT, k2 Array<int>) duplicate key (k1)
- -> distributed by hash(k1) buckets 1 properties('replication_num' = '1');
-mysql> insert into array_type_table values (0, []), (1, [NULL]), (2, [1, 2,
3]), (3, [1, NULL, 3]);
-mysql> set enable_vectorized_engine = true; # enable vectorized engine
-mysql> select k2, array_sum(k2) from array_type_table;
-+--------------+-----------------+
-| k2 | array_sum(`k2`) |
-+--------------+-----------------+
-| [] | NULL |
-| [NULL] | NULL |
-| [1, 2, 3] | 6 |
-| [1, NULL, 3] | 4 |
-+--------------+-----------------+
-4 rows in set (0.01 sec)
-
-```
-
-### keywords
-
-ARRAY_SUM
-
diff --git a/docs/sql-manual/sql-functions/array-functions/element_at.md
b/docs/sql-manual/sql-functions/array-functions/element_at.md
deleted file mode 100644
index 34e083d5d7..0000000000
--- a/docs/sql-manual/sql-functions/array-functions/element_at.md
+++ /dev/null
@@ -1,81 +0,0 @@
----
-{
- "title": "element_at",
- "language": "en"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## element_at
-
-### description
-
-#### Syntax
-
-`T element_at(ARRAY<T> arr, BIGINT position)`
-
-`T arr[position]`
-
-Returns an element of an array located at the input position. If there is no
element at the position, return NULL.
-
-`position` is 1-based and support negtive number.
-
-### notice
-
-`Only supported in vectorized engine`
-
-### example
-
-positive `position` example:
-
-```
-mysql> set enable_vectorized_engine=true;
-
-mysql> SELECT id,c_array,element_at(c_array, 5) FROM `array_test`;
-+------+-----------------+--------------------------+
-| id | c_array | element_at(`c_array`, 5) |
-+------+-----------------+--------------------------+
-| 1 | [1, 2, 3, 4, 5] | 5 |
-| 2 | [6, 7, 8] | NULL |
-| 3 | [] | NULL |
-| 4 | NULL | NULL |
-+------+-----------------+--------------------------+
-```
-
-negtive `position` example:
-
-```
-mysql> set enable_vectorized_engine=true;
-
-mysql> SELECT id,c_array,c_array[-2] FROM `array_test`;
-+------+-----------------+----------------------------------+
-| id | c_array | %element_extract%(`c_array`, -2) |
-+------+-----------------+----------------------------------+
-| 1 | [1, 2, 3, 4, 5] | 4 |
-| 2 | [6, 7, 8] | 7 |
-| 3 | [] | NULL |
-| 4 | NULL | NULL |
-+------+-----------------+----------------------------------+
-```
-
-### keywords
-
-ELEMENT_AT, SUBSCRIPT
diff --git a/docs/sql-manual/sql-functions/array-functions/size.md
b/docs/sql-manual/sql-functions/array-functions/size.md
deleted file mode 100644
index 8642edb9ff..0000000000
--- a/docs/sql-manual/sql-functions/array-functions/size.md
+++ /dev/null
@@ -1,70 +0,0 @@
----
-{
- "title": "size",
- "language": "en"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## size (cardinality)
-
-### description
-
-#### Syntax
-
-```
-BIGINT size(ARRAY<T> arr)
-BIGINT cardinality(ARRAY<T> arr)
-```
-
-Returns the size of the array, returns NULL for NULL input.
-
-### notice
-
-`Only supported in vectorized engine`
-
-### example
-
-```
-mysql> set enable_vectorized_engine=true;
-
-mysql> select k1,k2,size(k2) from array_test;
-+------+-----------+------------+
-| k1 | k2 | size(`k2`) |
-+------+-----------+------------+
-| 1 | [1, 2, 3] | 3 |
-| 2 | [] | 0 |
-| 3 | NULL | NULL |
-+------+-----------+------------+
-
-mysql> select k1,k2,cardinality(k2) from array_test;
-+------+-----------+-------------------+
-| k1 | k2 | cardinality(`k2`) |
-+------+-----------+-------------------+
-| 1 | [1, 2, 3] | 3 |
-| 2 | [] | 0 |
-| 3 | NULL | NULL |
-+------+-----------+-------------------+
-```
-
-### keywords
-
-SIZE, CARDINALITY
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/array_avg.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/array_avg.md
deleted file mode 100644
index 39ab60fe18..0000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/array_avg.md
+++ /dev/null
@@ -1,60 +0,0 @@
----
-{
- "title": "ARRAY_AVG 函数",
- "language": "zh-CN"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## ARRAY_AVG
-
-### Name
-
-ARRAY_AVG
-
-### description
-
-返回数组中所有元素的平均值，数组中的`NULL`值会被跳过。空数组以及元素全为`NULL`值的数组，结果返回`NULL`值。
-
-### example
-
-```shell
-mysql> create table array_type_table(k1 INT, k2 Array<int>) duplicate key (k1)
- -> distributed by hash(k1) buckets 1 properties('replication_num' = '1');
-mysql> insert into array_type_table values (0, []), (1, [NULL]), (2, [1, 2,
3]), (3, [1, NULL, 3]);
-mysql> set enable_vectorized_engine = true; # enable vectorized engine
-mysql> select k2, array_avg(k2) from array_type_table;
-+--------------+-----------------+
-| k2 | array_avg(`k2`) |
-+--------------+-----------------+
-| [] | NULL |
-| [NULL] | NULL |
-| [1, 2, 3] | 2 |
-| [1, NULL, 3] | 2 |
-+--------------+-----------------+
-4 rows in set (0.01 sec)
-
-```
-
-### keywords
-
-ARRAY_AVG
-
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/array_contains.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/array_contains.md
deleted file mode 100644
index 8cf1fd52bd..0000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/array_contains.md
+++ /dev/null
@@ -1,65 +0,0 @@
----
-{
- "title": "array_contains",
- "language": "zh-CN"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## array_contains
-
-### description
-
-#### Syntax
-
-`BOOLEAN array_contains(ARRAY<T> arr, T value)`
-
-判断数组中是否包含value。返回结果如下：
-
-```
-1 - value在数组arr中存在；
-0 - value不存在数组arr中；
-NULL - arr为NULL时。
-```
-
-### notice
-
-`仅支持向量化引擎中使用`
-
-### example
-
-```
-mysql> set enable_vectorized_engine=true;
-
-mysql> SELECT id,c_array,array_contains(c_array, 5) FROM `array_test`;
-+------+-----------------+------------------------------+
-| id | c_array | array_contains(`c_array`, 5) |
-+------+-----------------+------------------------------+
-| 1 | [1, 2, 3, 4, 5] | 1 |
-| 2 | [6, 7, 8] | 0 |
-| 3 | [] | 0 |
-| 4 | NULL | NULL |
-+------+-----------------+------------------------------+
-```
-
-### keywords
-
-ARRAY_CONTAINS
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/array_max.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/array_max.md
deleted file mode 100644
index c112eda8d9..0000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/array_max.md
+++ /dev/null
@@ -1,60 +0,0 @@
----
-{
- "title": "ARRAY_MAX 函数",
- "language": "zh-CN"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## ARRAY_MAX
-
-### Name
-
-ARRAY_MAX
-
-### description
-
-返回数组中最大的元素，数组中的`NULL`值会被跳过。空数组以及元素全为`NULL`值的数组，结果返回`NULL`值。
-
-### example
-
-```shell
-mysql> create table array_type_table(k1 INT, k2 Array<int>) duplicate key (k1)
- -> distributed by hash(k1) buckets 1 properties('replication_num' = '1');
-mysql> insert into array_type_table values (0, []), (1, [NULL]), (2, [1, 2,
3]), (3, [1, NULL, 3]);
-mysql> set enable_vectorized_engine = true; # enable vectorized engine
-mysql> select k2, array_max(k2) from array_type_table;
-+--------------+-----------------+
-| k2 | array_max(`k2`) |
-+--------------+-----------------+
-| [] | NULL |
-| [NULL] | NULL |
-| [1, 2, 3] | 3 |
-| [1, NULL, 3] | 3 |
-+--------------+-----------------+
-4 rows in set (0.02 sec)
-
-```
-
-### keywords
-
-ARRAY_MAX
-
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/array_min.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/array_min.md
deleted file mode 100644
index 1681d681f5..0000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/array_min.md
+++ /dev/null
@@ -1,60 +0,0 @@
----
-{
- "title": "ARRAY_MIN 函数",
- "language": "zh-CN"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## ARRAY_MIN
-
-### Name
-
-ARRAY_MIN
-
-### description
-
-返回数组中最小的元素，数组中的`NULL`值会被跳过。空数组以及元素全为`NULL`值的数组，结果返回`NULL`值。
-
-### example
-
-```shell
-mysql> create table array_type_table(k1 INT, k2 Array<int>) duplicate key (k1)
- -> distributed by hash(k1) buckets 1 properties('replication_num' = '1');
-mysql> insert into array_type_table values (0, []), (1, [NULL]), (2, [1, 2,
3]), (3, [1, NULL, 3]);
-mysql> set enable_vectorized_engine = true; # enable vectorized engine
-mysql> select k2, array_min(k2) from array_type_table;
-+--------------+-----------------+
-| k2 | array_min(`k2`) |
-+--------------+-----------------+
-| [] | NULL |
-| [NULL] | NULL |
-| [1, 2, 3] | 1 |
-| [1, NULL, 3] | 1 |
-+--------------+-----------------+
-4 rows in set (0.02 sec)
-
-```
-
-### keywords
-
-ARRAY_MIN
-
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/array_position.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/array_position.md
deleted file mode 100644
index bce5f3a5c7..0000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/array_position.md
+++ /dev/null
@@ -1,65 +0,0 @@
----
-{
- "title": "array_position",
- "language": "zh-CN"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## array_position
-
-### description
-
-#### Syntax
-
-`BIGINT array_position(ARRAY<T> arr, T value)`
-
-返回`value`在数组中第一次出现的位置/索引。
-
-```
-position - value在array中的位置（从1开始计算）；
-0 - 如果value在array中不存在；
-NULL - 如果数组为NULL，或者value为NULL。
-```
-
-### notice
-
-`仅支持向量化引擎中使用`
-
-### example
-
-```
-mysql> set enable_vectorized_engine=true;
-
-mysql> SELECT id,c_array,array_position(c_array, 5) FROM `array_test`;
-+------+-----------------+------------------------------+
-| id | c_array | array_position(`c_array`, 5) |
-+------+-----------------+------------------------------+
-| 1 | [1, 2, 3, 4, 5] | 5 |
-| 2 | [6, 7, 8] | 0 |
-| 3 | [] | 0 |
-| 4 | NULL | NULL |
-+------+-----------------+------------------------------+
-```
-
-### keywords
-
-ARRAY_POSITION
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/array_product.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/array_product.md
deleted file mode 100644
index a2e5e510a3..0000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/array_product.md
+++ /dev/null
@@ -1,60 +0,0 @@
----
-{
- "title": "ARRAY_PRODUCT 函数",
- "language": "zh-CN"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## ARRAY_PRODUCT
-
-### Name
-
-ARRAY_PRODUCT
-
-### description
-
-返回数组中所有元素的乘积，数组中的`NULL`值会被跳过。空数组以及元素全为`NULL`值的数组，结果返回`NULL`值。
-
-### example
-
-```shell
-mysql> create table array_type_table(k1 INT, k2 Array<int>) duplicate key (k1)
- -> distributed by hash(k1) buckets 1 properties('replication_num' = '1');
-mysql> insert into array_type_table values (0, []), (1, [NULL]), (2, [1, 2,
3]), (3, [1, NULL, 3]);
-mysql> set enable_vectorized_engine = true; # enable vectorized engine
-mysql> select k2, array_product(k2) from array_type_table;
-+--------------+---------------------+
-| k2 | array_product(`k2`) |
-+--------------+---------------------+
-| [] | NULL |
-| [NULL] | NULL |
-| [1, 2, 3] | 6 |
-| [1, NULL, 3] | 3 |
-+--------------+---------------------+
-4 rows in set (0.01 sec)
-
-```
-
-### keywords
-
-ARRAY_PRODUCT
-
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/array_sum.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/array_sum.md
deleted file mode 100644
index c84b83261c..0000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/array_sum.md
+++ /dev/null
@@ -1,60 +0,0 @@
----
-{
- "title": "ARRAY_SUM 函数",
- "language": "zh-CN"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## ARRAY_SUM
-
-### Name
-
-ARRAY_SUM
-
-### description
-
-返回数组中所有元素之和，数组中的`NULL`值会被跳过。空数组以及元素全为`NULL`值的数组，结果返回`NULL`值。
-
-### example
-
-```shell
-mysql> create table array_type_table(k1 INT, k2 Array<int>) duplicate key (k1)
- -> distributed by hash(k1) buckets 1 properties('replication_num' = '1');
-mysql> insert into array_type_table values (0, []), (1, [NULL]), (2, [1, 2,
3]), (3, [1, NULL, 3]);
-mysql> set enable_vectorized_engine = true; # enable vectorized engine
-mysql> select k2, array_sum(k2) from array_type_table;
-+--------------+-----------------+
-| k2 | array_sum(`k2`) |
-+--------------+-----------------+
-| [] | NULL |
-| [NULL] | NULL |
-| [1, 2, 3] | 6 |
-| [1, NULL, 3] | 4 |
-+--------------+-----------------+
-4 rows in set (0.01 sec)
-
-```
-
-### keywords
-
-ARRAY_SUM
-
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/element_at.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/element_at.md
deleted file mode 100644
index 873524a4e9..0000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/element_at.md
+++ /dev/null
@@ -1,81 +0,0 @@
----
-{
- "title": "element_at",
- "language": "zh-CN"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## element_at
-
-### description
-
-#### Syntax
-
-`T element_at(ARRAY<T> arr, BIGINT position)`
-
-`T arr[position]`
-
-返回数组中位置为 `position` 的元素。如果该位置上元素不存在，返回NULL。
-
-`position` 从1开始，并且支持负数。
-
-### notice
-
-`仅支持向量化引擎中使用`
-
-### example
-
-`position` 为正数使用范例:
-
-```
-mysql> set enable_vectorized_engine=true;
-
-mysql> SELECT id,c_array,element_at(c_array, 5) FROM `array_test`;
-+------+-----------------+--------------------------+
-| id | c_array | element_at(`c_array`, 5) |
-+------+-----------------+--------------------------+
-| 1 | [1, 2, 3, 4, 5] | 5 |
-| 2 | [6, 7, 8] | NULL |
-| 3 | [] | NULL |
-| 4 | NULL | NULL |
-+------+-----------------+--------------------------+
-```
-
-`position` 为负数使用范例:
-
-```
-mysql> set enable_vectorized_engine=true;
-
-mysql> SELECT id,c_array,c_array[-2] FROM `array_test`;
-+------+-----------------+----------------------------------+
-| id | c_array | %element_extract%(`c_array`, -2) |
-+------+-----------------+----------------------------------+
-| 1 | [1, 2, 3, 4, 5] | 4 |
-| 2 | [6, 7, 8] | 7 |
-| 3 | [] | NULL |
-| 4 | NULL | NULL |
-+------+-----------------+----------------------------------+
-```
-
-### keywords
-
-ELEMENT_AT, SUBSCRIPT
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/size.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/size.md
deleted file mode 100644
index bf4e319fd3..0000000000
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-functions/array-functions/size.md
+++ /dev/null
@@ -1,70 +0,0 @@
----
-{
- "title": "size",
- "language": "zh-CN"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## size (cardinality)
-
-### description
-
-#### Syntax
-
-```
-BIGINT size(ARRAY<T> arr)
-BIGINT cardinality(ARRAY<T> arr)
-```
-
-返回数组中元素数量，如果输入数组为NULL，则返回NULL
-
-### notice
-
-`仅支持向量化引擎中使用`
-
-### example
-
-```
-mysql> set enable_vectorized_engine=true;
-
-mysql> select k1,k2,size(k2) from array_test;
-+------+-----------+------------+
-| k1 | k2 | size(`k2`) |
-+------+-----------+------------+
-| 1 | [1, 2, 3] | 3 |
-| 2 | [] | 0 |
-| 3 | NULL | NULL |
-+------+-----------+------------+
-
-mysql> select k1,k2,cardinality(k2) from array_test;
-+------+-----------+-------------------+
-| k1 | k2 | cardinality(`k2`) |
-+------+-----------+-------------------+
-| 1 | [1, 2, 3] | 3 |
-| 2 | [] | 0 |
-| 3 | NULL | NULL |
-+------+-----------+-------------------+
-```
-
-### keywords
-
-SIZE, CARDINALITY
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
