airborne12 commented on code in PR #21184:
URL: https://github.com/apache/doris/pull/21184#discussion_r1241936575


##########
docs/zh-CN/docs/data-table/index/inverted-index.md:
##########
@@ -97,13 +97,35 @@ table_properties;
 ```
 
 - 已有表增加倒排索引
+
+**2.0-beta版本之前:**
 ```sql
 -- 语法1
 CREATE INDEX idx_name ON table_name(column_name) USING INVERTED 
[PROPERTIES("parser" = "english|unicode|chinese")] [COMMENT 'your comment'];
 -- 语法2
 ALTER TABLE table_name ADD INDEX idx_name(column_name) USING INVERTED 
[PROPERTIES("parser" = "english|unicode|chinese")] [COMMENT 'your comment'];
 ```
 
+**2.0-beta版本(含2.0-beta)之后:**
+
+上述`create/add index`操作只对增量数据生成倒排索引,增加了build index的语法用于对存量数据加倒排索引:
+```sql
+-- 语法1,默认给全表的存量数据加上倒排索引
+BUILD INDEX index_name ON table_name;
+-- 语法2,可指定partition,可指定一个或多个
+BUILD INDEX index_name ON table_name PARTITIONS(partition_name1, 
partition_name2);
+```
+(**在执行build index之前需要已经执行了以上`create/add index`的操作**)
+
+查看`build index`进展,可通过以下语句进行查看:
+```sql
+show build index [FROM db_name];
+-- 示例1,查看所有的build index任务进展
+show build index;
+-- 示例2,查看指定table的build index任务进展
+show build index wehre TableName = "table1";

Review Comment:
   typo also wehre->where



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