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. ImportantFor 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. ImportantFor 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.
| boolean | false |