question Is there a way to find out the query used by a particular job using the application ID? in Archives of Support Questions (Read Only)

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

Yukti — Thu, 22 Dec 2016 14:24:44 GMT

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

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

rajkumar_singh — Sun, 18 Aug 2019 11:08:07 GMT

@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

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

sgowda — Sun, 18 Aug 2019 11:07:59 GMT

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