Comparing Hive queries in Hue
You can compare two queries to know how each query is performing in terms of speed and cost-effectiveness. Hue compares various aspects of the two queries, based on which you can identify what changed between the executions of those two queries, and you can debug performance-related issues between different runs of the same query.
The query comparison report provides you a detailed side-by-side comparison of your queries, including recommendations for each query, metadata about the queries, visual explain for each query, query timeline, query configuration, Directed Acyclic Graph (DAG) information, DAG flows, DAG swimlanes, DAG counters, and DAG configurations.
- Go to the Cloudera Data Warehouse (CDW) web interface and open Hue from your Virtual Warehouse.
Click Jobs from the left assist panel.
The Job Browser page is displayed.
Go to the Queries tab.
A list of queries that were run is displayed.
Select the two queries you want to compare and click
The query comparison report is displayed, as shown in the following image: