Re: Hive Metastore Server 0.9 Connection Reset and Connection Timeout errors

Thanks Ashutosh. Filed https://issues.apache.org/jira/browse/HIVE-5172 On Thu, Aug 29, 2013 at 11:53 AM, Ashutosh Chauhan wrote: > Thanks Agatea for digging in. Seems like you have hit a bug. Would you > mind opening a jira and adding your findings to it. > > Thanks, > Ashutosh > > > On Thu, Au

Re: Hive Metastore Server 0.9 Connection Reset and Connection Timeout errors

Thanks Ashutosh. Filed https://issues.apache.org/jira/browse/HIVE-5172 On Thu, Aug 29, 2013 at 11:53 AM, Ashutosh Chauhan wrote: > Thanks Agatea for digging in. Seems like you have hit a bug. Would you > mind opening a jira and adding your findings to it. > > Thanks, > Ashutosh > > > On Thu, A

Re: Problème with min function in HiveQL

indeed. you nailed it. On Thu, Aug 29, 2013 at 11:53 AM, John Meagher wrote: > Aggregate functions need to go in a HAVING clause instead of the WHERE > clause. WHERE clauses are applied prior to aggregation, HAVING is > applied post aggregation. > > select ... > from ... > where some row level

Re: Hive Metastore Server 0.9 Connection Reset and Connection Timeout errors

Thanks Agatea for digging in. Seems like you have hit a bug. Would you mind opening a jira and adding your findings to it. Thanks, Ashutosh On Thu, Aug 29, 2013 at 11:22 AM, agateaaa wrote: > Sorry hit send too soon ... > > Hi All: > > Put some debugging code in TUGIContainingTransport.getTran

Re: Problème with min function in HiveQL

Aggregate functions need to go in a HAVING clause instead of the WHERE clause. WHERE clauses are applied prior to aggregation, HAVING is applied post aggregation. select ... from ... where some row level filter group by ... having some aggregate level filter On Thu, Aug 29, 2013 at 2:49 PM, Ja

Re: Problème with min function in HiveQL

Looks like the issue is the use of min() within the WHERE clause - the place where the exception is being thrown has the following comment: // UDAF in filter condition, group-by caluse, param of funtion, etc. On Aug 29, 2013, at 3:01 AM, Jérôme Verdier wrote: > Hi everybody, > > I am

Re: Hive Metastore Server 0.9 Connection Reset and Connection Timeout errors

Sorry hit send too soon ... Hi All: Put some debugging code in TUGIContainingTransport.getTransport() and I tracked it down to @Override public TUGIContainingTransport getTransport(TTransport trans) { // UGI information is not available at connection setup time, it will be set later // via set_

Re: Problème with min function in HiveQL

well. i would suggest you test whether or not min() works on timestamp datatype. it seems like something one should rule out first before going down the rabbit hole further. My opinion only! On Thu, Aug 29, 2013 at 9:28 AM, Jérôme Verdier wrote: > ** > Hi stephen, > > Thanks for your reply. >

Re: Hive Metastore Server 0.9 Connection Reset and Connection Timeout errors

Hi All: Put some debugging code in TUGIContainingTransport.getTransport() and I tracked it down to @Override public TUGIContainingTransport getTransport(TTransport trans) { // UGI information is not available at connection setup time, it will be set later // via set_ugi() rpc. transMap.putIfAbse

Re: Problème with min function in HiveQL

Hi stephen, Thanks for your reply. Effectively, dt_jour is timestamp format. What is the problem with this? -Original Message- From: Stephen Sprague Date: Thu, 29 Aug 2013 09:24:27 To: user@hive.apache.org Reply-To: user@hive.apache.org Subject: Re: Problème with min function in HiveQ

Re: Problème with min function in HiveQL

the min function at column 62 is on on the column b.dt_jour. what datatype is that? if its of type 'timestamp' that might explain it. On Thu, Aug 29, 2013 at 3:01 AM, Jérôme Verdier wrote: > Hi everybody, > > I am coding some HiveQL script to do some calculations. > > I have a problem with the

Problème with min function in HiveQL

Hi everybody, I am coding some HiveQL script to do some calculations. I have a problem with the min() function. My hive script is below : INSERT INTO TABLE default.THM_CA_RGRP_PRODUITS_SEM SELECT '${hiveconf:in_co_societe}' as co_societe, '${hiveconf:in_co

Re: Cannot insert into a bucketized table from the same table

Neha, its not a bug. Hive does not support insert into bucketed table as of now. There is a patch available for same at HIVE-3244 You can also refer HIVE-3077 On Thu, Aug 29, 2013 at 2:32 PM, Neha S

Cannot insert into a bucketized table from the same table

Hive version: 0.10.0-cdh4.2.1 Trying to insert into a bucketized table from the same table, throws exception: "FAILED: SemanticException [Error 10122]: Bucketized tables do not support INSERT INTO: Table:" To test the scenario, I create the following 3 test tables: create table temp1 (a int) PART