This is an automated email from the ASF dual-hosted git repository.
yiguolei pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris.git
The following commit(s) were added to refs/heads/master by this push:
new 47dfd915c6 [doc](faq) add Problem with the SSL CA cert FAQ (#11982)
47dfd915c6 is described below
commit 47dfd915c6a116d315214bf395495be58de39f95
Author: Mingyu Chen <morningman....@gmail.com>
AuthorDate: Wed Aug 24 09:13:16 2022 +0800
[doc](faq) add Problem with the SSL CA cert FAQ (#11982)
---
docs/en/docs/faq/sql-faq.md | 18 ++++++++++++++++++
docs/zh-CN/docs/faq/sql-faq.md | 8 ++++++++
2 files changed, 26 insertions(+)
diff --git a/docs/en/docs/faq/sql-faq.md b/docs/en/docs/faq/sql-faq.md
index 348a5d54a0..26d8533631 100644
--- a/docs/en/docs/faq/sql-faq.md
+++ b/docs/en/docs/faq/sql-faq.md
@@ -76,3 +76,21 @@ In version 1.1.x, when vectorization is enabled, and the
bitmp type field in the
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
+
+### Q5. The problem of querying bitmap/hll type data returns NULL
+
+In version 1.1.x, when vectorization is turned on, 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
+
+### Q6. Error when accessing object storage: curl 77: Problem with the SSL CA
cert
+
+If the `curl 77: Problem with the SSL CA cert` error appears in the be.INFO
log. You can try to solve it in the following ways:
+
+1. Download the certificate at
[https://curl.se/docs/caextract.html](https://curl.se/docs/caextract.html):
cacert.pem
+2. Copy the certificate to the specified location: `sudo cp /tmp/cacert.pem
/etc/ssl/certs/ca-certificates.crt`
+3. Restart the BE node.
diff --git a/docs/zh-CN/docs/faq/sql-faq.md b/docs/zh-CN/docs/faq/sql-faq.md
index 530062c45b..79cc41eb82 100644
--- a/docs/zh-CN/docs/faq/sql-faq.md
+++ b/docs/zh-CN/docs/faq/sql-faq.md
@@ -76,3 +76,11 @@ Doris的 Master FE 节点会主动发送心跳给各个FE或BE节点，并且在
3. 关闭 SQL 缓存 `set [global] enable_sql_cache = false;`
这里是因为 bitmap / hll 类型在向量化执行引擎中：输入均为NULL，则输出的结果也是NULL而不是0
+
+### Q6. 访问对象存储时报错：curl 77: Problem with the SSL CA cert
+
+如果 be.INFO 日志中出现 `curl 77: Problem with the SSL CA cert` 错误。可以尝试通过以下方式解决：
+
+1. 在
[https://curl.se/docs/caextract.html](https://curl.se/docs/caextract.html)
下载证书：cacert.pem
+2. 拷贝证书到指定位置：`sudo cp /tmp/cacert.pem /etc/ssl/certs/ca-certificates.crt`
+3. 重启 BE 节点。
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
