Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
How to write Hierarchical queries in Vertica - Any inbuilt function
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!
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Comments
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
Thank you for your quick response. Will try at my end.
This Vertica extension supports only integer inputs and does not work if the parent & child relationship is established as a STRING. is there a way to resolve this?
Since Version 10.1, we do have the recursive query capability
See here:
Data Preparation
Demo Test