8000 Support `lag`/`lead` window function with `default` argument · Issue #10817 · risingwavelabs/risingwave · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

Support lag/lead window function with default argument #10817

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.

Sign up for GitHub

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

Jump to bottom
Open
Tracked by #9124
lmatz opened this issue Jul 7, 2023 · 6 comments
Open
Tracked by #9124

Support lag/lead window function with default argument #10817

lmatz opened this issue Jul 7, 2023 · 6 comments
Assignees
@stdrc
Labels
A-window-func Area: Window function, OverWindow. good first issue Good for newcomers no-issue-activity type/feature Type: New feature.

Comments

@lmatz
Copy link
Contributor
lmatz commented Jul 7, 2023

Is your feature request related to a problem? Please describe.

We have supported lag, but default value is requested by one PoC user

dev=> create table t (
dev(>       id int
dev(>     , p1 int
dev(>     , p2 int
dev(>     , time int
dev(>     , v1 int
dev(>     , v2 int
dev(> );
CREATE_TABLE
dev=> create materialized view mv_c as
dev-> select
dev->     *
dev->     , lag(v1, 0, 5) over (partition by p1 order by id) as out5 from t;
ERROR:  QueryError: Bind error: failed to bind expression: lag(v1, 0, 5) OVER (PARTITION BY p1 ORDER BY id)

Caused by:
  Feature is not yet implemented: `lag` window function with `default` argument is not supported yet
No tracking issue yet. Feel free to submit a feature request at https://github.com/risingwavelabs/risingwave/issues/new?labels=type%2Ffeature&template=feature_request.yml

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response
@lmatz lmatz added the type/feature Type: New feature. label Jul 7, 2023
@github-actions github-actions bot added this to the release-0.20 milestone Jul 7, 2023
@lmatz lmatz mentioned this issue Jul 7, 2023
Open
38 tasks
@lmatz lmatz added open to contribution Issues that are open to contribution. P-high Priority: High. and removed P-high Priority: High. labels Jul 7, 2023
@lmatz lmatz modified the milestones: release-1.0, release-1.1 Jul 14, 2023
@lmatz lmatz modified the milestones: release-1.1, release-1.2 Aug 8, 2023
@fuyufjh
Copy link
Collaborator
fuyufjh commented Sep 11, 2023

@stdrc please take a look

@fuyufjh fuyufjh modified the milestones: release-1.2, release-1.3 Sep 11, 2023
@stdrc stdrc modified the milestones: release-1.3, release-1.4 Oct 10, 2023
@stdrc stdrc changed the title Support lag window function with default argument Support lag/lead window function with default argument Nov 1, 2023
@stdrc stdrc modified the milestones: release-1.4, release-1.5 Nov 7, 2023
@stdrc stdrc modified the milestones: release-1.5, release-1.6 Dec 4, 2023
@stdrc stdrc modified the milestones: release-1.6, release-1.7 Jan 9, 2024
@stdrc stdrc modified the milestones: release-1.7, release-1.8 Mar 6, 2024
@stdrc stdrc modified the milestones: release-1.8, release-1.9 Apr 8, 2024
@stdrc stdrc removed this from the release-1.9 milestone May 10, 2024
@github-actions GitHub Actions
Copy link
Contributor
github-actions bot commented Aug 1, 2024

This issue has been open for 60 days with no activity.

If you think it is still relevant today, and needs to be done in the near future, you can comment to update the status, or just manually remove the no-issue-activity label.

You can also confidently close this issue as not planned to keep our backlog clean.
Don't worry if you think the issue is still valuable to continue in the future.
It's searchable and can be reopened when it's time. 😄

@xxchan xxchan added the good first issue Good for newcomers label Aug 1, 2024
@stdrc stdrc removed the open to contribution Issues that are open to contribution. label Mar 18, 2025
@stdrc stdrc added the A-window-func Area: Window function, OverWindow. label May 26, 2025
@lewisthorpe1994
Copy link

Hi, is anyone actively looking at this at the moment? Can i take a look at it if not?

@jetjinser
Copy link
Contributor

Hi, is anyone actively looking at this at the moment? Can i take a look at it if not?

👋，If you're willing to look at it, I am okay with it!
cc @stdrc.

@lewisthorpe1994
Copy link

@jetjinser I'm happy to take a look at this in parallel then :)

@stdrc
Copy link
Member
stdrc commented Jun 2, 2025

Hi, is anyone actively looking at this at the moment? Can i take a look at it if not?

Sure you can take it. Thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@stdrc stdrc

Labels
A-window-func Area: Window function, OverWindow. good first issue Good for newcomers no-issue-activity type/feature Type: New feature.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
6 participants
@stdrc @lmatz @fuyufjh @xxchan @jetjinser @lewisthorpe1994
0