Impala does not have READ_WRITE access to path

[#1]

Hi everyone,

I'm trying to figure out what causes this Impala warning that is generated when external tables are created:

Impala does not have READ_WRITE access to path 'hdfs://xxxxxxxxxxx'

At first, we thought it was a permissions issue with Ranger, but after numerous attempts, we still get the same warning.

We also checked the permissions on the HDFS paths, but there are folders with permissions of 775, 750, and 755, so there doesn't seem to be a correlation between the warning and POSIX permissions.

Could it be an issue with the user and/or group? In many paths, the owner and group of the folder are hdfs:hdfs. Should the owner be changed to impala?

Unfortunately, I haven't found any helpful documentation on this topic that would allow me to eliminate the warning. Many users think that the tables are actually not being created and that there is no way to write to them.

[#2 · Accepted solution]

hi @HadoopHero 

assign permission to the "impala" user in the specified directory

always analyze the audit in "Ranger" to collect errors and thus apply solutions.

[#3]

Hi @yagoaparecidoti 

thanks for the help. I’ve resolved the problem