4paradigm / 4paradigm/OpenMLDB

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

Open
#616 1 comment 0 reactions 1 assignee Claimed by @zhanghaohit View on GitHub
community
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.