Hive view unable to upload table E090 HDFS020 Could not write file

[#1]

Why I can't upload a table to hive view? When I try to upload, it throws the next fail:

E090 HDFS020 Could not write file /user/admin/hive/jobs/hive-job-11-2017-01-03_06-05/query.hql [HdfsApiException]

I have all the permission on the HDFS Custom core-site:

But when I try to upload I see the next:

I am using Centos7, with Ambari HDP. My firewalld is disabled. Could be Selinux?

[#2]

@Asier Gomez

Click on the exception and share the complete stack trace. In most case, issue is related to hadoop.proxyuser.<user_name>.hosts and hadoop.proxyuser.<user_name>.groups configurations from core-site under HDFS configs.

[#3 · Accepted solution]

@Asier Gomez

Adding to my previous reply, check if the directory /user/admin exists under HDFS. If not, do the following:

su - hdfs

hdfs dfs -mkdir /user/admin

hdfs dfs -chown -R admin:hdfs /user/admin

Then, try running the query again.

[#4]

Really thanks it works great!!!:)

[#5]

Issue is related to hadoop.proxyuser.<user_name>.hosts and hadoop.proxyuser.<user_name>.groups configurations from core-site under HDFS configs, for all properties hadoop.proxyuser.<user_name>.hosts changed values to * and it will worked.