This is an automated email from the ASF dual-hosted git repository.
morrysnow 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 bb33ad0bde [opt](docs) update nereids doc to reflect the latest
changes (#21444)
bb33ad0bde is described below
commit bb33ad0bdeea16204bf01b4ed5741e1b4abb05aa
Author: morrySnow <[email protected]>
AuthorDate: Mon Jul 3 18:50:01 2023 +0800
[opt](docs) update nereids doc to reflect the latest changes (#21444)
---
docs/en/docs/query-acceleration/nereids.md | 9 ++++-----
docs/zh-CN/docs/query-acceleration/nereids.md | 11 +++++------
2 files changed, 9 insertions(+), 11 deletions(-)
diff --git a/docs/en/docs/query-acceleration/nereids.md
b/docs/en/docs/query-acceleration/nereids.md
index 68260aebcb..d66523011d 100644
--- a/docs/en/docs/query-acceleration/nereids.md
+++ b/docs/en/docs/query-acceleration/nereids.md
@@ -66,6 +66,8 @@ Turn on auto fall back to legacy planner
SET enable_fallback_to_original_planner=true;
```
+Recommand execute analyze on table before query on it to get the benefits of
cbo
+
## Known issues and temporarily unsupported features
### temporarily unsupported features
@@ -73,15 +75,12 @@ SET enable_fallback_to_original_planner=true;
> If automatic fallback is enabled, it will automatically fall back to the old
> optimizer execution
- Json、Array、Map and Struct types: The table in the query contains the above
types, or the expressions in the query outputs the above types
-- DML: All DML statements such as Insert Into Select, Create Table As Select,
Update, Delete, etc.
+- DML: Only support below DML statements: Insert Into Select, Update and Delete
+- Matrialized view with predicates
- Function alias
- Java UDF and HDFS UDF
- High concurrent point query optimize
-- Inverted index
### known issues
- Cannot use query cache and partition cache to accelarate query
-- Not support MTMV
-- Not support MV created after version 2.0.0
-- Some unsupported subquery usage will produce an error result instead of an
error
diff --git a/docs/zh-CN/docs/query-acceleration/nereids.md
b/docs/zh-CN/docs/query-acceleration/nereids.md
index a49052cd54..717013605c 100644
--- a/docs/zh-CN/docs/query-acceleration/nereids.md
+++ b/docs/zh-CN/docs/query-acceleration/nereids.md
@@ -66,6 +66,8 @@ SET enable_nereids_planner=true;
SET enable_fallback_to_original_planner=true;
```
+为了能够充分利用新优化器的CBO能力，强烈建议对关注性能查询所以来的表，执行analyze语句，以收集列统计信息
+
## 已知问题和暂不支持的功能
### 暂不支持的功能
@@ -73,15 +75,12 @@ SET enable_fallback_to_original_planner=true;
> 如果开启了自动回退，则会自动回退到旧优化器执行
- Json、Array、Map、Struct 类型：查询的表含有以上类型，或者查询中的函数会输出以上类型
-- DML：所有的 DML 语句，例如 Insert Into Select，Create Table As Select，Update，Delete 等
-- 函数别名
+- DML：仅支持如下DML：Insert Into Select, Update, Delete
+- 带过滤条件的物化视图
+- 别名函数
- Java UDF 和 HDFS UDF
- 高并发点查询优化
-- 倒排索引
### 已知问题
- 不支持命中 Query Cache 和 Partition Cache
-- 不支持选中多表物化视图
-- 不支持选中使用 2.0 版本新创建物化视图
-- 部分不支持的子查询用法会产生错误结果而不是报错
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
