@diplompils  It is not necessary that file is lost if you are getting the output as false for recoverLease command. Usually file can't be deleted until it has lease acquired and not explicitly deleted using rm command.    You can try below- hdfs debug recoverLease -path <file> -retries 10 Or you may check - https://issues.apache.org/jira/browse/HDFS-8576 ... View more

Check for more details and got error as : "Unexpected end of input stream"   Now, Get the hdfs LOCATION for the table by using below command on HUE or HIVE shell: show create table <table-name>;   Check for the zero byte size files and remove them from hdfs location using below command: hdfs dfs -rm -skipTrash $(hdfs dfs -ls -R <hdfs_location> | grep -v "^d" | awk '{if ($5 == 0) print $8}')   Try running again our query which ran successfully this time. ... View more