question Re: Configuring hive.users.in.admin.role in Support Questions

Configuring hive.users.in.admin.role

Seaport — Wed, 31 Jul 2019 04:40:06 GMT

I am following the instruction at links below to add users to Hive admin role.

https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.3.2/bk_dataintegration/content/hive-013-feature-sql-standard-based-grant-revoke.html

and

https://community.hortonworks.com/articles/4568/sql-based-authorization-in-hive.html

However, I could not find this configuration "hive.users.in.admin.role" via Ambari UI (Hive - Configs - Advanced). I downloaded the hive_site.xml (via Ambria's Download Client Configs button) and found no such configuration in the xml file either. What did I miss?

Below is my current Hive security settings.

Authorization: SQL-Standard Based (SQLStdAuth)
Authentication: None
Run as end user instead of Hive user: False

Re: Configuring hive.users.in.admin.role

Shelton — Sat, 17 Aug 2019 23:27:26 GMT

@Haijin Li

To be able to help, it's a good idea to always share your cluster config and version. I can see you are referencing HDP 2.3 documentation which is obsolete and personally I am wondering why you are running this version?

Some parameters like hive.users.in.admin.role are not default values in hive_site.xml , so you will need to add them in Custom hive-site these are considered custom site values see attached screenshot Haijin2.png

Authorization: SQL-Standard Based (SQLStdAuth)

Custom values

The above UI is specific to HDP 3.1.0.0 running Ambari Version 2.7.3.0 but even with earlier versions of Ambari you can filter see the ARROW

HTH

Re: Configuring hive.users.in.admin.role

Seaport — Wed, 31 Jul 2019 23:17:43 GMT

@Geoffrey Shelton Okot

That is exactly what I missed. Thank you very much for the prompt and right-to-the-point response.