[HIVE-1304] add row_sequence UDF

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.7.0
• Fix Version/s: 0.7.0
• Component/s: UDF
• Hadoop Flags: Reviewed
• Assignee: John Sichi
• Reporter: John Sichi
• Created: 13/Apr/10 21:29
• Updated: 16/Dec/11 23:59
• Resolved: 23/Jun/10 07:16

Description

This is a poor man's answer to the standard analytic function row_number(); it assigns a sequence of numbers to rows, starting from 1.

I'm calling it row_sequence() to distinguish it from the real analytic function, so that once we add support for those, there won't be any conflict with the existing UDF.

The problem with this UDF approach is that there are no guarantees about ordering in SQL processing internals, so use with caution.

Issue Links

• is related to: HIVE-896 Add LEAD/LAG/FIRST/LAST analytical windowing functions to Hive.