Cloudera Docs

Activating Hive query editor on Cloudera Data Explorer (Hue) UI

You may not see the Hive query editor on the Hue user interface if you have not installed and selected the HIVE_ON_TEZ service on your cluster. The HIVE_ON_TEZ service is needed to configure and use Hive with Hue.

To enable the Hive query editor on the Hue web UI:
  1. Sign in to Cloudera Manager as an Administrator.
  2. Check whether the HIVE_ON_TEZ service is installed on your cluster.
    If it is not installed already, add it as a service.
  3. Go to Clusters > Hue service > Configuration.
    The list of Hue configurations is displyed.
  4. Search for the HiveServer2 Service field and select the HIVE_ON_TEZ service.
  5. Save the changes and restart Hue.
The Hive query editor should now be available on the Hue user interface.