Problem
Executing sql in ambari’s hive view reports an error Unauthorized connection for super-user: root from IP
Solution
On the Ambari Web UI, select Services > HDFS > Configs.
Advanced option in the core-site section.
Add the following two lines and change the corresponding values if they already exist
hadoop.proxyuser.root.groups=*
hadoop.proxyuser.root.hosts=*Restart corresponding services
Similar Posts:
- [Solved] hive beeline Connect Error: User:*** is not allowed to impersonate
- Hive Error: root is not allowed to impersonate root (state=08S01,code=0)
- Hiveserver2 Connect Error: Could not open client transport with JDBC Uri: jdbc:hive2://hadoop01:100…
- [Solved] Exception in thread “main“ java.net.ConnectException: Call From
- Solution to unknown hostexception error when HBase starts regionserver
- Hadoop command error: permission problem [How to Solve]
- Error: Could not find or load main class org.apache.hadoop.mapreduce.v2.app.MRAppMaster
- [Solved] Hadoop runs start-dfs.sh error: attempting to operate on HDFS as root
- [Solved] Hadoop3 Install Error: there is no HDFS_NAMENODE_USER defined. Aborting operation.
- HDFS problem set (1), use the command to report an error: com.google.protobuf.servicee xception:java.lang.OutOfMemoryError :java heap space