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.

Hive : User does not belong to hive error

Hive : User does not belong to hive error

Explorer

chgrp: changing ownership of 'hdfs://xxxxxx': User does not belong to hive

hive> SHOW CURRENT ROLES; FAILED: SemanticException The current builtin authorization in Hive is incomplete and disabled.

Am getting user does not belong to Hive and current roles is not working.

Is it because of user not assigned to hive warehouse ?

3 REPLIES 3

Re: Hive : User does not belong to hive error

Mentor

@Ram

CREATE ROLE is done in beeline, not HIVE and thereafter grant privileges with beeline
Highlighted

Re: Hive : User does not belong to hive error

Explorer

DDL and DML statements has to be run in CLI mode or beeline mode ?

Re: Hive : User does not belong to hive error

Cloudera Employee

Looks like you have authorization enabled , but have authorization.manager set to the default (legacy) authorizer.

It also looks like you are using some variant of hive that deviates from apache hive. That above error message is not something that appears in apache hive (which Hive in HDP is closely based on).

You would want to refer to the documents to setup authorization properly , and use either sql std auth or ranger. Sql std auth docs are here - https://cwiki.apache.org/confluence/display/Hive/SQL+Standard+Based+Hive+Authorization

Also, as Geoffrey mentioned, grant/revoke based authorization are not supported/effective in HIVE CLI for sql std auth or ranger. You would want to use beeline with HiveServer2.