Snowshoe logo
all-things-risingwave

Does Risingwave support Recursive CTEs?

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?

Ca

Carlo Nucera

Asked on Aug 31, 2022

  • 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.
Nov 28, 2022Edited by