ERROR: "java.io.IOException: Not a file" while running Hive

[ritch...@abrs.com.hk]

This could be caused by Hive cannot properly traverse a folder (pls see: https://community.hortonworks.com/content/supportkb/150654/error-javaioioexception-not-a-file-while-running-h.html)

I fixed with moving the data from an interim folder location:  eg. /tmp/hive/..... to eg. /tmp/hive/test   where test is the leaf node in the tree.

Also avoid saving it I tmp folder, which may be flushed by other systems:

15 down vote
https://community.hortonworks.com/questions/55496/safe-to-delete-under-tmp-in-hdfs-how-about-tmphive.html
accepted

HDFS /tmp directory mainly used as a temporary storage during mapreduce operation. Mapreduce artifacts, intermediate data etc will be kept under this directory. These files will be automatically cleared out when mapreduce job execution completes. If you delete this temporary files, it can affect the currently running mapreduce jobs. 

https://community.hortonworks.com/questions/55496/safe-to-delete-under-tmp-in-hdfs-how-about-tmphive.html