HappenLee commented on code in PR #2631:
URL: https://github.com/apache/doris-website/pull/2631#discussion_r2209863030
##########
i18n/zh-CN/docusaurus-plugin-content-docs/current/table-design/row-store.md:
##########
@@ -50,23 +57,48 @@ CREATE TABLE `tbl_point_query` (
`v6` float NULL,
`v7` datev2 NULL
) ENGINE=OLAP
-UNIQUE KEY(`key`)
+UNIQUE KEY(`k`)
COMMENT 'OLAP'
-DISTRIBUTED BY HASH(`key`) BUCKETS 1
+DISTRIBUTED BY HASH(`k`) BUCKETS 1
PROPERTIES (
"enable_unique_key_merge_on_write" = "true",
"light_schema_change" = "true",
- "row_store_columns" = "key,v1,v3,v5,v7",
+ "row_store_columns" = "k,v1,v3,v5,v7",
"row_store_page_size" = "4096"
);
```
-查询
+查询 1
+
```
-SELECT key, v1, v3, v5, v7 FROM tbl_point_query WHERE key = 100；
+SELECT k, v1, v3, v5, v7 FROM tbl_point_query WHERE k = 100
```
+explain 上诉语句应该包含 `SHORT-CIRCUIT` 相应的标记。更多点查的使用请参考
[高并发点查](../query-acceleration/high-concurrent-point-query) 。
+
+下面这个例子展示了 DUPLICATE 表怎么命中行存查询条件
-更多点查的使用请参考 [高并发点查](../query-acceleration/high-concurrent-point-query) 。
+```
+CREATE TABLE `tbl_duplicate` (
+ `k` int(11) NULL,
+ `v1` string NULL
+) ENGINE=OLAP
+DUPLICATE KEY(`k`)
+COMMENT 'OLAP'
+DISTRIBUTED BY HASH(`k`) BUCKETS 1
+PROPERTIES (
+ "light_schema_change" = "true",
+ "store_row_column" = "true",
+ "row_store_page_size" = "4096"
+);
+```
+` "store_row_column" = "true",` 是必须的
+
+查询 2（注意命中 TOPN 查询优化以及需要是`SELECT *`）
+
+```
+SELECT * FROM tbl_duplicate WHERE k < 10 ORDER BY k LIMIT 10
+```
+explain 上诉语句应该包含`FETCH ROW STORE` 相应的标记，以及`OPT TWO PHASE`标记
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]
