title: recursive cte in spark SQL
body: <pre><code>; WITH  Hierarchy as 
          (
              select distinct PersonnelNumber
              , Email
              , ManagerEmail 
              from dimstage
              union all
              select e.PersonnelNumber
              , e.Email           
              , e.ManagerEmail 
              from dimstage  e
              join Hierarchy as  h on e.Email = h.ManagerEmail
          )
          select * from Hierarchy
  </code></pre>
  <p>Can you help achieve the same in SPARK SQL</p>