See http://www.edwardcapriolo.com/roller/edwardcapriolo/entry/doing_rank_with_hive
thanks, Shrikanth On Dec 14, 2012, at 8:18 AM, maya bhardwaj wrote: > I am converting the Netezza query in hive.How can i achieve following query > in hive --> row_number() over (partition by record_id, event_id order by > e_timestamp desc) as rnum
