Troubleshooting: 401 Unauthorized when accessing Hive

Problem: Session returns a 401: Unauthorized error when you are accessing a Hive database.

Check that the Hive or Impala Virtual Warehouse is working.

Solution: Follow these steps to check that Hive or Impala data warehouse is running, and restart if needed.
  1. In the control plane, go to Cloudera Data Warehouse.
  2. Click Virtual Warehouses, and select the data warehouse for the connection.
  3. Check the status of that data warehouse, and make sure that it is running or in a good state.