How to retrieve get complete HQL hive query from hive spark and tez

Question

Hi team,

I want to know that if I have an application id and I want to check what hive query was executed for that particular application id, then how I find that hive query using Hive, Tez view, and spark. Is there anything we can know what would be the hql for a particular app id. I know we can see this from the resource manager, but it does not show the complete query .it just shows some part of it.

Answer 1

To get full query running for the application id goto TEZ UI from ambari(there you can see query history)

Steps go to Tez view via ambari:-

1) From the Ambari home page, hover over the top right corner, and select "Tez View"

2) Next, you can either search by application ID or the hive query itself to find your application.

3) Select your application - the entire hive query should be displayed here and also you can see the status of the query.

(or) from hiveserver2.log

You can check hive.exec.scratchdir set in hive-site.xml to know hive query logs location but in general Hive Server2 logs are in /var/log/hive but to retrieve the query from there requires integration of Ambari + Tez.