question hive-interactive and hive.server2.enable.doas in Archives of Support Questions (Read Only)

hive-interactive and hive.server2.enable.doas

guillaume_roger — Thu, 15 Jun 2017 15:06:08 GMT

I was using hive 1 with hive.server2.enable.doas=true. Now I want to use hive-interactive, but hive.server2.enable.doas has to be false apparently (that is what ambari says). This of course makes most of my queries break because of wrong permissions.

I am curious to know

why this setting cannot be true
is there know workaround for this.

Context: hdp 2.6 with hive and hive-interactive.

Thanks!

Re: hive-interactive and hive.server2.enable.doas

ledel — Thu, 15 Jun 2017 18:58:57 GMT

@Guillaume Roger

you can set doas to true but it's advised not to for some reasons.

For example, when setting doAs to false then HS2 is able to share resources

you're encouraged to use Ranger instead of file-based permissions (SQL permissions are available and translated to Ranger rules when activated), it's more secure and you can even set permissions to a column level.

Re: hive-interactive and hive.server2.enable.doas

nasmart.me — Sat, 06 Jan 2018 06:30:50 GMT

It's worth reading this https://community.hortonworks.com/questions/146229/hive-llap-has-conflict-with-hive-sql-standadard-au.html