10-04-2023 07:47 AM
recursive CTE is not supported in spark. but there is a workaround using python:
https://medium.com/@24chynoweth/recursive-cte-on-databricks-2ac0dff8ca06
