matrixorigin / matrixorigin/matrixone
[Feature Request]: Support MATERIALIZED VIEW
- 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
Assessment
This issue has not been assessed yet.