[ https://issues.apache.org/jira/browse/HIVE-3804?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13532408#comment-13532408 ]
maya bhardwaj commented on HIVE-3804: ------------------------------------- Thanks I will ask question there. I am new to this so asked here :( > Row number issue in hive > ------------------------ > > Key: HIVE-3804 > URL: https://issues.apache.org/jira/browse/HIVE-3804 > Project: Hive > Issue Type: Task > Reporter: maya bhardwaj > Priority: Critical > Fix For: 0.9.0 > > > 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 -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira