apache / apache/cloudberry-site
Document issue about "CREATE MATERIALIZED VIEW"
- 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.