This is an automated email from the ASF dual-hosted git repository.
eldenmoon 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 a5892712fad add variant in table-design/data-type.md (#755)
a5892712fad is described below
commit a5892712fadaae1d7980b8a64cb30e874c426241
Author: lihangyu <15605149...@163.com>
AuthorDate: Tue Jun 18 14:49:33 2024 +0800
add variant in table-design/data-type.md (#755)
---
docs/table-design/data-type.md | 1 +
.../docusaurus-plugin-content-docs/current/table-design/data-type.md | 1 +
.../docusaurus-plugin-content-docs/version-2.1/table-design/data-type.md | 1 +
versioned_docs/version-2.1/table-design/data-type.md | 1 +
4 files changed, 4 insertions(+)
diff --git a/docs/table-design/data-type.md b/docs/table-design/data-type.md
index 2b5822b22f2..47ba73ecbba 100644
--- a/docs/table-design/data-type.md
+++ b/docs/table-design/data-type.md
@@ -52,5 +52,6 @@ The list of data types supported by Doris is as follows:
| STRUCT | / | A structure composed of multiple Fields
can also be understood as a collection of multiple columns. It cannot be used
as a Key. Currently, STRUCT can only be used in tables of Duplicate models. The
name and number of Fields in a Struct are fixed and are always Nullable.|
| JSON | / | Binary JSON type, stored in binary JSON
format, access internal JSON fields through JSON function. Supported up to
1048576 bytes (1MB) by default, and can be adjusted to a maximum of 2147483643
bytes (2GB). This limit can be modified through the BE configuration parameter
'jsonb_type_length_soft_limit_bytes'. |
| AGG_STATE | / | Aggregate function can only be used with
state/merge/union function combiners. AGG_STATE cannot be used as a key
column. When creating a table, the signature of the aggregate function needs to
be declared alongside. Users do not need to specify the length or default
value. The actual data storage size depends on the function's implementation. |
+| VARIANT | / | Variant allows storing complex data
structures containing different data types (such as integers, strings, boolean
values, etc.) without the need to define specific columns in the table
structure beforehand.During the writing process, this type can automatically
infer column information based on the structure and types of the columns,
dynamicly merge written schemas. It stores JSON keys and their corresponding
values as columns and dynamic sub-columns. |
You can also view all the data types supported by Doris with the `SHOW DATA
TYPES; `statement.
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-type.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-type.md
index eb7813b7553..f685aa7ab3b 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-type.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/data-type.md
@@ -54,5 +54,6 @@ Doris 已支持的数据类型列表如下：
| STRUCT | / | 由多个 Field 组成的结构体，也可被理解为多个列的集合。不能作为 Key 使用，目前
STRUCT 仅支持在 Duplicate 模型的表中使用。一个 Struct 中的 Field 的名字和数量固定，总是为 Nullable。|
| JSON | / | 二进制 JSON 类型，采用二进制 JSON 格式存储，通过 JSON 函数访问 JSON
内部字段。默认支持 1048576 字节（1MB），可调大到 2147483643 字节（2GB）。可通过 BE 配置
jsonb_type_length_soft_limit_bytes 调整。 |
| AGG_STATE | / | 聚合函数，只能配合 state/merge/union 函数组合器使用。AGG_STATE
不能作为 key 列使用，建表时需要同时声明聚合函数的签名。用户不需要指定长度和默认值。实际存储的数据大小与函数实现有关。 |
+| VARIANT | / |
VARIANT允许存储包含不同数据类型（如整数、字符串、布尔值等）的复杂数据结构，而无需在表结构中提前定义具体的列。VARIANT
类型特别适用于处理复杂的嵌套结构，而这些结构可能随时会发生变化。在写入过程中，该类型可以自动根据列的结构、类型推断列信息，动态合并写入的
schema，并通过将 JSON 键及其对应的值存储为列和动态子列 |
您也可通过`SHOW DATA TYPES;`语句查看 Doris 支持的所有数据类型。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-type.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-type.md
index eb7813b7553..f685aa7ab3b 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-type.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/table-design/data-type.md
@@ -54,5 +54,6 @@ Doris 已支持的数据类型列表如下：
| STRUCT | / | 由多个 Field 组成的结构体，也可被理解为多个列的集合。不能作为 Key 使用，目前
STRUCT 仅支持在 Duplicate 模型的表中使用。一个 Struct 中的 Field 的名字和数量固定，总是为 Nullable。|
| JSON | / | 二进制 JSON 类型，采用二进制 JSON 格式存储，通过 JSON 函数访问 JSON
内部字段。默认支持 1048576 字节（1MB），可调大到 2147483643 字节（2GB）。可通过 BE 配置
jsonb_type_length_soft_limit_bytes 调整。 |
| AGG_STATE | / | 聚合函数，只能配合 state/merge/union 函数组合器使用。AGG_STATE
不能作为 key 列使用，建表时需要同时声明聚合函数的签名。用户不需要指定长度和默认值。实际存储的数据大小与函数实现有关。 |
+| VARIANT | / |
VARIANT允许存储包含不同数据类型（如整数、字符串、布尔值等）的复杂数据结构，而无需在表结构中提前定义具体的列。VARIANT
类型特别适用于处理复杂的嵌套结构，而这些结构可能随时会发生变化。在写入过程中，该类型可以自动根据列的结构、类型推断列信息，动态合并写入的
schema，并通过将 JSON 键及其对应的值存储为列和动态子列 |
您也可通过`SHOW DATA TYPES;`语句查看 Doris 支持的所有数据类型。
diff --git a/versioned_docs/version-2.1/table-design/data-type.md
b/versioned_docs/version-2.1/table-design/data-type.md
index 2b5822b22f2..47ba73ecbba 100644
--- a/versioned_docs/version-2.1/table-design/data-type.md
+++ b/versioned_docs/version-2.1/table-design/data-type.md
@@ -52,5 +52,6 @@ The list of data types supported by Doris is as follows:
| STRUCT | / | A structure composed of multiple Fields
can also be understood as a collection of multiple columns. It cannot be used
as a Key. Currently, STRUCT can only be used in tables of Duplicate models. The
name and number of Fields in a Struct are fixed and are always Nullable.|
| JSON | / | Binary JSON type, stored in binary JSON
format, access internal JSON fields through JSON function. Supported up to
1048576 bytes (1MB) by default, and can be adjusted to a maximum of 2147483643
bytes (2GB). This limit can be modified through the BE configuration parameter
'jsonb_type_length_soft_limit_bytes'. |
| AGG_STATE | / | Aggregate function can only be used with
state/merge/union function combiners. AGG_STATE cannot be used as a key
column. When creating a table, the signature of the aggregate function needs to
be declared alongside. Users do not need to specify the length or default
value. The actual data storage size depends on the function's implementation. |
+| VARIANT | / | Variant allows storing complex data
structures containing different data types (such as integers, strings, boolean
values, etc.) without the need to define specific columns in the table
structure beforehand.During the writing process, this type can automatically
infer column information based on the structure and types of the columns,
dynamicly merge written schemas. It stores JSON keys and their corresponding
values as columns and dynamic sub-columns. |
You can also view all the data types supported by Doris with the `SHOW DATA
TYPES; `statement.
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
