@Landan George​ 

Hey, I am looking into same issue, but when I execute what's suggested in the post for CTE_Recursive https://medium.com/globant/how-to-implement-recursive-queries-in-spark-3d26f7ed3bc9

I get error

Error in SQL statement: AnalysisException: Table or view not found: CTE_Recursive; line x pos y;

I created the same table as in the post's example and even copied the code and executed it so I am not doing something else.

Can you please advise ?