Carlo Nucera is interested in using Recursive CTEs in Risingwave to calculate the transitive closure of a graph. Are there other ways to achieve this in Risingwave that respect incrementality?
RisingWave does not currently support Recursive CTEs for processing queries.
While RisingWave does not have native support for graph computation, as a SQL database, users can leverage the SQL power to build graph applications.
Users can model relations in the SQL database to work with graph-related use cases like calculating transitive closure or detecting connectivity patterns in real-time applications.