Beeline連接hiveserver2報錯
報錯資訊
Error: Could not open client transport with JDBC Uri: jdbc:hive2://node-4:10000: Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: root is not allowed to impersonate root (state=08S01,code=0)
報這個錯的關鍵地方是:User: root is not allowed to impersonate root
解決
把hadoop/core-site.xml檔案添加如下內容,然后分發到各個服務器
<property>
<name>hadoop.proxyuser.root.hosts</name>
<value>*</value>
</property>
<property>
<name>hadoop.proxyuser.root.groups</name>
<value>*</value>
</property>
注意
如果報錯資訊是:hadoop is not allowed to impersonate anonymous
(hadoop在這里就是舉個例子,是你自己的用戶名)
要把組態檔里的root改成你自己的用戶名,這里用hadoop舉例,就改為hadoop
<property>
<name>hadoop.proxyuser.hadoop.hosts</name>
<value>*</value>
</property>
<property>
<name>hadoop.proxyuser.hadoop.groups</name>
<value>*</value>
</property>
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/192734.html
標籤：其他
上一篇：FineReader15.0
下一篇：《SQL 必知必會》讀書筆記