Recursive cte sql in dremio

[smora]

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?

[Rakesh_Malugu]

Hello @smora

Currently Dremio doesn’t support Recursive cte.

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

Thanks,
@Rakesh_Malugu

[dqmdev]

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.