hive中User: xxx is not allowed to impersonate xxx

hive中User: xxx is not allowed to impersonate xxx,第1张

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 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文件,添加配置

 
        hive.server2.enable.doAs
        false


然后就可以正常 *** 作了

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

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

欢迎分享,转载请注明来源:内存溢出

原文地址: http://outofmemory.cn/zaji/5705437.html

(0)
打赏 微信扫一扫 微信扫一扫 支付宝扫一扫 支付宝扫一扫
上一篇 2022-12-17
下一篇 2022-12-17

发表评论

登录后才能评论

评论列表(0条)

保存