eldenmoon commented on code in PR #4170:
URL: https://github.com/apache/doris-website/pull/4170#discussion_r4080069520
##########
i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/basic-element/sql-data-types/semi-structured/VARIANT.md:
##########
@@ -296,58 +536,83 @@ CREATE TABLE test_var_schema (
> NULL
)
PROPERTIES ("replication_num" = "1");
+```
-INSERT INTO test_var_schema VALUES (1, '{
- "large_int_val" : "123222222222222222222222",
- "string_val" : "Hello World",
- "decimal_val" : 1.11111111,
- "datetime_val" : "2025-05-16 11:11:11",
- "tz_val" : "2025-05-16 11:11:11+08:00",
- "ip_val" : "127.0.0.1"
-}');
+模板字段可以使用以下类型：
-SELECT variant_type(v1) FROM test_var_schema;
+- 数值：`TINYINT`、`SMALLINT`、`INT`、`BIGINT`、`LARGEINT`、`FLOAT`、`DOUBLE`，以及 `p <=
38` 的 `DECIMAL(p, s)`
+- `STRING`（或 `TEXT`）
+- `BOOLEAN`
+- `DATE`、`DATETIME(p)`、`TIMESTAMPTZ(p)`、`TIMESTAMP_NS`
+- `IPV4`、`IPV6`
+- `ARRAY<T>`，`T` 为以上类型之一（仅支持一维）
-+---------------------------------------------------------------------------------------------------------------------------------------------------+
-| variant_type(v1)
|
-+---------------------------------------------------------------------------------------------------------------------------------------------------+
-|
{"datetime_val":"datetimev2","decimal_val":"decimal128i","ip_val":"ipv4","large_int_val":"largeint","string_val":"string","tz_val":"timestamptz"}
|
-+---------------------------------------------------------------------------------------------------------------------------------------------------+
-```
+`CHAR`、`VARCHAR`、`DECIMALV2`、`TIME`、`JSON`、`MAP`、`STRUCT` 和嵌套数组不能用于 Schema
Template。DOC mode 下，模板字段进一步限制为字符串、整数、`FLOAT`、`DOUBLE`、`BOOLEAN` 以及由这些类型组成的数组。
Review Comment:
550 这一行删除
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
