Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB