This is an automated email from the ASF dual-hosted git repository.

morningman 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 d59f750570d [doc] permission issues when adding and inserting data 
into Hive.  (#2271)
d59f750570d is described below

commit d59f750570d102cace4b7668325b8e017aba740a
Author: wuwenchi <[email protected]>
AuthorDate: Thu Apr 10 22:33:59 2025 +0800

    [doc] permission issues when adding and inserting data into Hive.  (#2271)
    
    ## Versions
    
    - [x] dev
    - [x] 3.0
    - [x] 2.1
    - [ ] 2.0
    
    ## Languages
    
    - [x] Chinese
    - [x] English
    
    ## Docs Checklist
    
    - [ ] Checked by AI
    - [ ] Test Cases Built
---
 docs/faq/lakehouse-faq.md                                             | 4 ++++
 .../zh-CN/docusaurus-plugin-content-docs/current/faq/lakehouse-faq.md | 4 ++++
 .../docusaurus-plugin-content-docs/version-2.1/faq/lakehouse-faq.md   | 4 ++++
 .../docusaurus-plugin-content-docs/version-3.0/faq/lakehouse-faq.md   | 4 ++++
 versioned_docs/version-2.1/faq/lakehouse-faq.md                       | 4 ++++
 versioned_docs/version-3.0/faq/lakehouse-faq.md                       | 4 ++++
 6 files changed, 24 insertions(+)

diff --git a/docs/faq/lakehouse-faq.md b/docs/faq/lakehouse-faq.md
index 4b346f9c696..b62f2a28213 100644
--- a/docs/faq/lakehouse-faq.md
+++ b/docs/faq/lakehouse-faq.md
@@ -244,6 +244,10 @@ ln -s 
/etc/pki/ca-trust/extracted/openssl/ca-bundle.trust.crt /etc/ssl/certs/ca-
 
     It is because the Doris built-in `libz.a` conflicts with the system 
environment's `libz.so`. To resolve this issue, first execute `export 
LD_LIBRARY_PATH=/path/to/be/lib:$LD_LIBRARY_PATH`, and then restart the BE 
process.
 
+12. When inserting data into Hive, an error occurred as 
`HiveAccessControlException Permission denied: user [user_a] does not have 
[UPDATE] privilege on [database/table]`.
+
+    Since after inserting the data, the corresponding statistical information 
needs to be updated, and this update operation requires the alter privilege. 
Therefore, the alter privilege needs to be added for this user on Ranger.
+
 ## HDFS
 
 1. When accessing HDFS 3.x, if you encounter the error `java.lang.VerifyError: 
xxx`, in versions prior to 1.2.1, Doris depends on Hadoop version 2.8. You need 
to update to 2.10.2 or upgrade Doris to versions after 1.2.2.
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/faq/lakehouse-faq.md 
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/faq/lakehouse-faq.md
index 6970a38fe6e..f7c3ea2d82b 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/current/faq/lakehouse-faq.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/current/faq/lakehouse-faq.md
@@ -272,6 +272,10 @@ ln -s 
/etc/pki/ca-trust/extracted/openssl/ca-bundle.trust.crt /etc/ssl/certs/ca-
 
     为了解决这个问题,需要先执行 `export LD_LIBRARY_PATH=/path/to/be/lib:$LD_LIBRARY_PATH` 
然后重启 BE 进程。
 
+12. 在插入 hive 数据的时候报错:`HiveAccessControlException Permission denied: user 
[user_a] does not have [UPDATE] privilege on [database/table]`。
+
+    因为插入数据之后,需要更新对应的统计信息,这个更新的操作需要 alter 权限,所以要在 ranger 上给该用户新增 alter 权限。
+
 ## HDFS
 
 1. 访问 HDFS 3.x 时报错:`java.lang.VerifyError: xxx`
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/faq/lakehouse-faq.md 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/faq/lakehouse-faq.md
index 47fcc57e9b6..be95eed6b8b 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/faq/lakehouse-faq.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/faq/lakehouse-faq.md
@@ -272,6 +272,10 @@ ln -s 
/etc/pki/ca-trust/extracted/openssl/ca-bundle.trust.crt /etc/ssl/certs/ca-
 
     为了解决这个问题,需要先执行 `export LD_LIBRARY_PATH=/path/to/be/lib:$LD_LIBRARY_PATH` 
然后重启 BE 进程。
 
+12. 在插入 hive 数据的时候报错:`HiveAccessControlException Permission denied: user 
[user_a] does not have [UPDATE] privilege on [database/table]`。
+
+    因为插入数据之后,需要更新对应的统计信息,这个更新的操作需要 alter 权限,所以要在 ranger 上给该用户新增 alter 权限。
+
 ## HDFS
 
 1. 访问 HDFS 3.x 时报错:`java.lang.VerifyError: xxx`
diff --git 
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/faq/lakehouse-faq.md 
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/faq/lakehouse-faq.md
index 47fcc57e9b6..be95eed6b8b 100644
--- a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/faq/lakehouse-faq.md
+++ b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/faq/lakehouse-faq.md
@@ -272,6 +272,10 @@ ln -s 
/etc/pki/ca-trust/extracted/openssl/ca-bundle.trust.crt /etc/ssl/certs/ca-
 
     为了解决这个问题,需要先执行 `export LD_LIBRARY_PATH=/path/to/be/lib:$LD_LIBRARY_PATH` 
然后重启 BE 进程。
 
+12. 在插入 hive 数据的时候报错:`HiveAccessControlException Permission denied: user 
[user_a] does not have [UPDATE] privilege on [database/table]`。
+
+    因为插入数据之后,需要更新对应的统计信息,这个更新的操作需要 alter 权限,所以要在 ranger 上给该用户新增 alter 权限。
+
 ## HDFS
 
 1. 访问 HDFS 3.x 时报错:`java.lang.VerifyError: xxx`
diff --git a/versioned_docs/version-2.1/faq/lakehouse-faq.md 
b/versioned_docs/version-2.1/faq/lakehouse-faq.md
index 4b346f9c696..b62f2a28213 100644
--- a/versioned_docs/version-2.1/faq/lakehouse-faq.md
+++ b/versioned_docs/version-2.1/faq/lakehouse-faq.md
@@ -244,6 +244,10 @@ ln -s 
/etc/pki/ca-trust/extracted/openssl/ca-bundle.trust.crt /etc/ssl/certs/ca-
 
     It is because the Doris built-in `libz.a` conflicts with the system 
environment's `libz.so`. To resolve this issue, first execute `export 
LD_LIBRARY_PATH=/path/to/be/lib:$LD_LIBRARY_PATH`, and then restart the BE 
process.
 
+12. When inserting data into Hive, an error occurred as 
`HiveAccessControlException Permission denied: user [user_a] does not have 
[UPDATE] privilege on [database/table]`.
+
+    Since after inserting the data, the corresponding statistical information 
needs to be updated, and this update operation requires the alter privilege. 
Therefore, the alter privilege needs to be added for this user on Ranger.
+
 ## HDFS
 
 1. When accessing HDFS 3.x, if you encounter the error `java.lang.VerifyError: 
xxx`, in versions prior to 1.2.1, Doris depends on Hadoop version 2.8. You need 
to update to 2.10.2 or upgrade Doris to versions after 1.2.2.
diff --git a/versioned_docs/version-3.0/faq/lakehouse-faq.md 
b/versioned_docs/version-3.0/faq/lakehouse-faq.md
index 4b346f9c696..b62f2a28213 100644
--- a/versioned_docs/version-3.0/faq/lakehouse-faq.md
+++ b/versioned_docs/version-3.0/faq/lakehouse-faq.md
@@ -244,6 +244,10 @@ ln -s 
/etc/pki/ca-trust/extracted/openssl/ca-bundle.trust.crt /etc/ssl/certs/ca-
 
     It is because the Doris built-in `libz.a` conflicts with the system 
environment's `libz.so`. To resolve this issue, first execute `export 
LD_LIBRARY_PATH=/path/to/be/lib:$LD_LIBRARY_PATH`, and then restart the BE 
process.
 
+12. When inserting data into Hive, an error occurred as 
`HiveAccessControlException Permission denied: user [user_a] does not have 
[UPDATE] privilege on [database/table]`.
+
+    Since after inserting the data, the corresponding statistical information 
needs to be updated, and this update operation requires the alter privilege. 
Therefore, the alter privilege needs to be added for this user on Ranger.
+
 ## HDFS
 
 1. When accessing HDFS 3.x, if you encounter the error `java.lang.VerifyError: 
xxx`, in versions prior to 1.2.1, Doris depends on Hadoop version 2.8. You need 
to update to 2.10.2 or upgrade Doris to versions after 1.2.2.


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to