Recursive cte sql in dremio

Hi Dremio Team,
does dremio support any kind of recursive sql? like oracle connect by/level?

dremio UI highlights “recursive” as a known keyword, is there a way to use this keyword?

1 Like

Hello @smora

Currently Dremio doesn’t support Recursive cte.

Also, ‘recursive’ keyword is reserved for the future scope.


Will help if the Dremio documentation team improves the online SQL reference to outline grammar in detail. Much as one would find in many database vendors SQL refs.