Job in Ambari Hive view fails - looking for log information for the job

[#1]

Running this in the ambari hive 2.0 view. Trying to join 2 tables into a new table. Query seems to run then stalls at 100% and returns with an error but no specific error message is provided in the hive view.

Where can I find the error message or at least logs associated with the job ID provided by the hive view?

[#2]

Hi @Jon Page

if you have an application ID, you can view the yarn logs both from the YARN Resource Manager UI (Ambari->Yarn->Quick Links) or via CLI: yarn logs -applicationId <app ID>

[#3]

Hive view logs can be found at path : /var/log/ambari-server/hive20-view/hive20-view.log

You can get the job id for the hive view job from the jobs tab on hive view.

Once you get the job id, you can use the below API to get more info about the job:

<AMBARI_IP>/api/v1/views/HIVE/versions/2.0/instances/<view_name>/resources/jobs/<job_id>