Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Explorer

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:

11008-custom-coresite.png

But when I try to upload I see the next:

11009-exception.png

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

1 ACCEPTED SOLUTION

avatar
@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.

View solution in original post

4 REPLIES 4

avatar
@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.

avatar
@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.

avatar
Explorer

Really thanks it works great!!!:)

avatar
New Contributor

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.