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 the properties as part of this four-part mapping process:

• Setting up queues
• Manage cluster capacity with queues
• Define queue mapping policies
• Set up ACLs

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.