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 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 SQL editor:
  5. Click FIX.
    Screenshot showing how to use the SQL AI Assistant in Data Explorer 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 Data Explorer along with an explanation.
    Click Insert to insert the fixed query in the Data Explorer editor and run it.