Oliver Lee created CALCITE-6039:
-----------------------------------
Summary: 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
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)
