Hi Michael, This is supported and should work.
Ashish -----Original Message----- From: Michael E. Driscoll [mailto:[email protected]] Sent: Friday, July 03, 2009 2:35 AM To: [email protected] Subject: aggregations over multiple columns? 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
