Impala SQL: Unable to LOAD DATA from HDFS path due to WRITE permissions

Issue:

While you are using Impala Official docker image "cloudera/quickstart", following exception might be thrown while executing LOAD DATA command to do data migration.

 

Error:

[Simba]ImpalaJDBCDriver ERROR processing query/statement. Error Code: 0, SQL state: TStatus(statusCode:ERROR_STATUS, sqlState:HY000, errorMessage:AnalysisException: Unable to LOAD DATA from hdfs://quickstart.cloudera:8020/user/customer.tbl.1 because Impala does not have WRITE permissions on its parent directory hdfs://quickstart.cloudera:8020/user ), Query: load data inpath '/user/customer.tbl.1' overwrite into table my_table. [SQL State=HY000, DB Errorcode=500051]

 

Reason: (https://community.cloudera.com/t5/Interactive-Short-cycle-SQL/Impala-SQL-Unable-to-LOAD-DATA-from-HDFS-path-due-to-WRITE/m-p/5194