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. Go to the Cloudera Data Warehouse (CDW) web interface and open Hue from your Virtual Warehouse.
  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.