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

feat: ordered-set aggregate in streaming queries #12857

Open
Tracked by #10038
stdrc opened this issue Oct 16, 2023 · 4 comments
Open
Tracked by #10038

feat: ordered-set aggregate in streaming queries #12857

stdrc opened this issue Oct 16, 2023 · 4 comments
Assignees

Comments

@stdrc
Copy link
Member

stdrc commented Oct 16, 2023

Ordered-set aggregate functions are currently not supported in streaming queries. One of our user seems need this.

create materialized view mv as
select
  percentile_cont(0.5) within group (order by a),
  percentile_disc(0.5) within group (order by a)
from t;
@kwannoel
Copy link
Contributor

Depends on #12570

@stdrc stdrc modified the milestones: release-1.10, release-1.11 Jul 10, 2024
@stdrc
Copy link
Member Author

stdrc commented Jul 10, 2024

Depends on #12570

This is already merged. Are we currently doing Streaming Percentile or Streaming Approx Percentile? @kwannoel

@kwannoel
Copy link
Contributor

Depends on #12570

This is already merged. Are we currently doing Streaming Percentile or Streaming Approx Percentile? @kwannoel

I'm working on Streaming Approx Percentile. Streaming Percentile is not worked on yet. You may take it up if interested.

@stdrc
Copy link
Member Author

stdrc commented Oct 17, 2024

Since we already support approx_percentile, I guess it's not an urgent to support accurate percentile_cont/cont? We can remove the milestone for now.

@stdrc stdrc removed this from the release-2.2 milestone Oct 17, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

4 participants