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.