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

2014-10-20 Thread 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

HIVE::START WITH and CONNECT BY implementation in Hive

2014-10-20 Thread 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 a