hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Carl Steinbach <>
Subject Re: selecting data where max is found
Date Tue, 23 Feb 2010 21:00:13 GMT

The example in the link will compile and execute on Hive without


On Tue, Feb 23, 2010 at 12:46 PM, Tom Nichols <> wrote:

> Hi Hive users,
> I've got a somewhat convoluted query which I'm wondering how I would
> translate it to hive...  It is similar to the first FAQ example here:
> So following the example above, I could easily get the last run date
> for each report, but how would I get the _user_ who last ran the
> report?  It involves a join based on a subquery.  Conceptually this
> seems like it wouldn't be difficult because I can carry all of the
> columns while searching for a 'max' of one column in a M-R job...  it
> just doesn't express itself in SQL quite the same way.
> Is there a way to put the result of my inner select directly into
> another Hive table and then my outer select would just join on that
> table?
> Thanks.

View raw message