[CALCITE-5955] BigQuery PERCENTILE functions are unparsed incorrectly

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.37.0
• Labels: pull-request-available
• Assignee: Tanner Clary
• Reporter: Tanner Clary
• Created: 24/Aug/23 18:23
• Updated: 06/May/24 22:19
• Resolved: 19/Dec/23 21:37

Description

Currently if you have a query like:

SELECT PERCENTILE_CONT(x, .5) OVER() FROM x; the OVER() clause gets unparsed with a window frame clause which BigQuery defines here.

From the docs: "Only aggregate analytic functions can use a window frame clause."

This causes BigQuery to fail with the following error: Window framing clause is not allowed for analytic function percentile_cont

Issue Links

• is part of: CALCITE-6036 Support WITHIN GROUP(ORDER BY x) OVER (PARTITION BY y)
• is part of: CALCITE-6039 PERCENTILE_CONT for BigQuery dialect has different syntax and is parsed incorrectly
• is part of: CALCITE-6035 Correctly unparse WITHIN GROUP for Big Query dialect
• links to: GitHub Pull Request #3438