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] Materialized Views: Support splitting into tablets explicitly #11204

Open
def- opened this issue Jan 25, 2022 · 0 comments
Open

[YSQL] Materialized Views: Support splitting into tablets explicitly #11204

def- opened this issue Jan 25, 2022 · 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

@def-
Copy link
Contributor

def- commented Jan 25, 2022 •
edited by yugabyte-ci
Loading

Jira Link: DB-1084

Description

Currently Materialized Views (#10102) don't support explicitly splitting into tablets:

matview=#   CREATE MATERIALIZED VIEW mvtest_tv4 AS SELECT type, sum(amt) AS totamt FROM mvtest_t2 GROUP BY type SPLIT INTO 10 TABLETS;
ERROR:  syntax error at or near "SPLIT"
LINE 1: ..., sum(amt) AS totamt FROM mvtest_t2 GROUP BY type SPLIT INTO...
                                                             ^
@def- def- added kind/new-feature This is a request for a completely new feature area/ysql Yugabyte SQL (YSQL) pgcm labels Jan 25, 2022
@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
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
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@def- @yugabyte-ci @fizaaluthra