apache / apache/cloudberry-site

Document issue about "CREATE MATERIALIZED VIEW"

Open
#47 4 comments 0 reactions 1 assignee Claimed by @TomShawn View on GitHub
Dominant language
TypeScript
Stars
26
Forks
42
Avg merge
3d 13h
Merged PRs (30d)
7

Description

https://github.com/cloudberrydb/cloudberrydb-site/blob/cbdb-doc-validation/docs/sql-stmts/sql-stmt-create-materialized-view.md

---
CREATE MATERIALIZED VIEW [ IF NOT EXISTS ]
[ ( [, ...] ) ]
[ USING ]
[ WITH ( [= ] [, ... ] ) ]
[ TABLESPACE ]
AS
[ WITH [ NO ] DATA ]
[DISTRIBUTED {| BY [], [ ... ] | RANDOMLY | REPLICATED }]

---
DISTRIBUTED clause is not correct. Missing '(' and '|' should not be in front of 'BY'.

The following is an actual example tried on CBDB.

gpadmin=# CREATE MATERIALIZED VIEW mt11 (mc1, mc2, mc3) as select c1,c2,c3 from t1 distributed by (mc1 int4_ops,mc2 text_ops);
SELECT 4

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.