search

matrixorigin / matrixone

Hyperconverged cloud-edge native database
https://docs.matrixorigin.cn/en
Apache License 2.0
1.79k stars 276 forks source link

[Feature Request]: Support MATERIALIZED VIEW #6593

Open domingozhang opened 2 years ago

domingozhang commented 2 years ago

Is there an existing issue for the same feature request?

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:

Describe implementation you've considered

No response

Documentation, Adoption, Use Case, Migration Strategy

No response

Additional information

No response

nnsgmsone commented 2 years ago

Why do you want the user to perceive the materialized view. create view is not good?

fengttt commented 1 year ago

user wants to create materialized view -- it means user is willing to pay for maintenance to get better performance.

gavinyue commented 1 year ago

Implement this in streaming project: https://github.com/orgs/matrixorigin/projects/17