Cloudera Docs

Optimizing a query in Cloudera Data Explorer (Hue)

You can use the SQL AI Assistant to optimize a SQL query. Data Explorer identifies the issues in the source query, optimizes it, and provides the optimized version of the SQL query. Data Explorer also summarizes the issues and how it optimized the query in natural language.

  1. Log in to the service as DWUser.
  2. Open Data Explorer (Hue) corresponding to your Virtual Warehouse.
  3. Insert a SQL query in the Data Explorer editor that you would like to optimize.
  4. Click Assistant on the Data Explorer (Hue) SQL editor:
    Screenshot showing how to launch the SQL AI Assistant from the Data Explorer web interface.
  5. Click OPTIMIZE.
    Screenshot showing how to use the SQL AI Assistant in Hue to optimize a SQL query.
    Data Explorer displays the original and the optimized SQL query side-by-side. It also provides an explanation of the issues in the original query and how it was optimized.
    Screenshot showing the original and the optimized SQL query generated using SQL AI Assistant in Hue along with an explanation.