apache / apache/ignite

Is there any plan to support window aggregation in Calcite Query Engine

Open
#11,321 1 comment 0 reactions 0 assignees View on GitHub
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.