[
https://issues.apache.org/jira/browse/CALCITE-5564?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17723246#comment-17723246
]
Julian Hyde commented on CALCITE-5564:
--------------------------------------
[~tanclary], Can you link related bugs. (I was just in CALCITE-4666 but
couldn't find this case because you hadn't linked.)
Can you edit the description and add an example in both the BigQuery syntax and
the regular syntax. It will help me and others understand the mapping between
the two syntaxes.
> Support 2-argument PERCENTILE_CONT, PERCENTILE_DISC aggregate functions (as
> in BigQuery)
> ----------------------------------------------------------------------------------------
>
> Key: CALCITE-5564
> URL: https://issues.apache.org/jira/browse/CALCITE-5564
> Project: Calcite
> Issue Type: Improvement
> Reporter: Tanner Clary
> Assignee: Tanner Clary
> Priority: Major
>
> Calcite currently has implementations for the {{PERCENTILE_CONT}} and
> {{PERCENTILE_DISC}} functions. Their syntax may be found
> [here|https://learn.microsoft.com/en-us/sql/t-sql/functions/percentile-cont-transact-sql?view=sql-server-ver16].
>
> BigQuery offers these functions as well, but the syntax is slightly
> different, and may be found
> [here|https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#percentile_cont].
> The main difference is that instead of using a {{WITHIN GROUP}} clause, the
> array is passed in directly as the first argument to the function.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
