Apache Ambari Views
Also available as:
PDF
loading table of contents...

Analyzing the Details of Hive Queries

Click the relevant link in the Query ID column for a query that you want to investigate. A window with three tabs containing information about the query is displayed.

Details Tab

The Details tab, the first of the three tabs, is displayed after clicking a Query ID link.

Figure 11.4. Details for a Successful Query with Links to Application and DAG Windows


Total Timeline View

Click the Timeline tab to get a visual representation of Hive performance logs. The view represents the following pre-execution, runtime, and post-execution phases of a query:

  • Pre-execution and DAG construction

  • DAG submission

  • DAG runtime

  • Post-execution

Duration data about each phase are distilled into more granular metrics based on query execution logs.

A search-enabled table with raw performance log names and their major values is displayed under the timeline visualization.

Figure 11.5. Total Timeline and Log Details of a Submitted Query


Configurations Tab

Click the Configurations tab to see a list of configuration properties and settings that are used in the Hive query. You can use this tab to verify that configuration property values align with your expectations.

[Tip]Tip

By default, only configuration property names that contain the substring tez are listed. Use the Search field to change the search criteria.

Figure 11.6. Configurations Tab