Grokbase Groups Hive user July 2009
FAQ
Hi Michael,

This is supported and should work.

Ashish

-----Original Message-----
From: Michael E. Driscoll
Sent: Friday, July 03, 2009 2:35 AM
To: hive-user@hadoop.apache.org
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

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

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