[HIVE-13842] Expose ability to set number of connections in the pool in TxnHandler

• Type: Improvement
• Status: Closed
• Priority: Critical
• Resolution: Done
• Affects Version/s: 1.0.0
• Fix Version/s: 3.0.0
• Component/s: Transactions
• Target Version/s: 1.3.0, 3.0.0
• Assignee: Eugene Koifman
• Reporter: Eugene Koifman
• Created: 25/May/16 03:20
• Updated: 27/Feb/24 22:23
• Resolved: 02/Oct/17 20:27

Description

Current defaults are hardcoded 8/10 for dbcp/bonecp

Various Connection pool managers support reading configs from a config file.

The implementation would ideally allow end user to point Hive at the manager specific config file to let the user have full control

HikariCP supports
HikariConfig config = new HikariConfig("/some/path/hikari.properties");
see https://github.com/brettwooldridge/HikariCP

BoneCP supports
bonecp-config.xml
see https://github.com/wwadge/bonecp/blob/master/bonecp/src/main/java/com/jolbox/bonecp/BoneCPConfig.java

Issue Links

• is related to: HIVE-16321 Possible deadlock in metastore with Acid enabled
• relates to: HIVE-12592 Expose connection pool tuning props in TxnHandler