I have to create external Hive tables (and then add partitions on these
tables) on the existing data files in hdfs.
On doing it I am getting the error :
FAILED: Error in metadata:
MetaException(message:java.lang.IllegalStateException: Can't overwrite
cause)
FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask

The solution for this as I found is to have write access to
the files.
I don't have write access to these files.
Also,I don¹t want to copy files over to my directory and then create
external table on them because It will involve copying a huge data.I also
tried to create managed table then load data to it but then also I get the
permission denied error.

What are other possible solutions for this problem ?

Thanks.

Reply via email to