4paradigm / 4paradigm/OpenMLDB

more flexible support to window (SimpleOps)

Offen
#3,024 0 Kommentare 0 Reaktionen 1 zugewiesene Person Beansprucht von @aceforeverd Auf GitHub ansehen
enhancement execute-engine
Vorherrschende Sprache
C++
Sterne
1.7k
Forks
331
Ø Merge
12 T. 12 Std.
Gemergte PRs (30 T.)
1

Beschreibung

Here *SimpleOps* refer to one of:

- SimpleProject(TableSource)
- SimpleProject(Last Join)
- SImpleProject (Rename)
- SImpleProject (A last join ( SimpleProject (B last join C))
- ...

Known limits
- window op (the partition by & order by) may only refer to left most physical table inside simple project

There are already issues which actually part of this feature:
- https://github.com/4paradigm/OpenMLDB/issues/2563
- window union #2832

Beitragsleitfaden

Beitragsleitfaden öffnen

Rechercherichtung

The issue describes extending window function support in SimpleOps. Start by reading the linked issue #2563 and PR #2832 to understand the current limitations. Examine the code for window operations and SimpleProject handling, likely in the query planner or optimizer. Determine how partition by and order by clauses are currently resolved and where they are restricted to the leftmost physical table.

Vom Indexierungsmodell aus dem Issue-Text verfasst.

Bewertung

Tech-Stack
sql
Bereich
data-engineering, databases, machine-learning
Issue-Typ
Feature
Schwierigkeit
4/5
Geschätzter Aufwand
3-5 Tage
Aktivitätsstatus
Veraltet
Klarheit
Muss geklärt werden
Anfängerfreundlichkeit
30/100

Neue Issues direkt in Ihr Postfach

Eine kurze Übersicht über anfängerfreundliche GitHub-Issues.