Hello, Is there a setting where all tables created will default to external? I know this isn't ideal long term but I am setting up the environment and would rather start with all tables being external then switch them to manager if necessary.
Thanks, George -----Original Message----- From: Aniket Mokashi Sent: 21 Mar 2013 18:31:01 GMT To: user@hive.apache.org Subject: Re: Important information required about Hive metastore connections You need -<property><name>datanucleus.connectionPool.maxActive</name><value>1</value></property> in your hive-site.xml. Even with that, hive will open 2 connections to metastore. Thanks, Aniket On Mon, Mar 18, 2013 at 7:33 PM, Navis류승우 <navis....@nexr.com> wrote: > 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.tiw...@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" > -- "...:::Aniket:::... Quetzalco@tl"
