[PHOENIX-419] Support PERCENT_RANK aggregate function

• Type: Task
• Status: Resolved
• Resolution: Fixed
• Labels: enhancement
• old issue number: 288
• Assignee: Anoop Sam John
• Reporter: James R. Taylor
• Created: 10/Mar/14 23:47
• Updated: 16/Mar/14 07:17
• Resolved: 16/Mar/14 07:17

Description

Support an aggregate function that calculates the percent rank of an expression like this:

SELECT PERCENT_RANK(<perc>) WITHIN GROUP (ORDER BY <expression> ASC)
FROM t

The PERCENT_RANK function would return a type of DECIMAL.