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

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

iamfromsky — Fri, 16 Sep 2022 09:09:00 GMT

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.

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

iamfromsky — Fri, 03 Oct 2014 14:50:07 GMT

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.

HDFS — Thu, 16 Oct 2014 21:31:14 GMT

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.

zeeshan.khan — Wed, 08 Jul 2015 10:04:02 GMT

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

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

kingzhou — Fri, 01 Jul 2016 06:10:16 GMT

how could we use beeline to create role?

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

paachu — Thu, 20 Apr 2017 17:53:01 GMT

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