How to write Hierarchical queries in Vertica - Any inbuilt function

abhiashu85

Hello Everyone,

I am looking for function in Vertica which can write Hierarchical queries like in Oracle we have CONNECT_BY_PATH function.

Appreciate any pointers or help here. Thank You!

Jim_Knicely

There is an extension that might be able to help you out in the Vertica github repository:

https://github.com/vertica/Vertica-Extension-Packages/tree/master/compatlib_functions

abhiashu85

Thank you for your quick response. Will try at my end.