Is there a way to find out the query used by a particular job using the application ID?

[#1]

I have one application id which i got from Resource manager and since this job ran by hive as user so i am not able to find out exactly who ran that job. So i have application ID and now i need to know the code or query used by that particular application id. Is there a way to get any kind of logs from which i can get the code or query used by that application ID

[#2]

@Yukti Agrawal

if you have a tez view set up with ambari then you can open that and search with application id, opening this you will able to see the query

[#3 · Accepted solution]

@Yukti Agrawal

On accessing the RM UI and click on the applicationId and corresponding logs link. It will take you to a screen something as below.

Here you would see a file dag_*.dot, this should give you the query/MR graph that is being executed.

Other option would be if the execution engine is TEZ, then you can leverage TEZ UI to view the actual query as well.