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 error

hive load data error

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)/

2 REPLIES 2

Re: hive load data error

Explorer

Can you check if user hive is having access to empdata.tx file?

Highlighted

Re: hive load data error

Mentor

@Manoj690 

I think this is a permission issue that should be resolved if you followed the below steps

Solution:

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). If it doesn't already exist 

 

Restart the stale Hive services for the changes to take effect then retry