Reply
Highlighted
Explorer
Posts: 25
Registered: ‎04-26-2016

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

[ Edited ]

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.

Posts: 388
Topics: 11
Kudos: 60
Solutions: 34
Registered: ‎09-02-2016

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

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

 

Explorer
Posts: 25
Registered: ‎04-26-2016

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

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.

Posts: 388
Topics: 11
Kudos: 60
Solutions: 34
Registered: ‎09-02-2016

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

@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

Announcements