4paradigm / 4paradigm/OpenMLDB

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

未关闭
#616 1 条评论 0 个 reaction 已指派 1 人 已被 @zhanghaohit 认领 在 GitHub 查看
community
主要语言
C++
星标
1.7k
派生
331
平均合并
12 天 12 小时
30 天内合并 PR
1

描述

**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.

贡献指南

打开贡献指南

调研方向

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.

由索引模型根据 Issue 内容生成。

评估

技术栈
sql
领域
databases, machine-learning
Issue 类型
功能
难度
4/5
预计耗时
一周以上
活跃度
停滞
描述清晰度
基本清楚
新手友好度
35/100

把新 issue 发到你的邮箱

精选适合新手参与的 GitHub issue 摘要。