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).