4paradigm / 4paradigm/OpenMLDB
Feat: Add ```CREATE VIEW``` or ```CREATE MATERIALIZED VIEW```
- Dominant language
- C++
- Stars
- 1.7k
- Forks
- 331
- Avg merge
- 12d 12h
- Merged PRs (30d)
- 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.
Contributor guide
Research direction
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.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- sql
- Domain
- databases, machine-learning
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100