question Re: "E090 HDFS020 Could not write file" error occurred in Support Questions

"E090 HDFS020 Could not write file" error occurred

nasu — Mon, 19 Aug 2019 09:02:09 GMT

Hi, I just installed Ranger from Ambari UI.

When I throw query, "E090 HDFS020 Could not write file" error occurred. I already checked and applied the Support KB as follow: https://community.hortonworks.com/content/supportkb/49578/e090-hdfs020-could-not-write-file-useradminhivejob.html However, the error still exist.

Before Ranger was installed, there were no error like that.

I have no idea for this. Cloud you please tell me what I should check?

Regards, Takashi

Re: "E090 HDFS020 Could not write file" error occurred

dsharma — Fri, 02 Dec 2016 18:32:38 GMT

can you try creating a ranger hdfs policy for the admin user on resource /user/admin with recursive true

Re: "E090 HDFS020 Could not write file" error occurred

ssubhas — Fri, 02 Dec 2016 18:44:19 GMT

@Takashi Nasu

Create the directory /user/admin under hdfs as below and then try running the query:

hdfs dfs -mkdir /user/admin

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

Re: "E090 HDFS020 Could not write file" error occurred

nasu — Fri, 02 Dec 2016 19:12:19 GMT

Thank you! /user/admin directory is as below:

[admin@ip-192-168-xxx ~]$ hdfs dfs -chown admin:admin /user/admin
[admin@ip-192-168-xxx ~]$ hdfs dfs -ls  /user/admin
Found 3 items
drwx------   - admin hdfs          0 2016-12-01 11:47 /user/admin/.Trash
drwxr-xr-x   - admin hdfs          0 2016-12-01 11:52 /user/admin/.hiveJars
drwxr-xr-x   - admin hdfs          0 2016-12-01 11:39 /user/admin/hive

Ranger policy is as below:

ranger1.png

ranger2.png

ranger3.png

I don't understand what is the root cause...

Re: "E090 HDFS020 Could not write file" error occurred

ssubhas — Fri, 02 Dec 2016 19:18:54 GMT

@Takashi Nasu

Are you able to run the queries now? If yes, then issue could be missing HDFS directory and no Ranger policy in place.

Re: "E090 HDFS020 Could not write file" error occurred

nasu — Fri, 02 Dec 2016 20:12:25 GMT

@Sindhu

Sorry, I still have the issue. I'm getting the same error now...

Re: "E090 HDFS020 Could not write file" error occurred

TimothySpann — Thu, 12 Jan 2017 03:24:43 GMT

Are you running Apache Atlas?

Re: "E090 HDFS020 Could not write file" error occurred

nasu — Thu, 12 Jan 2017 09:03:03 GMT

Hi, I configured hadoop.proxyuser.root.hosts=* of HDFS configs in Ambari.

Then the issue was gone.

Thank you for everyone!

Re: "E090 HDFS020 Could not write file" error occurred

sso — Sun, 29 Oct 2017 08:44:43 GMT

Thanks.

It also works for me.

I am using HDP 2.6.2 with Ambari 2.5,

After installing, the default proxy value is

hadoop.proxyuser.root.hosts=ambari1.ec2.internal

After changing to

hadoop.proxyuser.root.hosts=*

Error is resolved.

Re: "E090 HDFS020 Could not write file" error occurred

sidatbigdata — Tue, 21 Nov 2017 20:08:18 GMT

@Takashi Nasu is the issue resolved? I am having the similar issue. I tried all the above solution given by folks but still facing the same error. I do not have security installed in my system and i believe its just permission issue but couldnt able to identify where it could be. Can @Deepak Sharma or any one help to resolve this please

Re: "E090 HDFS020 Could not write file" error occurred

nasu — Wed, 22 Nov 2017 13:34:08 GMT

Hi, This issue was resolved by the settings as follows:

hadoop.proxyuser.root.hosts=*

You can also see the answer on the below comment.
https://community.hortonworks.com/comments/144449/view.html