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

edited March 2019 in General Discussion

query starts like :

with campaigns as (QUERY1),
campaign_sample as (QUERY2)

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)


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file