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
CONNECT BY
Moderator: NorbertKrupa
-
- Intermediate
- Posts: 149
- Joined: Mon Apr 30, 2012 10:04 pm
- Location: New York
- Contact:
Re: CONNECT BY
There is an extension that might be able to help you out in the Vertica github repository -- https://github.com/vertica/Vertica-Exte ... _functions.