924060929 commented on code in PR #3439:
URL: https://github.com/apache/doris-website/pull/3439#discussion_r2903708905


##########
i18n/zh-CN/docusaurus-plugin-content-docs/current/query-acceleration/query-cache.md:
##########
@@ -0,0 +1,238 @@
+---
+{
+    "title": "Query Cache",
+    "language": "zh-CN"
+}
+---
+
+# Query Cache(查询缓存)
+
+## 概述
+
+在分析型查询场景中,同一个聚合查询经常会被重复执行,而底层数据并未发生变化。例如:
+
+```sql
+SELECT region, SUM(revenue) FROM orders WHERE dt = '2024-01-01' GROUP BY 
region;
+SELECT region, SUM(revenue) FROM orders WHERE dt = '2024-01-01' GROUP BY 
region;

Review Comment:
   我建议
   1. 这里给的例子是分区有重叠,但不完全相同的sql,表示可以共用这部分的交集的缓存。
   然后再下面讲清楚缓存的是交集的部分
   2. 明确讲清楚缓存的不是整个sql的结果,而是聚合算子的中间结果



-- 
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]

Reply via email to