FAILED: SemanticException The current builtin authorization in Hive is incomplete and disabled.

[#1]

i have installed Sentry, and tried to combine HIVE and sentry to work together. then i followed the documentation to setup sentry service configuration, and setup LDAP group mapping. from the namenode log and LDAP log i can sure the GROUP mapping is normal. 

but when i issued create role role_name in HIVE, the it appears the error like "FAILED: SemanticException The current builtin authorization in Hive is incomplete and disabled."

anybody has suffered this kind errors?  can you give some advises. thanks. 

[#2 · Accepted solution]

i have got to resolve this problems. thanks everybody.

this is becase CREATE ROLE just can be done by beeline, not HIVE.  after grant privileges with beeline, it's ok now.

[#3]

I am getting an error like this in beeline:-

Error: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.SentryGrantRevokeTask. Access denied to admin. Server Stacktrace: org.apache.sentry.provider.db.SentryAccessDeniedException: Access denied to admin

any idea?

[#4]

---

@iamfromsky wrote:

i have got to resolve this problems. thanks everybody.

this is becase CREATE ROLE just can be done by beeline, not HIVE.  after grant privileges with beeline, it's ok now.

---

Can you tell us exactly how to do it step by step ? 

Thanks alot !

[#5]

if you fixed the issue, please tell me how do create roles for hive database and grant permissions.

[#6]

how could we use beeline to create role?