Impala editor in hue ui having authorization error

[#1]

Hello,

We have a strange issue here.

We are on CDP7.1.9 and have ranger in place for authorizations. A user is trying to execute queries from Hue on Impala Editor and fails with Authorization errors. However, same query works fine via Hive and also via Impala shell. It fails only from Hue editor.

We have:

1. Refreshed metadata

2. Invalidated metadata

3. Verified permissions are in place in Ranger

4. There are no logs generated (I checked in Hue, Sentry Server and Catalog server). Please suggest if any other place should also be checked.

Example query:

select * from DB.table limit 5;

Kindly help to diagnose and resolve this issue.

[#2]

Hello @hadoopranger 

Do provide the complete error stack trace from hue log and error screenshot from Hue UI to check the same.

Try restarting impala, hue and see if any difference.

Regards,

Chethan YM

[#3 · Accepted solution]

Sssd issue on unix this is resolved