This is supported and should work.
From: Michael E. Driscoll
Sent: Friday, July 03, 2009 2:35 AM
Subject: aggregations over multiple columns?
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)
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).