This is an automated email from the ASF dual-hosted git repository.
luzhijing 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 307a5fbaac [doc](inverted index) match phrase slop feature added (#553)
307a5fbaac is described below
commit 307a5fbaacd5e6efcffef535c4529eb315e8894f
Author: zzzxl <[email protected]>
AuthorDate: Mon Apr 15 16:04:26 2024 +0800
[doc](inverted index) match phrase slop feature added (#553)
---
docs/data-table/index/inverted-index.md | 3 ++-
.../current/data-table/index/inverted-index.md | 3 ++-
.../version-2.0/table-design/index/inverted-index.md | 3 ++-
.../version-2.1/data-table/index/inverted-index.md | 3 ++-
versioned_docs/version-2.0/table-design/index/inverted-index.md | 3 ++-
versioned_docs/version-2.1/data-table/index/inverted-index.md | 3 ++-
6 files changed, 12 insertions(+), 6 deletions(-)
diff --git a/docs/data-table/index/inverted-index.md
b/docs/data-table/index/inverted-index.md
index 3e76e325b9..cfd8f6cf20 100644
--- a/docs/data-table/index/inverted-index.md
+++ b/docs/data-table/index/inverted-index.md
@@ -181,8 +181,9 @@ SELECT * FROM table_name WHERE logmsg MATCH_ANY 'keyword1
keyword2';
-- 1.3 find rows that logmsg contains both keyword1 and keyword2 and more
keywords
SELECT * FROM table_name WHERE logmsg MATCH_ALL 'keyword1 keyword2';
--- 1.4 find rows that logmsg contains both keyword1 and keyword2, and in the
order of keyword1 appearing first and keyword2 appearing later.
+-- 1.4 When not specifying a slop for a phrase query, the default slop is 0,
meaning "keyword1 keyword2" must be adjacent. You can specify the slop for a
phrase query using the tilde (~) symbol.
SELECT * FROM table_name WHERE logmsg MATCH_PHRASE 'keyword1 keyword2';
+SELECT * FROM table_name WHERE logmsg MATCH_PHRASE 'keyword1 keyword2 ~3';
-- 1.5 perform prefix matching on the last word "keyword2" while maintaining
the order of words, defaulting to finding 50 prefix words (controlled by the
session variable inverted_index_max_expansions)
SELECT * FROM table_name WHERE logmsg MATCH_PHRASE_PREFIX 'keyword1 keyword2';
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-table/index/inverted-index.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-table/index/inverted-index.md
index 53461d8a02..bb1753f9f9 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-table/index/inverted-index.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-table/index/inverted-index.md
@@ -179,8 +179,9 @@ SELECT * FROM table_name WHERE logmsg MATCH_ANY 'keyword1
keyword2';
-- 1.3 logmsg中同时包含keyword1和keyword2的行，后面还可以添加多个keyword
SELECT * FROM table_name WHERE logmsg MATCH_ALL 'keyword1 keyword2';
--- 1.4 logmsg中同时包含keyword1和keyword2的行，并且按照keyword1在前，keyword2在后的顺序
+-- 1.4 不指定slop时短语查询slop为0，keyword1 keyword2位置相邻，可以通过~指定短语查询的slop
SELECT * FROM table_name WHERE logmsg MATCH_PHRASE 'keyword1 keyword2';
+SELECT * FROM table_name WHERE logmsg MATCH_PHRASE 'keyword1 keyword2 ~3';
-- 1.5
在保持词顺序的前提下，对最后一个词keyword2做前缀匹配，默认找50个前缀词（session变量inverted_index_max_expansions控制）
SELECT * FROM table_name WHERE logmsg MATCH_PHRASE_PREFIX 'keyword1 keyword2';
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/table-design/index/inverted-index.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/table-design/index/inverted-index.md
index b9ed28d34a..081e2f9732 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/table-design/index/inverted-index.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/table-design/index/inverted-index.md
@@ -228,8 +228,9 @@ SELECT * FROM table_name WHERE logmsg MATCH_ANY 'keyword1
keyword2';
-- 1.3 logmsg 中同时包含 keyword1 和 keyword2 的行，后面还可以添加多个 keyword
SELECT * FROM table_name WHERE logmsg MATCH_ALL 'keyword1 keyword2';
--- 1.4 logmsg 中同时包含 keyword1 和 keyword2 的行，并且按照 keyword1 在前，keyword2 在后的顺序
+-- 1.4 不指定slop时短语查询slop为0，keyword1 keyword2位置相邻，可以通过~指定短语查询的slop
SELECT * FROM table_name WHERE logmsg MATCH_PHRASE 'keyword1 keyword2';
+SELECT * FROM table_name WHERE logmsg MATCH_PHRASE 'keyword1 keyword2 ~3';
-- 2. 普通等值、范围、IN、NOT IN，正常的 SQL 语句即可，例如
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-table/index/inverted-index.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-table/index/inverted-index.md
index 53461d8a02..bb1753f9f9 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-table/index/inverted-index.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-table/index/inverted-index.md
@@ -179,8 +179,9 @@ SELECT * FROM table_name WHERE logmsg MATCH_ANY 'keyword1
keyword2';
-- 1.3 logmsg中同时包含keyword1和keyword2的行，后面还可以添加多个keyword
SELECT * FROM table_name WHERE logmsg MATCH_ALL 'keyword1 keyword2';
--- 1.4 logmsg中同时包含keyword1和keyword2的行，并且按照keyword1在前，keyword2在后的顺序
+-- 1.4 不指定slop时短语查询slop为0，keyword1 keyword2位置相邻，可以通过~指定短语查询的slop
SELECT * FROM table_name WHERE logmsg MATCH_PHRASE 'keyword1 keyword2';
+SELECT * FROM table_name WHERE logmsg MATCH_PHRASE 'keyword1 keyword2 ~3';
-- 1.5
在保持词顺序的前提下，对最后一个词keyword2做前缀匹配，默认找50个前缀词（session变量inverted_index_max_expansions控制）
SELECT * FROM table_name WHERE logmsg MATCH_PHRASE_PREFIX 'keyword1 keyword2';
diff --git a/versioned_docs/version-2.0/table-design/index/inverted-index.md
b/versioned_docs/version-2.0/table-design/index/inverted-index.md
index f6a1211810..5491595488 100644
--- a/versioned_docs/version-2.0/table-design/index/inverted-index.md
+++ b/versioned_docs/version-2.0/table-design/index/inverted-index.md
@@ -175,8 +175,9 @@ SELECT * FROM table_name WHERE logmsg MATCH_ANY 'keyword1
keyword2';
-- 1.3 find rows that logmsg contains both keyword1 and keyword2 and more
keywords
SELECT * FROM table_name WHERE logmsg MATCH_ALL 'keyword1 keyword2';
--- 1.4 find rows that logmsg contains both keyword1 and keyword2, and in the
order of keyword1 appearing first and keyword2 appearing later.
+-- 1.4 When not specifying a slop for a phrase query, the default slop is 0,
meaning "keyword1 keyword2" must be adjacent. You can specify the slop for a
phrase query using the tilde (~) symbol.
SELECT * FROM table_name WHERE logmsg MATCH_PHRASE 'keyword1 keyword2';
+SELECT * FROM table_name WHERE logmsg MATCH_PHRASE 'keyword1 keyword2 ~3';
-- 2. normal equal, range query
SELECT * FROM table_name WHERE id = 123;
diff --git a/versioned_docs/version-2.1/data-table/index/inverted-index.md
b/versioned_docs/version-2.1/data-table/index/inverted-index.md
index 3e76e325b9..cfd8f6cf20 100644
--- a/versioned_docs/version-2.1/data-table/index/inverted-index.md
+++ b/versioned_docs/version-2.1/data-table/index/inverted-index.md
@@ -181,8 +181,9 @@ SELECT * FROM table_name WHERE logmsg MATCH_ANY 'keyword1
keyword2';
-- 1.3 find rows that logmsg contains both keyword1 and keyword2 and more
keywords
SELECT * FROM table_name WHERE logmsg MATCH_ALL 'keyword1 keyword2';
--- 1.4 find rows that logmsg contains both keyword1 and keyword2, and in the
order of keyword1 appearing first and keyword2 appearing later.
+-- 1.4 When not specifying a slop for a phrase query, the default slop is 0,
meaning "keyword1 keyword2" must be adjacent. You can specify the slop for a
phrase query using the tilde (~) symbol.
SELECT * FROM table_name WHERE logmsg MATCH_PHRASE 'keyword1 keyword2';
+SELECT * FROM table_name WHERE logmsg MATCH_PHRASE 'keyword1 keyword2 ~3';
-- 1.5 perform prefix matching on the last word "keyword2" while maintaining
the order of words, defaulting to finding 50 prefix words (controlled by the
session variable inverted_index_max_expansions)
SELECT * FROM table_name WHERE logmsg MATCH_PHRASE_PREFIX 'keyword1 keyword2';
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
