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.

  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.
    A list of queries that were run is displayed.
  4. Select the two queries you want to compare and click Compare.
    The query comparison report is displayed, as shown in the following image:

    Report showing comparison of two queries in Hue.