Configuring the connection pool size

To follow recommendations about configuring properties for optimum performance during replication, you need to know how to set the connection pool size.

  • Make a note of the value of maximum concurrent policies (hive.scheduled.queries.max.executors). is equal to or higher than the number of configured maximum concurrent policies
  • Minimum required role: Replication Administrator or Full Administrator
In this procedure you configure the connection pool size equal to or higher than the number of configured maximum concurrent policies.
  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 datanucleus.connectionPool.maxPoolSize.
  3. In Value, enter a value.
  4. Save, and restart Hive.