Cloudera Docs

Fixing a query in Cloudera Data Explorer (Hue)

You can use the SQL AI Assistant to fix a broken SQL query. Data Explorer identifies the issues in SQL syntax and provides the corrected version.

  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 fix.
  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 FIX.
    Screenshot showing how to use the SQL AI Assistant in Hue to fix a SQL query.
    Data Explorer displays the original and the fixed SQL query in a side-by-side comparison.
    Screenshot showing the original and the fixed SQL query generated using SQL AI Assistant in Hue along with an explanation.
    Click Insert to insert the fixed query in the Data Explorer editor and run it.