Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[YSQL] Support for Materialized Views #10102

Closed
mheer9 opened this issue Sep 24, 2021 · 0 comments
Closed

[YSQL] Support for Materialized Views #10102

mheer9 opened this issue Sep 24, 2021 · 0 comments
Assignees
@fizaaluthra
Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature pgcm priority/medium Medium priority issue

Comments

@mheer9
Copy link

mheer9 commented Sep 24, 2021 •
edited by yugabyte-ci
Loading

Jira Link: DB-745
This is a master issue for tracking the progress of MATERIALIZED VIEWS

Phase 1 - Support create, drop, refresh materialized view

Status Feature GitHub Issue Comments
✅ CREATE, DROP Materialized View #10509 Handled like any other YB relation
✅ REFRESH Materialized view (non-concurrent) #10510 We create a new relation which stores the updated data, and then we swap the storage of the old relation with that of the new relation

Phase 2 - Support concurrent refreshes

Status Feature GitHub Issue Comments
✅ REFRESH Materialized View (concurrent) #10511 We load the data into a temporary relation, construct a diff relation of the new data and the old matview data, and perform deletes and inserts accordingly.

Phase 3 - Support alters

Status Feature GitHub Issue Comments
⬜️ ALTER Materialized View #10512
@mheer9 mheer9 added kind/new-feature This is a request for a completely new feature area/ysql Yugabyte SQL (YSQL) labels Sep 24, 2021
@m-iancu m-iancu added this to YQL-beta Nov 8, 2021
@adil246 adil246 mentioned this issue Dec 28, 2021
Closed
@def- def- mentioned this issue Jan 25, 2022
Open
@yugabyte-ci yugabyte-ci added the priority/medium Medium priority issue label Jun 8, 2022
@yugabyte-ci yugabyte-ci added kind/enhancement This is an enhancement of an existing feature and removed kind/new-feature This is a request for a completely new feature labels Aug 18, 2022
@yugabyte-ci yugabyte-ci moved this to Done in YQL-beta Nov 8, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@fizaaluthra fizaaluthra

Labels
area/ysql Yugabyte SQL (YSQL) kind/enhancement This is an enhancement of an existing feature pgcm priority/medium Medium priority issue
Projects
YQL-beta
Status: Done
Milestone
No milestone
Development

No branches or pull requests
4 participants
@sushantrmishra @yugabyte-ci @fizaaluthra @mheer9