question Re: Hive view unable to upload table E090 HDFS020 Could not write file in Archives of Support Questions (Read Only)

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

asierga95 — Mon, 19 Aug 2019 11:38:59 GMT

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?

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

ssubhas — Tue, 03 Jan 2017 17:57:23 GMT

@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

ssubhas — Tue, 03 Jan 2017 17:59:28 GMT

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

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

asierga95 — Tue, 03 Jan 2017 18:10:54 GMT

Really thanks it works great!!!:)

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

kharade_ajay — Wed, 23 Aug 2017 20:30:44 GMT

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.