Hive Metastore JDBC

Skip to main content

Snowflake Documentation

Hive Metastore JDBC

You may optionally configure the following properties to manage the Hive Metastore JDBC connection pooling. Unravel uses the c3p0 library to manage the pooling.

Property/Description	Set by user	Unit	Default
com.unraveldata.metastore.db.c3p0.acquireRetryAttempts Controls how many times c3p0 tries to obtain an connection from the database before giving up. Important For MapR you must set this value to 0.		count	30
com.unraveldata.metastore.db.c3p0.acquireRetryDelay Controls how much waiting time is between each retry attempts in milliseconds. Important For MapR you must set this value to 0.		ms	1000
com.unraveldata.metastore.db.c3p0.breakafteracquirefailure Allows you to mark data source as broken and permanently be closed if a connection cannot be obtained from database. The default value is false.		boolean	false
com.unraveldata.metastore.db.c3p0.maxconnectionage The maximum number of seconds any connections were forced to be released from the pool. If the default value (0) is used the connections will never be released.		sec	0
com.unraveldata.metastore.db.c3p0.maxidletimeexcessconnections The number of seconds that connections are permitted to remain idle in the pool before being released. If the default value (0) is used the connections will never be released.		sec	0
com.unraveldata.metastore.db.c3p0.maxpoolsize The maximum connections in the connection pool.		count	5
com.unraveldata.metastore.db.c3p0.idleconnectiontestperiod			0
com.unraveldata.metastore.databasePattern		string	dname*
com.unraveldata.print.metastore.stats		boolean	false
com.unraveldata.metastore.use.jdbc Enables read-only access to retrieve data from HiveMetastore with simple JDBC calls. `true`: read-only access for HiveMetastore data retrieval. `false`: read-write access for HiveMetastore data retrieval.		boolean	false

In this section:

Would you like to provide feedback? Just click here to suggest edits.