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

[#1]

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

[#2]

Hi @kavitha velaga

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

[#3]

thank you very much Ryan

[#4]

@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

[#5]

thank you very much

[#6 · Accepted solution]

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

[#7]

thank you very much Divakar