The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

vsql returns error on using with statement

hananshanans
edited March 2019 in General Discussion

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)

Comments

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.