[
https://issues.apache.org/jira/browse/HIVE-259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12668699#action_12668699
]
Edward Capriolo commented on HIVE-259:
--------------------------------------
95% percentile is very often used in Internet Service Provider billing that
might be useful.
The percentile calculation is a sort and then picking an element. The syntax
could be like:
* PERCENTILE(column, .99)
* PERCENTILE(column, .50)
In this manner you could do any percentile.
> Add PERCENTILE aggregate function
> ---------------------------------
>
> Key: HIVE-259
> URL: https://issues.apache.org/jira/browse/HIVE-259
> Project: Hadoop Hive
> Issue Type: New Feature
> Components: Query Processor
> Reporter: Venky Iyer
>
> Compute atleast 25, 50, 75th percentiles
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
