Skip to main content
HanzalaShaikh
Gold ⭐️
November 1, 2020
Solved

Not able to access the runtime profile or execution summary on Impala shell

Hi,

 

I am trying to see a summary of a query's progress that updates in real-time, Hence I ran 'set
LIVE_PROGRESS=1;'. But I am getting the message stating as below:

 

ERROR: User hadmin@HADOOP-GROUP.LOCAL is not authorized to access the runtime profile or execution summary.

 

However, the user hadmin is the authorized user to view that particular database and table.

 

Please suggest what could be the reason and how to fix this, Since I have taken the Kerberos ticket as well.

tusharkathpal
Gold ⭐️
November 1, 2020

@HanzalaShaikh 

 

Could you try the below and see if this helps or not.

 

grant SELECT on DATABASE `_impala_builtins` to role <role-name mapped to user hadmin>

1 reply

tusharkathpal
Gold ⭐️
Gold ⭐️
November 1, 2020

@HanzalaShaikh 

 

Could you try the below and see if this helps or not.

 

grant SELECT on DATABASE `_impala_builtins` to role <role-name mapped to user hadmin>

Translate