all-things-risingwave
What are the limitations on the definitions of materialized views in the context of joins and clauses?
The documentation mentions that only the ON clause is supported for joins. Can materialized views have JOIN, ON, and WHERE clauses?
Ng
Nghia Tran
Asked on Dec 15, 2022
- Materialized views can have JOIN operations with the ON clause.
- WHERE clause is supported by default for materialized views.
- Conditional join operations are allowed in materialized views, using the ON clause but not the USING clause.
- The documentation note refers to the limitation of not supporting the USING clause for join operations in materialized views.
Dec 16, 2022Edited by