Iterative and recursive problems not well suited for map reduce because tasks do not share state or coordinate with each other. Most of the syntax shown here http://psoug.org/reference/connectby.html does not look like a good fit for a hadoop or hive problem.
On Tue, May 8, 2012 at 2:14 PM, Thulasi Ram Naidu Peddineni <thulasiram...@gmail.com> wrote: > Hi, > Is there a way to implement connect by (similar to the one in > Oracle) in hive ? (Join works if you know the number of levels of but > my use-case is such that I don't know number of levels.) > > ----- > Regards, > Thulasi Ram P