Cloudera Docs

Fixing issues with Hive Virtual Warehouse

After an HDFS NameNode migration on a Cloudera Base on premises instance, the Hive Virtual Warehouse can go down and become inoperable. Learn how to fix issues with your Hive Virtual Warehouse.

The simplest way to fix this issue is to delete the Hive Virtual Warehouse and recreate it with the same name, configuration, autoscaling parameters, user groups, and so on. However, if deleting the Virtual Warehouse is not an option, then perform the following steps.
  1. From the Cloudera Data Warehouse Overview page, click the Virtual Warehouses tab.
  2. Select the required Hive Virtual Warehouse and click > Edit.
  3. From the Virtual Warehouse details page, click Configurations and update the value of dfs.ha.namenodes.ns1 in the hadoop-hdfs-site configuration file for Hiveserver2, Query Coordinator, and Query Executor. Use the NameNode value that you saved previously from the prerequisite section.


  4. In the hadoop-hdfs-site configuration file for Hiveserver2, Query Coordinator, and Query Executor, update the remaining NameNode specific configurations that you saved previously from the prerequisites section.


  5. Click Apply Changes and wait for the Hive Virtual Warehouse to reach a healthy state.