4paradigm / 4paradigm/OpenMLDB

Feat: Add ```CREATE VIEW``` or ```CREATE MATERIALIZED VIEW```

Ouverte
#616 1 commentaire 0 réactions 1 personne assignée Réclamée par @zhanghaohit Voir sur GitHub
community
Langage dominant
C++
Étoiles
1.7k
Forks
331
Merge moyen
12 j 12 h
PR mergées (30 j)
1

Description

**Is your feature request related to a problem? Please describe.**
Previous issue #223 mentioned supporting approximate aggregate in a long windows, however it is better to support something like *MATERIALIZED VIEW* to make a query to be scheduled later by job manager.

**Describe the solution you'd like**
Add support for ```CREATE VIEW``` or ```CREATE MATERIALIZED VIEW``` for storing precomputed result of a query and support to trigger it to be refreshed later upon demand.

Guide de contribution

Ouvrir le guide de contribution

Piste de recherche

The issue is about adding CREATE VIEW and CREATE MATERIALIZED VIEW support to OpenMLDB, a C++ database for machine learning. Look at the SQL parser and query execution engine to understand how queries are currently processed. Research how materialized views are refreshed and integrated with a job scheduler. Check existing issues like #223 for context on approximate aggregates and long windows.

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

Évaluation

Stack technique
sql
Domaine
databases, machine-learning
Type d'issue
Fonctionnalité
Difficulté
4/5
Temps estimé
Plus d'une semaine
Activité
À l'abandon
Clarté
Plutôt claire
Accessibilité débutants
35/100

Recevez les nouvelles issues par e-mail

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