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

Posted to user@hive.apache.org by yogesh dhari <yo...@gmail.com> on 2014/10/20 09:12:24 UTC

HIVE::START WITH and CONNECT BY implementation in Hive

Hello All


How can we achive

*start with .. connect by* clause can be used to select data that has a
hierarchical relationship (usually some sort of parent->child
(boss->employee or thing->parts).

into Hive, or what would be the other work around to implement this.



Please suggest

Thanks in advance
Yogesh

Re: HIVE::START WITH and CONNECT BY implementation in Hive

Posted by "Moore, Douglas" <Do...@thinkbiganalytics.com>.

Look up "Transitive Closure"
It's a fast technique to analyze hierarchical data w/o proprietary SQL extensions.
- Douglas

On Oct 20, 2014, at 3:12 AM, yogesh dhari <yo...@gmail.com>> wrote:

Hello All


How can we achive

start with .. connect by clause can be used to select data that has a hierarchical relationship (usually some sort of parent->child (boss->employee or thing->parts).

into Hive, or what would be the other work around to implement this.



Please suggest

Thanks in advance
Yogesh