Configure HiveServer for ETL using YARN queues

You need to set several configuration properties to allow placement of the Hive workload on the Yarn queue manager, which is common for running an ETL job. You need to set several parameters that effectively disable the reuse of containers. Each new query gets new containers routed to the appropriate queue.

Hive configuration properties affect mapping users and groups to YARN queues. You set these properties to use with YARN Placement Rules.

To set Hive properties for YARN queues:

  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.