there should be no limitation AFAIK. example + error message is always
helpful - even if you might regret it. :)
On Fri, Aug 30, 2013 at 8:16 AM, Jérôme Verdier
wrote:
> Hi,
>
> Is it possible to have multiple conditions in Having clause ?
>
> I get an error when i'm trying this.
>
> Thanks a
Hi,
Is it possible to have multiple conditions in Having clause ?
I get an error when i'm trying this.
Thanks a lot.
2013/8/30 Jérôme Verdier
> Thanks Stephen,
>
> Yes i realise that it was so a stupid questionMaybe i wasn't really
> awaked this morning ;-)
>
> now it's working well.
>
>
Thanks Stephen,
Yes i realise that it was so a stupid questionMaybe i wasn't really
awaked this morning ;-)
now it's working well.
Thanks everyone.
2013/8/30 Stephen Sprague
> awright Jerome. look closely at the error message. you can figure this
> one out.
>
>
> On Fri, Aug 30, 2013 at
awright Jerome. look closely at the error message. you can figure this one
out.
On Fri, Aug 30, 2013 at 1:17 AM, Jérôme Verdier
wrote:
> Ok, thanks for this solution.
>
> Unfortunately, i have rewrited my script like this :
>
> INSERT INTO TABLE default.THM_CA_RGRP_PRODUITS_SEM
>
> SELE
Ok, thanks for this solution.
Unfortunately, i have rewrited my script like this :
INSERT INTO TABLE default.THM_CA_RGRP_PRODUITS_SEM
SELECT
'${hiveconf:in_co_societe}' as co_societe,
'${hiveconf:in_co_an_semaine}'as co_an_semaine,
a.type
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
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
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
r your reply.
>
> Effectively, dt_jour is timestamp format.
>
> What is the problem with this?
> --
> *From: * Stephen Sprague
> *Date: *Thu, 29 Aug 2013 09:24:27 -0700
> *To: *user@hive.apache.org
> *ReplyTo: * user@hive.apache.org
> *Subject:
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
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
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
12 matches
Mail list logo
