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

HanzalaShaikh — Sun, 01 Nov 2020 10:54:37 GMT

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.

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

tusharkathpal — Sun, 01 Nov 2020 14:10:15 GMT

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

question Re: Not able to access the runtime profile or execution summary on Impala shell in Support Questions

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

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