matrixorigin / matrixorigin/matrixone

[Feature Request]: Support MATERIALIZED VIEW

Open
#6,593 3 comments 0 reactions 1 assignee Claimed by @iamlinjunhong View on GitHub
kind/feature long-term-job needs-triage priority/p0 source/on-demand
Dominant language
Go
Stars
1.9k
Forks
311
Avg merge
1d 3h
Merged PRs (30d)
768

Description

### Is there an existing issue for the same feature request?

- [X] I have checked the existing issues.

### Is your feature request related to a problem?

_No response_

### Describe the feature you'd like

CREATE MATERIALIZED VIEW [ IF NOT EXISTS ] view_name
[ (column_name [, ...] ) ]
[ USING method ]
AS query
[ WITH [ NO ] DATA

DROP [ IF EXISTS ] MATERIALIZED VIEW view_name

REFRESH MATERIALIZED VIEW [ CONCURRENTLY ] view_name
[ WITH [ NO ] DATA ]

Feature list:
- Support the syntax by following PG in both CREATE and DROP
- Support refresh manually

### Describe implementation you've considered

_No response_

### Documentation, Adoption, Use Case, Migration Strategy

_No response_

### Additional information

_No response_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.