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 <33418555+zzzxl1...@users.noreply.github.com> 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: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org