4paradigm / 4paradigm/OpenMLDB

more flexible support to window (SimpleOps)

Ouverte
#3,024 0 commentaires 0 réactions 1 personne assignée Réclamée par @aceforeverd Voir sur GitHub
enhancement execute-engine
Langage dominant
C++
Étoiles
1.7k
Forks
331
Merge moyen
12 j 12 h
PR mergées (30 j)
1

Description

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

Guide de contribution

Ouvrir le guide de contribution

Piste de recherche

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.

Rédigé par le modèle d'indexation à partir du texte de l'issue.

Évaluation

Stack technique
sql
Domaine
data-engineering, databases, machine-learning
Type d'issue
Fonctionnalité
Difficulté
4/5
Temps estimé
3-5 jours
Activité
À l'abandon
Clarté
À clarifier
Accessibilité débutants
30/100

Recevez les nouvelles issues par e-mail

Un résumé court des issues GitHub adaptées aux débutants.