question Ambari - Manage HIVE view - Add Groups using REST in Archives of Support Questions (Read Only)

Ambari - Manage HIVE view - Add Groups using REST

daniel_issaharo — Sat, 17 Aug 2019 23:12:49 GMT

Hello,

I would like to know if is possible to add a Permission Group to the HIVE View (Hive View 2.0) using REST API....

The Group has been created and defined.

Thanks in advance,
Daniel

Re: Ambari - Manage HIVE view - Add Groups using REST

akhilsnaik — Mon, 10 Dec 2018 12:40:00 GMT

Hi @Daniel Issaharoff ,

Can you please try the following REST API :

curl -u <USERNAME>:<PASSWORD> -H "X-Requested-By:ambari" -i -X POST http://<AMBARIFQDN>:8080/api/v1/views/HIVE/versions/2.0.0/instances/<HIVE_INSTANCE_NAME>/privileges -d '[{
    "PrivilegeInfo": {
      "permission_name": "VIEW.USER",
      "principal_name": "<YOUR DESIRED GROUP NAME>",
      "principal_type": "GROUP"
    }
  }]'

for ex :

here qa is the new group privilage i am adding for my AUTO_HIVE20_INSTANCE

curl -u admin:admin -H "X-Requested-By:ambari" -i -X POST http://asnaik1.openstacklocal:8080/api/v1/views/HIVE/versions/2.0.0/instances/AUTO_HIVE20_INSTANCE/privileges -d '[{
    "PrivilegeInfo": {
      "permission_name": "VIEW.USER",
      "principal_name": "qa",
      "principal_type": "GROUP"
    }
  }]'

If this is the answer you are looking for please accept my answer.

Re: Ambari - Manage HIVE view - Add Groups using REST

daniel_issaharo — Mon, 10 Dec 2018 23:35:19 GMT

Hello @Akhil S Naik

Thanks a lot for your prompt reply.... and of course, for your help! It worked!
(I needed to convert it to a PowerShell Invoke-WebRequest call, but it worked fine!
I'm working in an Azure HDInsight cluster, and when the cluster starts Ambari does not have the group defined in the Hive view.
(I don't know why Ambari does not keep that information...)

Once again, Thanks for your help.

Regards,
Daniel

Re: Ambari - Manage HIVE view - Add Groups using REST

daniel_issaharo — Mon, 10 Dec 2018 23:40:56 GMT

For those interested in using this in PowerShell, This is the way I'm calling the REST-API:

$Headers = @{'X-Requested-By' = 'ambari'} 

$Body = '[{"PrivilegeInfo": { "permission_name": "VIEW.USER", "principal_name": "group_poc", "principal_type": "GROUP" } }]' 

$Resp = Invoke-WebRequest -Method Post -Uri "https://<Your-Cluster-Name>/api/v1/views/HIVE/versions/2.0.0/instances/AUTO_HIVE20_INSTANCE/privileges/"  -Credential <Your-Credentials> -Headers $Headers  -Body $Body