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

i am getting the below error : FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Got exception: org.apache.hadoop.security.AccessControlException Permission denied:

when I try to external create a hive table with data in the hdfs.

I just have the read access and not write access, is that a problem?

Answers


Yes, you need write access to create external table in hive. then if you are using dynamic partition then you have to unable dynamic partition true. for that use below code.

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

Need Your Help

Understanding Equatable in swift 3?

ios arrays swift swift3

I have an array of enum which I need to delete one of the Enum. I have written generic remove operation based on here. We usually conform Equatable to Struct. So I am curious how Equatable will beh...

Add variables whilst ignoring NA`s using transform function

r

I have a data frame with a large number of variables. I am creating new variables by adding together some of the old ones. The code I am using to do so is: