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 local inpath query failing with the below error

Highlighted

HIve load data local inpath query failing with the below error

Super Collaborator

LOAD DATA LOCAL INPATH '/tmp/sample.txt' OVERWRITE INTO TABLE employee;

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)

0: jdbc:hive2://starbucks-spark-job-test:2181> dfs -ls /user/hive;

Error: Error while processing statement: Permission denied: Principal [name=hive, type=USER] does not have following privileges for operation DFS [ADMIN] (state=,code=1)

0: jdbc:hive2://starbucks-spark-job-test:2181> dfs -ls /tmp;

Error: Error while processing statement: Permission denied: Principal [name=hive, type=USER] does not have following privileges for operation DFS [ADMIN] (state=,code=1)

0: jdbc:hive2://starbucks-spark-job-test:2181>


In hive config i have found below property in Advanced HiveServer2-site

hive.conf.restricted.list = hive.security.authenticator.manager,hive.security.authorization.manager,hive.security.metastore.authorization.manager,hive.security.metastore.authenticator.manager,hive.users.in.admin.role,hive.server2.xsrf.filter.enabled,hive.security.authorization.enabled

do something we need to change above property ??

Please Advice ?