Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Solved Go to solution

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

Expert Contributor

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. 

1 ACCEPTED SOLUTION

Accepted Solutions

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

Expert Contributor

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.

5 REPLIES 5

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

Expert Contributor

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.

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

Expert Contributor

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?

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


@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 !

Highlighted

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

Explorer

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

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

New Contributor

how could we use beeline to create role?