Support ROW_NUMBER() over
Open
dsl
new feature
P3
sql
- Dominant language
- Java
- Stars
- 8.7k
- Forks
- 4.7k
- Avg merge
- 2d 5h
- Merged PRs (30d)
- 204
Description
Design and implement ROW_NUMBER() OVER window. It is supported by Calcite and we should look at feasibility of supporting it in Beam SQL
[StackOverflow Post](https://stackoverflow.com/questions/50724531/implement-row-number-in-beamsql)
Imported from Jira [BEAM-4509](https://issues.apache.org/jira/browse/BEAM-4509). Original Jira may contain additional context.
Reported by: kedin.
Contributor guide
Research direction
Start by reviewing Beam SQL's existing window-function support and Calcite's ROW_NUMBER() OVER behavior. Use the linked Stack Overflow post and original Jira issue for context, then determine the implementation scope and validation needed for Beam SQL to support the syntax.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- data-engineering, databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100