Skip to main content
hadoopranger
Gold ⭐️⭐️
May 14, 2024
Solved

Impala editor in hue ui having authorization error

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.

 

hadoopranger
Gold ⭐️⭐️
May 24, 2024

Sssd issue on unix this is resolved 

2 replies

ChethanYM
Gold ⭐️
Gold ⭐️
May 15, 2024

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

Translate
hadoopranger
hadooprangerAuthorAnswer
Gold ⭐️⭐️
May 24, 2024

Sssd issue on unix this is resolved 

Translate