Skip to content

Support distributed by clause specification when Create MV if not exists#563

Merged
my-ship-it merged 5 commits into
apache:mainfrom
reshke:support_distr
Aug 21, 2024
Merged

Support distributed by clause specification when Create MV if not exists#563
my-ship-it merged 5 commits into
apache:mainfrom
reshke:support_distr

Conversation

@reshke

@reshke reshke commented Aug 8, 2024

Copy link
Copy Markdown
Contributor

$subj

For some reason, current grammatical parser does not accept Distributed By clause in case IF NOT EXISTS specified for materialized view, which I don't any any reason to disallow

@reshke

reshke commented Aug 8, 2024

Copy link
Copy Markdown
Contributor Author

hmmm icw-test are failing, but they look unrelated to C.M.V, aren't they?

@avamingli

Copy link
Copy Markdown
Contributor

Hi, please provide cases to verify what you have done.

@reshke

reshke commented Aug 8, 2024

Copy link
Copy Markdown
Contributor Author

Hi, please provide cases to verify what you have done.

Hi, you mean some regression test-cases? They are as obvious as

create table t1(i int);
create materialized view if not exists mv1 as select i from t1 distributed by (i);

(this fails on current HEAD)

I dont think we need anything more complicated here.

Will do

@reshke

reshke commented Aug 9, 2024

Copy link
Copy Markdown
Contributor Author

Seems that matview_optimizer.out depends on matview tests. Pushed commit should fix test

Comment thread src/test/regress/sql/matview.sql
Comment thread src/test/regress/sql/matview.sql
@reshke

reshke commented Aug 16, 2024

Copy link
Copy Markdown
Contributor Author

Are there any open items/suggestion/issues?

@my-ship-it
my-ship-it merged commit 978bab5 into apache:main Aug 21, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

None yet

Projects

None yet

Development

Successfully merging this pull request may close these issues.

3 participants