Is there any way to find the full SQL query when getting info about a hive job via the Resource Manager Web UI?
Now I can only see a truncated string of the SQL query.
We are trying to find out which query was run for a specific job so we can see stats and logs for a specific query.
Sometimes we make small changes to a query and rerun it again. We would like to see stats for multiple runs of similar queries on History Server UI and Resource Manager UI but we can't differenciate the queries because the name is truncated so it is the same for different queries.
How can I get a job/query XML from Hive Server 2? Can you point me to a document with instructions?
Cloudera Manager's YARN -> Application page already does this for you BTW; Have you read http://www.cloudera.com/documentation/enterprise/latest/topics/cm_dg_yarn_applications.html?
Aside of showing you the full query behind a YARN MR2 Application, if the job was from a query, it can also show you all jobs pertaining to a single query instance, AND let you select multiple such jobs across different query instances. The charts tab can further let you compare various stats of the job. Does this not suffice?
I am trying to get Hive query and its details, But i can get its details not the full query. I need to get all the user data query by API or HDFS command, please give me an perfect solution asap.