The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
vsql returns error on using with statement

query starts like :
with campaigns as (QUERY1), campaign_sample as (QUERY2) QUERY3
running vsql on the query gets:
vsql:generate_data.sql:54: ERROR 4566: Relation "campaign_sample" does not exist
running the same sql file from intellij datagrip works (not from the vsql command line)
0
Comments
Works okay like this:
Your QUERY3 should be selecting from one of the WITH clause named queries
See:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Statements/SELECT/WITHClause.htm