Viewing the Impala query execution plan

The query execution plan in Hue provides details on how the query will be executed, the operators involved, and other information before the query is submitted to the Impala engine.

  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 Impala Queries tab and click on the query for which you want to view the execution plan.
    The following image shows the Plan tab on the Hue web interface:

    Plan tab showing information such as memory, CPU threads, operators, tables involved, and other details included in the query execution plan.