Page History

...

datanucleus.connectionPoolingType

• Default Value: DBCP in Hive 0.7 to 0.11; BoneCP in 0.12 and later to 2.3; HikariCP in 3.0 and later
• Added In: Hive 0.7.0

Uses a HikariCP connection pool for JDBC metastore from 3.0 release onwards (HIVE-16383).

Uses a BoneCP connection pool for JDBC metastore in release 0.12 and later to 2.3 (HIVE-4807), or a DBCP connection pool in releases 0.7 to 0.11.

As of Hive 2.2.0 (HIVE-13159), this parameter can also be set to none.

datanucleus.connectionPool.maxPoolSize

• Default Value: 10
• Added In: Hive 3.0.0

Specify the maximum number of connections in the connection pool.

Note: The configured size will be used by 2 connection pools (TxnHandler and ObjectStore).

When configuring the max connection pool size, it is recommended to take into account the number of metastore instances and the number of HiveServer2 instances

configured with embedded metastore. To get optimal performance, set config to meet the following condition

(2 * pool_size * metastore_instances + 2 * pool_size * HS2_instances_with_embedded_metastore) = (2 * physical_core_count + hard_disk_count).

datanucleus.validateTables

...