[PHOENIX-422] Support PERCENTILE_CONT aggregate function

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

Description

Support an aggregate function that generates an interpolated value that, if added to the group, would correspond to the percentile given

SELECT PERCENTILE_CONT(<percentile>) WITHIN GROUP (ORDER BY <expression> ASC)
FROM t

The PERCENTILE_CONT function would return the same type as <expression>. See [here](http://my.safaribooksonline.com/book/databases/sql/9780596155322/ansi-sql-aggregate-functions/id3491773_X2ludGVybmFsX0h0bWxWaWV3P3htbGlkPTk3ODA1OTYxNTUzMjIlMkZpZDM0ODkwMjAmcXVlcnk9) for some additional documentation.