[HIVE-17315] Make the DataSource used by the DataNucleus in the HMS configurable using Hive properties

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0
• Target Version/s: 3.0.0
• Assignee: Barna Zsombor Klara
• Reporter: Barna Zsombor Klara
• Created: 14/Aug/17 15:02
• Updated: 03/Nov/22 17:59

Description

Currently we may use several connection pool implementations in the backend (hikari, dbCp, boneCp) but these can only be configured using proprietary xml files and not through hive-site.xml like DataNucleus.
We should make them configurable just like DataNucleus, by allowing Hive properties prefix by hikari, dbcp, bonecp to be set in the hive-site.xml. However since these configurations may contain sensitive information (passwords) these properties should not be displayable or manually settable.

Issue Links

• is related to: HIVE-26702 Backport HIVE-17317 (DBCP and HikariCP property configuration support) to 3.2.0.

Sub-Tasks

• Use String.startsWith for the hidden configuration variables: Closed
• Make Dbcp configurable using hive properties in hive-site.xml: Closed
• Make Hikari CP configurable using hive properties in hive-site.xml: Closed
• Make BoneCp configurable using hive properties in hive-site.xml: Closed
• Change startsWith relation introduced in HIVE-17316: Closed