is there Hierarchical queries in Vertica?

Moderator: NorbertKrupa

Post Reply
jagadeesh
Newbie
Newbie
Posts: 21
Joined: Tue Feb 05, 2013 9:36 am

is there Hierarchical queries in Vertica?

Post by jagadeesh » Tue Feb 05, 2013 9:52 am

Hi,

I am looking for Hierarchical queries in Vertica that is equivalent to START With... and CONNECT By in ORACLE.

I referred in the SQL reference guide but couldn't get it, please share the knowledge.

Thanks,
Jagadeesh.

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: is there Hierarchical queries in Vertica?

Post by JimKnicely » Tue Feb 05, 2013 2:48 pm

Hi!

Welcome to the community!

Check out this forum post:

viewtopic.php?f=46&t=581
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

jagadeesh
Newbie
Newbie
Posts: 21
Joined: Tue Feb 05, 2013 9:36 am

Re: is there Hierarchical queries in Vertica?

Post by jagadeesh » Thu Feb 07, 2013 7:08 am

Thanks Jim.

DanielleShriek
Newbie
Newbie
Posts: 1
Joined: Mon May 13, 2013 7:44 am

Re: is there Hierarchical queries in Vertica?

Post by DanielleShriek » Tue May 14, 2013 6:17 am

I want to define linear function using Vertica..But I am unable to do so..How I define it and connect it to back end?

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1825
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: is there Hierarchical queries in Vertica?

Post by JimKnicely » Tue May 14, 2013 2:04 pm

Hi,

Welcome to the forums!

Are you asking how to create a function that you can call in SQL from Vertica?
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

Post Reply

Return to “New to Vertica SQL”