question Re: Will hive-impersonation works in non-secure hadoop cluster. in Archives of Support Questions (Read Only)

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

rakesh_nix08 — Wed, 15 Mar 2017 02:02:24 GMT

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

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

apathan — Wed, 15 Mar 2017 02:08:13 GMT

@rakesh kumar

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

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

namaheshwari — Wed, 15 Mar 2017 03:57:01 GMT

Below post has a pretty good explanation:

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

Hope this helps.

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

tli — Tue, 28 Mar 2017 05:35:15 GMT

@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.