question what is the difference between hive.server2.enable.do='true' and hive.server2.enable.impersnation='true'? in Support Questions

what is the difference between hive.server2.enable.do='true' and hive.server2.enable.impersnation='true'?

Neyyu — Wed, 03 Aug 2016 05:06:13 GMT

what is the difference between hive.server2.enable.do='true' and hive.server.enabler.impersnation='true'?

Re: what is the difference between hive.server2.enable.do='true' and hive.server2.enable.impersnation='true'?

RyanCicak — Wed, 03 Aug 2016 05:40:25 GMT

https://cwiki.apache.org/confluence/display/Hive/Setting+Up+HiveServer2

This is the new standard to impersonate (doAs)

hive.server2.enable.doAs – Impersonate the connected user, default true.

The most recent documentation doesn't seem to discuss "hive.server2.enable.impersonation", therefore, I'd stick with doAs

Re: what is the difference between hive.server2.enable.do='true' and hive.server2.enable.impersnation='true'?

mqureshi — Wed, 03 Aug 2016 05:41:24 GMT

@kavitha velaga

I think they are both same and hive community may have changed to the newer "doAs". Try setting hive.server.enable.impersonation to false. I don't think it will make a difference. The property used is hive.server2.enable.doAs

Re: what is the difference between hive.server2.enable.do='true' and hive.server2.enable.impersnation='true'?

divakarreddy_a — Wed, 03 Aug 2016 05:47:00 GMT

@kavitha velaga

hive.server2.enable.do= True --> Run hive scripts as end user instead of Hive user.

= False --> All the jobs will run as hive user.

hive.server2.enable.impersnation --It's old property and no longer in use.

for more info on Hive impersnation:

http://hortonworks.com/blog/best-practices-for-hive-authorization-using-apache-ranger-in-hdp-2-2/

Re: what is the difference between hive.server2.enable.do='true' and hive.server2.enable.impersnation='true'?

Neyyu — Wed, 03 Aug 2016 21:49:31 GMT

thank you very much Divakar

Re: what is the difference between hive.server2.enable.do='true' and hive.server2.enable.impersnation='true'?

Neyyu — Wed, 03 Aug 2016 21:49:59 GMT

thank you very much

Re: what is the difference between hive.server2.enable.do='true' and hive.server2.enable.impersnation='true'?

Neyyu — Wed, 03 Aug 2016 21:50:03 GMT

thank you very much Ryan