1

I'm new in Hive and Datastage development. I'm trying to do a recursive query like we can do in Orcale with connect by or with clause, but Hive doesn't support recursive queries. Is there any way to do this in Hive? Or to do the logic through IBM datastage job?

Many thanks,

Priscila Ferreira

Priscila Ferreira
  • 21
  • 1
  • Can you give some examples of what it is you're trying to do? – user3334690 Jul 30 '18 at 18:27
  • So, I have a table with parent-child relationship and I need to know for specific parent which childrens are below him. Graphically, I have a tree. But I never know until which level the hierarchy goes. For that reason, i can't do a loop and i would need the recursivity. – Priscila Ferreira Jul 31 '18 at 08:34

0 Answers0