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 ?
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.