title: Get application id from hive log for given query
body: <p>In our env, we have a number of users that issue Hive queries from different tools. Many times the user will give us a query and say it failed around a certain time, and we need to dig through and find the reason.
  So we need to parse hive logs and find the query.</p>
  
  <p>Finding the query is the easier part, is there a way to figure out easily once the query is found (usually after the words Executing command) in hive logs, how do I easily get the yarn application id associated with it?</p>
  
  <p>I'm trying to automate this process so that I can cut down our analysis time.</p>
  
  <p>Thanks</p>