MapReduce Query Details
The MapReduce Query Details page contains the following panels.
- Summary
- Query Trends
- Query
- Application Stats
- Query Plan
The summary panel displays the following information.
| Field Name | Description |
|---|---|
| User | The name of the user that executed the job. |
| Status | The status of the job that can be one of the following: Succeeded, Failed, Killed, Undefined. |
| Duration | The duration of the query execution. |
| Start Time | The time at which the query execution started. |
| End Time | The time at which the query execution ended. |
| # of Applications | The number of applications used by the query. |
| Memory | The amount of memory used by the query. |
| VCore | The number of VCores consumed by the query. |
Query Trends
The Query Trends panel displays a chart showing the pattern of jobs running at a particular time, based on the following factors.
| Metric | Description |
|---|---|
| Elapsed Time | The time taken to run the jobs at a particular time. |
| VCores | The number of VCores consumed to execute the query within a timeframe. |
| Memory | The amount of memory used to execute the query within a timeframe. |
Comparing Runs
Click Compare Runs to compare different runs of the query. Select the runs that you want to compare. You can choose from upto 10 previous runs of the query. The metrics that are different are highlighted and displayed at the very top of the comparison result.
Recommendations
The Recommendations panel displays recommendations that you can use to improve the performance of the SQL Query.
Query
The Query panel displays the query along with the table joins used in the query.
Application Stats
The Application Stats tab displays the details of applications used in the query by elapsed time. You can sort the data by Start Time and Duration.
Query Plan
Query Plan is a logical representation of how MapReduce executes the query, where a query is broken into different stages. The query plan is displayed in JSON format.