Reply
Highlighted
Expert Contributor
Posts: 147
Registered: ‎09-29-2014
Accepted Solution

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

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. 

Expert Contributor
Posts: 147
Registered: ‎09-29-2014

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

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.

Expert Contributor
Posts: 93
Registered: ‎09-17-2014

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

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?

Explorer
Posts: 10
Registered: ‎07-29-2014

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

[ Edited ]

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 !

New Contributor
Posts: 4
Registered: ‎06-30-2016

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

how could we use beeline to create role?

New Contributor
Posts: 4
Registered: ‎03-08-2017

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

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

Announcements