[ https://issues.apache.org/jira/browse/HIVE-3804?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13532402#comment-13532402 ]
Swarnim Kulkarni commented on HIVE-3804: ---------------------------------------- I think you should first try posting the question on the user/dev mailing list before opening up a JIRA for it. > 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