Configure HiveServer for ETL using YARN queues

If you upgrade from CDH and want to run an ETL job, you need to set several configuration properties to allow placement of the Hive workload on the Yarn queue manager.

  1. In Cloudera Manager, click Clusters > Hive on Tez > Configuration.
  2. Search for the Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml setting.
  3. In the Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml setting, click +.
  4. In Name enter the property hive.server2.tez.initialize.default.sessions and in value enter false.
  5. In Name enter the property hive.server2.tez.queue.access.check and in value enter true.
  6. In Name enter the property hive.server2.tez.sessions.custom.queue.allowed and in value enter true.