What Hive user belongs to the admin role?

neagamaxim — Sat, 25 Aug 2018 02:54:01 GMT

It appears that neither "hive" nor "root" are in the admin group by default. Here is what I tried:

su - hive

> beeline

beeline> !connect jdbc:...

Enter username for jdbc:...: hive

Entered password 0: jdbc:...

> set role admin;

Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. hive doesn't belong to role admin (state=08S01,code=1)

I have tried the same as user "root", but also got "root doesn't belong to role admin".

Re: What Hive user belongs to the admin role?

neagamaxim — Sat, 25 Aug 2018 04:41:32 GMT

It looks like I was missing Configuring SQL Standard-Based Authorization.

question What Hive user belongs to the admin role? in Archives of Support Questions (Read Only)

What Hive user belongs to the admin role?

Re: What Hive user belongs to the admin role?