Convert recursive query to Hive

[#1]

I am trying to convert a recursive query to Hive.

The structure of my query is as following

WITH RECURSIVE REG_AGGR as

( select * from abc where rn=1

union all

select * from REG_AGGR where REG_AGGR.id=abc.id

)

select * from REG_AGGR;

[#2]

Are you able to find any solution?

[#3]

any solution for this ?

[#4]

See the following links for more information:

https://community.hortonworks.com/questions/120941/recursive-query-or-better-way-to-build-hierarchic...

https://blog.pythian.com/recursion-in-hive/

https://stackoverflow.com/questions/38765543/recursive-query-in-hive