This is an automated email from the ASF dual-hosted git repository. morningman pushed a commit to branch branch-1.2-unstable in repository https://gitbox.apache.org/repos/asf/doris.git
commit 61049913179794c9c70dff20344350b68c6d8068 Author: Liqf <109049295+lemonlit...@users.noreply.github.com> AuthorDate: Wed Nov 9 08:40:38 2022 +0800 [typo](docs)update array type doc #14057 --- docs/en/docs/sql-manual/sql-reference/Data-Types/ARRAY.md | 12 +----------- .../zh-CN/docs/sql-manual/sql-reference/Data-Types/ARRAY.md | 13 +------------ 2 files changed, 2 insertions(+), 23 deletions(-) diff --git a/docs/en/docs/sql-manual/sql-reference/Data-Types/ARRAY.md b/docs/en/docs/sql-manual/sql-reference/Data-Types/ARRAY.md index bc344e48c6..62d0db7fe5 100644 --- a/docs/en/docs/sql-manual/sql-reference/Data-Types/ARRAY.md +++ b/docs/en/docs/sql-manual/sql-reference/Data-Types/ARRAY.md @@ -38,15 +38,6 @@ T-type could be any of: BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, DECIMAL, DATE, DATETIME, CHAR, VARCHAR, STRING ``` -### notice - -We should turn on the switch for the ARRAY types feature with the following command before use: - -``` -$ mysql-client > admin set frontend config("enable_array_type"="true"); -``` - -In this way the config will be reset after the FE process restarts. For permanent setting, you can add config `enable_array_type=true` inside fe.conf. ### example @@ -71,9 +62,8 @@ Insert data example: ``` mysql> INSERT INTO `array_test` VALUES (1, [1,2,3,4,5]); -mysql> INSERT INTO `array_test` VALUES (2, array(6,7,8)), (3, array()), (4, null); +mysql> INSERT INTO `array_test` VALUES (2, [6,7,8]), (3, []), (4, null); ``` -Note: The above sql supports the array() function only in non-vectorized scenarios, but not in vectorized scenarios. Select data example: diff --git a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Types/ARRAY.md b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Types/ARRAY.md index 636857e0c5..699d0ba9e4 100644 --- a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Types/ARRAY.md +++ b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Types/ARRAY.md @@ -39,16 +39,6 @@ BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, DECIMAL, DATE, DATETIME, CHAR, VARCHAR, STRING ``` -### notice - -使用前可以通过如下命令打开Array开关: - -``` -$ mysql-client > admin set frontend config("enable_array_type"="true"); -``` - -这种方式下Array开关会在Fe进程重启后重置,或者在fe.conf中添加`enable_array_type=true`配置项可永久生效。 - ### example 建表示例如下: @@ -72,9 +62,8 @@ PROPERTIES ( ``` mysql> INSERT INTO `array_test` VALUES (1, [1,2,3,4,5]); -mysql> INSERT INTO `array_test` VALUES (2, array(6,7,8)), (3, array()), (4, null); +mysql> INSERT INTO `array_test` VALUES (2, [6,7,8]), (3, []), (4, null); ``` -注意:以上sql仅在非向量化场景下,支持 array() 函数,向量化场景不支持。 查询数据示例: --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org