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
commit e5e8b8922ac46861902b1f9a6e19cec9e3d3d6cd Author: jiafeng.zhang <[email protected]> AuthorDate: Fri Nov 25 18:15:53 2022 +0800 remove array --- docs/sql-manual/sql-reference/Data-Types/ARRAY.md | 89 --------------------- .../sql-manual/sql-reference/Data-Types/ARRAY.md | 90 ---------------------- 2 files changed, 179 deletions(-) diff --git a/docs/sql-manual/sql-reference/Data-Types/ARRAY.md b/docs/sql-manual/sql-reference/Data-Types/ARRAY.md deleted file mode 100644 index 8a0ddb88ea8..00000000000 --- a/docs/sql-manual/sql-reference/Data-Types/ARRAY.md +++ /dev/null @@ -1,89 +0,0 @@ ---- -{ - "title": "ARRAY", - "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 - -### description - -ARRAY\<T\> - -An array of T-type items, it cannot be used as a key column. Now ARRAY can only used in Duplicate Model Tables. - -T-type could be any of: - -``` -BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, DECIMAL, DATE, -DATETIME, CHAR, VARCHAR, STRING -``` -### notice - -please open `enable_array_type` before use ARRAY - -### example - -Create table example: - -``` -mysql> set enable_array_type=true; - -mysql> CREATE TABLE `array_test` ( - `id` int(11) NULL COMMENT "", - `c_array` ARRAY<int(11)> NULL COMMENT "" -) ENGINE=OLAP -DUPLICATE KEY(`id`) -COMMENT "OLAP" -DISTRIBUTED BY HASH(`id`) BUCKETS 1 -PROPERTIES ( -"replication_allocation" = "tag.location.default: 1", -"in_memory" = "false", -"storage_format" = "V2" -); -``` - -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); -``` - -Select data example: - -``` -mysql> SELECT * FROM `array_test`; -+------+-----------------+ -| id | c_array | -+------+-----------------+ -| 1 | [1, 2, 3, 4, 5] | -| 2 | [6, 7, 8] | -| 3 | [] | -| 4 | NULL | -+------+-----------------+ -``` - -### keywords - - ARRAY, array_contains, array_position, element_at diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Types/ARRAY.md b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Types/ARRAY.md deleted file mode 100644 index 3a6277b6ccf..00000000000 --- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Types/ARRAY.md +++ /dev/null @@ -1,90 +0,0 @@ ---- -{ - "title": "ARRAY", - "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 - -### description - -ARRAY\<T\> - -由T类型元素组成的数组，不能作为key列使用。目前支持在Duplicate模型的表中使用。 - -T支持的类型有： - -``` -BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, LARGEINT, FLOAT, DOUBLE, DECIMAL, DATE, -DATETIME, CHAR, VARCHAR, STRING -``` - -### notice - -使用时需要先打开`enable_array_type`开关 - -### example - -建表示例如下： - -``` -mysql> set enable_array_type=true; - -mysql> CREATE TABLE `array_test` ( - `id` int(11) NULL COMMENT "", - `c_array` ARRAY<int(11)> NULL COMMENT "" -) ENGINE=OLAP -DUPLICATE KEY(`id`) -COMMENT "OLAP" -DISTRIBUTED BY HASH(`id`) BUCKETS 1 -PROPERTIES ( -"replication_allocation" = "tag.location.default: 1", -"in_memory" = "false", -"storage_format" = "V2" -); -``` - -插入数据示例： - -``` -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> SELECT * FROM `array_test`; -+------+-----------------+ -| id | c_array | -+------+-----------------+ -| 1 | [1, 2, 3, 4, 5] | -| 2 | [6, 7, 8] | -| 3 | [] | -| 4 | NULL | -+------+-----------------+ -``` - -### keywords - - ARRAY, array_contains, array_position, element_at --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
