01-25-2017 05:58 AM - edited 01-25-2017 06:35 AM
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.
01-25-2017 08:23 AM
I've answered to a similar question already, you can refer to this link
01-26-2017 10:35 AM
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.
01-26-2017 02:41 PM
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