Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Using filter + within group is not supported #75

Open
crisptrutski opened this issue Jun 24, 2024 · 0 comments
Open

Using filter + within group is not supported #75

crisptrutski opened this issue Jun 24, 2024 · 0 comments
Labels
bug Something isn't working .Team/BackendComponents

Comments

@crisptrutski
Copy link
Contributor

Here is a minimally reproducing query:

  select
    e.instance_id
   -- this next one is fine
    , percentile_cont(0.75) within group (order by e.running_time) / 1000.0 as p75_time
   -- this is also fine
    , avg(e.running_time) filter (where e.error = '') / 1000.0 as avg_success_time
   -- this one causes a parse error
    , percentile_cont(0.75) within group (order by e.running_time) filter (where e.error = '') / 1000.0 as p75_success_time
  from execution e
  group by 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working .Team/BackendComponents
Projects
None yet
Development

No branches or pull requests

1 participant