Impala does not have READ_WRITE access to path

HadoopHero — Wed, 24 Jan 2024 13:45:35 GMT

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.

Re: Impala does not have READ_WRITE access to path

yagoaparecidoti — Wed, 24 Jan 2024 14:47:07 GMT

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.

Re: Impala does not have READ_WRITE access to path

HadoopHero — Sun, 28 Jan 2024 13:13:54 GMT

Hi @yagoaparecidoti

thanks for the help. I’ve resolved the problem

question Impala does not have READ_WRITE access to path in Support Questions

Impala does not have READ_WRITE access to path

Re: Impala does not have READ_WRITE access to path

Re: Impala does not have READ_WRITE access to path