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.git
The following commit(s) were added to refs/heads/master by this push:
new a92172c54a4 [doc](Variant) fix doc rendering and add version bar
(#30249)
a92172c54a4 is described below
commit a92172c54a42ce92e0d0179b0a6f68eaa5edf3ae
Author: lihangyu <15605149...@163.com>
AuthorDate: Tue Jan 23 11:48:15 2024 +0800
[doc](Variant) fix doc rendering and add version bar (#30249)
---
docs/en/docs/sql-manual/sql-reference/Data-Types/VARIANT.md | 8 ++++++--
docs/zh-CN/docs/sql-manual/sql-reference/Data-Types/VARIANT.md | 8 ++++++--
2 files changed, 12 insertions(+), 4 deletions(-)
diff --git a/docs/en/docs/sql-manual/sql-reference/Data-Types/VARIANT.md
b/docs/en/docs/sql-manual/sql-reference/Data-Types/VARIANT.md
index 5f745c21948..9382b7dbda0 100644
--- a/docs/en/docs/sql-manual/sql-reference/Data-Types/VARIANT.md
+++ b/docs/en/docs/sql-manual/sql-reference/Data-Types/VARIANT.md
@@ -26,6 +26,10 @@ under the License.
## VARIANT
+<version since="2.1.0">
+
+</version>
+
### Description
VARIANT Type
@@ -151,7 +155,7 @@ DISTRIBUTED BY HASH(id) BUCKETS 10
properties("replication_num" = "1");
```
-::: tip
+:::tip
1. Creating an index on VARIANT columns, such as when there are numerous
sub-columns in payload, might lead to an excessive number of index columns,
impacting write performance.
2. The tokenization properties for the same VARIANT column are uniform. If you
have varied tokenization requirements, consider creating multiple VARIANT
columns and specifying index properties separately for each.
@@ -260,7 +264,7 @@ DESCRIBE ${table_name} PARTITION ($partition_name);
**Querying**
-::: warning
+:::tip
When utilizing filtering and aggregation functionalities to query sub-columns,
additional casting operations need to be performed on sub-columns (because the
storage types are not necessarily fixed and require a unified SQL type).
For instance, `SELECT * FROM tbl where CAST(var['titile'] as text) MATCH
"hello world"`
diff --git a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Types/VARIANT.md
b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Types/VARIANT.md
index dca483fe230..c784a1ada36 100644
--- a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Types/VARIANT.md
+++ b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Types/VARIANT.md
@@ -26,6 +26,10 @@ under the License.
## VARIANT
+<version since="2.1.0">
+
+</version>
+
### Description
VARIANT类型
@@ -156,7 +160,7 @@ properties("replication_num" = "1");
**需要注意的是:**
-::: tip
+:::tip
1. 在 VARIANT 列上创建索引，比如 payload 的子列很多时，可能会造成索引列过多，影响写入性能
2. 同一个 VARIANT 列的分词属性是相同的，如果您有不同的分词需求，那么可以创建多个 VARIANT 然后分别指定索引属性
@@ -266,7 +270,7 @@ DESCRIBE ${table_name} PARTITION ($partition_name);
**查询**
-::: warning
+:::tip
**注意**
如使用过滤和聚合等功能来查询子列, 需要对子列进行额外的 cast 操作（因为存储类型不一定是固定的，需要有一个 SQL 统一的类型）。
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
