Support Questions
Find answers, ask questions, and share your expertise

Hive View 2.0 AuthorizationException


Hi all,

We're having issues launching queries from the Hive View 2.0, with a simple show tables query we're getting the following exception:

Caused by: org.apache.hadoop.ipc.RemoteException( Unauthorized connection for super-user: hortonworks from IP
 at org.apache.hadoop.hdfs.web.JsonUtil.toRemoteException(
 at org.apache.hadoop.hdfs.web.WebHdfsFileSystem.validateResponse(

We've been reading quite a lot and find out that some people have experimented the same issue. They have solved it by changing the hdfs.proxy settings, we've tried that and no luck for us, see attached our current values (hdfsprops)

It's important to notice that we've also have Ranger up & running and both the hive and hdfs plugins are enabled. We've granted permissions in Ranger for all the users (admin, hortonworks...)

Permissions in HDFS within the folder where hive is trying to write seem also to be ok.

Any ideas??