This is an automated email from the ASF dual-hosted git repository.
jiafengzheng 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 b07193f063e bloomfilter doc fix
b07193f063e is described below
commit b07193f063ebc7ebc5f2eb8743b66aa6d6edc33f
Author: jiafeng.zhang <[email protected]>
AuthorDate: Tue Aug 9 13:40:23 2022 +0800
bloomfilter doc fix
---
docs/data-table/index/bloomfilter.md | 5 +++--
.../current/data-table/index/bloomfilter.md | 10 +++++-----
2 files changed, 8 insertions(+), 7 deletions(-)
diff --git a/docs/data-table/index/bloomfilter.md
b/docs/data-table/index/bloomfilter.md
index feba85f72b4..eaf92303b66 100644
--- a/docs/data-table/index/bloomfilter.md
+++ b/docs/data-table/index/bloomfilter.md
@@ -123,11 +123,12 @@ You can consider establishing a Bloom Filter index for a
column when the followi
2. The query will be filtered according to the high frequency of the column,
and most of the query conditions are in and = filtering.
-3. Unlike Bitmap, BloomFilter is suitable for high cardinality columns. Such
as UserID. Because if it is created on a low-cardinality column, such as a
"gender" column, each Block will almost contain all values, causing the
BloomFilter index to lose its meaning
+3. Unlike Bitmap, BloomFilter is suitable for high cardinality columns. Such
as UserID. Because if it is created on a low-cardinality column, such as a
"gender" column, each Block will almost contain all values, causing the
BloomFilter index to lose its meaning.
### **Doris BloomFilter use precautions**
1. It does not support the creation of Bloom Filter indexes for Tinyint,
Float, and Double columns.
2. The Bloom Filter index only has an acceleration effect on in and =
filtering queries.
-3. If you want to check whether a query hits the Bloom Filter index, you can
check the profile information of the query
+
+3. If you want to check whether a query hits the Bloom Filter index, you can
check the profile information of the query.
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-table/index/bloomfilter.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-table/index/bloomfilter.md
index cf18df47f99..4382feccaaa 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-table/index/bloomfilter.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-table/index/bloomfilter.md
@@ -116,12 +116,12 @@ ALTER TABLE <db.table_name> SET ("bloom_filter_columns" =
"k1,k3");
满足以下几个条件时可以考虑对某列建立Bloom Filter 索引：
-1. 首先BloomFilter适用于非前缀过滤.
-2. 查询会根据该列高频过滤，而且查询条件大多是in和 = 过滤.
-3. 不同于Bitmap,
BloomFilter适用于高基数列。比如UserID。因为如果创建在低基数的列上，比如”性别“列，则每个Block几乎都会包含所有取值，导致BloomFilter索引失去意义
+1. 首先BloomFilter适用于非前缀过滤。
+2. 查询会根据该列高频过滤，而且查询条件大多是 in 和 = 过滤。
+3. 不同于Bitmap, BloomFilter适用于高基数列。比如UserID。因为如果创建在低基数的列上，比如 “性别”
列，则每个Block几乎都会包含所有取值，导致BloomFilter索引失去意义。
## **Doris BloomFilter使用注意事项**
1. 不支持对Tinyint、Float、Double 类型的列建Bloom Filter索引。
-2. Bloom Filter索引只对in和 = 过滤查询有加速效果。
-3. 如果要查看某个查询是否命中了Bloom Filter索引，可以通过查询的Profile信息查看
+2. Bloom Filter索引只对 in 和 = 过滤查询有加速效果。
+3. 如果要查看某个查询是否命中了Bloom Filter索引，可以通过查询的Profile信息查看。
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
