Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

How to find complete Hive Query for application_id?

How to find complete Hive Query for application_id?

New Contributor

Hello ,

As as Hadoop admin , where we can find the complete Hive query for any application in yarn?

We can see initial 50 character of query only on RM UI.

Thanks..

3 REPLIES 3

Re: How to find complete Hive Query for application_id?

Super Guru

@Ashish Wadnerkar

To get full query running for the applicationid 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

Re: How to find complete Hive Query for application_id?

New Contributor

Thanks Shu..

One thing I forgot to mentioned that ..My job in is MR mode.

Another thing is that I tried to find the complete query in hiveserver2.log , but I didn't get it.

Could you please let me know , where I can get the info.

Highlighted

Re: How to find complete Hive Query for application_id?

Contributor
@Ashish Wadnerkar

You can grep hiveserver2.log with "Parsing command" string and you will get complete hive query.