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

Switch to Plain View
Hive >> mail # user >> Hive Row number


+
maya bhardwaj 2012-12-14, 16:18
Copy link to this message
-
Re: Hive Row number
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

+
maya bhardwaj 2012-12-14, 16:26
+
maya bhardwaj 2012-12-18, 19:33