vsql returns error on using with statement

hanans

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)

Jim_Knicely

Works okay like this:

dbadmin=> WITH campaigns AS (SELECT * FROM dual),
dbadmin->      campaign_sample AS (SELECT * FROM dual)
dbadmin-> SELECT * FROM campaign_sample;
 dummy
-------
 X
(1 row)

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