morrySnow commented on code in PR #2641:
URL: https://github.com/apache/doris-website/pull/2641#discussion_r2218115047
##########
i18n/zh-CN/docusaurus-plugin-content-docs/current/query-acceleration/materialized-view/async-materialized-view/functions-and-demands.md:
##########
@@ -613,6 +613,14 @@ ON l_orderkey = o_orderkey
WHERE l_linenumber > 1 and o_orderdate = '2023-10-18';
```
+:::caution 注意
+
+如果 join 的条件包含了非列的表达式，目前改写会失败，比如上述查询语句中的 `l_orderkey = o_orderkey`，改成
+
+`cast(l_orderkey as bigint) = cast(o_orderkey as bigint)`则无法进行透明改写。
+
Review Comment:
这个是之前的 bug，正常情况下，不会有发生 join hash 条件两侧不是 slot 的情况
##########
i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/table-and-view/async-materialized-view/CREATE-ASYNC-MATERIALIZED-VIEW.md:
##########
@@ -212,7 +231,7 @@ refresh_trigger
)
DISTRIBUTED BY HASH(o_orderkey) BUCKETS 3
PROPERTIES (
- "replication_num" = "1"
+ "replication_num" = "3"
Review Comment:
为啥改成 3 了？
##########
i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/table-and-view/async-materialized-view/CREATE-ASYNC-MATERIALIZED-VIEW.md:
##########
@@ -132,6 +144,13 @@ refresh_trigger
| enable_nondeterministic_function | 物化视图定义 SQL 是否允许包含 nondeterministic 函数，比如
current_date(), now(), random() 等，如果 是 true, 允许包含，否则不允许包含，默认不允许包含。 |
| use_for_rewrite | 标识此物化视图是否参与到透明改写中，如果为 false，不参与到透明改写，默认是
true。数据建模场景中，如果物化视图只是用于直查，物化视图可以设置此属性，从而不参与透明改写，提高查询响应速度。 |
+:::caution 注意
+excluded_trigger_tables 属性只支持写表名，如果想要写 catalog 和 database，比如
internal.db1.table1
Review Comment:
不太通顺
--
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]
