all-things-risingwave
Is it possible to execute recursive queries in RisingWave?
Charlie is asking if it's possible to execute recursive queries in RisingWave, mentioning the need to build hierarchical materialized views for directories trees, groups, and subgroups.
Ch
Charlie
Asked on Jul 29, 2023
- RisingWave currently doesn’t support recursive common table expressions (CTE) like in PostgreSQL.
- One possible workaround could be building materialized views on top of other materialized views to achieve a similar hierarchical structure.
- It's common for users to use materialized views on top of each other to handle hierarchical data.
- RisingWave team will discuss internally to see if there's a workaround or quick implementation for this requirement.
Jul 30, 2023Edited by