o: * user@hive.apache.org
> *Subject: *Re: Hive query failing on group by
>
> Bejoy,
>
> I've been using this install of Hive for some time now, and simple queries
> and joins work fine. It's the GROUP BY that I have problems with, sometimes
> even with COUNT(*
10:55:34
To: ;
Reply-To: user@hive.apache.org
Subject: Re: Hive query failing on group by
Bejoy,
I've been using this install of Hive for some time now, and simple queries
and joins work fine. It's the GROUP BY that I have problems with, sometimes
even with COUNT(*).
I am trying to i
r form
>>>> there. From hive CLI you could hardly find out the root cause of your
>>>> errors. From job tracker web UI < http://hostname:50030/jobtracker.jsp>
>>>> you can easily browse to failed tasks and get the actual exception from
>>>> there. If you ar
Oct 2011 10:02:57
To:
Reply-To: user@hive.apache.org
Subject: Re: Hive query failing on group by
Vikas,
I am using Cloudera CDHU1 on Ubuntu. I get the same results on RedHat CDHU0.
Mark
On Wed, Oct 19, 2011 at 9:47 AM, Vikas Srivastava <
vikas.srivast...@one97.net> wrote:
> install
exception from
>>> there. If you are not able to figure out from there then please post in
>>> those logs with your table schema.
>>>
>>> Regards
>>> Bejoy K S
>>> --
>>> *From: * Mark Kerzner
>>> *Dat
ctual exception from
>> there. If you are not able to figure out from there then please post in
>> those logs with your table schema.
>>
>> Regards
>> Bejoy K S
>> ----------
>> *From: * Mark Kerzner
>> *Date: *Wed, 19 Oct 2011 09:
--
> *From: * Mark Kerzner
> *Date: *Wed, 19 Oct 2011 09:06:13 -0500
> *To: *Hive user
> *ReplyTo: * user@hive.apache.org
> *Subject: *Hive query failing on group by
>
> HI,
>
> I am trying to figure out what I am doing wrong with this query and the
> unusual err
eption from there. If you are not
able to figure out from there then please post in those logs with your table
schema.
Regards
Bejoy K S
-Original Message-
From: Mark Kerzner
Date: Wed, 19 Oct 2011 09:06:13
To: Hive user
Reply-To: user@hive.apache.org
Subject: Hive query failing on gr
HI,
I am trying to figure out what I am doing wrong with this query and the
unusual error I am getting. Also suspicious is the reduce % going up and
down.
select trans.property_id, day(trans.log_timestamp) from trans JOIN opts on
trans.ext_booking_id["ext_booking_id"] = opts.ext_booking_id group
