It's true. One month back I was also trying to solve a similar hierarchy problem and realized that recursive CTE is not supported in Databricks SQL. Now the only option is to go withPySpark. 

If you can describe your problem statement more, I will help you with the solution. 

Thanks.