[
https://issues.apache.org/jira/browse/CALCITE-6039?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Tanner Clary reassigned CALCITE-6039:
-------------------------------------
Assignee: Tanner Clary
> PERCENTILE_CONT for BigQuery dialect has different syntax and is parsed
> incorrectly
> -----------------------------------------------------------------------------------
>
> Key: CALCITE-6039
> URL: https://issues.apache.org/jira/browse/CALCITE-6039
> Project: Calcite
> Issue Type: Bug
> Reporter: Oliver Lee
> Assignee: Tanner Clary
> Priority: Major
>
> For Big Query syntax, PERCENTILE_CONT uses the key word OVER instead of
> WITHIN GROUP
> See documentation
> [here|https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#percentile_cont].
> There are a couple of issues incorrect with current parsing
> * {{Parser.jj}} currently will incorrectly parses OVER into
> {{SqlOverOperator}} (which is correct for other dialects, however not
> entirely correct for Big Query)
> * Should support: OVER(PARTITION BY y ORDER BY x)
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
