I figured out the issue was not with target directory, it was with source directory where the files were coming from , hence i fixed the permissions on those directories and now all got succeeded here is further commands i wrote to grand permissions (Please becarefull with 777 as it is not a good practice) [hdfs@sandbox-hdp ~]$ hdfs dfs -chmod 777 /user/hadoop [hdfs@sandbox-hdp ~]$ hdfs dfs -chmod 777 /user/hadoop/silverPop 0: jdbc:hive2://10.88.79.112:10000> LOAD DATA INPATH '/user/hadoop/silverPop/testme.csv' OVERWRITE INTO TABLE dwstg.dummy; successful ... View more