-Re: aggregations over multiple columns?
Amr Awadallah 2009-07-04, 07:02
This is a valid query, group by over multiple columns works in hive.
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(purchasePrice)
> FROM transactions
> GROUP BY customer, store
> If aggregation over multiple columns is not currently supported, how
> might I reformulate this to work in HIVE, possibly via a simpler
> series of queries?
> (I will post the exact error and reproducible code if it turns out
> this query is valid).
> b: www.dataspora.com/blog
> t: www.twitter.com/dataspora