hadoop - External hive table with partition - permission error when i add partition with the data having read access -

i getting below error : failed: execution error, return code 1 org.apache.hadoop.hive.ql.exec.ddltask. metaexception(message:got exception: org.apache.hadoop.security.accesscontrolexception permission denied:

when try external create hive table data in hdfs.

i have read access , not write access, problem?

yes, need write access create external table in hive. if using dynamic partition have unable dynamic partition true. use below code.

set hive.exec.dynamic.partition.mode=nonstrict; set hive.exec.dynamic.partition=true;