hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Navis류승우 <navis....@nexr.com>
Subject Re: Important information required about Hive metastore connections
Date Tue, 19 Mar 2013 02:33:12 GMT
Hive uses DBCP as a connection pool.

Ref http://www.datanucleus.org/products/accessplatform_2_2/rdbms/dbcp.html

2013/3/19 Siddharth Tiwari <siddharth.tiwari@live.com>:
> Hi team,
>
> What we have observed is, hive creates so many connections to metastore
> (mysql). This makes us change the numer of connections to mysql.
>
> Can anyone explain me how does hive manages its connections to metastore
> database.
>
> is it one for every Job submitted by every user ? if not then how and when
> hive makes connections to metastore.
>
> 2. Is it possible to limit the number of maximum connections hive could make
> to mysql metastore ? Or is it possible to limit number of maximum jobs than
> can be submitted to hive at anytime ?
>
> Please help
>
> Thanks in advance.
>
>
> *------------------------*
> Cheers !!!
> Siddharth Tiwari
> Have a refreshing day !!!
> "Every duty is holy, and devotion to duty is the highest form of worship of
> God.”
> "Maybe other people will try to limit me but I don't limit myself"

Mime
View raw message