Yes, the Hive MetaStore does support JDBC connection pooling to the underlying metastore database. You can configure this in hive-site.xml
<property> <name>datanucleus.connectionPoolingType</name> <value>DBCP</value> <description>Uses a DBCP connection pool for JDBC metastore</description> </property> In addition, you can also pool threads that service the requests received over the MetaStore Thrift interface. Best Regards, Sonal Nube Technologies <http://www.nubetech.co> <http://in.linkedin.com/in/sonalgoyal> On Sat, Oct 5, 2013 at 12:03 AM, S R <skr...@gmail.com> wrote: > Is there a connection pooling mechanism for Hive Metastore Service? I am > using embedded Postgres for my testing but in production we are planning to > use MySQL. >