Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

want to get the user details who ran the query on hue impala

want to get the user details who ran the query on hue impala

Explorer

Want to check which user ran queries on impala hue, the queries took a lot of space populating tables almost 70Tb of space is taken by 4 queries. i killed the process.

 

the user info all it says is:hue/svrhdpm03.tth.corp.int@TTH.CORP.INT

 

When i looked at the queries on the cloudera manager, i don't see the user who triggered the query.

How to get the details of the user who ran the query.

 

Is it from cloudera manager or need to get the details on unix putty side.

 

Can you please provide the steps to get the user details who ran the query.

 

Thanks a lot for the helpful info.

3 REPLIES 3

Re: want to get the user details who ran the query on hue impala

Champion

@cplusplus1

 

I've answered to a similar question already, you can refer to this link 

 

https://community.cloudera.com/t5/Cloudera-Manager-Installation/To-generate-reports-on-Impala-daemon...

 

Re: want to get the user details who ran the query on hue impala

Explorer

Hi Kumar,

 

Thanks for your response, i already tried the attributes option where to add show additional columns details.

 

but for the user or delegated user or anything : all is howing is like this: hue/svrhdpm03.tth.corp.int@TTH.CORP.INT

 

There is no way to figure out looking at the above value.

 

Looking for the hue username, who are running queries.

 

Thank you.

Re: want to get the user details who ran the query on hue impala

Champion

@cplusplus1

 

You can get additional reports from CM -> Cluster (menu) -> Reports...

 

it may help you, otherwise you may have to customize it (on your own risk)

 

Note: pls do not share any confidential informations in the public site