Activating Hive query editor on 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.