Support Questions
Find answers, ask questions, and share your expertise

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

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

Accepted Solutions

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

@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

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

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

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

@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

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

Explorer

Really thanks it works great!!!:)

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

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.