[HIVE-894] Add UDAFs max_n(), min_n() to contrib

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.6.0
• Component/s: UDF
• Hadoop Flags: Reviewed
• Assignee: Zheng Shao
• Reporter: Zheng Shao
• Created: 20/Oct/09 23:08
• Updated: 17/Dec/11 00:03
• Resolved: 04/Feb/10 06:55

Description

These 2 UDAFs should return the max n numbers, min n numbers in order.

SELECT max_n(userid, 3) FROM src;
[999,997,996]
SELECT max_n(userid, 3)[1] FROM src;
997
SELECT min_n(userid, 3) FROM src;
[0, 3, 8]
SELECT min_n(userid, 3)[2] FROM src;
8