Will hive-impersonation works in non-secure hadoop cluster.

[#1]

Can anyone confirm and provide more details on hive-impersonation in hadoop.For, hive-impersonation i believe below 'do.as' property needs to be set to true and does hive-impersonation works on non-secure cluster or it will work only on secure(kerberos) hadoop cluster. hive.server2.enable.do=true

[#2 · Accepted solution]

@rakesh kumar

Hive user impersonation should work irrespective of simple or kerberos hadoop cluster. Please refer to the documenation here.

[#3]

Below post has a pretty good explanation:

https://community.hortonworks.com/questions/2408/ranger-implementation-hive-impersonation-false.html

Hope this helps.

[#4]

@rakesh kumar

Kerberos is for authentication purpose while doAs is for authorization. When doAs is set to true, the queries against Metastore and jobs executed on HADOOP cluster run as the end user as opposed to user "hive". For example, the HDFS permission checks during job executions will be against the end user.