This is an automated email from the ASF dual-hosted git repository.
luzhijing 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 b098072ca92b variant aggregation model supported (#536)
b098072ca92b is described below
commit b098072ca92b5061a96539cd72c7605d17cdcee0
Author: lihangyu <[email protected]>
AuthorDate: Thu Apr 11 23:03:55 2024 +0800
variant aggregation model supported (#536)
---
docs/sql-manual/sql-reference/Data-Types/VARIANT.md | 3 +--
.../current/sql-manual/sql-reference/Data-Types/VARIANT.md | 3 +--
.../version-2.1/sql-manual/sql-reference/Data-Types/VARIANT.md | 3 +--
.../version-2.1/sql-manual/sql-reference/Data-Types/VARIANT.md | 3 +--
4 files changed, 4 insertions(+), 8 deletions(-)
diff --git a/docs/sql-manual/sql-reference/Data-Types/VARIANT.md
b/docs/sql-manual/sql-reference/Data-Types/VARIANT.md
index 01539e12ab2e..a7469ca219c6 100644
--- a/docs/sql-manual/sql-reference/Data-Types/VARIANT.md
+++ b/docs/sql-manual/sql-reference/Data-Types/VARIANT.md
@@ -287,7 +287,7 @@ mysql> SELECT
-> cast(repo['name'] as text) as repo_name, count() AS stars
-> FROM github_events
-> WHERE type = 'WatchEvent'
- -> GROUP BY
+ -> GROUP BY repo_name
-> ORDER BY stars DESC LIMIT 5;
+--------------------------+-------+
| repo_name | stars |
@@ -357,7 +357,6 @@ When the above types cannot be compatible, they will be
transformed into JSON ty
**Other limitations include:**
-- Aggregate models are currently not supported.
- VARIANT columns can only create inverted indexes or bloom filter to speed up
query.
- Using the **RANDOM** mode or [group
commit](https://doris.apache.org/docs/dev/data-operate/import/import-way/group-commit-manual/)
mode is recommended for higher write performance.
- Non-standard JSON types such as date and decimal should ideally use static
types for better performance, since these types are infered to text type.
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Types/VARIANT.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Types/VARIANT.md
index f4a05fe454a8..eee0987f74f1 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Types/VARIANT.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-reference/Data-Types/VARIANT.md
@@ -295,7 +295,7 @@ mysql> SELECT
-> cast(repo['name'] as text) as repo_name, count() AS stars
-> FROM github_events
-> WHERE type = 'WatchEvent'
- -> GROUP BY stars
+ -> GROUP BY repo_name
-> ORDER BY stars DESC LIMIT 5;
+--------------------------+-------+
| repo_name | stars |
@@ -365,7 +365,6 @@ VARIANT 动态列与预定义静态列几乎一样高效。处理诸如日志之
其它限制如下：
-- 目前不支持 Aggregate 模型
- VARIANT 列只能创建倒排索引或者bloom filter来加速过滤
- **推荐使用 RANDOM 模式和[Group
Commit](https://doris.apache.org/zh-CN/docs/dev/data-operate/import/import-way/group-commit-manual/)模式，
写入性能更高效**
- 日期、decimal 等非标准 JSON 类型会被默认推断成字符串类型，所以尽可能从 VARIANT 中提取出来，用静态类型，性能更好
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-reference/Data-Types/VARIANT.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-reference/Data-Types/VARIANT.md
index f4a05fe454a8..eee0987f74f1 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-reference/Data-Types/VARIANT.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-reference/Data-Types/VARIANT.md
@@ -295,7 +295,7 @@ mysql> SELECT
-> cast(repo['name'] as text) as repo_name, count() AS stars
-> FROM github_events
-> WHERE type = 'WatchEvent'
- -> GROUP BY stars
+ -> GROUP BY repo_name
-> ORDER BY stars DESC LIMIT 5;
+--------------------------+-------+
| repo_name | stars |
@@ -365,7 +365,6 @@ VARIANT 动态列与预定义静态列几乎一样高效。处理诸如日志之
其它限制如下：
-- 目前不支持 Aggregate 模型
- VARIANT 列只能创建倒排索引或者bloom filter来加速过滤
- **推荐使用 RANDOM 模式和[Group
Commit](https://doris.apache.org/zh-CN/docs/dev/data-operate/import/import-way/group-commit-manual/)模式，
写入性能更高效**
- 日期、decimal 等非标准 JSON 类型会被默认推断成字符串类型，所以尽可能从 VARIANT 中提取出来，用静态类型，性能更好
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-reference/Data-Types/VARIANT.md
b/versioned_docs/version-2.1/sql-manual/sql-reference/Data-Types/VARIANT.md
index 01539e12ab2e..a7469ca219c6 100644
--- a/versioned_docs/version-2.1/sql-manual/sql-reference/Data-Types/VARIANT.md
+++ b/versioned_docs/version-2.1/sql-manual/sql-reference/Data-Types/VARIANT.md
@@ -287,7 +287,7 @@ mysql> SELECT
-> cast(repo['name'] as text) as repo_name, count() AS stars
-> FROM github_events
-> WHERE type = 'WatchEvent'
- -> GROUP BY
+ -> GROUP BY repo_name
-> ORDER BY stars DESC LIMIT 5;
+--------------------------+-------+
| repo_name | stars |
@@ -357,7 +357,6 @@ When the above types cannot be compatible, they will be
transformed into JSON ty
**Other limitations include:**
-- Aggregate models are currently not supported.
- VARIANT columns can only create inverted indexes or bloom filter to speed up
query.
- Using the **RANDOM** mode or [group
commit](https://doris.apache.org/docs/dev/data-operate/import/import-way/group-commit-manual/)
mode is recommended for higher write performance.
- Non-standard JSON types such as date and decimal should ideally use static
types for better performance, since these types are infered to text type.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
