One thing you can do is - modify your metastore table to set default value for column for external as 1. That may do the trick.
On Thu, Mar 21, 2013 at 12:06 PM, Babe Ruth <gtevelde-h...@hotmail.com>wrote: > 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" > -- "...:::Aniket:::... Quetzalco@tl"
