question Re: Impossible to see tables from Impala in a Security Zone in Support Questions

Impossible to see tables from Impala in a Security Zone

HadoopHero — Tue, 12 Dec 2023 20:22:01 GMT

Hello everyone,

recently on Ranger, we noticed that when enabling users in a security zone, they are unable to see tables in a database through Impala. When connecting via JDBC through the command line or directly from HUE, they can view the tables and their respective data, but if all of this is done through Impala, they have no visibility at all.

We have 4 clusters, and all of them have the same type of configuration and permissions, but we encounter the issue in 3 of these clusters. All configurations in Ranger have been checked and appear to be correct in all environments.

At this point, I have no idea where to begin the analysis of the problem.

Also, there are no access issues reported from Ranger to tables in the security zone, and there are no error logs or access denied logs.
I realize that without providing an error log, it's difficult to conduct an analysis, but perhaps some of you have suggestions on where to start investigating the problem.

Have any of you ever encountered a similar case?

Thanks!!!

Re: Impossible to see tables from Impala in a Security Zone

James G — Tue, 12 Dec 2023 21:05:48 GMT

What Impala command are you running and what is the error ?

Re: Impossible to see tables from Impala in a Security Zone

HadoopHero — Wed, 13 Dec 2023 10:04:30 GMT

Hello @James G

the only mistake is the lack of display of the tables. Unfortunately, I have no way to execute any command on Impala.

Re: Impossible to see tables from Impala in a Security Zone

vamsi_redd — Mon, 11 Mar 2024 14:17:39 GMT

Hi @HadoopHero, can you please check if ranger impala plugins are syncing. go to ranger UI--> audit--> plugin status --> search for impala and attach screenshot

Re: Impossible to see tables from Impala in a Security Zone

vamsi_redd — Sat, 31 Aug 2024 04:06:43 GMT

It seems the Impala plugins were not syncing check the impala logs and fix the plugin issue