4paradigm / 4paradigm/OpenMLDB
Feat: Add ```CREATE VIEW``` or ```CREATE MATERIALIZED VIEW```
- 主要言語
- C++
- スター
- 1.7k
- フォーク
- 331
- 平均マージ
- 12日 12時間
- マージ済み PR(30日)
- 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
- 見積もり時間
- 1週間以上
- 活発さ
- 停滞
- 明瞭さ
- おおむね明確
- 初心者へのやさしさ
- 35/100