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

[Moore, Douglas]

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 
mailto:yogeshh...@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

HIVE::START WITH and CONNECT BY implementation in Hive

[yogesh dhari]

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