Vertica View syntax issues
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?
0
Comments
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 .
Thank you, but I figured this out already