This is an automated email from the ASF dual-hosted git repository.
morningman pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new 471dd3221d0 [fix] fix create-index (#3609)
471dd3221d0 is described below
commit 471dd3221d0854d879971e24c90b0250c8032c7e
Author: Mingyu Chen (Rayner) <[email protected]>
AuthorDate: Tue May 5 19:10:26 2026 -0700
[fix] fix create-index (#3609)
---
.../sql-statements/table-and-view/index/CREATE-INDEX.md | 14 ++++++++------
.../sql-statements/table-and-view/index/CREATE-INDEX.md | 14 ++++++++------
.../sql-statements/table-and-view/index/CREATE-INDEX.md | 14 +++++++-------
.../sql-statements/table-and-view/index/CREATE-INDEX.md | 14 +++++++-------
4 files changed, 30 insertions(+), 26 deletions(-)
diff --git
a/docs-next/sql-manual/sql-statements/table-and-view/index/CREATE-INDEX.md
b/docs-next/sql-manual/sql-statements/table-and-view/index/CREATE-INDEX.md
index 3798ff9ab98..577c305ca47 100644
--- a/docs-next/sql-manual/sql-statements/table-and-view/index/CREATE-INDEX.md
+++ b/docs-next/sql-manual/sql-statements/table-and-view/index/CREATE-INDEX.md
@@ -87,7 +87,7 @@ The user executing this SQL command must have at least the
following permissions
```sql
- CREATE INDEX index1 ON table1 USING INVERTED;
+ CREATE INDEX index1 ON table1(col1) USING INVERTED;
```
- Create an NGram BloomFilter index `index2` on `table1`
@@ -95,15 +95,17 @@ The user executing this SQL command must have at least the
following permissions
```sql
- CREATE INDEX index2 ON table1 USING NGRAM_BF PROPERTIES("gram_size"="3",
"bf_size"="1024");
+ CREATE INDEX index2 ON table1(col1) USING NGRAM_BF
PROPERTIES("gram_size"="3", "bf_size"="1024");
```
+
- Create an ANN index `index3` on `table1` (`embedding`) vector column.
+
```sql
CREATE INDEX index3 ON table1 (`embedding`) USING ANN PROPERTIES(
- "index_type"="hnsw",
- "metric_type"="l2_distance",
- "dim"="128"
+ "index_type"="hnsw",
+ "metric_type"="l2_distance",
+ "dim"="128"
);
- ```
+ ```
diff --git
a/docs/sql-manual/sql-statements/table-and-view/index/CREATE-INDEX.md
b/docs/sql-manual/sql-statements/table-and-view/index/CREATE-INDEX.md
index 3798ff9ab98..577c305ca47 100644
--- a/docs/sql-manual/sql-statements/table-and-view/index/CREATE-INDEX.md
+++ b/docs/sql-manual/sql-statements/table-and-view/index/CREATE-INDEX.md
@@ -87,7 +87,7 @@ The user executing this SQL command must have at least the
following permissions
```sql
- CREATE INDEX index1 ON table1 USING INVERTED;
+ CREATE INDEX index1 ON table1(col1) USING INVERTED;
```
- Create an NGram BloomFilter index `index2` on `table1`
@@ -95,15 +95,17 @@ The user executing this SQL command must have at least the
following permissions
```sql
- CREATE INDEX index2 ON table1 USING NGRAM_BF PROPERTIES("gram_size"="3",
"bf_size"="1024");
+ CREATE INDEX index2 ON table1(col1) USING NGRAM_BF
PROPERTIES("gram_size"="3", "bf_size"="1024");
```
+
- Create an ANN index `index3` on `table1` (`embedding`) vector column.
+
```sql
CREATE INDEX index3 ON table1 (`embedding`) USING ANN PROPERTIES(
- "index_type"="hnsw",
- "metric_type"="l2_distance",
- "dim"="128"
+ "index_type"="hnsw",
+ "metric_type"="l2_distance",
+ "dim"="128"
);
- ```
+ ```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs-next/current/sql-manual/sql-statements/table-and-view/index/CREATE-INDEX.md
b/i18n/zh-CN/docusaurus-plugin-content-docs-next/current/sql-manual/sql-statements/table-and-view/index/CREATE-INDEX.md
index c7b0cac2a3a..456d9c06b51 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs-next/current/sql-manual/sql-statements/table-and-view/index/CREATE-INDEX.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs-next/current/sql-manual/sql-statements/table-and-view/index/CREATE-INDEX.md
@@ -15,7 +15,7 @@
```sql
CREATE INDEX [IF NOT EXISTS] <index_name>
ON <table_name> (<column_name> [, ...])
- [USING {INVERTED | NGRAM_BF}]
+ [USING {INVERTED | NGRAM_BF | ANN}]
[PROPERTIES ("<key>" = "<value>"[ , ...])]
[COMMENT '<index_comment>']
```
@@ -84,21 +84,21 @@ CREATE INDEX [IF NOT EXISTS] <index_name>
- 在 table1 上创建倒排索引 index1
```sql
- CREATE INDEX index1 ON table1 USING INVERTED;
+ CREATE INDEX index1 ON table1(col1) USING INVERTED;
```
- 在 table1 上创建 NGram BloomFilter 索引 index2
```sql
- CREATE INDEX index2 ON table1 USING NGRAM_BF PROPERTIES("gram_size"="3",
"bf_size"="1024");
+ CREATE INDEX index2 ON table1(col1) USING NGRAM_BF
PROPERTIES("gram_size"="3", "bf_size"="1024");
```
-- 在 table1 上创建 ANN 索引 index3
+- 在table1 上创建 ANN 索引 index3
```sql
CREATE INDEX index3 ON table1 (`embedding`) USING ANN PROPERTIES(
- "index_type"="hnsw",
- "metric_type"="l2_distance",
- "dim"="128"
+ "index_type"="hnsw",
+ "metric_type"="l2_distance",
+ "dim"="128"
);
```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/table-and-view/index/CREATE-INDEX.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/table-and-view/index/CREATE-INDEX.md
index c7b0cac2a3a..456d9c06b51 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/table-and-view/index/CREATE-INDEX.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/table-and-view/index/CREATE-INDEX.md
@@ -15,7 +15,7 @@
```sql
CREATE INDEX [IF NOT EXISTS] <index_name>
ON <table_name> (<column_name> [, ...])
- [USING {INVERTED | NGRAM_BF}]
+ [USING {INVERTED | NGRAM_BF | ANN}]
[PROPERTIES ("<key>" = "<value>"[ , ...])]
[COMMENT '<index_comment>']
```
@@ -84,21 +84,21 @@ CREATE INDEX [IF NOT EXISTS] <index_name>
- 在 table1 上创建倒排索引 index1
```sql
- CREATE INDEX index1 ON table1 USING INVERTED;
+ CREATE INDEX index1 ON table1(col1) USING INVERTED;
```
- 在 table1 上创建 NGram BloomFilter 索引 index2
```sql
- CREATE INDEX index2 ON table1 USING NGRAM_BF PROPERTIES("gram_size"="3",
"bf_size"="1024");
+ CREATE INDEX index2 ON table1(col1) USING NGRAM_BF
PROPERTIES("gram_size"="3", "bf_size"="1024");
```
-- 在 table1 上创建 ANN 索引 index3
+- 在table1 上创建 ANN 索引 index3
```sql
CREATE INDEX index3 ON table1 (`embedding`) USING ANN PROPERTIES(
- "index_type"="hnsw",
- "metric_type"="l2_distance",
- "dim"="128"
+ "index_type"="hnsw",
+ "metric_type"="l2_distance",
+ "dim"="128"
);
```
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
