hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Owen O'Malley" <omal...@apache.org>
Subject Re: ROW_NUMBER() equivalent in Hive
Date Thu, 21 Feb 2013 16:08:01 GMT
What are the semantics for ROW_NUMBER? Is it a global row number? Per a
partition? Per a bucket?

-- Owen


On Wed, Feb 20, 2013 at 11:33 PM, kumar mr <kumar.mr@aol.com> wrote:

> Hi,
>
>  This is Kumar, and this is my first question in this group.
>
>  I have a requirement to implement ROW_NUMBER() from Teradata in Hive
> where partitioning happens on multiple columns along with multiple column
> ordering.
> It can be easily implemented in Hadoop MR, but I have to do in Hive. By
> doing in UDF can assign same rank to grouping key considering dataset is
> small, but ordering need to be done in prior step.
> Can we do this in lot simpler way?
>
>  Thanks in advance.
>
>  Regards,
> Kumar
>

Mime
View raw message