You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@hive.apache.org by Thulasi Ram Naidu Peddineni <th...@gmail.com> on 2012/05/08 20:14:32 UTC

Suggestions on implementing connect by in hive

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

Re: Suggestions on implementing connect by in hive

Posted by Edward Capriolo <ed...@gmail.com>.

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
<th...@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