My Oracle Support Banner

Using Hive and Running "Show Current Roles" Command "FAILED: SemanticException The current builtin authorization in Hive is incomplete and disabled. (state=42000,code=40000)" (Doc ID 2594344.1)

Last updated on NOVEMBER 19, 2019

Applies to:

Big Data Cloud Service - Version 1.0 and later
Big Data Appliance Integrated Software - Version 4.10.0 and later
Information in this document applies to any platform.

Symptoms

NOTE: In the examples that follow, user details, table name, company name, email, hostnames, etc. represent a fictitious sample (and are used to provide an illustrative example only). Any similarity to actual persons, or entities, living or dead, is purely coincidental and not intended in any manner.

When running the "show current roles" hive command in beeline on a Big Data Appliance (BDA), or Big Data Cloud Service (BDCS)cluster, the command fails with error:

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.