[
https://issues.apache.org/jira/browse/HIVE-259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12806183#action_12806183
]
Carl Steinbach commented on HIVE-259:
-------------------------------------
@Jerome: Agreed. Allowing sort results to be shared by multiple functions (like
in the following example) is key to supporting analytic functions efficiently.
{code:sql}
SELECT department_id,
PERCENTILE_CONT(0.5) WITHIN GROUP (ORDER BY salary DESC)
"Median cont",
PERCENTILE_DISC(0.5) WITHIN GROUP (ORDER BY salary DESC)
"Median disc"
FROM employees GROUP BY department_id;
{code}
> 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.
