You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Rafay A (Jira)" <ji...@apache.org> on 2021/06/22 17:15:00 UTC
[jira] [Comment Edited] (CALCITE-4644) Add PERCENTILE_CONT and
PERCENTILE_DISC aggregate functions
[ https://issues.apache.org/jira/browse/CALCITE-4644?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17367525#comment-17367525 ]
Rafay A edited comment on CALCITE-4644 at 6/22/21, 5:14 PM:
------------------------------------------------------------
SqlBasicAggFunction was added recently and I did not notice that COLLECT now extend from it. I'll update my patch and apply your feedback.
I'll rename the word "positive". How about "[UNIT_INTERVAL_NUMERIC_LITERAL|https://en.wikipedia.org/wiki/Unit_interval]"
Postgres returns this error message if the argument is not in the range:
{code:java}
ERROR: percentile value 1.5 is not between 0 and 1
ERROR: percentile value -1.5 is not between 0 and 1
{code}
was (Author: rafay):
SqlBasicAggFunction was added recently and I did not notice that COLLECT now extend from it. I'll update my patch and apply your feedback.
I'll rename the word "positive". How about "[UNIT_INTERVAL_NUMERIC_LITERAL|https://en.wikipedia.org/wiki/Unit_interval]"
Postgres returns this error message if the argument is not in the range:
{code:java}
ERROR: percentile value 1.5 is not between 0 and 1
ERROR: percentile value -1.5 is not between 0 and 1
{code}
> Add PERCENTILE_CONT and PERCENTILE_DISC aggregate functions
> -----------------------------------------------------------
>
> Key: CALCITE-4644
> URL: https://issues.apache.org/jira/browse/CALCITE-4644
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Reporter: Rafay A
> Priority: Major
> Labels: pull-request-available
> Time Spent: 40m
> Remaining Estimate: 0h
>
> Add percentile functions in the operator table.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)