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

[#1]

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.

[#2 · Accepted solution]

@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>