Is there any plan to support window aggregation in Calcite Query Engine
Open
- Dominant language
- Java
- Stars
- 5.1k
- Forks
- 1.9k
- Avg merge
- 3d 2h
- Merged PRs (30d)
- 46
Description
```
select "deptno",
rank() over (order by "deptno") as r
from "hr"."emps"
```
Calcite supports the above Sql, but Ignite's Calcite Query Engine does not support window aggregation syntax. Is there any plan to implement window aggregation in Calcite Query Engine.
Contributor guide
Research direction
No file or test is named. Begin by tracing how the Calcite Query Engine handles the shown rank() OVER (ORDER BY "deptno") query, then define support and verification using the hr.emps example. Done means the query executes successfully in Ignite's Calcite Query Engine.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, sql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 25/100