This is an automated email from the ASF dual-hosted git repository.
airborne 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 af68ac53a30 Add example output table for scoring query (#3047)
af68ac53a30 is described below
commit af68ac53a3087a6d914db6456403cc227ab0b6a1
Author: zzzxl <[email protected]>
AuthorDate: Mon Nov 10 10:51:08 2025 +0800
Add example output table for scoring query (#3047)
## Versions
- [x] dev
- [ ] 3.x
- [ ] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
docs/ai/text-search/scoring.md | 11 +++++++++++
.../current/ai/text-search/scoring.md | 13 ++++++++++++-
versioned_docs/version-4.x/ai/text-search/scoring.md | 11 +++++++++++
3 files changed, 34 insertions(+), 1 deletion(-)
diff --git a/docs/ai/text-search/scoring.md b/docs/ai/text-search/scoring.md
index 552137e22b7..715e8e3e61b 100644
--- a/docs/ai/text-search/scoring.md
+++ b/docs/ai/text-search/scoring.md
@@ -96,6 +96,17 @@ LIMIT 10;
This query returns the top 10 rows most relevant to the search terms, ranked
by BM25 score.
+```text
++------+-----------------------------------+---------+--------------+-----------+
+| id | content | author | publish_date |
relevance |
++------+-----------------------------------+---------+--------------+-----------+
+| 1 | Full text search engine test demo | Alice | 2024-01-01 |
2.915228 |
+| 7 | Text processing techniques | Grace | 2024-01-07 |
1.341931 |
+| 5 | Performance test framework | Eve | 2024-01-05 |
1.341931 |
+| 3 | Advanced search algorithms | Charlie | 2024-01-03 |
1.341931 |
++------+-----------------------------------+---------+--------------+-----------+
+```
+
---
## Result Interpretation
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/ai/text-search/scoring.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/ai/text-search/scoring.md
index ad2b12fafeb..aa360f160e8 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/ai/text-search/scoring.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/ai/text-search/scoring.md
@@ -88,13 +88,24 @@ avgdl = total_terms / total_rows
SELECT *,
score() AS relevance
FROM search_demo
-WHERE content MATCH_ANY '检索测试'
+WHERE content MATCH_ANY 'text search test'
ORDER BY relevance DESC
LIMIT 10;
```
该语句会根据 BM25 打分结果返回前 10 条最相关的记录。
+```text
++------+-----------------------------------+---------+--------------+-----------+
+| id | content | author | publish_date |
relevance |
++------+-----------------------------------+---------+--------------+-----------+
+| 1 | Full text search engine test demo | Alice | 2024-01-01 |
2.915228 |
+| 7 | Text processing techniques | Grace | 2024-01-07 |
1.341931 |
+| 5 | Performance test framework | Eve | 2024-01-05 |
1.341931 |
+| 3 | Advanced search algorithms | Charlie | 2024-01-03 |
1.341931 |
++------+-----------------------------------+---------+--------------+-----------+
+```
+
---
## 结果说明
diff --git a/versioned_docs/version-4.x/ai/text-search/scoring.md
b/versioned_docs/version-4.x/ai/text-search/scoring.md
index 552137e22b7..715e8e3e61b 100644
--- a/versioned_docs/version-4.x/ai/text-search/scoring.md
+++ b/versioned_docs/version-4.x/ai/text-search/scoring.md
@@ -96,6 +96,17 @@ LIMIT 10;
This query returns the top 10 rows most relevant to the search terms, ranked
by BM25 score.
+```text
++------+-----------------------------------+---------+--------------+-----------+
+| id | content | author | publish_date |
relevance |
++------+-----------------------------------+---------+--------------+-----------+
+| 1 | Full text search engine test demo | Alice | 2024-01-01 |
2.915228 |
+| 7 | Text processing techniques | Grace | 2024-01-07 |
1.341931 |
+| 5 | Performance test framework | Eve | 2024-01-05 |
1.341931 |
+| 3 | Advanced search algorithms | Charlie | 2024-01-03 |
1.341931 |
++------+-----------------------------------+---------+--------------+-----------+
+```
+
---
## Result Interpretation
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
