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 load data not working

HIVE load data not working

Explorer

LOAD DATA LOCAL INPATH 'empdata.txt' OVERWRITE INTO TABLE emp;
Error: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: Principal [name=hive, type=USER] does not have following privileges for operation LOAD [ADMIN] (state=42000,code=40000)

1 REPLY 1

Re: HIVE load data not working

Mentor

@Manoj690 

Go to Ambari > Hive > CONFIGS > ADVANCED > Custom hive-site and add hive.users.in.admin.role to the list of comma-separated users who require admin role authorization (such as the user hive). Restart the Hive services for the changes to take effect.

The permission denied error should be  fixed after adding hive .users.in.admin.role=hive and restarting hive because properties that are listed in hive.conf.restricted.list cannot be reset with hiveconf 

Please do that and revert.
Don't have an account?
Coming from Hortonworks? Activate your account here