Configuring maximum concurrent queries

You can configure maximum concurrent queries to optimize performance.

Minimum required role: Replication Administrator or Full Administrator
  1. In Cloudera Manager, click Clusters > Hive on Tez > Configuration, and search for Hive Service Advanced Configuration Snippet (Safety Valve) for hive-site.xml.
  2. Click Add and in Name, enter hive.scheduled.queries.max.executors , and in Value, enter the required value.
  3. Save, and restart Hive.
    If you set the value to 50, Hive runs a maximum of 50 concurrent replication policies at a time.