Grokbase Groups Hive user July 2009
FAQ
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(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).

regards,

Mike

b: www.dataspora.com/blog
t: www.twitter.com/dataspora

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 5 | next ›
Discussion Overview
groupuser @
categorieshive, hadoop
postedJul 3, '09 at 9:35a
activeJul 7, '09 at 2:51a
posts5
users5
websitehive.apache.org

People

Translate

site design / logo © 2021 Grokbase