Support Questions
Find answers, ask questions, and share your expertise

What Hive user belongs to the admin role?

Explorer

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".

1 ACCEPTED SOLUTION

Accepted Solutions

Explorer
1 REPLY 1

Explorer