Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
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
Attachments
Issue Links
- is part of
-
CALCITE-6036 Support WITHIN GROUP(ORDER BY x) OVER (PARTITION BY y)
-
- Open
-
-
CALCITE-6039 PERCENTILE_CONT for BigQuery dialect has different syntax and is parsed incorrectly
-
- Open
-
-
CALCITE-6035 Correctly unparse WITHIN GROUP for Big Query dialect
-
- Open
-
- links to