hive中User: xxx is not allowed to impersonate xxx

最新推荐文章于 2023-10-12 13:46:24 发布

原创最新推荐文章于 2023-10-12 13:46:24 发布 · 2k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#hive

本文介绍了解决Hive插入数据时报权限错误的方法。通过调整hive-site.xml中的hive.server2.enable.doAs配置项，可以避免因用户权限问题导致的任务失败。

今天使用hive，插入数据是使用insert，遇到报错

INFO  : Launching Job 1 out of 3
INFO  : Starting task [Stage-1:MAPRED] in serial mode
INFO  : Number of reduce tasks determined at compile time: 1
INFO  : In order to change the average load for a reducer (in bytes):
INFO  :   set hive.exec.reducers.bytes.per.reducer=<number>
INFO  : In order to limit the maximum number of reducers:
INFO  :   set hive.exec.reducers.max=<number>
INFO  : In order to set a constant number of reducers:
INFO  :   set mapreduce.job.reduces=<number>
ERROR : Job Submission failed with exception 'org.apache.hadoop.security.authorize.AuthorizationException(User: bigdata is not allowed to impersonate bigdata)'
org.apache.hadoop.security.authorize.AuthorizationException: User: bigdata is not allowed to impersonate bigdata

ERROR : FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask. User: bigdata is not allowed to impersonate bigdata
INFO  : Completed executing command(queryId=bigdata_20220114234734_7f82943d-3d16-4314-9224-c958dac724a8); Time taken: 852.104 seconds

后面发现是hive-site.xml文件出现问题，没有添加
hive.server2.enable.doAs配置
在hive目录下的conf文件下的hive-site.xml文件，添加配置

 <property>
        <name>hive.server2.enable.doAs</name>
        <value>false</value>
</property>

然后就可以正常操作了

hive.server2.enable.doAs设置成false则，yarn作业获取到的hiveserver2用户都为hive用户。

设置成true则为实际的用户名