hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Siddharth Tiwari <siddharth.tiw...@live.com>
Subject Fwd: Hive accessing metastore
Date Thu, 21 Mar 2013 14:49:51 GMT


Sent from my iPhone

Begin forwarded message:

> From: Siddharth Tiwari <siddharth.tiwari@live.com>
> Date: 21 March 2013 7:43:41 AM MST
> To: hive user list <user@hive.apache.org>
> Subject: Hive accessing metastore
> 
> 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. Specifically 2 connections per user out
of which one remains idle and other one is used. When we talk about using hive prompt for
jobs.
> 
> Can anyone explain me how does hive manages its connections to metastore database.
> Also why 2 connections ? Can we pool connections from hive to metastore by setting any
variable ?
> 
> 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"
> 
> Sent from my iPhone
Mime
View raw message