hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kumar mr <kumar...@aol.com>
Subject ROW_NUMBER() equivalent in Hive
Date Thu, 21 Feb 2013 07:33:16 GMT
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