ssage-
> From: Amr Awadallah [mailto:a...@cloudera.com]
> Sent: Saturday, July 04, 2009 12:02 AM
> To: hive-user@hadoop.apache.org
> Subject: Re: aggregations over multiple columns?
>
> Mike,
>
> This is a valid query, group by over multiple columns works in hive.
>
>
Hi Michael,
This is supported and should work.
Ashish
-Original Message-
From: Michael E. Driscoll [mailto:m.e.drisc...@gmail.com]
Sent: Friday, July 03, 2009 2:35 AM
To: hive-user@hadoop.apache.org
Subject: aggregations over multiple columns?
Hi HIVErs,
I'm trying to perfor
Thanks & regards,
Avram
-Original Message-
From: Amr Awadallah [mailto:a...@cloudera.com]
Sent: Saturday, July 04, 2009 12:02 AM
To: hive-user@hadoop.apache.org
Subject: Re: aggregations over multiple columns?
Mike,
This is a valid query, group by over multiple columns works in hive.
-- a
Mike,
This is a valid query, group by over multiple columns works in hive.
-- amr
Michael E. Driscoll wrote:
Hi HIVErs,
I'm trying to perform the following aggregation query in HIVE, which
finds the largest purchase for all combinations of customer and store:
SELECT customer, store, max(p
Hi HIVErs,
I'm trying to perform the following aggregation query in HIVE, which
finds the largest purchase for all combinations of customer and store:
SELECT customer, store, max(purchasePrice)
FROM transactions
GROUP BY customer, store
If aggregation over multiple columns is not currently
