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 7b2ff9839e3 Description of bitmap type query result is null
7b2ff9839e3 is described below
commit 7b2ff9839e301d3749240faa054200d5fb1c483e
Author: jiafeng.zhang <zhang...@gmail.com>
AuthorDate: Thu Aug 4 15:02:58 2022 +0800
Description of bitmap type query result is null
Description of bitmap type query result is null
---
docs/faq/sql-faq.md | 10 ++++++++++
.../docusaurus-plugin-content-docs/current/faq/sql-faq.md | 10 ++++++++++
2 files changed, 20 insertions(+)
diff --git a/docs/faq/sql-faq.md b/docs/faq/sql-faq.md
index 6e30ae2a60d..348a5d54a08 100644
--- a/docs/faq/sql-faq.md
+++ b/docs/faq/sql-faq.md
@@ -66,3 +66,13 @@ For example, the table is defined as k1, v1. A batch of
imported data is as foll
Then maybe the result of copy 1 is `1, "abc"`, and the result of copy 2 is `1,
"def"`. As a result, the query results are inconsistent.
To ensure that the data sequence between different replicas is unique, you can
refer to the [Sequence
Column](../data-operate/update-delete/sequence-column-manual.md) function.
+
+### Q5. The problem of querying bitmap/hll type data returns NULL
+
+In version 1.1.x, when vectorization is enabled, and the bitmp type field in
the query data table returns a NULL result,
+
+1. First you have to `set return_object_data_as_binary=true;`
+2. Turn off vectorization `set enable_vectorized_engine=false;`
+3. Turn off SQL cache `set [global] enable_sql_cache = false;`
+
+This is because the bitmap / hll type is in the vectorized execution engine:
the input is all NULL, and the output result is also NULL instead of 0
diff --git a/i18n/zh-CN/docusaurus-plugin-content-docs/current/faq/sql-faq.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/faq/sql-faq.md
index ae8fadce106..530062c45b4 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/faq/sql-faq.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/faq/sql-faq.md
@@ -66,3 +66,13 @@ Doris的 Master FE 节点会主动发送心跳给各个FE或BE节点，并且在
那么可能副本1 的结果是 `1, "abc"`，而副本2 的结果是 `1, "def"`。从而导致查询结果不一致。
为了确保不同副本之间的数据先后顺序唯一，可以参考 [Sequence
Column](../data-operate/update-delete/sequence-column-manual.md) 功能。
+
+### Q5. 查询 bitmap/hll 类型的数据返回 NULL 的问题
+
+在 1.1.x 版本中，在开启向量化的情况下，执行查询数据表中 bitmp 类型字段返回结果为 NULL 的情况下，
+
+1. 首先你要 `set return_object_data_as_binary=true;`
+2. 关闭向量化 `set enable_vectorized_engine=false;`
+3. 关闭 SQL 缓存 `set [global] enable_sql_cache = false;`
+
+这里是因为 bitmap / hll 类型在向量化执行引擎中：输入均为NULL，则输出的结果也是NULL而不是0
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
