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 <[email protected]<mailto:[email protected]>> 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
