Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Hive Row number


Copy link to this message
-
Re: Hive Row number
shrikanth shankar 2012-12-14, 16:22
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