On Thursday, 27 February 2014 12:37 PM, Rishabh Bhardwaj <[EMAIL PROTECTED]> wrote:
I have created a external table and when I provide the location of the data for this table I get the following 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 Also I am able to load the same file using PIG Script using the PigStorage() loader function. I have the following permissions on the file: rw-rw-r-- and on the folder where this file resides (Giving the path of this folder in location in the query ) : drwxrwxr-x What can be the cause for this and how to correct this error ?
Re: Error in metadata: MetaException(message:java.lang.IllegalStateException: Can't overwrite cause)
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 ?
NEW: Monitor These Apps!
Apache Lucene, Apache Solr and all other Apache Software Foundation projects and their respective logos are trademarks of the Apache Software Foundation.
Elasticsearch, Kibana, Logstash, and Beats are trademarks of Elasticsearch BV, registered in the U.S. and in other countries. This site and Sematext Group is in no way affiliated with Elasticsearch BV.
Service operated by Sematext