[CALCITE-6035] Correctly unparse WITHIN GROUP for Big Query dialect

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Labels: pull-request-available
• Assignee: Oliver Lee
• Reporter: Oliver Lee
• Created: 05/Oct/23 20:37
• Updated: 30/Oct/23 16:29

Description

In Big Query SQL, the percentile_cont function uses the keyword OVER instead of WITHIN GROUP. 

This is not to be confused with ISO SQL OVER, which is used in windowed aggregate functions. (percentile_cont is not a window function) 

 

Requirements: 

select percentile_cont(0.5) within group (order by x)  in ISO SQL should be unparsed as select percentile_cont(0.5) over (order by x) if the target dialect is Big Query

Issue Links

• incorporates: CALCITE-5955 BigQuery PERCENTILE functions are unparsed incorrectly
• links to: GitHub Pull Request #3466