从 Hive 表创建 Elasticsearch 表时出错 - HiveAccessControlException 权限被拒绝：用户没有 [RWSTORAGE] 权限

发布于 2025-01-12 08:28:32 字数 657 浏览 0 评论 0原文

我有一个 Hive 表，我想将其转换为 Elasticsearch 索引。当我尝试创建 Elasticsearch 索引时，出现如下错误。

我将不胜感激调试此问题的任何帮助。我已经检查了 Ranger 政策，但它并没有帮助我解决问题。

这是错误消息：

错误：编译语句时出错：失败： HiveAccessControlException 权限被拒绝：用户 [ab_user] 没有对 [esstoragehandler://upsert/////false/] 拥有 [RWSTORAGE] 权限（状态=42000，代码=40000）

关于 Ranger 的说明：在这种情况下，我无法直接访问 Ranger，我必须请其他人为我执行此操作。我在 Ranger 上请求了以下权限，请告诉我这是否正确。

Elasticsearch StoragerHandler policy:
Storage Type: EsStorageHandler
Storage Url: esstoragehandler://upsert/<ES server ip>/<index key>/<index name>/<ES Port>/false/

提前致谢！

原文

I have a Hive table that I want to convert to an Elasticsearch index. When I try to create the Elasticsearch index, I am getting the error shown as below.

I will appreciate any help in debugging this issue. I have checked the Ranger policies but it did not help me resolve the issue.

Here is the error message:

Error: Error while compiling statement: FAILED:
HiveAccessControlException Permission denied: user [ab_user] does not
have [RWSTORAGE] privilege on [esstoragehandler://upsert/////false/]
(state=42000,code=40000)

A note on Ranger: In this case, I do not have access to Ranger directly, and I have to ask someone else to do this for me. I requested for following permissions on Ranger, please let me know if this is correct.

Elasticsearch StoragerHandler policy:
Storage Type: EsStorageHandler
Storage Url: esstoragehandler://upsert/<ES server ip>/<index key>/<index name>/<ES Port>/false/

Thanks in advance!

分享到QQ

分享到微博