hive中User: xxx is not allowed to impersonate xxx

今天使用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=
INFO  : In order to limit the maximum number of reducers:
INFO  :   set hive.exec.reducers.max=
INFO  : In order to set a constant number of reducers:
INFO  :   set mapreduce.job.reduces=
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 bigdataERROR : 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文件，添加配置

 hive.server2.enable.doAsfalse

然后就可以正常操作了

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

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

本文来自互联网用户投稿，文章观点仅代表作者本人，不代表本站立场，不承担相关法律责任。如若转载，请注明出处。 如若内容造成侵权/违法违规/事实不符，请点击【内容举报】进行投诉反馈！