[HIVE-3804] Row number issue in hive

• Type: Task
• Status: Resolved
• Priority: Critical
• Resolution: Invalid
• Fix Version/s: 0.9.0
• Assignee: Unassigned
• Reporter: maya bhardwaj
• Created: 14/Dec/12 15:35
• Updated: 14/Dec/12 16:09
• Resolved: 14/Dec/12 16:09

Description

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