Setting to make all tables external by default

2013-03-21 Thread Babe Ruth
ello, 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: Bab

Re: Important information required about Hive metastore connections

2013-03-21 Thread Babe Ruth
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: A

Re: Important information required about Hive metastore connections

2013-03-21 Thread Aniket Mokashi
You need -datanucleus.connectionPool.maxActive1 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류승우 wrote: > Hive uses DBCP as a connection pool. > > Ref http://www.datanucleus.org/products/accessplatform_2

Re: HiveServer2 released in some branch

2013-03-21 Thread Rodrigo Trujillo
Hi Thejas, thank you for the explanation. So, HiveServer2 is going to be part of Hive 0.11, and I have read that HCatalog is going to be merged in version 0.11 too. What is the target date for Hive 0.11 ? I searched this information or a schedule, but did not find. Do you, or someone, know

Fwd: Hive accessing metastore

2013-03-21 Thread Siddharth Tiwari
Sent from my iPhone Begin forwarded message: > From: Siddharth Tiwari > Date: 21 March 2013 7:43:41 AM MST > To: hive user list > Subject: Hive accessing metastore > > Hi team, > > What we have observed is, hive creates so many connections to metastore > (mysql). This makes us change the n

Hive accessing metastore

2013-03-21 Thread Siddharth Tiwari
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 e

Re: Where is exception stacktrace and root cause for UDF

2013-03-21 Thread FangKun Cao
Hi you can find the Exception log at map or reduce task logs . http://your_task_tracker:50060/tasklog?taskid=attempt_20130*_*_r_00_0&all=true 2013/3/21 Harsh J > They should be viewable if you enable the DEBUG mode. > > hive -hiveconf hive.root.logger=DEBUG,console > > On