Cloudera Docs

Viewing explain plan for a Hive query

The Visual Explain feature provides a graphical representation of the query execution plan. The Explain plan is read from right to left. It provides details about every stage of query execution.

  1. Log in to the Hue web interface.
  2. Click Jobs from the left assist panel.
    The Job Browser page is displayed.
  3. Go to the Queries tab and click on the query for which you want to view the query details.
  4. Click on Visual Explain.
    The following image shows the Visual Explain tab on the Hue web interface:

    Visual Explain tab showing the query execution plan.
  5. (Optional) Click to download the query explain plan in JSON format.