Configure HiveServer for ETL using YARN queues

As Administrator or Data Engineer, you upgrade and want to run an ETL job. You need to check, and if not found, add several configuration properties to allow placement of the Hive workload on the Yarn queue manager.

  1. In Cloudera Manager, click Clusters > Hive > 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.