Re: Hive and using Pooled Connections

Thanks Alan. My Hive is version 2 transactional and its metastore is on Oracle. I saw this note stating .Using Oracle as the Metastore DB and "datanucleus.connectionPoolingType=BONECP" may generate intermittent "No such lock

Re: Hive and using Pooled Connections

It’s depends on how it’s configured. In $HIVE_HOME/conf/hive-site.xml you can set the datanucleus.connectionPoolingType variable to BONECP or DBCP. By default it should be using BONECP I believe. (I think NONE is also a valid value, but that doesn’t yet work with ACID turned on.) Alan. > On

Hive and using Pooled Connections

Hi, I am sure someone knows the answer to this question. Does Hive 2.0 use connection pool to connect to its metastore? I see a lot of open and closed connections to the metastore that may not be necessary. A *connection pool* is a cache of database connection objects. Connection pools promote