CONNECT BY

Moderator: NorbertKrupa

Post Reply
User avatar
Josh
Intermediate
Intermediate
Posts: 106
Joined: Thu Jan 26, 2012 9:38 pm

CONNECT BY

Post by Josh » Mon Apr 23, 2012 6:49 pm

Hi, Is there a similar function in Vertica that mimics the CONNECT BY feature in Oracle? That is, how should we best (for performance) traverse up and down a self referencing table? Thanks!

PS. We're trying to migrate an Oracle database into Vertica (to save some $$$) and finding there is a lot of code that doesn't convert easily :(
Thank you!
Joshua

jpcavanaugh
Intermediate
Intermediate
Posts: 149
Joined: Mon Apr 30, 2012 10:04 pm
Location: New York
Contact:

Re: CONNECT BY

Post by jpcavanaugh » Mon Apr 30, 2012 10:15 pm

There is an extension that might be able to help you out in the Vertica github repository -- https://github.com/vertica/Vertica-Exte ... _functions.

Post Reply

Return to “New to Vertica”