Vertica View syntax issues

Slaagh

Hello,

I recently reverse engineered a SQL View into a Vertica view. I have several nested CTE's in the view.

So, I run the script and the Vertica view is created, but when I open the view in Vertica the syntax is very different. I do not see any of my CTE's and there are tons of conversions going on in the view.

Simply put, the syntax is very different from the view that I created. Does Vertica re-write the view for performance reasons? Or is something seriously wrong?

[Deleted User]

Process you are following to create and check defination of view in Vertica is not very clear to me . Can you please provide an example ?

You can check view_defination in system table vs_views .

Slaagh

Thank you, but I figured this out already