I found the solution for this issue. we can resolve the issue in following two ways. 1) we have to setfacl for 'rwx' permission for the directory from where we loading the data.   Or 2) give 777 access permission for the directory from where we loading the data.   Option1 is safer because only hive user have 'rwx' permission. In second option all the hdfs users will have 'rwx' permissions. ... View more