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

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 1 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